Chat with us, powered by LiveChat
Home > Querying Data with Transact-SQL (MOC 20761)

Querying Data with Transact-SQL (MOC 20761)

70-761 Querying Data with Transact-SQL Exam

 Querying Data with Transact-SQL (MOC 20761)

Course Duration: 3 Days

70-761 Querying Data with Transact-SQL

What Students Receive

Each student will receive:

  • Expert instruction from a SQL Server Trainer
  • A printed courseware manual with samples and hands-on exercises for use during and after class.
  • Sample course files and solutions
  • Access to a complete, online SQL Server lab environment both during and after class to practice your new skills.
  • A course completion certificate upon successful completion of the course

Course Description

In this Querying Data with Transact-SQL Training course, students will learn how to use T-SQL to select, modify and delete data. In addition, students will learn about SQL Server data types, how to use built-in functions in T-SQL statements, how to write subqueries, how to implement views and create and use stored procedures and how to use programming constructs in T-SQL such as loops, variables and conditions. In addition, this course helps prepare students who are interested in either moving on to other more in-depth SQL Server courses or who are preparing to take the Microsoft 70-761 Querying Data with Transact-SQL certification exam.

Course Audience

The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

Course Prerequisites

To ensure success in this course, students should have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.

Certification Exam

This course helps prepare students to take the 70-761 Querying Data with Transact-SQL Exam

Download Class Outline and Class Modules 70-761 Querying Data with Transact-SQL

Enter phone number
Enter Course Name

 

Share with your followers...
Email this to someone
email
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
ga('send', 'pageview');
× Chat with us!