Live Webinar - Options for Running Microservices in AWS

closeClose

Querying Data with Transact-SQL (90 Day)

Course Details
Code: OD20761
Tuition (USD): $870.00 $652.50 • Self Paced
Generate a quote
This course is available in other formats
Instructor-Led Classroom & Virtual
Querying Data with Transact-SQL (20761)



This course is designed to introduce students to Transact-SQL. It
is designed for both students requiring the knowledge for other courses in the
SQL Server curriculum, and for students preparing for the skills required to
take exam 70-761.


Skills Gained

Aftercompleting this course, students will be able to:

  • Describe key capabilities and components of SQL Server.
  • Describe T-SQL, sets, 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.
  • Write 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 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.

Who Can Benefit

The main purpose of the course is to give students a goodunderstanding of the Transact-SQL language which is used by all SQLServer-related disciplines; namely, Database Administration, DatabaseDevelopment and Business Intelligence. As such, the primary target audience forthis course is: Database Administrators, Database Developers and BIprofessionals.