Overview
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