This course is a perfect choice for those candidates who are interested in learning SQL Server 2012 / 2014. This course will also covers all the new features introduced in SQL Server 2014.
The best suited audience for this course can be-
Business Intelligence Professionals
Client Application Developers
This course is designed to train you from very basic concepts of Microsoft SQL Server to advance level. In this course you will get complete knowledge which required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for those people who are preparing for the certification exam Querying Microsoft SQL Server 2012/2014 (Exam code - 70-461).
After completing this course, you will be able -
To understand basic architecture and concepts of Microsoft SQL Server 2012 / 2014.
To understand what is Transact-SQL
To find the similarities and differences between Transact-SQL and other computer languages.
To write SELECT queries with multiple tables
To sort and filter records
To use various window ranking, offset and aggregate functions
To work with stored procedures
To handle errors