Microsoft SQL Server 2019 Querying SQL Server
- Caption
- Certificate
- Dedicated Tutors
- 67 Videos
- 10.5 Hours
- 75 Test Questions
Course Description
Microsoft SQL Server 2019: Querying SQL Server
The Microsoft SQL Server 2019 query SQL Server course is designed for individuals who want to develop their skills in querying and analyzing data using SQL Server 2019. This course covers the fundamentals of Transact-SQL (T-SQL), SQL Server’s query language, and provides practical instruction on writing efficient queries, extracting valuable insights, and manipulating data. It is ideal for data analysts, developers, and anyone looking to enhance their proficiency in SQL Server querying.Key Features:
- Introduction to T-SQL: Get an overview of Transact-SQL (T-SQL), SQL Server’s query language, including its syntax, structure, and how it extends standard SQL for advanced querying.
- Basic Querying: Learn how to write basic queries using SELECT statements to retrieve and filter data from single and multiple tables, and use WHERE clauses to specify criteria.
- Advanced Query Techniques: Explore advanced querying techniques, including complex joins (INNER JOIN, LEFT JOIN, RIGHT JOIN), subqueries, and set operations (UNION, INTERSECT, EXCEPT), to handle sophisticated data retrieval tasks.
- Data Aggregation and Grouping: Master the use of aggregate functions (SUM, COUNT, AVG, MIN, MAX) and GROUP BY clauses to summarize and analyze data, and use HAVING to filter aggregated results.
- Sorting and Pagination: Learn how to sort query results using ORDER BY clauses and implement pagination to manage large result sets.
- Data Manipulation: Understand how to perform data manipulation operations using INSERT, UPDATE, and DELETE statements to modify data within SQL Server databases.
- Common Table Expressions (CTEs): Discover how to use CTEs to simplify complex queries and improve readability, and how to use recursive CTEs for hierarchical data.
- Window Functions: Explore window functions such as ROW_NUMBER, RANK, DENSE_RANK, and analytical functions to perform advanced calculations and analysis over partitions of data.
- Stored Procedures and Functions: Learn how to create and use stored procedures and user-defined functions to encapsulate business logic and streamline query execution.
- Query Performance Optimization: Gain insights into query performance tuning, including indexing strategies, query execution plans, and techniques for optimizing slow-running queries.
- Error Handling and Transactions: Understand error handling in T-SQL and manage transactions to ensure data integrity and consistency.
This course provides a comprehensive guide to querying SQL Server 2019, equipping participants with the skills needed to write efficient and effective SQL queries for data analysis, reporting, and application development.
Proudly Display Your Achievement
Upon completion of your training, you will receive a personalized certificate of completion to help validate your new skills.
Step-by-Step Courses List
Module 1 - Query Tools
- 1. Course Introduction
- 2. Module 1 Introduction
- 3. Intro to Management Studio
- 4. Intro to command-line query tools
Module 2 - Introduction to T-SQL Querying
- Module 2 Introduction
- Introducing T-SQL
- Understanding Sets
- Understanding the Logical Order of Operations in SELECT statements
Bangalore - 560045 Module 3 - Basic SELECT Queries
- Module 3 Introduction
- Writing Simple SELECT Statements
- Eliminate Duplicates with DISTINCT
- Using Column and Table Aliases
- Write Simple CASE Expressions
Module 4 - Querying Multiple Tables
- Module 4 Introduction
- Understanding Joins
- Querying with Inner Joins
- Querying with Outer Joins
- Querying with Cross Joins and Self Joins
Module 5 - Sorting and Filtering Data
- 1.Module 5 Introduction
- 2.Sorting Data
- 3.Filtering Data with Predicates
- 4.Filtering with the TOP and OFFSET-FETCH
- 5.Working with Unknown Values
Module 6 - Working with SQL Server Data Types
- Module 6 Introduction
- Writing Queries that return Date and Time Data
- Writing Queries that use Date and Time Functions
- Writing Queries that return Character Data
- Writing Queries that use Character Functions
Module 7 - Using DML to Modify Data
- 1. Module 7 Introduction
- 2. Inserting Records with DML
- 3. Updating Records Using DML
- 4. Deleting Records Using DML
Module 8 - Using Built-In Functions
- Module 8 Introduction
- Writing Queries with Built-In Functions
- Using Conversion Functions
- Using Logical Functions
- Using Functions to Work with NULL
Module 9 - Grouping and Aggregating Data
- 1. Module 9 Introduction
- 2. Using Aggregate Functions
- 3. Using the GROUP BY Clause
- 4. Filtering Groups with HAVING
Module 10 - Using Subqueries
- Module 10 Introduction
- Writing Self-Contained Subqueries
- Writing Correlated Subqueries
- Using the EXISTS Predicate with Subqueries
Module 11 - Using Table Expressions
- Module 11 Introduction
- Using Views
- Using Inline Table-Valued Functions
- Using Derived Tables
- Using Common Table Expressions
Module 12 - Using Set Operators
- Module 12 Introduction
- Writing Queries with the UNION operator
- Using EXCEPT and INTERSECT
- Using APPLY
Module 13 - Using Window Ranking, Offset, and Aggregate Functions
- 1. Module 13 Introduction
- 2.Creating Windows with OVER
- 3.Exploring Window Functions
Module 14 - Pivoting and Grouping Sets
- 1.Module 14 Introduction
- 2.Writing Queries with PIVOT and UNPIVOT
- 3.Working with Grouping Setsnguages Known : English, Telugu
Module 15 - Implementing Error Handling
- Module Introduction
- Implementing T-SQL error handling
- Implementing structured exception handling
Module 16 - Managing Transactions
- 1. Module 16 Introduction
- 2. Transactions and the Database Engine
- 3. Controlling Transactions
- 4. Course Wrap Up
Reviews
You must be logged in to post a review.
What is Included
-
Professional Certification
Exam-focused prep and certification guidance aligned to your learning path.
-
ATS-Optimized Resume
Build a resume that highlights your new skills for recruiters and hiring systems.
-
Mock Interviews
Practice real interview scenarios with structured feedback from career coaches.
-
LinkedIn Optimization
Polish your profile so employers discover your credentials and achievements.
-
Job Placement Support
Career guidance and placement resources on eligible programs.
-
Practical Labs
Hands-on labs and exercises to reinforce concepts from your courses.
I liked the hands-on labs and real-world scenarios included in the lessons.
I liked the hands-on labs and real-world scenarios included in the lessons.
Great instructor-led content with practical exercises that made learning easier.
Excellent training with easy-to-follow modules and helpful demonstrations.