Microsoft SQL Data Analysis Training

This training equips participants with the essential technical skills to write basic Transact-SQL queries for Microsoft SQL Server. Serving as the foundational course for all SQL Server domains, it is a key starting point for careers in Database Administration, Development, and Business Intelligence.

Designed with aspiring Database Administrators, Developers, and BI professionals in mind, the course introduces core SQL concepts and practical query writing skills that are critical across all SQL Server-related roles.

Skill Gained

• Describe the basic architecture and concepts of Microsoft SQL Server
• Understand the similarities and differences between Transact-SQL and other computer languages
• Write SELECT queries
• Query multiple tables
• Sort and filter data
• Describe the use of data types in SQL Server
• Modify data using Transact-SQL
• Use built-in functions
• Group and aggregate data
• Use subqueries
• Use table expressions
• Use set operators
• Use window ranking, offset and aggregate functions
• Implement pivoting and grouping sets
• Execute stored procedures
• Program with T-SQL
• Implement error handling
• Implement transactions