In this instructor-led, online training course, students will be introduced to Transact-SQL. Students will be given a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Course Instructor: Doug Perez

Course Outline

  • Introduction to Microsoft SQL Server
  • Introduction to T-SQL querying
  • Writing SELECT queries
  • Querying multiple tables
  • Sorting and filtering data
  • Working with SQL Server data types
  • Using DML to modify data
  • Using built-in functions
  • Grouping and aggregating data
  • Using subqueries
  • Using table expressions
  • Using set operators
  • Using Windows ranking, offset, and aggregate functions
  • Pivoting and grouping sets
  • Executing stored procedures
  • Programming with T-SQL
  • Implementing error handling
  • Implementing transactions

Skills Learned

After completing this online training course, students will be able to:

  • Describe key capabilities and components of SQL Server
  • Describe T-SQL, sets, and predicate logs
  • Write a single table SELECT statement
  • Write a multi-table SELECT statement
  • Write SELECT statements with filtering and sorting
  • Describe how SQL Server uses data types
  • Write DML statements
  • Write queries that use built-in functions
  • Write queries that aggregate data
  • Write subqueries
  • Create and implement views and table-valued functions
  • Use set operations to combine query results
  • Write queries that use window ranking, offset, and aggregate functions
  • Transform data by implementing pivot, unpivot, rollup and cube
  • Create and implement stored procedures
  • Add programming constructs such as variables, conditions, and loops to T-SQL code