Microsoft 70-461: Querying SQL Server 2012

Develop the technical skills for successful querying of Microsoft SQL Server 2012 in this detailed course, designed to get you up-to-speed quickly and ready for the certification exam. Well begin with an overview of SQL Server 2012, its components and the various versions. Well delve into the built-in SQL tools, including SQL tools such as SQL Server Management Studio (SSMS) and SQL Profiler. Importantly, you'll learn how to write Transact-SQL (T-SQL) queries for SQL. You'll also master the fundamentals of working with SQL data types, sorting and filtering data, querying and modifying data, writing select queries, implementing stored procedures, and more. By completing this in-depth course, you'll be equipped to successfully complete the Querying Microsoft SQL Server 2012 (70-461) exam. You'll gain a solid understanding of how to utilize the SQL database and query with confidence.

Learning objectives:

• Utilize built-in SQL tools such as SQL Server Management Studio (SSMS)
• Generate Transact-SQL queries within Microsoft SQL Server 2012
• Identify the fundamentals of Microsoft SQL data types
• Demonstrate an ability to sort and filter a wide range of data
• Demonstrate knowledge in implementing stored procedures
• Develop the know-how to query and modify data