This course teaches the fundamentals of Transact-SQL, Microsoft’s dialect of the standard SQL language. It covers querying and modifying data in relational databases hosted on Microsoft SQL Server-based systems, including SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric.
$ 469,00
Questions about this course? let our team answer them!
Course Outline
1. Introduction to Transact-SQL
• Work with schemas
• Explore the structure of SQL statements
• Examine the SELECT statement
• Work with data types
• Handle NULLs
• Exercise – Work with SELECT statements
2. Sort and filter results in T-SQL
• Sort your results
• Limit the sorted results
• Page results
• Remove duplicates
• Filter data with predicates
• Exercise – Sort and filter query results
3. Combine multiple tables with JOINs in T-SQL
• Understand joins concepts and syntax
• Use inner joins
• Use outer joins
• Use cross joins
• Use self joins
• Exercise – Query multiple tables with joins
4. Write Subqueries in T-SQL
• Understand subqueries
• Use scalar or multi-valued subqueries
• Use self-contained or correlated subqueries
• Exercise – Use subqueries
5. Use built-in functions and GROUP BY in Transact-SQL
• Categorize built-in functions
• Use scalar functions
• Use ranking and rowset functions
• Use aggregate functions
• Summarize data with GROUP BY
• Filter groups with HAVING
• Exercise – Use built-in functions
6. Modify data with T-SQL
• Insert data
• Generate automatic values
• Update data
• Delete data
• Merge data based on multiple tables
• Exercise – Modify data
Course Details
• Familiarity with working with tables of data, for example in a spreadsheet.
Anyone who needs to write basic SQL or Transact-SQL queries, including data analysts, data engineers, data scientists, database administrators, database developers, solution architects, students, and technology managers.
For online (live) format
$ 469,00
NextGen Newsletter
Don’t miss a thing! Sign up to receive updates and exclusive content.
© NextGen Skills LLC. All rights reserved.
1207 Delaware Ave, #4405, Wilmington, Delaware 19806, US
