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

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

POWER OF CHOOSING YOUR TRAINER - TAKE DEMO FROM 3 TRAINERS AND SELECT


Harshal kamble
M.Tech
From
Professional Experience

Subject Expertise
Database

Certification

Profile
I have 5 years of total experience in IT world. Mostly working on Database Technologies and experties in Database Performince Tunning.
RATING & REVIEWS
Ramesh
MCA
From
Professional Experience

Subject Expertise
Server

Certification

Profile
I have 8+ years of experience as SQL Server DBA .
RATING & REVIEWS
Afzal Saleem
B Tech
From
Professional Experience

Subject Expertise
Database

Certification

Profile
He is having 9+ years of experience.
RATING & REVIEWS
Kanika Shrivastava
B.TECH(ECE)
From
Professional Experience

Subject Expertise
Microsoft

Certification

Profile
I am Trained, certified and experienced with SQL Server. Having 3+ years exp in Microsoft SQL Server Development,Database Administration, Designing & Implementing Business Intelligence Solutions on SQL Server.
RATING & REVIEWS
Rammohan
B.tech(cs)
From
Professional Experience

Subject Expertise
Database

Certification

Profile
He is having 6+ years of experience.
RATING & REVIEWS
Amee Trivedi
MCA
From
Professional Experience

Subject Expertise
C, C++

Certification

Profile
I have completed my master in computer application. I have experience of 2 years in education field.
RATING & REVIEWS
Tapan Kapri
M.TECH
From
Professional Experience

Subject Expertise
Angular JS

Certification

Profile
I obtained MTech Degree in Information Technology and Diploma in Software Engineering.I am MCT for responsive Web with 9+ Years of experience in the IT industry as Programmer, Developer,Project Lead, Corporate Trainer & Consultant. Currently I am working as a Corporate Trainer for Web & Mobile Technologies. I am a having In depth exposure to Web Technology, Responsive Web Development, PHP, MYSQL, DRUPAL,WORDPRESS, JOOMLA, JAVA SCRIPT, ANGULAR JS,MS SQL SERVER .I always fascinated with live projects in Web development & I utilize hard earned knowledge in the field of Corporate Training. Core Competencies: � JAVA SCRIPT/JQUERY/ANGULAR JS/MEAN Stack � PHP � PHONEGAP, TITANIUM, XAMARIN � PHP � MYSQL/SQL SERVER � DRUPAL/WORDPRESS/JOOMLA/MAGENTO � RESPONSIVE WEB-HTML5, CSS3 � WEB ADMINISTRATION
RATING & REVIEWS
Vivek Agarwal
Msc IT
From
Professional Experience

Subject Expertise
Data Structure

Certification

Profile
Corporate Trainer cum Consultant Corporate Trainer Skills : RDBMS Oracle 11g DBA Oracle 12c DBA PLSQL 11g PLSQL 12c SQL LINUX ADMIN Unix Shell Script Oracle RAC MySQL Development MSSQL DBA POSTGRESQL DBA
RATING & REVIEWS
Praveen Madupu
Masters in Computer Applications
From
Professional Experience

Subject Expertise
Microsoft SQL Server

Certification

Profile
RATING & REVIEWS
T, Sanjay
M.E. (Computers)
From
Professional Experience

Subject Expertise
.NET

Certification

Profile
RATING & REVIEWS
Deepa kumari
Microsoft Certified
From
Professional Experience

Subject Expertise
Microsoft Dynamics CRM

Certification

Profile
RATING & REVIEWS
Bhawna Gunwani
MCA
From
Professional Experience

Subject Expertise
.NET

Certification

Profile
6+ Years of Experience in Training Industry with a clear and depth understanding of student handling, learning needs, data analysis, content delivery, content management and process orientation. Specialties Programming and Technologies : C, C++, Data Structure, C#.Net, VB.Net, Asp.Net, Asp.Net MVC, WCF, WPF, Entity Framework, NHibernate, Web Services, Web API, AngularJS, AJAX, JavaScript. RDBMS : Oracle SQL and PL/SQL, Oracle DBA Workshop I and II, OBIEE, Microsoft SQL Server and T-SQL, SQL DBA etc.
RATING & REVIEWS
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