Maxtrain.com - info@maxtrain.com - 513-322-8888 - 866-595-6863
DP-080
Querying Data with Microsoft Transact-SQL
Alert MeDescription
Querying Data with Microsoft Transact-SQL Introduction
Course Objectives
- Master the essentials of Transact-SQL (T-SQL).
- Use SQL Server query tools effectively.
- Write SELECT statements to retrieve data from one or more tables.
- Sort and filter data.
- Employ built-in functions for data manipulation.
- Create groups of data and aggregate results.
- Modify data using INSERT, UPDATE, DELETE, and MERGE statements.
Prerequisites
- Basic knowledge of the Microsoft Windows operating system.
- Working knowledge of relational databases.
Audience
This course is designed for individuals in various roles, including:
- Data Analysts
- Data Engineers
- Data Scientists
- Database Administrators
- Database Developers
- Solution Architects
- Students
- Technology Managers
Querying Data with Microsoft Transact-SQL Outline
Getting Started with Transact-SQL
- Introduction to Transact-SQL
- Using the SELECT statement
- Lab: Get started with SQL Server query tools and writing queries in T-SQL
Sorting and Filtering Query Results
- Sorting query results
- Filtering the data
- Lab: Sort and filter data returned by SELECT queries
Using Joins and Subqueries
- Using JOIN operations
- Using subqueries
- Lab: Write queries with JOIN operations
- Lab: Write SELECT statements using subqueries
Using Built-in Functions
- Getting started with scalar functions
- Grouping aggregated results
- Lab: Built-in functions
Modifying Data
- Inserting data into tables
- Modifying and deleting data
- Lab: Modify data
PreRequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
$995.00
|
2 Days Course |