Description
Course Description
The Querying Microsoft SQL Server with Transact-SQL course covers the basics of the SQL language as implemented by Microsoft SQL Server. The course is designed to give delegates practical experience in writing Transact-SQL statements. This will be done using the SQL Server Management Studio (SSMS) development environment. The basic Transact-SQL statements, including the use of many built-in Transact-SQL functions are covered on this course. Most importantly, this course covers Microsoft SQL Server up to version 2014. At the same time,this course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. In addition,this course is the foundation for all SQL Server-related disciplines, namely;
- Database Administration
- Database Development
- Business Intelligence
. This course helps people prepare for exam 70-761.
Learning Objectives
To provide the Transact-SQL (T-SQL) coding skills needed to query and modify data held within a Microsoft SQL Server database.
Requirements For Querying Microsoft SQL Server
- The delegate must have a working knowledge of relational database. Also, possess some basic understanding of Microsoft Windows operating the system and other Microsoft programs.
- General computer knowledge.
Exams & Certification
This course will cover some of the topics required for exam:
- 70-761:Querying Data with Transact-SQL
Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience.
- Start your prep for the Microsoft MCSA 70-461 certification exam with the MCSA/MCSE – Querying Microsoft SQL Server 2012/2014 course and lab. Lab delivers a hands-on experience replacing expensive physical labs. The course and lab completely cover the MCSA 70-461 exam objectives and provide an understanding on topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions, and more.
Related copurses: MTA: Database Fundamentals