Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price # Enroll Book free demo
Weekend
40 Hrs Weekend Evening-Batch USD 500
INR 22000
Enroll Now Book free demo class
Weekend
40 Hrs Weekend Morning-Batch USD 500
INR 22000
Enroll Now Book free demo class
Weekdays
40 Hrs Weekdays Morning-Batch USD 500
INR 22000
Enroll Now Book free demo class
Weekdays
40 Hrs Weekdays Evening-Batch USD 500
INR 22000
Enroll Now Book free demo class

# Cloud lab charges will be extra. Our technical consultant will share actual lab charges with you.

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.

CURRICULUM

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

Select Trainer for Demo


Harshal kamble
Certification:
From
Professional Experience
Training Experience

Qualification
M.Tech

Skills
Database, Java , Java Script, JQuery , MySQL , Spring, Struts,

Profile
I have 5 years of total experience in IT world. Mo stly working on Database Technologies and experties in Database Performince Tunning. Read More...
RATING & REVIEWS
Satish Reddy
Certification: Microsoft Certified Trainer (MCT) , Microsoft Dynamics CRM
From
Professional Experience
Training Experience

Qualification
B Tech

Skills
.NET, ASP.NET MVC, CRM, Microsoft Dynamics CRM, SQL,

Profile
Dynamics CRM architect and MCT certified trainer a uthorized to deliver CRM official curriculum from Microsoft. Conducted onsite instructor led trainings for 1. Microsoft 2. Infosys 3. TCS 4. HP 5. SA Global 6. Syntel 7. SFW 8. Capgemini 9. Nitor etc. 10. AllState, Chicago. 11. Hitachi Consulting. 12. Tata Technologies 13. CGI 14. Tata Technologies 15. Ericsson Read More...
RATING & REVIEWS
Thania Kruger
Satish has a number of strengths to offer, communicates well with clients and co-workers and is very well organized and dependable. Always interacted well with the team and is reliable and shows good judgment. He will go the extra mile to ensure a job is done and well done.
Santosh Artham
Satish is very good at designing and implementing business solutions in Dynamics CRM, his in-depth knowledge in CRM helps him in delivering efficient solutions. i personally gained lot of CRM concepts by working with him.
Manu Kapoor
I worked with Satish very closely a few years ago. I thoroughly enjoyed working with him and valued him deeply as a team member. He has a very good attitude towards learning new things and going deep into the subject. He always had a solution to any technical problem and his can-do attitude made it very easy to work with him. I wish him all the best in his future endeavors and I am sure he will continue to shine wherever he goes.
Ravi Prakash Reddy Lonka
Satish has natural talent and skills that he has carried from the college days.
Disclaimer

** The above course information is taken from Microsoft.

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


Copyright ©2015 Hub4Tech.com, 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.
FOLLOW US