SQL Course Registration

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.

Why should you enroll?

  • Certificate of Completion
  • Additional 25% Discount on our Power BI Bootcamp
  • Trained by highly skilled, practicing and experienced Instructor
  • Acquire in-depth knowledge of topmost highly demanded SQL Server’s Transact-SQL
  • 100% live instructor-led  virtual classes
  • Real-world analytical problem scenarios
  • Access to recorded videos of live classes for reinforcements

SQL Learning outcomes

Participants will be strongly equipped and capacitated with the practical understanding and knowledge of:

  • Using The Select Statement
  • Sorting Query Results
  • Filtering Query Results
  • Using Join Operations
  • Using Scalar Functions
  • Grouping aggregated results
  • Inserting data into tables
  • Modifying and deleting data

SQL Course Content

Module 1

  • Using a query tool to write and execute queries in Transact-SQL
  • Understand the basic concepts of relational database and the T-SQL language
  • Write SELECT statements to retrieve data from a relational database table
  • Understand basic datatypes and how they are used
  • Understand the basics of NULL values

Module 2

  • Use ORDER BY to sort results from a T-SQL SELECT statement
  • Add a TOP clause to limit the ordered rows returned
  • Page the sorted data with OFFSET-FET
  • Write WHERE clauses to filter the rows returned
  • Use DISTINCT to eliminate duplicate rows in the results

Module 3

  • Write queries accessing data from multiple tables using JOIN operations
  • Understand the differences between type of JOIN operations: INNER JOIN, OUTER JOIN
  • Understand how to join a table to itself with a self-join

Module 4

  • Write queries using scalar functions
  • Write queries using aggregate functions
  • Use GROUP BY to combine data into groups based on a common column value
  • Understand how HAVING is used to filter groups of rows

Module 5

  • Insert data into an existing table
  • Specify that a column should be automatically populating with an IDENTITY value
  • Modify data using the UPDATE statement
  • Delete data using the DELETE statement

About the next program

The program is designed to run virtually for 5 consecutive weekends (Saturdays only), starting 15th of January 2022 and ending 12th of February 2022.

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

Audience

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.

Prerequisites

No prior knowledge of data analytics required. No prior knowledge of SQL programming required.

Participants should download and install SQL Server Management Studio and SQL Server on their laptops before classes commence.

Training Fees

The fees for attending comes at a discounted price of N50,000 or $99 for International participants.

TRAINER’S PROFILE

Daniel Ajayi

SQL Trainer


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.

Consulting

Address: Divine Plaza, Suite B5, First Floor, 59, Ajayi Road, Ogba, Lagos.

Phone: +234-708-057-9790

Email: info@foresightbi.com.ng


Ahmed Oyelowo
(MVP, MCSA, MCT, AFM)

Subscribe To Our Newsletter

Join our newsletter to receive updates on trainings, live webinars & news from our blog.

Translate »
Scroll Up