Querying Data with Transact-SQL
This course is designed to introduce students to Transact-SQL. It is designed so that the first three days can be taught as a course to students who require knowledge of other courses in the SQL Server curriculum.
COD: MOC 20761
CATEGORY: Microsoft
Teaching methodology
The course includes educational laboratories in which each student will be able to work in order to complete training exercises that will provide practical experience in using the instrument, for each of the topics covered during the course.
Who should participate
The main purpose of the course is to provide students with a good understanding of the Transact-SQL language used by all disciplines related to SQL Server; namely, Database Administration, Database Development and Business Intelligence. Therefore, the primary target audience for this course is: database administrators, database developers, and BI professionals.
Prerequisites
Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its main features.
Outgoing knowledge/skills
By the end of the course, you should be able to achieve the following objectives:
- Describe key features and components of SQL Server 2016.
- Describe T-SQL, set and predicate logic.
- 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.
- Writing queries that use built-in functions.
- Write queries that aggregate data.
- Write subqueries.
- Create and implement views and table-valued functions.
- Use set operators to combine query results.
- Write queries that use window classification, offset, and aggregation 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.
Educational program
- Introduction to Microsoft SQL Server 2016
- Introduction to T-SQL queries
- Writing SELECT queries
- Querying multiple tables
- Sorting and filtering data
- Working with SQL Server 2016 data types
- Using DML to modify data
- Use of built-in functions
- Data grouping and aggregation
- Using subqueries
- Using table expressions
- Using Set Operators
- Using the Windows positioning, offset and aggregation functions
- Pivot sets and grouping
- Execution of stored procedures
- Programming with T-SQL
- Implementing error handling
- Transaction implementation
Duration – 5 days
Delivery – in Classroom, On Site, Remote
PC and SW requirements:
Internet connection
Web browser, Google Chrome
Zoom
Language
Instructor: English
Workshop: English
Slides: English
