.NET Courses
UI Technologies
Cloud ComputingCloud Computing
Data EngineeringData Engineering
AI / MLAI / ML
Microsoft Power PlatformMicrosoft Power Platform
Testing Tools
Others

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
NewBatches / Webinars Download Curriculum

21 Modules

33.27 Hours

WatchDemo
Course Modules
Videos

  1. Basic Concepts Part -1
    Preview 45 Mins : 0

  2. Basic Concepts Part -2
    Preview 54 Mins : 0

  3. Normalization
    Preview 39 Mins : 0

  4. ER Modeling
    Preview 18 Mins : 0

Documents
  1. Basic Database Concepts Course Material
  2. E R Model CaseStudy Course Material
Premium Features New
Videos

  1. SQL Server Installation Guide
    Preview 30 Mins : 0

  2. SQL Server 2012 Installation
    Preview 7 Mins : 0

  3. Using SSMS to Connect to SQL Server
    Preview 13 Mins : 0

  4. SQL Server 2016 Installation
    Preview 9 Mins : 0

  5. SQL Server 2017 Installation
    Preview 18 Mins : 0

Documents
  1. SQL SERVER INSTALLATION GUIDE Course Material
Premium Features New
Videos

  1. Installations and Introduction to SQL Server
    Watch Now     56 Mins : 0

  2. Installation
    Watch Now     11 Mins : 0

Documents
  1. Introduction to SQL SERVER and SQL Course Material
Premium Features New
Videos

  1. Create Database using UI
    Watch Now     44 Mins : 0

  2. Create Alter Database using T SQL
    Watch Now     31 Mins : 0

  3. Schema and Synonym
    Watch Now     33 Mins : 0

Documents
  1. Creating Databse Course Material
Premium Features New
Videos

  1. Create Alert Drop table
    Watch Now     19 Mins : 0

  2. Datatypes Overview
    Watch Now     10 Mins : 0

  3. Insert Update Delete
    Watch Now     25 Mins : 0

  4. Working with Table-2; Understanding IDENTITY Column
    Watch Now     11 Mins : 0

  5. Working with Table-1; Understanding Foreign Key
    Watch Now     6 Mins : 0

Documents
  1. Working With Table Course Material
Premium Features New
Videos

  1. T-SQL Select Queries Overview
    Watch Now     3 Mins : 0

  2. Understanding simple SELECT
    Watch Now     24 Mins : 0

  3. Sorting Data
    Watch Now     14 Mins : 0

  4. Filter using Predicates part-1
    Watch Now     31 Mins : 0

  5. Filter using predicates PART-2
    Watch Now     20 Mins : 0

  6. Filter using TOP, OFFSET, FETCH
    Watch Now     20 Mins : 0

  7. Case Expression
    Watch Now     10 Mins : 0

  8. Set Operation
    Watch Now     16 Mins : 0

  9. Working with unknown value
    Watch Now     10 Mins : 0

Documents
  1. Create T SQL Select Queries Course Material
Premium Features New
Videos

  1. Joins Overview
    Watch Now     2 Mins : 0

  2. Introduction To JOINS
    Watch Now     10 Mins : 0

  3. INNER JOIN
    Watch Now     8 Mins : 0

  4. OUTER JOIN
    Watch Now     16 Mins : 0

  5. SELF JOIN
    Watch Now     10 Mins : 0

  6. Multi JOIN queries
    Watch Now     25 Mins : 0

Documents
  1. Query Multiple Tables Using JOIN Course Material
Premium Features New
Videos

  1. Aggregate and Built-in Functions Overview
    Watch Now     3 Mins : 0

  2. Aggregate Functions Introduction
    Watch Now     20 Mins : 0

  3. Understanding GroupBy
    Watch Now     20 Mins : 0

  4. Understanding Having Clause
    Watch Now     34 Mins : 0

  5. Introduction To Built-in Functions
    Watch Now     33 Mins : 0

  6. Logical Functions
    Watch Now     17 Mins : 0

  7. Functions to work with NULL
    Watch Now     17 Mins : 0

  8. Working with Date Functions
    Watch Now     10 Mins : 0

  9. Date Comparision
    Watch Now     11 Mins : 0

  10. String Functions
    Watch Now     7 Mins : 0

  11. Format Function
    Watch Now     13 Mins : 0

  12. System Functions
    Watch Now     7 Mins : 0

Documents
  1. Implement functions and Aggregate data Course Material
Premium Features New
Videos

  1. Understanding INSERT
    Watch Now     20 Mins : 0

  2. Understanding UPDATE DELETE
    Watch Now     19 Mins : 0

  3. Identity
    Watch Now     8 Mins : 0

  4. Understanding GUIDs
    Watch Now     6 Mins : 0

  5. Understanding Sequence
    Watch Now     13 Mins : 0

  6. Understanding MERGE
    Watch Now     12 Mins : 0

  7. Using OUTPUT
    Watch Now     15 Mins : 0

Documents
  1. Modify Data Course Material
Premium Features New
Videos

  1. Introduction to Subquery
    Watch Now     3 Mins : 0

  2. Self Contained Subquery
    Watch Now     35 Mins : 0

  3. Co-related Subquery
    Watch Now     14 Mins : 0

  4. Using EXISTS NOT EXISTS
    Watch Now     8 Mins : 0

  5. APPLY Operator
    Watch Now     10 Mins : 0

