Canadian Academy of IT

SQL for Beginners

Learn all the essentials of Structured query language (SQL)
  • Beginner
  • Online Classes
  • Total 8 hours in class
  • SQL for Beginners

Requirements

You should have basic computing knowledge.

Class Details

This training course will teach you the essentials of SQL. In this course you’ll learn how to use SQL to create a database & tables, retrieve data from a database, filter data, aggregation, use functions, subqueries, join multiple tables and create views.

Course Outline

  1. Understanding Databases and DBMS
    • Database and DBMS
    • Introduction to MS SQL Server
    • Introduction to Azure SQL Database
  2. Structured Query Language (SQL) and T-SQL
    • Introduction to SQL and Transact-SQL (T-SQL)
    • USE Command
    • Create Databases using SQL
    • Drop Databases using SQL
    • Creating, Altering and Removing Tables using SQL
    • Commenting and Saving SQL
  3. Data Manipulation Language
    • Introduction to DML
    • INSERT statements
    • UPDATE statements
    • DELETE statements
  4. Retrieving Data
    • Introduction to the SELECT Statement
    • Retrieving Columns
    • Using DISTINCT to find unique values
    • Concatenating Columns
    • Creating Calculated Field
    • Limiting Results by using TOP Clause
  5. Filtering Data
    • Using WHERE for filtering
    • Using the NOT operator
    • Using the LIKE operator
    • Using IS NULL and IS NOT NULL
  6. Sorting Data Using ORDER BY
    • Sorting Data
    • Sorting by Multiple Columns
    • Specifying Sort Direction
  7. Aggregation and grouping
    • COUNT, SUM, AVG, MIN, MAX
    • Grouping by fields
    • Using HAVING to filter results
  8. Using Functions
    • LEFT and Right
    • MONTH
    • YEAR
    • DAY
  9. Combining multiple SELECT Results
    • UNION
    • UNION ALL
  10. Using Subqueries
    • Introduction to Subqueries
    • Filtering by Subquery
    • Subqueries in the SELECT clause
  11. Joins
    • Inner joins
    • Table aliases
    • Left and right outer joins
    • Full outer joins
  12. Creating and Using Views
    • Introduction of Views
    • Creating Views using SQL

Request for Course Dates and Booking

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

Subscribe to our newsletter

Sign up for our newsletter, so you can be the first to find out the latest news and tips about our classes, as well as general updates throughout the year.