Microsoft SQL Server 2016 Querying Transact-SQL

185.00

Online Learning Course available throughout Ireland on Microsoft SQL Server 2016 Querying Transact-SQL.

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

Additional information

COURSE ACCESS

1 Year

COMPATIBILITY

Android, iPad, iPhone, Mac, Windows

BROWSERS

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

OPERATING SYSTEMS

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