Documents
  1. Subquery and Apply Course Material
Premium Features New
Videos

  1. Introduction to Table Expression
    Watch Now     2 Mins : 0

  2. Derived Table
    Watch Now     15 Mins : 0

  3. Common Table Expression
    Watch Now     16 Mins : 0

  4. Recursive Common Table Expression
    Watch Now     9 Mins : 0

  5. View
    Watch Now     8 Mins : 0

  6. Table Valued Function
    Watch Now     17 Mins : 0

Documents
  1. Table Expression Course Material
Premium Features New
Videos

  1. Grouping Sets
    Watch Now     16 Mins : 0

  2. ROLLUP
    Watch Now     9 Mins : 0

  3. CUBE
    Watch Now     4 Mins : 0

  4. Distingushing NULLs in Result set
    Watch Now     17 Mins : 0

  5. Introduction To Window Function
    Watch Now     3 Mins : 0

  6. Window Aggregate Function
    Watch Now     6 Mins : 0

  7. Ranking Function
    Watch Now     14 Mins : 0

  8. Windows OFFSET Function
    Watch Now     7 Mins : 0

  9. Framing
    Watch Now     15 Mins : 0

  10. PIVOT UNPIVOT
    Watch Now     21 Mins : 0

Documents
  1. Group and Pivot Data Course Material
Premium Features New
Videos

  1. Constraints part-1
    Watch Now     34 Mins : 0

  2. Constraints part-2
    Watch Now     19 Mins : 0

Documents
  1. Constraints Course Material
Premium Features New
Videos

  1. Introduction to Views
    Watch Now     21 Mins : 0

  2. Create Alter Drop Views
    Watch Now     24 Mins : 0

  3. Updatable Views
    Watch Now     14 Mins : 0

  4. Partitioned Views
    Watch Now     4 Mins : 0

  5. Refreshing Views
    Watch Now     6 Mins : 0

  6. Catalogue Views
    Watch Now     10 Mins : 0

Documents
  1. View Course Material
Premium Features New
Videos

  1. Index part-1
    Watch Now     15 Mins : 0

  2. Index part-2
    Watch Now     23 Mins : 0

  3. Index part-3
    Watch Now     19 Mins : 0

  4. Index part-4
    Watch Now     14 Mins : 0

Documents
  1. Index Course Material
Premium Features New
Videos

  1. Introduction to T SQL
    Watch Now     4 Mins : 0

  2. Script and Batches
    Watch Now     14 Mins : 0

  3. Variables and Statements
    Watch Now     11 Mins : 0

  4. Table Variable
    Watch Now     8 Mins : 0

  5. Global Variable and Keywords
    Watch Now     7 Mins : 0

  6. Controlling Program Flow
    Watch Now     14 Mins : 0

  7. T SQL Scripts Examples
    Watch Now     24 Mins : 0

  8. Temporary Tables
    Watch Now     10 Mins : 0

  9. Check Existence of Database Objects
    Watch Now     6 Mins : 0

Documents
  1. Programming Using T-SQL Course Material
Premium Features New
Videos

  1. Execution Plan
    Watch Now     23 Mins : 0

  2. Stored Procedure Part-I
    Watch Now     43 Mins : 0

  3. Stored Procedure Part-II
    Watch Now     16 Mins : 0

  4. Stored Procedure Part-III
    Watch Now     29 Mins : 0

  5. UDF
    Watch Now     33 Mins : 0

Documents
  1. Stored Procedures Course Material
Premium Features New
Videos

  1. Introduction To Error Handling
    Watch Now     7 Mins : 0

  2. Understanding Rais Error Part-1
    Watch Now     18 Mins : 0

  3. Understanding Rais Error Part-2
    Watch Now     11 Mins : 0

  4. Using THROW
    Watch Now     3 Mins : 0

  5. Using Error Final
    Watch Now     7 Mins : 0

  6. Understanding TRY CATCH Part-1
    Watch Now     12 Mins : 0

  7. Understanding TRY CATCH Part-2
    Watch Now     9 Mins : 0

  8. FORMAT MESSAGE
    Watch Now     4 Mins : 0

  9. Transactions
    Watch Now     22 Mins : 0

  10. USING XACT ABORT
    Watch Now     9 Mins : 0

  11. USING XACT STATE()
    Watch Now     7 Mins : 0

Documents
  1. Implement Error Handling And Transaction Course Material
Premium Features New
Videos

  1. Triggers Part-I
    Watch Now     47 Mins : 0

  2. Triggers Part-II
    Watch Now     20 Mins : 0

  3. Triggers Part-III
    Watch Now     10 Mins : 0

  4. SQL Triggers
    Watch Now     31 Mins : 0

Documents
  1. TRIGGERS Course Material
Premium Features New

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.

Know more about Vandana Soni - https://www.bestitcourses.com/Vandanasoni

Follow her on LinkedIn -https://www.linkedin.com/in/vandana-soni-85a29475/

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.

Got a question or have an insight to share ?

Join this discussion here and connect with your fellow learners and Subject experts.

0 Comments
Post Image
Enroll
Packages
Trending Certification Courses:
Microsoft Mock Exams:
Other links
About
Resources
Bestitcourse google plus
© Copyright 1997 - 2025 | www.bestitcourses.com | www.deccansoft.com | All Rights Reserved.

Thank you for visiting BestITCourses, How can I help you