ssdn

Cart (0)

  • Cart Is Empty

70-461 Microsoft SQL Server 2014 Certification Training

Overview

TOP

This associate level program is comprised of two courses of which the Course 20461D is first one. Microsoft launched this course to update students with the technical skills and professional knowledge required in writing basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2014. This official course by Microsoft prepares students for the Exam 70-461. This course is considered as a foundation for all other courses in SQL server discipline such as Database Development, Database Administration, and Business Intelligence.

The course training at SSDN Technologies, a Microsoft partner and leading SQL Server Training Institute in Gurgaon goes combined having both theoretical and official lab practical experience. With the course credential from SSDN, your hiring value enormously increases. 

What will you learn

TOP

Successful completion of the course will increase your competency and make you proficient in –

  •  Describing the basic concepts and architecture of MS SQL Server 2014 
  •  Understanding about the differences and similarities between T-SQL and other such computer languages 
  •  Writing SELECT queries; Sorting and filtering data 
  •  Querying multiple tables 
  •  Describing uses of data types in MS SQL Server 
  •  Modifying data using T-SQL, using built-in functions 
  •  Data grouping and aggregation 
  •  Using subqueries, set operators, table expressions, window ranking,  offset and aggregate functions 
  •  Implementing pivoting and grouping sets 
  •  Programming with T-SQL 
  •  Executing stored procedures 
  •  Implementing Transactions and error handling 

Module 1: Introduction to Microsoft SQL Server 2014

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

Module 2: Introduction to T-SQL Querying

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

Module 3: Writing SELECT Queries

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

Module 4: Querying Multiple Tables

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

Module 5: Sorting and Filtering Data

  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH
  • Working with Unknown Values

Module 6: Working with SQL Server 2014 Data Types

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

Module 7: Using DML to Modify Data

  • Inserting Data
  • Modifying and Deleting Data

Module 8: Using Built-In Functions

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

Module 9: Grouping and Aggregating Data

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

Module 10: Using Subqueries

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

Module 11: Using Table Expressions

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

Module 12: Using Set Operators

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

Module 13: Using Window Ranking, Offset, and Aggregate Functions

  • Creating Windows with OVER
  • Exploring Window Functions

Module 14: Pivoting and Grouping Sets

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

Module 15: Querying data with Stored Procedures

  • Writing Queries with PIVOT and UNPIVOT
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL

Module 16: Programming with T-SQL

  • T-SQL Programming Elements
  • Controlling Program Flow

Module 17: Implementing Error Handling

  • Using TRY / CATCH Blocks
  • Working with Error Information

Module 18: Implementing Transactions

  • Transactions and the Database Engine
  • Controlling Transactions

Module 19: Appendix 1: Improving Query Performance

  • Factors in Query Performance
  • Displaying Query Performance Data

Module 20: Appendix 2: Querying SQL Server Metadata

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

What will you get

TOP

  •  A certificate of successful completion of the course 
  •  Opportunity to get trained in Microsoft official labs 
  •  Training from highly experienced Microsoft certified trainers 
  •  Microsoft official course content 

Mode of Training

TOP

Instructor Led TrainingInstructor-led

Instructor-led--

  • Group TrainingGroup Training
  • 1-on-1 training at Additional Cost1-on-1 training at Additional Cost
  • Instructor-led live interactive TrainingInstructor-led live interactive Training
  • Intensive Hands-on Exposure Intensive Hands-on Exposure
  • Lab AccessLab Access
  • Course Completion CertificateCourse Completion Certificate
  • CoursewareCourseware
  • Exam VoucherExam Voucher
E-learning Training

E-learning--

  • 1-on-1 training at Additional Cost1-on-1 training at Additional Cost
  • Lab AccessLab Access
  • Course Completion CertificateCourse Completion Certificate
  • CoursewareCourseware
  • Exam VoucherExam Voucher
Boot camp

Boot Camp--

  • Group TrainingGroup Training
  • 1-on-1 training at Additional Cost1-on-1 training at Additional Cost
  • Instructor-led live interactive TrainingInstructor-led live interactive Training
  • Intensive Hands-on Exposure Intensive Hands-on Exposure
  • Lab AccessLab Access
  • Course Completion CertificateCourse Completion Certificate
  • CoursewareCourseware

Training on Demand--

  • Group TrainingGroup Training
  • 1-on-1 training at Additional Cost1-on-1 training at Additional Cost
  • Instructor-led live interactive TrainingInstructor-led live interactive Training
  • Intensive Hands-on Exposure Intensive Hands-on Exposure
  • Lab AccessLab Access
  • Course Completion CertificateCourse Completion Certificate
  • CoursewareCourseware
  • Exam VoucherExam Voucher

Pre-requisite

TOP

Along with professional experience, participants to this course need to possess working knowledge of –

  •  Windows Operating Systems (OS) and its various functions 
  •  Relational database Systems 

Target Audience

TOP

  •  The course is designed for database developers and administrators and Business Intelligence professionals 
  •  The course is also suited for SQL power users such as business analysts, report writers, and client application developers 

Why Choose SSDN

TOP

  •  The Microsoft Certified Solutions Associates (MCSA) SQL Server 2012/2014 program is a product of Microsoft and SSDN is an authorized training partner of Microsoft 
  •  Availability of course in various delivery mode 
  •  A knowledge delivery is critical to the successful completion of the course and SSDN boasts of its highly experienced trainers for the purpose 
  •  Well-equipped labs at SSDN makes the whole learning environment innovative and motivating 
  •  The participants to the course get involved in live projects which elevate the overall experience to a practical level 
  •  At SSDN, the work ethics and values are moulded in such a way that inspires to grow and the participants learn something new valuable apart from the curriculum 
  •  Standard methodology of training would please and instill confidence in you 

Testimonials

TOP

FAQ

TOP

SSDN Technologies provides the 70-461 Microsoft SQL Server 2014 Training course from the experts and the duration of this course is 5 Days. We also provide fast-track batch for Microsoft SQL Server 2014 Training as per your requirement.

Feedback

TOP

5
1 ratings
5 Star
100%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
Leave Comments
Your email will not be published. Required field are marked*

 

Enquiry Form