Visa utbildning.se som: Mobil

Querying Data with Transact-SQL

Learning Tree International AB
Kort om utbildningen
Längd: 5 dagar
Pris: 30 950 SEK exkl. moms
Nästa tillfälle: 2018-06-18 - Distans
Ort: Distans, Stockholm
Språk: Engelska
Kommande starter
Distans
2018-06-18  
30 950 SEK
2018-07-09  
30 950 SEK
2018-08-27  
30 950 SEK
Stockholm
2018-11-05  
30 950 SEK

Beskrivning av: Querying Data with Transact-SQL

Transact SQL utbildning

 

Transact SQL for Database Administrators, Developers and BI Professionals

The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

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 is part of aMicrosoft Certification Pathand can help you prepare for your MCSA Certification, MCSE Certification, or MCSD Certification.

 

You will learn how to:

  • Describe key capabilities and components of SQL Server 2016.
  • Describe T-SQL, sets, and predicate logic.
  • Write a single table SELECT statement.
  • Write a multi-table SELECT statement.
  • Write SELECT statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • Write queries that aggregate data.
  • Write subqueries.
  • Create and implement views and table-valued functions.
  • Use set operators to combine query results.
  • Write queries that use window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs such as variables, conditions, and loops to T-SQL code.

Målgrupp

Requirements:

  • Working knowledge of relational databases
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Exam Information:

  • This course helps you prepare for the Microsoft 70-761 certification exam,Querying Data with Transact-SQL.

Kursinnehåll

Module 1: Introduction to Microsoft SQL Server 2016

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.

Module 2: Introduction to T-SQL Querying

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.

Module 3: Writing SELECT Queries

This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.

Module 4: Querying Multiple Tables

This module describes how to write queries that combine data from multiple sources in Microsoft SQL Server 2016.

Module 5: Sorting and Filtering Data

This module describes how to implement sorting and filtering.

Module 6: Working with SQL Server 2016 Data Types

This module introduces the data types SQL Server uses to store data.

Module 7: Using DML to Modify Data

This module describes how to create DML queries, and why you would want to.

Use UPDATE, MERGE, DELETE, and TRUNCATE

Module 8: Using Built-In Functions

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.

Module 9: Grouping and Aggregating Data

This module describes how to use aggregate functions.

Module 10: Using Subqueries

This module describes several types of subquery and how and when to use them.

Module 11: Using Table Expressions

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 2016 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.

Module 12: Using Set Operators

This module introduces how to use the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.

Module 13: Using Windows Ranking, Offset, and Aggregate Functions

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.

Module 14: Pivoting and Grouping Sets

This module describes write queries that pivot and unpivot result sets. Write queries that specify multiple groupings with grouping sets.

Module 15: Executing Stored Procedures

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.

Module 16: Programming with T-SQL

This module describes how to enhance your T-SQL code with programming elements.

Module 17: Implementing Error Handling

This module introduces error handling for T-SQL.

Module 18: Implementing Transactions

This module describes how to implement transactions.

Investering

I kurspriset inkluderas:

Coaching av läraren efter kursen

När du kommer tillbaka till jobbet kan du boka tid för kostnadsfri coachning för att få vägledning i hur du använder dina nya kunskaper i ditt dagliga arbete.

Computing Sandbox efter kursen

Efter kursen får du access till en virtuell dator som innehåller den programvaran som används under utbildningen. Här kan du göra om övningsuppgifter, skriva/testa kod och labba i en felsäker miljö.

Learning Trees kunskapstest

Learning Trees kunskapstest som erbjuds i slutet av kurserna ingår i kurspriset. För certifieringstest från tredje part (ex. ITIL) tillkommer en avgift.

Intresseanmälan

Fyll i dina uppgifter om du är intresserad och vill veta mer om kursen: Querying Data with Transact-SQL.


En intresseanmälan ger dig möjlighet att komma i kontakt med utbildningsarrangören


Du blir kontaktad och får mer information - För att kunna ta rätt beslut


En intresseanmälan är ingen bokning. Du förbinder dig inte till något

Errors
Valfritt
Valfritt
Valfritt
Valfritt
Valfritt
Skicka mig gärna information om liknande kurser!

Learning Tree International AB

Learning Tree International AB

Learning Tree International

Learning Tree är ett internationellt utbildningsföretag med över 40 års erfarenhet av att leverera utbildning till yrkesverksamma IT-proffs, projektledare, verksamhetsutvecklare och chefer. Vi erbjuder allt från enstaka kurser till globala utbildningsprogram, och vi hjälper våra kunder att införa hållbara processer som fungerar idag och förbereder...


Läs mer om Learning Tree International AB och visa alla utbildningar.

Kontaktuppgifter till Learning Tree International AB

Learning Tree International AB

Lindhagensgatan 126
112 51 Stockholm

 Visa telefonnummer

Recensioner

Kursdeltagare   |   2017-10-29
Mycket bra lärare, anpassade sina kommentarer efter oss.
          (4)
Kursdeltagare   |   2017-10-29
5 av 5
          (5)
Kursdeltagare   |   2017-10-29
5 av 5
          (5)