Skype | Facebook | Google+ | Home | Sitemap | Contact us | +92 321 3499131











 
ICT Offers
Partnership
Online Training

SQL Server 2014

SQL Server training curriculum is carefully designed to meet the requirements of Microsoft exam: Querying Microsoft SQL Server 70-461. Course helps developing strong understanding of Microsoft SQL Server and development foundation.

[Download Outline]

SQL Server Course Contents

Introduction to Microsoft SQL Server 2014

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio

Introduction to T-SQL Querying

  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements

Writing SELECT Queries

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions

Querying Multiple Tables

  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins

Sorting and Filtering Data

  • Sorting Data
  • Filtering Data with a WHERE Clause
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown and Missing Values

Working with SQL Server 2014 Data Types

  • Introducing SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data

Using DML to Modify Data

  • Inserting Data
  • Modifying and Deleting Data

Using Built-In Functions

  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL

Grouping and Aggregating Data

  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING

Using Subqueries

  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries

Using Table Expressions

  • Using Derived Tables
  • Using Common Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions

Using Set Operators

  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY

Using Window Ranking, Offset, and Aggregate Functions

  • Creating Windows with OVER
  • Exploring Window Functions

Pivoting and Grouping Sets

  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets

Executing Stored Procedures

  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL

Programming with T-SQL

  • T-SQL Programming Elements
  • Controlling Program Flow

Implementing Error Handling

  • Using TRY / CATCH Blocks
  • Working with Error Information

Implementing Transactions

  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels

Improving Query Performance

  • Factors in Query Performance
  • Displaying Query Performance Data

Querying SQL Server Metadata

  • Querying System Catalog Views and Functions
  • Executing System Stored Procedures
  • Querying Dynamic Management Objects

 

Practical Approach

A real-time examples, will be given throughout the lectures.

 

www.ict-trainings.com/curriculum/sqlserver-leaflet.pdf


Training Schedule
Download Full Calendar


26 Jan 2017

MCSE-2012
Thu-Fri-Sat 07:00 PM-09:00 PM


28 Jan 2017

Linux
Sat-Sun 05:30 PM-08:30 PM


Quick Links
Web Designing & Development Android Mobile App Development SEO Internet Marketing MCSE CCNA CCNP
Home

Contact

Web Development

Java Android

.NET

Graphics Designing

AutoCAD

MCSE 2012

CCNA

CCNP & CCIE

SharePoint 2013

Spoken English

Ms Office

IELTS
ICT Trainings facebook Icon ICT Trainings Twitter Icon ICT Google Plus Icon ICT Trainings Google Plus Icon ICT Trainings linkedin Icon
Coming Soon ICT Trainings App!
ICT Trainings - iTunes App ICT Trainings - Google Play App
ict

© Copyright 2007-2017 - ICT Trainings - All rights reserved.
Designed by Creative.