Cart ()

    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 Trainingab

    Classroom--

    • 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
    Online Training

    Online Training--

    • 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
    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.

    View more

    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