title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Querying Data with Microsoft Transact-SQL
Course Description
Overview
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.Objectives
Prerequisites
-
After completing this course, students will be able to:
- Use SQL Server query tools
- Write SELECT statements to retrieve columns from one or more tables
- Sort and filter selected data
- Use built-in functions to returned data values
- Create groups of data and aggregate the results
- Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
Topics
- Introduction to Transact-SQL
- Using the SELECT statement
- Lab : Get started with SQL Server query tools and writing queries in T-SQL
- Using a query tool to write and execute queries in Transact-SQL
- Understand the basic concepts of relational database and the T-SQL language
- Write SELECT statements to retrieve data from a relational database table
- Understand basic datatypes and how they are used
- Understand the basics of NULL values
- Sorting query results
- Filtering the data
- Lab : Sort and filter data returned by SELECT queries
- Use ORDER BY to sort results from a T-SQL SELECT statement
- Add a TOP clause to limit the ordered rows returned
- Page the sorted data with OFFSET-FET
- Write WHERE clauses to filter the rows returned
- Use DISTINCT to eliminate duplicate rows in the results
- Using JOIN operations
- Using subqueries
- Lab : Write queries with JOIN operations
- Lab : Write SELECT statements using subqueries
- Write queries accessing data from multiple tables using JOIN operations
- Understand the differences between type of JOIN operations: INNER JOIN, OUTER JOIN, CROSS JOIN
- Understand how to join a table to itself with a self-join
- Write subqueries within a SELECT statement
- Understand the difference between scalar and multi-valued subqueries
- Understand the difference between correlated and self-contained subqueries
- Getting started with scalar functions
- Grouping aggregated results
- Lab : Built-in functions
- Write queries using scalar functions
- Write queries using aggregate functions
- Use GROUP BY to combine data into groups based on a common column value
- Understand how HAVING is used to filter groups of rows
- Inserting data into tables
- Modifying and deleting data
- Lab : Modify data
- Insert data into an existing table
- Specify that a column should be automatically populating with an IDENTITY or a SEQUENCE value
- Modify data using the UPDATE statement
- Delete data using the DELETE statement
- Modify data using MERGE to synchronize two tables
Related Courses
-
SQL Server Integration Services
MOC-55321- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,500.00 USD
-
Getting Started with Cosmos DB NoSQL Development
MOC-DP-3015- Duration: 1
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Exam Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Purchase Information
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.