20761: Querying Data with Transact-SQL Training is designed to help professionals develop a conceptual understanding of Transact SQL language utilized by all SQL Server-related disciplines.
Course Price : $2875 Per Participant
Note: DP-080T00 is the replacement course for 20761: Querying Data with Transact-SQL.
This course is retired, Please contact Microtek Learning Consultant or email us at info@microteklearning.com for assistance.
20761: Querying Data with Transact-SQL Training is designed to help professionals develop a conceptual understanding of Transact SQL language utilized by all SQL Server-related disciplines.
This technical course is ideal for professionals who want to transform themselves into a pro relational database navigator and build their credibility.
It teaches about the critical components and capabilities of SQL Server and boosts one's confidence to speak about TSQL, predicate logic, and sets.
After finishing this training program, trainees will be able to write, multi and single-table SELECT statements and elaborate how SQL Server utilizes data types.
Our enterprise training program is best for large companies and organizations. It enhances the ability to manipulate set operators to blend query results and build and implement stored methodologies.
Moreover, professionals will also learn to write DML queries and statements and operate with and apply table-valued functions.
This training is designed based on the objectives of the course variant 20761C.
Courses
Years of Experience
Global Learners
The objective of this course is to provide students with a decent understanding of the Transact-SQL language.
This language is used throughout all the SQL servers such as Database Administrations, Business Intelligence, and Database Development.
Thus, the primary audience for the course is Database Admins and Developers, and Business Intelligence Pros.
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.
For dates, times, and location customization of this course, get in touch with us.
You can also speak with a learning consultant by calling 800-961-0337.
This module introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.
Lab: Working with SQL Server Tools
After completing this module, you will be able to:
This module describes the elements of T-SQL and their role in writing queries. Describe the use of sets in SQL Server. Describe the use of predicate logic in SQL Server. Describe the logical order of operations in SELECT statements.
Lab: Introduction to T-SQL Querying
After completing this module, you will be able to:
This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.
Lab: Writing Basic SELECT Statements
After completing this module, you will be able to:
This module describes how to write queries that combine data from multiple sources in Microsoft SQL Server.
Lab: Querying Multiple Tables
After completing this module, you will be able to:
This module describes how to implement sorting and filtering.
Lab: Sorting and Filtering Data
After completing this module, you will be able to:
This module introduces the data types SQL Server uses to store data.
Lab: Working with SQL Server Data Types
After completing this module, you will be able to:
This module describes how to create DML queries, and why you would want to.
Lab: Using DML to Modify Data
After completing this module, you will be able to:
This module introduces some of the many built in functions in SQL Server.
Lab: Using Built-In Functions
After completing this module, you will be able to:
This module describes how to use aggregate functions.
Lab: Grouping and Aggregating Data
After completing this module, you will be able to:
This module describes several types of subquery and how and when to use them.
Lab: Using Subqueries
After completing this module, you will be able to:
Previously in this course, you learned about using subqueries as an expression that returned results to an outer calling query. Like subqueries, table expressions are query expressions, but table expressions extend this idea by allowing you to name them and to work with their results as you would work with data in any valid relational table. Microsoft SQL Server supports four types of table expressions: derived tables, common table expression (CTEs), views, and inline table-valued functions (TVFs). In this module, you will learn to work with these forms of table expressions and learn how to use them to help create a modular approach to writing queries.
Lab: Using Table Expressions
After completing this module, you will be able to:
This module introduces how to use the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.
Lab: Using Set Operators
After completing this module, students will be able to:
This module describes the benefits to using window functions. Restrict window functions to rows defined in an OVER clause, including partitions and frames. Write queries that use window functions to operate on a window of rows and return ranking, aggregation, and offset comparison results.
Lab: Using Windows Ranking, Offset, and Aggregate Functions
After completing this module, students will be able to:
This module describes write queries that pivot and unpivot result sets. Write queries that specify multiple groupings with grouping sets
Lab: Pivoting and Grouping Sets
After completing this module, students will be able to:
This module describes how to return results by executing stored procedures. Pass parameters to procedures. Create simple stored procedures that encapsulate a SELECT statement. Construct and execute dynamic SQL with EXEC and sp_executesql.
Lab: Executing Stored Procedures
After completing this module, students will be able to:
This module describes how to enhance your T-SQL code with programming elements.
Lab: Programming with T-SQL
After completing this module, students will be able to:
This module introduces error handling for T-SQL.
Lab: Implementing Error Handling
After completing this module, students will be able to:
This module describes how to implement transactions.
Lab: Implementing Transactions
After completing this module, students will be able to:
©2023 Microtek Learning – All Rights Reserved