MICROSOFT EXAM 70-461 QUERYING SQL SERVER 2012 ONLINE TRAINING BY LEARN365

Provided by Learning 247

  • Sector IT
  • Course Type Online
  • Duration Part-time
  • Ref LE-MS70461
  • Price £150.00 use code Jobstoday10 to get 10% discount

Enquire about this course

About the course

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is preparation for exam 70-461. 

COURSE OUTLINE„

Lesson 1: Getting Started with SQL Server 2012
Lesson 2: Working with T-SQL
Lesson 3: Writing SELECT Queries
Lesson 4: Working with SQL Data Types
Lesson 5: Sorting and Filtering Data
Lesson 6: Querying Data from Multiple Tables
Lesson 7: Modifying Data
Lesson 8: Working with SQL Server Built-in Functions
Lesson 9: Programming in T-SQL
Lesson 10: Implementing Stored Procedures
Lesson 11: Working with Subqueries and Table Expressions
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
Lesson 14: Managing Error Handling and Transactions
Lesson 15: Querying SQL Server System
Lesson 16: Optimizing Query Performance

Enquire

Start date Location / delivery
No fixed date Online Book now

Related article

5 Qualities Of Effective Leaders

We have all experienced terrible leaders, just what does it take to be a great leader? Here we give you the five qualities great leaders should have.