SQL
$2875
Per Participant
Note:
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.
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 server such as Database Administrations, Business Intelligence and Database Development. Thus, the primary audience for the course is the 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:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.
Texas
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA