Transact-SQL (70-761) Online Training

Querying Data with Transact-SQL (70-761)

Learn querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL.

$ 70 / ₹ 5625 for 6 Months
Limited Period Anniversary Discount Price : $ 35 / ₹ 2812

21 Modules

33.27 Hours

Course Modules
Videos
  • Basic Concepts Part -1
    Preview 45 Mins : 0


  • Basic Concepts Part -2
    Preview 54 Mins : 0


  • Normalization
    Preview 39 Mins : 0


  • ER Modeling
    Preview 18 Mins : 0


Documents
Videos
  • SQL Server Installation Guide
    Preview 30 Mins : 0


  • SQL Server 2012 Installation
    Preview 7 Mins : 0


  • Using SSMS to Connect to SQL Server
    Preview 13 Mins : 0


  • SQL Server 2016 Installation
    Preview 9 Mins : 0


  • SQL Server 2017 Installation
    Preview 18 Mins : 0


Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents
Videos
Documents

Overview

Microsoft SQL Server can be an intimidating system. In this course, instructor Vandan Soni provides a quick overview of how SQL Server works—which can go a long way to making you feel more comfortable as you start exploring its powerful capabilities. She goes over the most important features of SQL Server 2017, helping to familiarize you with how the server operates. She also introduces the main working environment—SQL Server Management Studio—and walks through how to start creating tables and manipulating data.

Tools that use T-SQL

The following are the tools that use T-SQL:

  • SQL Server Management Studio (SSMS)
  • Azure Data Studio
  • SQL Server Data Tools (SSDT)
  • sqlcmd

Who is this course for?

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

Skills Measured

  • Manage data with Transact-SQL (40-45%)
  • Query data with advanced Transact-SQL components (30-35%)
  • Program databases by using Transact-SQL (27-30%)

Course Objectives

  • 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.

Instructor

Responsive image

Mrs. Vandana Soni is a Microsoft Certified Trainer, Azure Data Engineer Associate, and a Software and Corporate Trainer. With 25 years of IT experience, she is adept Corporate Training, Live Training, and Online Webinars.

She has trained 50,000+ individuals all over the world and delivered 50+ Corporate Training all over India and abroad in the following technologies. She specializes in Data Analytics, SQL Server Training, and giving Certification Guidance to Corporates. As an Azure Data Engineer, she has the confidence in teaching from basics to advanced level topics, covering every aspect in detail.

Pre-requisites:

This course can be taken by any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.

Please note that learning only SQL Server will not open lots of job opportunities unless you follow it up with MS.NET Programming or MSBI tools like SSIS, SSAS and SSRS.

Bestdotnet google plus