About Course
Course Overview:
This course is designed to introduce students to Transact-SQL (T-SQL), the primary language used to interact with Microsoft SQL Server databases. Participants will learn how to retrieve, manipulate, and analyze data efficiently using T-SQL queries.
The course is structured so that the foundational concepts covered in the first part can support learners progressing into more advanced SQL Server courses and database development tracks. It combines theoretical concepts with hands-on practice to ensure a solid understanding of querying techniques.
Module 1: Introduction to Microsoft SQL Server
- Overview of SQL Server platform
- Database concepts and architecture
Module 2: Introduction to T-SQL Querying
- Basics of Transact-SQL
- Writing simple queries
Module 3: Writing SELECT Queries
- SELECT statement fundamentals
- Retrieving specific columns and data
Module 4: Querying Multiple Tables
- Understanding joins
- INNER, LEFT, RIGHT, and FULL joins
Module 5: Sorting and Filtering Data
- ORDER BY clause
- WHERE clause and filtering techniques
Module 6: Working with SQL Server Data Types
- Common data types in SQL Server
- Data type conversions
Module 7: Using DML to Modify Data
- INSERT, UPDATE, DELETE statements
- Data modification techniques
Module 8: Using Built-In Functions
- Scalar functions
- Date, string, and mathematical functions
Module 9: Grouping and Aggregating Data
- GROUP BY clause
- Aggregate functions (SUM, COUNT, AVG, etc.)
Module 10: Using Subqueries
- Writing subqueries
- Correlated vs non-correlated subqueries
Module 11: Using Table Expressions
- Derived tables
- Common Table Expressions (CTEs)
Module 12: Using Set Operators
- UNION, INTERSECT, EXCEPT
Module 13: Using Window Functions
- Ranking functions
- Offset functions
- Aggregate window functions
Module 14: Pivoting and Grouping Sets
- PIVOT and UNPIVOT
- GROUPING SETS
Module 15: Executing Stored Procedures
- Creating and executing stored procedures
Module 16: Programming with T-SQL
- Variables and control-of-flow
- Conditional logic
Module 17: Implementing Error Handling
- TRY…CATCH
- Error handling techniques
Module 18: Implementing Transactions
- Transaction concepts
- COMMIT, ROLLBACK
