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
Querying Data with Microsoft Transact-SQL Course Objectives
- Master Core T-SQL Concepts: Understand the key elements of Transact-SQL, from basic syntax to advanced functions for data manipulation and retrieval.
- Enhance Querying Techniques: Learn to construct efficient and effective queries for both routine and complex data analysis tasks.
- Develop Advanced Data Operations Skills: Gain proficiency in sophisticated data operations such as subqueries, joins, and set operations to manage and analyze large datasets.
- Apply Skills Across Microsoft Database Platforms: Adapt the acquired T-SQL skills for use in various Microsoft database environments, including Azure SQL Database and Azure Synapse Analytics.
- Prepare for Professional Growth: Equip yourself with the necessary skills to excel in data-centric roles and explore new career opportunities in the field of database management.
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 |