SQL Complete – From Beginner to Advanced

Module 1. Database Fundamentals

• What is a relational database?
• Tables, columns, rows, primary and foreign keys
• Indexes – introduction
• Basic data modeling concepts

Module 2. Introduction to T-SQL

• What is T-SQL?
• Structure of a SELECT query
• Predicate logic and logical query processing order

Module 3. Writing Basic Queries

• Basic SELECT statements
• DISTINCT
• Column and table aliases
• Simple CASE expressions

Module 4. Working with SQL Server Data Types

• Character, numeric, date/time types
• Data type conversions
• Type precedence

Module 5. Sorting and Filtering

• WHERE clause, ORDER BY
• LIKE, IN, BETWEEN
• TOP and OFFSET-FETCH
• Handling NULL values

Module 6. Querying Multiple Tables

• INNER, LEFT, RIGHT, FULL JOIN
• CROSS JOIN and SELF JOIN
• ER diagrams to visualize relationships

Module 7. Built-In Functions

• Conversion functions, logical functions, NULL-handling
• String, date, and numeric functions

Module 8. Data Manipulation (DML)

• INSERT, UPDATE, DELETE
• Basic transactions for testing

Module 9. Aggregation and Grouping

• GROUP BY and HAVING
• COUNT, SUM, AVG, MIN, MAX

Module 10. Subqueries

• Self-contained vs. correlated subqueries
• Using IN, EXISTS, and NOT EXISTS

Module 11. Table Expressions & Views

• Derived tables, Common Table Expressions (CTEs)
• Views and inline table-valued functions

Module 12. Set Operators and APPLY

• UNION, INTERSECT, EXCEPT
• CROSS APPLY and OUTER APPLY

Module 13. Window Functions

• ROW_NUMBER, RANK, DENSE_RANK
• LEAD, LAG, NTILE
• PARTITION BY and window frames

Module 14. Recursive CTEs and Hierarchical Data

• Building and traversing hierarchies
• Tree structures in SQL

Module 15. Stored Procedures

• Creating and executing stored procedures
• Input and output parameters
• Dynamic SQL

Module 16. Procedural T-SQL Programming

• Variables, IF/ELSE, WHILE loops
• TRY / CATCH blocks and THROW
• Control of flow logic

Module 17. Transactions and Error Handling

• ACID principles
• BEGIN, COMMIT, ROLLBACK
• Isolation levels and deadlocks

Module 18. Query Optimization Techniques

• Execution plans and query analyzers
• Indexing strategies and index types
• Materialized views
• Comparing performance: CTEs vs subqueries vs joins

Module 19. SQL Security & Permissions

• GRANT / REVOKE / DENY
• Roles and users
• Row-Level Security (RLS)
• Dynamic Data Masking (DDM)

Module 20. Auditing and Logging

• Change Tracking vs Change Data Capture (CDC)
• Triggers for data change auditing
• Monitoring database activity

Module 21. SQL Testing & Validation

• Testing stored procedures
• Validating query results
• SQL Unit Testing with tSQLt

Module 22. SQL Server Tools & Features

• SQL Server Management Studio (SSMS) – tips & tricks
• SQL Profiler
• Database Tuning Advisor
• Extended Events (intro)
• Integration with BI Tools

Module 23. Advanced Data Modeling

• Normalization (1NF, 2NF, 3NF)
• Denormalization for performance
• ER diagrams (visual tools like dbdiagram.io)
• Schema evolution and versioning

Module 24. ETL with SQL

• What is ETL?
• Extracting, Transforming, Loading data
• Incremental loading strategies
• Change Data Capture
• Error handling in ETL processes

Module 25. Real-World Projects

• Full database project (HR / Sales / E-commerce)
• Stored procedures + testing + optimization
• Simulate real scenarios and reporting
• Technical Documentation

Module 26. Interview Preparation

• Most common technical questions (junior to senior)
• How to present yourself during an IT interview
• CV and interview tips

Joburile la care poți aplica imediat după absolvire:

• SQL Developer
• Database Developer
• Data Analyst
• Business Intelligence (BI) Developer
• BI Analyst
• Database Analyst
• Junior Database Administrator (DBA)
• Data Engineer
• Reporting Analyst
• ETL Developer
• Data Scientist (entry-level, pentru partea de manipulare date)
• Financial Data Analyst
• Marketing Data Analyst
• Backend Developer cu cunoștințe SQL
• Full-Stack Developer (cu accent pe manipularea datelor)
• Systems Analyst
• IT Analyst
• Junior Software Developer (cu accent pe SQL și baze de date)
• Application Support Analyst
• Data Quality Analyst
• Data Operations Specialist
• Technical Support Specialist (cu focus pe baze de date)
• Data Warehouse Developer
• Database Tester / QA Engineer (testare baze de date)
• SQL Reporting Specialist
• Microsoft Power BI Developer
• Data Integration Specialist
• SQL Automation Specialist
• T-SQL Programmer
• Junior Big Data Engineer (cu focus pe partea SQL)
• ERP Data Specialist (ex: SAP, Oracle)