Learn the language of Databases!
Acquire an in-depth mastery of industry standard analytics software for business problem-solving and data analytics.
Build the foundation for skills required to work with data, such as importing, reading, manipulating data, via MICROSOFT’S TRANSACT-SQL programming language.
Why should you enroll?
- Certificate of Completion
- Free enrollment for the T-SQL Advance course worth N80,000 for the first 20 applicants
- Trained by highly skilled, practicing and experienced Instructor
- Acquire in-depth knowledge of topmost highly demanded SQL Server’s Transact-SQL analytical and programming language
- 100% live instructor-led virtual classes
- Real-world analytical problem scenarios
- Access to recorded videos of live classes for reinforcements
- 2-months intensive close mentorship
- Discount on industry costs
SQL Learning outcomes
Participants will be strongly equipped and capacitated with the practical understanding and knowledge of:
- The concept of Data Analytics, Data Science, their contrast and the relationship with the Transact-SQL programming language
- Querying data with Transact-SQL
- Querying tables with SELECT
- Concept of JOINS
- Using SET operators to breakdown problems
- Using functions and aggregating data for high-level analytics
- Intro to subqueries for manipulating data
- Intro to using Table Expressions
SQL Course Content
- Intro to Transact-SQL
- Relational Databases
- Schemas and object names
- SQL statement types
- Launching and interacting with the SSMS User Interface
- Intro to the SELECT statement
- Usage and conversion of T-SQL datatypes
- The concept of NULLS and working with them
- Using the powerful concept of CASE for data categorization
- Addressing duplicate values in data using T-SQL
- Sorting results – The T-SQL way
- The OFFSET … FETCH concept for paging sorted results
- Filtering results using Predicate in T-SQL
- Intro to the JOIN concept
- Inner and Outer JOINS
- Cross JOINS
- UNION queries in T-SQL
- INTERSECT queries in T-SQL
- Intro to built-in functions in T-SQL
- Scalar functions in T-SQL
- Aggregate function in T-SQL
- Logical functions in T-SQL
- Aggregating data with the GROUP BY and sorting them with HAVING clauses
- Intro to subqueries
- T-SQL Scalar or Multi-valued?
- The concept VIEW object in T-SQL
- Temporary Tables
About the next program
The program is designed to run virtually for 5 consecutive weekends (Saturdays only), starting 13th of February 2021 and ending 13th of March 2021.
Each class will run for 4 hours from 1pm – 5pm (West African Time) and will include compulsory assignments due before the following class.
Class recordings will be available for participants at the end of each class day.
Participants will be provided with Microsoft Official Learning Document for T-SQL as soon as classes commence
This hands-on course is designed for anyone new to and intending to delve into the world of data analytics and data science.
It is also valuable to anyone who needs a solid foundation in and in-depth knowledge of the SQL programming and/or having insufficient practice experience.
No prior knowledge of data analytics required. No prior knowledge of SQL programming required.
The fees for attending comes at a discounted price of N40,000 or $99 for International participants.
With a degree in educational mathematics from the University of Lagos, Daniel is a Microsoft Certified Professional in Querying Data with Transact-SQL.
He proudly possesses more than ten years of consulting experience as a Data Analyst, Data Engineer and Business Intelligence Analyst with reputable organizations like the Nigerian Ports Authority, the Lagos State Government, Society for Family Health (a reputable NGO headquartered in Abuja, Nigeria).
Daniel has also trained managers, top officials and partners in leading corporate organizations like BDO Nigeria, one of Africa’s renowned audit firms.
He has successfully trained countless professionals in data analytics with SQL and Power BI in different and varying fields of life and has excelled in this endeavor.
Address: Divine Plaza, Suite B5, First Floor, 59, Ajayi Road, Ogba, Lagos.