QUERYING MICROSOFT SQL SERVER® 2014

Modular Course (Select your Modules)

   In this course students will provided by the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Basic (2 days)

• Introduction to Microsoft SQL Server 2014

• Introduction to T-SQL Querying

• Writing SELECT Queries

• Querying Multiple Tables

• Sorting and Filtering Data

• Grouping and Aggregating Data

• Using Subqueries

Intermediate (2 days)

• Working with SQL Server 2014 Data Types

• Using DML to Modify Data

• Using Built-In Functions

• Using Table Expressions

• Using Set Operators

• Using Window Ranking, Offset, and Aggregate Functions

• Pivoting and Grouping Sets

• Querying data with Stored Procedures

• Programming with T-SQL

• Implementing Error Handling

• Implementing Transactions

• Improving Query Performance (Optional)

• Querying SQL Server Metadata (Optional)

Advanced (2 days)

optional

optional

Visit

Setiabudi 2 Building. 6th Floor. Unit 606. Jl. HR. Rasuna Said. Kav. 62. Jakarta Selatan. Indonesia

 

Call

T: +62-21-521-0793
F: +62-21-521-0794

 

Contact         @ExecuTrain_JKT

sales@executrain.co.id

  • w-tbird

 2013 by ExecuTrain of Jakarta.