Faysal AzizMastering SQL with Microsoft SQL Server
From Fundamentals to Advanced Querying for Real-World Data Workflows in 3 days
Why this course
Structured Query Language (SQL) is the foundation of how data is accessed, managed, and analyzed in almost every business today. Whether you’re building reports, supporting applications, or extracting insights from large datasets, SQL remains the universal language that bridges people and data.
This three-day course focuses on Microsoft SQL Server, one of the most widely used database systems in enterprise environments, and takes you from learning what databases are to writing powerful queries that solve real problems. The curriculum is built around practical scenarios, industry best practices, and performance-oriented techniques, not just syntax.
By the end of the course, you’ll be confidently writing efficient queries, understanding how to structure data, and working with advanced SQL features that modern data professionals rely on every day.
Learning outcomes
After completing this course, learners will be able to:
- Understand core database concepts and how relational databases work
- Write basic to advanced SQL queries in Microsoft SQL Server
- Join, filter, aggregate, and manipulate data with confidence
- Use stored procedures, functions, and views
- Optimize queries for performance
- Understand indexes and execution plans
- Apply SQL skills to solve real business data tasks
Prerequisites
- Basic computer literacy (installing software, navigating menus, file system, data structures, network basics)
- No prior SQL or database experience required
- MS SQL Studio or VS Code with MS-SQL Plugin installed
- Access to open IP and port 1433
14 modules
01Foundations of Relational Databases7 topics
- What is a database?
- Tables, rows, columns
- Primary keys and relationships
- Introduction to Microsoft SQL Server
- SQL Server Management Studio (SSMS) overview
- Connecting to databases
- Creating your first database and table
02Basic Data Retrieval6 topics
- SELECT statement fundamentals
- Selecting single and multiple columns
- Using WHERE for filtering
- Logical operators (AND, OR, NOT)
- Sorting results with ORDER BY
- Limiting results (TOP)
03Working with Data Types and Expressions4 topics
- Understanding SQL data types (int, varchar, datetime, etc.)
- Implicit vs explicit conversion
- Using functions for data formatting
- NULL handling and ISNULL/COALESCE
04Advanced Filtering and Set Operations4 topics
- BETWEEN, IN, LIKE
- DISTINCT
- UNION and UNION ALL
- INTERSECT, EXCEPT
05Joins and Relationships6 topics
- INNER JOIN
- OUTER JOINS (LEFT, RIGHT)
- FULL OUTER JOIN
- CROSS JOIN
- Self-joins
- Joining multiple tables
06Aggregates and Grouping3 topics
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING
- Windowed aggregates (ROW_NUMBER, RANK, PARTITION BY)
07Modifying Data5 topics
- INSERT statements
- BULK INSERT options
- UPDATE statements
- DELETE statements
- Transactions (BEGIN, COMMIT, ROLLBACK)
08Subqueries and Derived Tables4 topics
- Scalar subqueries
- Subqueries in WHERE and FROM
- Correlated subqueries
- Inline Views
09Views, Indexes, and Schema Objects5 topics
- Creating and using Views
- Indexed views
- Creating Indexes
- Clustered vs non-clustered
- When to use indexes
10Stored Procedures and Functions5 topics
- Creating Stored Procedures
- Input and output parameters
- Error handling in procedures
- User-defined functions (scalar and table-valued)
- Best practices
11Performance Tuning Basics4 topics
- Reading Execution Plans
- Identifying slow queries
- Statistics and optimization
- Index maintenance basics
12Advanced Query Techniques4 topics
- CTEs (Common Table Expressions)
- Recursive queries
- Pivot and Unpivot
- Temporary tables vs table variables
13Security and Permissions3 topics
- User roles and security
- Granting and revoking access
- Principles of secure SQL design
14Practical Scenarios and Projects4 topics
- Real business reporting queries
- Building reusable query templates
- Data reconciliation and validation strategies
- Debugging complex queries
Over three days, you’ll progress from the first SELECT statement to advanced query techniques and performance tuning — all tailored to the demands of real database work in Microsoft SQL Server. This course prepares you not for academic exams but for the challenges you’ll face in data engineering, analytics, application support, and business intelligence roles.
A programme built around your team.
Share your training goals and requirements.