SQL From Basics to Advanced

---

Course Content

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. Built-In Functions
   • Introduction to Built-In Functions
   • Using System Functions
   • Conversion Functions - CONVERT
   • Using Mathematical functions
   • Using String Functions
9. Date and Time Functions
   • GETDATE
   • DATEADD
   • DATEDIFF
   • DATENAME
   • DATEPART
   • DAY, MONTH and YEAR
   • Using CONVERT to format a date/time
10. Combining multiple SELECT Results
    • UNION
    • UNION ALL
11. Subqueries
    • Introduction of Subqueries
    • Subqueries vs Joining Tables
    • Subqueries with Comparison Operators
    • Subqueries with IN and NOT IN Operators
12. Joins
    • Inner joins
    • Table aliases
    • Left and right outer joins
    • Full outer joins
    • Aggregate Queries with Multiple Tables

---

Course Dates, Prices & Enrolment

---

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a 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:

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: