Det finns inga varor i din kundvagn. Fortsätt handla på vår Kurskatalog sida.
Betala Nu -ELLER- betala Senare
Betala med kreditkort nu
-ELLER - betala mot faktura som vanligt.
This is Microsoft Official Course (MOC),Querying Data with Transact-SQL Training (20761), delivered by a Learning Tree expert instructor.
This hands-on Transact-SQL course provides an understanding of the Transact-SQL language which is used by all SQL Server-related disciplines such as Database Administration, Database Development and Business Intelligence. Attend this course and learn basic Transact-SQL queries for Microsoft SQL Server.
LIVE, LÄRARLEDD
UTBILDNING PÅ DIN ARBETSPLATS
Anpassa kurs och innehåll efter teamets behov
Kontakta ossLearning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .
21 - 25 jun
9:00 - 4:30 BST
Online (AnyWare)
20 - 24 sep
9:00 - 4:30 BST
Online (AnyWare)
13 - 17 dec
9:00 - 4:30 GMT
Online (AnyWare)
10 - 14 maj
9:00 - 4:30 EDT
Online (AnyWare)
9 - 13 aug
9:00 - 4:30 EDT
Herndon, VA / Online (AnyWare)
1 - 5 nov
9:00 - 4:30 EDT
New York / Online (AnyWare)
7 - 11 feb
9:00 - 4:30 EST
Herndon, VA / Online (AnyWare)
Kurs med startgaranti
När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.This course features Microsoft Official Courseware (MOC), Course 20761C: Querying Data with Transact-SQL. This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor.
This course can help you prepare for the following Microsoft certification exam — 70-761: Querying Data with Transact-SQL
This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
This course offers you the opportunity to earn the following industry credits and certifications.
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.
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.
Lessons
Lab: Working with SQL Server Tools
After completing this module, you will be able to:
This module introduces 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.
Lessons
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.
Lessons
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.
Lessons
Lab: Querying Multiple Tables
After completing this module, you will be able to:
This module describes how to implement sorting and filtering.
Lessons
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.
Lessons
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.
Lessons
Lab: Using DML to Modify Data
After completing this module, you will be able to:
This module introduces the use of functions that are built in to SQL Server Denali, and will discuss some common usages including data type conversion, testing for logical results and nullability.
Lessons
Lab: Using Built-In Functions
After completing this module, you will be able to:
This module describes how to use aggregate functions.
Lessons
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.
Lessons
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.
Lessons
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.
Lessons
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.
Lessons
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.
Lessons
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.
Lessons
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.
Lessons
Lab: Programming with T-SQL
After completing this module, students will be able to:
This module introduces error handling for T-SQL.
Lessons
Lab: Implementing Error Handling
After completing this module, students will be able to:
This module describes how to implement transactions.
Lessons
Lab: Implementing Transactions
After completing this module, students will be able to:
T-SQL is a proprietary set of programming extensions from Microsoft and Sybase used to interact with relational databases.
This course can help you prepare for the Microsoft Exam 70-761, Querying Data with Transact-SQL, but the exam voucher is not included with tuition fee.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs.
Yes, writing certain T-SQL statements is a covered topic in this course. Please review the course outline for details.
Questions about which training is right for you?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.