Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price Enroll
40 Hrs Weekend Evening-Batch USD 500 400

Enroll Now
40 Hrs Weekend Morning-Batch USD 500 400

Enroll Now
40 Hrs Weekdays Morning-Batch USD 500 400

Enroll Now
40 Hrs Weekdays Evening-Batch USD 500 400

Enroll Now

About Course

This course is a perfect choice for those candidates who are interested in learning SQL Server 2012 / 2014. This course will also covers all the new features introduced in SQL Server 2014.

The best suited audience for this course can be-

Database Administrators
Database Developers
Business Intelligence Professionals
Business Analysts
Client Application Developers
This course is designed to train you from very basic concepts of Microsoft SQL Server to advance level. In this course you will get complete knowledge which required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for those people who are preparing for the certification exam Querying Microsoft SQL Server 2012/2014 (Exam code - 70-461).
After completing this course, you will be able -

To understand basic architecture and concepts of Microsoft SQL Server 2012 / 2014.
To understand what is Transact-SQL
To find the similarities and differences between Transact-SQL and other computer languages.
To write SELECT queries with multiple tables
To sort and filter records
To use various window ranking, offset and aggregate functions
To work with stored procedures
To handle errors
There is no formal prerequisite to join this course but having a fundamental knowledge about RDBMS and Microsoft Windows Operating System will help you to cover this course in a quick way.


Microsoft SQL Server 2012

  • 1.1 The Basic Architecture of SQL Server
  • 1.2 SQL Server Editions and Versions
  • 1.3 Getting Started with SQL Server Management Studio
  • 2.1 Introducing T-SQL
  • 2.2 Understanding Sets
  • 2.3 Understanding Predicate Logic
  • 2.4 Understanding the Logical Order of Operations in SELECT statements
  • 3.1 Writing Simple SELECT Statements
  • 3.2 Eliminate Duplicates with DISTINCT
  • 3.3 Using Column and Table Aliases
  • 3.4 Write Simple CASE Expressions
  • 4.1 Understanding Joins
  • 4.2 Querying with Inner Joins
  • 4.3 Querying with Outer Joins
  • 4.4 Querying with Cross Joins and Self Joins
  • 5.1 Sorting Data
  • 5.2 Filtering Data with Predicates
  • 5.3 Filtering with the TOP and OFFSET-FETCH
  • 5.4 Working with Unknown Values
  • 6.1 Introducing SQL Server 2014 Data Types
  • 6.2 Working with Character Data
  • 6.3 Working with Date and Time Data
  • 7.1 Inserting Data
  • 7.2 Modifying and Deleting Data
  • 8.1 Writing Queries with Built-In Functions
  • 8.2 Using Conversion Functions
  • 8.3 Using Logical Functions
  • 8.4 Using Functions to Work with NULL
  • 9.1 Using Aggregate Functions
  • 9.2 Using the GROUP BY Clause
  • 9.3 Filtering Groups with HAVING
  • 10.1 Writing Self-Contained Subqueries
  • 10.2 Writing Correlated Subqueries
  • 10.3 Using the EXISTS Predicate with Subqueries
  • 11.1 Using Views
  • 11.2 Using Inline Table-Valued Functions
  • 11.3 Using Derived Tables
  • 11.4 Using Common Table Expressions
  • 12.1 Writing Queries with the UNION Operator
  • 12.2 Using EXCEPT and INTERSECT
  • 12.3 Using APPLY
  • 13.1 Creating Windows with OVER
  • 13.2 Exploring Window Functions
  • 14.1 Writing Queries with PIVOT and UNPIVOT
  • 14.2 Working with Grouping Sets
  • 15.1 Writing Queries with PIVOT and UNPIVOT
  • 15.2 Passing Parameters to Stored Procedures
  • 15.3 Creating Simple Stored Procedures
  • 15.4 Working with Dynamic SQL
  • 16.1 T-SQL Programming Elements
  • 16.2 Controlling Program Flow
  • 17.1 Using TRY / CATCH Blocks
  • 17.2 Working with Error Information
  • 18.1 Transactions and the Database Engine
  • 18.2 Controlling Transactions

Exam & Certification

The exam Querying Microsoft SQL Server 2012/2014 is designed and maintained by Microsoft for validating any individual’s technical ability to accomplish various task on SQL Server 2012/2014 Database.
Exam Code: 70-461
Languages: English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)
Audiences: IT professionals
Technology: Microsoft SQL Server 2012/2014
Credit towards certification: MCP, MCSA, MCSE
Number of Questions: 50
Question Type: Multiple Choice Questions
Passing Score: 70%
Exam Timing/ Duration: 120 Minutes

** The above course information is taken from Microsoft.

* Money Back Guarantee till demo and 1st class of the course.

Enhance your Skill

Drop us a Query

Copyright © 2015, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.