This 5-day Querying Microsoft SQL Server 2014 Exam 70-461 Training course delivers foundational knowledge to frame the Transact-SQL queries for Microsoft SQL Server 2014, by giving attention to various disciplines namely, Business Administration, Business Development, & Business Intelligence.
This course is designed for professionals who seek interest in learning SQL Server 2012 or 2014.
This course will help you prepare for the Exam 70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL and will earn you a certification of MCSA: SQL 2014.
Module 1: Introduction to Microsoft SQL Server 2014
This module describes and introduces the SQL Server platform and major tools.
Module 2: Introduction to T-SQL Querying
This module describes Transact-SQL as the primary querying language of SQL Server.
Module 3: Writing SELECT Queries
This module defines the fundamentals of the SELECT statement, focusing on queries against a single table.
Module 4: Querying Multiple Tables
In this module, you will learn how to write queries that combine data from multiple sources in SQL Server.
Module 5: Sorting and Filtering Data
This module explains how to enhance queries to limit the rows they return, and to control the order in which the rows are displayed.
Module 6: Working with SQL Server 2014 Data Types
This module describes the data types SQL Server uses to store data. It also explains conversions between data types, and the importance of type precedence.
Module 7: Using DML to Modify Data
This module explains the use of Transact-SQL Data Manipulation Language to perform data inserts, updates, and deletes.
Module 8: Using Built-In Functions
This module introduces the use of functions that are built into SQL Server Denali.
Module 9: Grouping and Aggregating Data
In this module you will learn methods for grouping data within a query, aggregating the grouped data and filtering groups with HAVING.
Module 10: Using Subqueries
This module will introduce the use of subqueries in various parts of a SELECT statement.
Module 11: Using Table Expressions
This module explains T-SQL expressions which return a valid relational table, typically for further use in the query.
Module 12: Using Set Operators
This module defines the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets
Module 13: Using Window Ranking, Offset, and Aggregate Functions
This module describes window functions including ranking, aggregate and offset function. Much of this functionality is new to SQL Server 2012.
Module 14: Pivoting and Grouping Sets
This module explains techniques for pivoting data in T-SQL as well to introduce the fundamentals of the GROUPING SETS clause.
Module 15: Querying data with Stored Procedures
This module describes the use of existing stored procedures in a T-SQL querying environment. Lessons
Module 16: Programming with T-SQL
This module gives basic information about T-SQL programming concepts and objects.
Module 17: Implementing Error Handling
This module describes the use of error handlers in T-SQL code.
Module 18: Implementing Transactions
This module describes the concepts of transaction management in SQL Server.
Module 19: Appendix 1: Improving Query Performance
This module discusses several key guidelines for writing well-performing queries, as well as ways to monitor the execution of your queries.
Module 20: Appendix 2: Querying SQL Server Metadata
SQL Server provides access to structured metadata by using a variety of mechanisms. In this module, you will learn how to write queries to return system metadata using these mechanisms.
The 20461: Querying Microsoft SQL Server 2014 (Exam 70-461) training course is ideal for those working with the profiles of:
|Microsoft Certified Professional (MCP) - [70-461]||70-461||USD 108|
I want to express the extent of my admiration and appreciation for the organization and the effort you had made for the sake to success the training I did particularly and the success to the Institute generally. What I have seen during the past few days will be an opportunity to return again and recommend the Institute among colleagues. Interacting with many tools and share information with the students. Moreover, to that the instructor provides activities and demonstrates the process for running tools in live mode.
I like Mercury Solutions, they provided me with what they promised. All communication with the staff was good. All the tactics used to impart training was good. The trainer was an awesome person. He has a vast knowledge and knows how to train a student, he taught me with all the possibilities in the security field. He knows his subject very well. I highly recommend the trainer for all the security related trainings. The company guest house and the staff was very good. The overall transportation was also good and the drivers are helpful. They also sent me for city tours which were awesome.
I am really delighted about the SQL Training course: Querying Microsoft SQL Server with Mercury Solutions. Every session was great and very valuable. Practical application made the course significantly more valuable. The thing most impressive was the way the entire programme was structured. Instructor is having great experience and diverse knowledge in SQL Server. I am looking for learning Administering Microsoft SQL Server 2014 Databases with same trainer.
I came to make resolution to learn Cisco Security, so I chose Mercury Solutions. I learnt a lot and gained a lot. Presently, I became CCNA certified and EC-Council Penetration Tester. I learnt a lot from good lectures and from trainers, and also I enjoyed a lot and I would advise all to come down and learn."
Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.