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 6 consecutive weekends (Sundays only), starting 5th of June 2022 and ending 10th of July 2022.

Each class will run for 3 hours from 1pm – 4pm (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.


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