SQL for Beginners

Beginner
Online Classes
Total 8 hours in class

Multi-Day Course
2-8 learners per class

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

Understanding Databases and DBMS
- Database and DBMS
- Introduction to MS SQL Server
- Introduction to Azure SQL Database
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
Data Manipulation Language
- Introduction to DML
- INSERT statements
- UPDATE statements
- DELETE statements
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
Filtering Data
- Using WHERE for filtering
- Using the NOT operator
- Using the LIKE operator
- Using IS NULL and IS NOT NULL
Sorting Data Using ORDER BY
- Sorting Data
- Sorting by Multiple Columns
- Specifying Sort Direction
Aggregation and grouping
- COUNT, SUM, AVG, MIN, MAX
- Grouping by fields
- Using HAVING to filter results
Using Functions
- LEFT and Right
- MONTH
- YEAR
- DAY
Combining multiple SELECT Results
- UNION
- UNION ALL
Using Subqueries
- Introduction to Subqueries
- Filtering by Subquery
- Subqueries in the SELECT clause
Joins
- Inner joins
- Table aliases
- Left and right outer joins
- Full outer joins
Creating and Using Views
- Introduction of Views
- Creating Views using SQL

Tutors

Younus Kazi

A professional Online and Classroom Teacher

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, deve...
View More...