Microsoft SQL Server 2016: Querying Transact-SQL (70-761)

$ 656.28

Microsoft SQL Server 2016: Querying Transact-SQL (70-761)

$ 656.28

Transact-SQL is how you communicate with a Microsoft SQL Server to add and retrieve data in their SQL Server databases, a key concept for IT professionals in many roles as the database lies at a crucial stage of operations for businesses in multiple industries.

In stock

SKU: EC113751 Category: Tags: ,
Only 4 items left in stock!

Description

Transact-SQL is how you communicate with a Microsoft SQL Server to add and retrieve data in their SQL Server databases, a key concept for IT professionals in many roles as the database lies at a crucial stage of operations for businesses in multiple industries.

This course is designed to give you a level of understanding of the Transact-SQL language that is good enough for you to not only pass the official 70-761 exam, but also practically implement the skills you learn when querying and managing data in a corporate environment to help efficiently run business IT and operations. People in job roles ranging from SQL Developer, DevOps, Database Administrator and Development will find the 70-761 beneficial to their career as it will teach you the core skills needed to manage a database, talk to the database server and store data for applications in a database.

The course is delivered to you through our convenient but effective online training platform where you will have unlimited access to the 18 hours of in-depth content which will guide you through how to query data with Transact-SQL in a Microsoft SQL Server using both basic and advanced protocols.

KEY LEARNING POINTS

  • Describe key capabilities and components of SQL Server
  • Describe T-SQL, sets, and predicate logic
  • Write a single table SELECT statement
  • Write a multi-table SELECT statement
  • Write SELECT statements with filtering and sorting
  • Describe how SQL Server uses data types
  • Write DML statements
  • Write queries that use built-in functions
  • Write queries that aggregate data
  • Write subqueries
  • Create and implement views and table-valued functions
  • Use set operators to combine query results
  • Write queries that use window ranking, offset, and aggregate functions
  • Transform data by implementing pivot, unpivot, rollup and cube
  • Create and implement stored procedures
  • Add programming constructs such as variables, conditions, and loops to T-SQL code

ADVANTAGES OF THE COURSE

  • Learn how to talk to the SQL Server to retrieve and input data
  • Talk to any version of the Microsoft database (including 2016, 2014 2012, even all the way back to 2000) with the skills you learn in this course
  • Learn how to master T-SQL and SQL Server with the help of subject matter experts with over 10 years’ experience in technical IT
  • 24-hour access to the course content, seven days a week for an entire year
  • This course includes a practice exam where you can become accustomed to the criteria needed for the official 70-761 exam

Brand

Microsoft Technical Course

Additional information

Course Access

Exam Included

Type of Course

Processor

1 gigahertz (GHz)

RAM

1 GB

Operating System

iOS, Mac OS, Windows 10, Windows 7, Windows 8

Browsers

Google Chrome, Internet Explorer 8 or above, Mozilla Firefox, Safari 6 or above

Compatibility

Android, iPad, iPhone, Mac, Windows

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.