GK6552A Querying Microsoft SQL Server 2014 (20461_D)

0% of 47 hours and 36 minutes completed.

In this course, you will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2014. This is the foundational course for all SQL server related disciplines: database administration, database development and business intelligence. Tools and skills you will learn include: SQL Server Management Studio, T-SQL, SELECT statements in querying multiple tables, data types, data sorting and filtering, data manipulation language (DML), grouping and aggregating data, table expressions, set operators, window functions, T-SQL programming, error handlers, and transaction management in SQL Server.

This course is designed for customers interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features of SQL Server 2014 as well as the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20461: Querying Microsoft SQL Server 2014. It covers the skills and knowledge measured by Exam 70-461 and along with on-the-job experience, helps you prepare for the exam.

After completing this course, you will be able to:

  • SELECT query writing
  • Query multiple tables
  • Sort and filter data
  • Data types in SQL Server
  • Data modification using T-SQL
  • Built-in functions
  • Group and aggregate data
  • Set operators
  • Window functions: ranking, offset, and aggregate
  • Pivot and group sets
  • T-SQL programming
  • Error handling and transaction implementation
There are no resources available.
0 attachments
0%
Introduction to Microsoft SQL Server 2014
3 hours 1 minute 23 Activities: Article  (0)  |  Lab  (9)  |  Video  (14)
0%
Introduction to T-SQL Querying
1 hour 55 minutes 30 Activities: Article  (0)  |  Lab  (9)  |  Video  (21)
0%
Writing SELECT Queries
2 hours 19 minutes 25 Activities: Article  (0)  |  Lab  (9)  |  Video  (16)
0%
Querying Multiple Tables
2 hours 50 minutes 30 Activities: Article  (0)  |  Lab  (9)  |  Video  (21)
0%
Sorting and Filtering Data
2 hours 29 minutes 24 Activities: Article  (0)  |  Lab  (9)  |  Video  (15)
0%
Working with SQL Server 2014 Data Types
3 hours 1 minute 29 Activities: Article  (0)  |  Lab  (9)  |  Video  (20)
0%
Using DML to Modify Data
1 hour 55 minutes 24 Activities: Article  (0)  |  Lab  (9)  |  Video  (15)
0%
Using Built-In Functions
2 hours 35 minutes 31 Activities: Article  (0)  |  Lab  (9)  |  Video  (22)
0%
Grouping and Aggregating Data
2 hours 48 minutes 24 Activities: Article  (0)  |  Lab  (9)  |  Video  (15)
0%
Using Subqueries
2 hours 11 minutes 22 Activities: Article  (0)  |  Lab  (9)  |  Video  (13)
0%
Using Table Expressions
3 hours 34 minutes 27 Activities: Article  (0)  |  Lab  (9)  |  Video  (18)
0%
Using Set Operators
2 hours 8 minutes 21 Activities: Article  (0)  |  Lab  (9)  |  Video  (12)
0%
Using Window Ranking, Offset, and Aggregate Functions
2 hours 22 minutes 24 Activities: Article  (0)  |  Lab  (9)  |  Video  (15)
0%
Pivoting and Grouping Sets
1 hour 56 minutes 19 Activities: Article  (0)  |  Lab  (9)  |  Video  (10)
0%
Executing Stored Procedures
2 hours 11 minutes 22 Activities: Article  (0)  |  Lab  (9)  |  Video  (13)
0%
Programming with T-SQL
2 hours 33 minutes 21 Activities: Article  (0)  |  Lab  (9)  |  Video  (12)
0%
Implementing Error Handling
1 hour 47 minutes 23 Activities: Article  (0)  |  Lab  (9)  |  Video  (14)
0%
Module 18 Overview: Implementing Transactions
1 hour 38 minutes 21 Activities: Article  (0)  |  Lab  (9)  |  Video  (12)
0%
Appendix A: Improving Query Performance
1 hour 56 minutes 24 Activities: Article  (0)  |  Lab  (9)  |  Video  (15)
0%
Appendix B: Querying SQL Server Metadata
1 hour 45 minutes 23 Activities: Article  (0)  |  Lab  (9)  |  Video  (14)
0%
Course Conclusion: GK6552A Querying Microsoft SQL Server 2014
2 minutes 1 Activity: Article  (0)  |  Lab  (0)  |  Video  (1)
0%
Knowledge Assessment: End of Course Questions
25 minutes 25 Activities: Article  (0)  |  Lab  (25)  |  Video  (0)
0%
Survey
5 minutes 1 Activity: Article  (1)  |  Lab  (0)  |  Video  (0)