• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/05/2018 11/09/2018
  • VLT
Live Online
12/03/2018 12/07/2018
  • VLT
Live Online

20461: Querying Microsoft SQL Server 2014 Course Overview

This 5-day educator drove course gives understudies the specialized abilities required to compose essential Transact-SQL questions for Microsoft SQL Server 2014. This course is the establishment for all SQL Server-related controls; specifically, Database Administration, Database Development and Business Intelligence. The primary motivation behind the course is to plan individuals for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the fundamental exam for all SQL Server-related controls; specifically, Database Administration, Database Development and Business Intelligence. All things considered, the essential target gathering of people for this course is: Database Administrators, Database Developers and BI experts.. 

Note: 20461: Querying Microsoft SQL Server 2014 course is intended for clients who are occupied with learning SQL Server 2012 or SQL Server 2014. It covers the new elements in SQL Server 2014, yet in addition the essential capacities over the SQL Server information stage. 

20461: Querying Microsoft SQL Server 2014 Audience Profile 

20461: Querying Microsoft SQL Server 2014 Course is planned for Database Administrators, Database Developers, and Business Intelligence experts. The course will probably be all around went to by SQL control clients who aren't really database-centered or design around taking the exam; to be specific, report journalists, business experts and customer application engineers. 

20461: Querying Microsoft SQL Server 2014 At Course Completion

Subsequent to finishing this course, understudies will have the capacity to: 

  • Depict the essential engineering and ideas of Microsoft SQL Server 2014. 
  • Comprehend the similitudes and contrasts between Transact-SQL and other coding languages. 
  • Compose SELECT questions 
  • Question various tables 
  • Sort and channel information 
  • Depict the utilization of information sorts in SQL Server 
  • Adjust information utilizing Transact-SQL 
  • Utilize worked in capacities 
  • Gathering and total information 
  • Utilize subqueries 
  • Utilize table articulations 
  • Utilize set administrators 
  • Utilize window positioning, balance and total capacities 
  • Actualize rotating and gathering sets 
  • Execute put away techniques 
  • Program with T-SQL 
  • Actualize blunder dealing with 
  • Actualize exchanges 

20461: Querying Microsoft SQL Server 2014 Course Outline 

1 - Introduction to Microsoft SQL Server 2014 

  • The Basic Architecture of SQL Server 
  • SQL Server Editions and Versions 
  • Beginning with SQL Server Management Studio 
  • Lab : Working with SQL Server 2014 Tools 

2 - Introduction to T-SQL Querying 

  • Presenting T-SQL 
  • Understanding Sets 
  • Understanding Predicate Logic 
  • Understanding the Logical Order of Operations in SELECT proclamations 
  • Lab : Introduction to Transact-SQL Querying 

3 - Writing SELECT Queries 

  • Composing Simple SELECT Statements 
  • Wiping out Duplicates with DISTINCT 
  • Utilizing Column and Table Aliases 
  • Composing Simple CASE Expressions 
  • Lab : Writing Basic SELECT Statements 

4 - Querying Multiple Tables 

  • Understanding Joins 
  • Questioning with Inner Joins 
  • Questioning with Outer Joins 
  • Questioning with Cross Joins and Self Joins 
  • Lab : Querying Multiple Tables 

5 - Sorting and Filtering Data 

  • Arranging Data 
  • Separating Data with a WHERE Clause 
  • Separating with the TOP and OFFSET-FETCH Options 
  • Working with Unknown and Missing Values 
  • Lab : Sorting and Filtering Data 

6 - Working with SQL Server 2014 Data Types 

  • Presenting SQL Server 2014 Data Types 
  • Working with Character Data 
  • Working with Date and Time Data 
  • Lab : Working with SQL Server 2014 Data Types 

7 - Using DML to Modify Data 

  • Embeddings Data 
  • Altering and Deleting Data 
  • Lab : Using DML to Modify Data 

8 - Using Built-In Functions 

  • Composing Queries with Built-In Functions 
  • Utilizing Conversion Functions 
  • Utilizing Logical Functions 
  • Utilizing Functions to Work with NULL 
  • Lab : Using Built-In Functions 

9 - Grouping and Aggregating Data 

  • Utilizing Aggregate Functions 
  • Utilizing the GROUP BY Clause 
  • Separating Groups with HAVING 
  • Lab : Grouping and Aggregating Data 

10 - Using Subqueries 

  • Keeping in touch with Self-Contained Subqueries 
  • Composing Correlated Subqueries 
  • Utilizing the EXISTS Predicate with Subqueries 
  • Lab : Using Subqueries 

11 - Using Table Expressions 

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

12 - Using Set Operators 

  • Composing Queries with the UNION Operator 
  • Utilizing EXCEPT and INTERSECT 
  • Utilizing APPLY 
  • Lab : Using Set Operators 

13 - Using Window Ranking, Offset, and Aggregate Functions 

  • Making Windows with OVER 
  • Investigating Window Functions 
  • Lab : Using Window Ranking, Offset and Aggregate Functions 

14 - Pivoting and Grouping Sets 

  • Composing Queries with PIVOT and UNPIVOT 
  • Working with Grouping Sets 
  • Lab : Pivoting and Grouping Sets 

15 - Executing Stored Procedures 

  • Questioning Data with Stored Procedures 
  • Passing Parameters to Stored Procedures 
  • Making Simple Stored Procedures 
  • Working with Dynamic SQL 
  • Lab : Executing Stored Procedures 

16 - Programming with T-SQL 

  • T-SQL Programming Elements 
  • Controlling Program Flow 
  • Lab : Programming with T-SQL 

17 - Implementing Error Handling 

  • Utilizing TRY/CATCH Blocks 
  • Working with Error Information 
  • Lab : Implementing Error Handling 

18 - Implementing Transactions 

  • Exchanges and the Database Engine 
  • Controlling Transactions 
  • Separation Levels 
  • Lab : Implementing Transactions
  • Working information of social databases. 
  • Essential information of the Microsoft Windows working framework and its center usefulness

Awards