Querying Microsoft SQL Server 2014 overview
Querying Microsoft SQL server 2014 is the foundation for all SQL Server-related disciplines: Database Administration, Database Development and Business Intelligence. Our SQL Server training will enable you to start managing your data and learn all the basic tools in SQL Server Management Studio.
Students will learn technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014.
Instructor Led Learning
Duration: 5 Days
Registration Open Now!
Video Learning
Duration: 5 Days
Registration Open Now!
What you will learn
-
- Orientation Lesson Welcome to MastergradeIT
- Lesson 1 Introduction to Microsoft SQL Server 2014
- Lesson 2 Introduction to T-SQL Querying
- Lesson 3 Writing SELECT Queries
- Lesson 4 Querying Multiple Tables
- Lesson 5 Sorting and Filtering Data
- Lesson 6 Working with SQL Server 2014 Data Types
- Lesson 7 Using DML to Modify Data
- Lesson 8 Using Built-In Functions
- Lesson 9 Grouping and Aggregating Data
- Lesson 10 Using Subqueries
- Lesson 11 Using Set Operators
- Lesson 12 Using Window Ranking, Offset, and Aggregate Functions
- Lesson 13 Pivoting and Grouping Sets
- Lesson 14 Executing Stored Procedures
- Lesson 15 Programming with T-SQL
- Lesson 16 Implementing Error Handling
- Lesson 17 Implementing Transactions
- Lesson 18 Improving Query Performance
- Lesson 19 Querying SQL Server Metadata
FULL COURSE OUTLINE
Join Over 10,000 Students that have studied with MasterGrade IT Now
Become Part of MasterGrade IT to Further Your Career.
