SQL Server

1. Fundamentals of relational Database

2. Creating tables

3. Data types

4. SELECT – Querying the data stored in the tables

5. WHERE – Filtering the data

6. Sorting data by using ORDER BY

7. Query multiple tables

8. Aggregate functions

9. Group data with GROUP BY

10. Delete and Update commands

11. Constraints

12. Views

13. Triggers

14. Stored procedures

15. Error handling with Try, Catch and Throw

16. Aggregate queries

17. Sub-queries

18. Functions

A basic knowledge of computer systems

After the completion of the course and the exam, you will be awarded with the course completion certificate.

16 hours