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

Querying Data with Transact-SQL (70-761)

Querying Data with Transact-SQL (70-761)

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

$66 / ₹5625 for 6 Months
NewBatches / Webinars Download Curriculum

21 Modules

33.17 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     11 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

The Transact-SQL (70-761) course covers writing queries for Microsoft SQL Server. Key topics include basic querying with SELECT statements, filtering data with WHERE clauses, joining multiple tables, and working with set operators. It also addresses advanced topics such as subqueries, functions, and implementing error handling and transactions

COURSE OBJECTIVES

  • Manage data with Transact-SQL: Understand how to write SELECT queries, use JOINs, and filter, sort, and group data
  • Query multiple tables: Master the use of various joins, subqueries, and set operators.
  • Implement programming objects: Create and manage views, stored procedures, and functions
  • Optimize and troubleshoot queries: Learn techniques for improving query performance and handling errors.

PRE-REQUISITES

  • Basic knowledge of relational databases: Understanding of database concepts and familiarity with SQL Server
  • Experience with SQL: Prior experience writing simple SQL queries.
  • Understanding of data types and tables: Knowledge of different data types and the structure of database tables.
  • Familiarity with basic programming concepts: Basic understanding of programming logic and flow control.

WHO CAN DO THIS COURSE

  • Database Administrators: Individuals responsible for managing and maintaining SQL Server databases.
  • Database Developers: Professionals who design, develop, and implement database solutions.
  • Data Analysts: Analysts who need to extract, analyse, and visualize data using SQL queries.
  • IT Professionals: Those looking to gain SQL skills for data management and querying in their roles

TRAINING AT BITC(BestITCourses)

  • 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 at Corporate Training, Live Training, and Online Webinars.
  • You can access videos and live sessions with your subscription. Videos can be used for learning the subject and practicing. Live sessions can be used for directly interacting with trainer and clarifying doubts then and there
  • YEvery week we schedule a Q&A session for clarifying any questions you may have.

Instructor

Vandana Soni
Certificate Background
Certificate

Meet Your Certified Trainer

Your Trainer - Vandana Soni 25+ years of Experience

Mrs. Vandana Soni, a Microsoft Certified Trainer and Azure Data Engineer Associate, has 25 years of IT experience. She excels in Corporate Training, Live Training, and Online Webinars.

She has trained 50,000+ individuals & delivered 50+ corporate trainings. She specializes in SQL Server, Azure Data Engineering, & Data Analytics, providing certification guidance from basics to advanced.

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

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

Certification Medal Certifications
  • Microsoft Certified Trainer
  • Microsoft Azure Data Engineer
  • Microsoft Data Analyst
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 - 2026 | www.bestitcourses.com | www.deccansoft.com | All Rights Reserved.

Thank you for visiting BestITCourses, How can I help you