JULY SITEWIDE DEALS | UP TO 50% Off
40% OFF SITEWIDE LABOR DAY SALE

Shop our Labor Day sale and take 40% off all regularly priced courses and bundles sitewide.  Just add to cart to see your discounts.

Lock In At Our Lowest Price Ever: $14.99/month for 2,500+ hours of IT training.
Limited time only. Enroll now, cancel anytime!

Learn SQL Server 2019 – Querying SQL Server

Upgrade your skills or learn SQL server with this informative course! You will gain the necessary technical skills to craft basic Transact-SQL queries for Microsoft SQL Server.

Included In This Course

Included In This Course

Total Hours
10  Training Hours
Learn SQL Server 2019 – Querying SQL Server
67 On-demand Videos
Closed Caption

Closed Captions

Course Topics
16  Topics
Prep Questions
75 Prep Questions
Learn SQL Server 2019 – Querying SQL Server

Certificate of Completion

Course Description

Learn Sql Server

Have you been wanting to hone your technical skills in SQL Server? Our learn SQL Server course is the perfect opportunity for that! Through this program, we will teach you how to construct basic Transact-SQL queries and obtain information from tables. You’ll also learn how to develop new data structures, amend or delete existing ones as well as apply filtering and sorting techniques across different types of data offered by SQL server. Join us now for an enriching experience with this Learn SQL Server training course! This course delves into the use of dynamic tables, giving SQL users the ability to hide implementation details from others who are accessing data via reporting tools. In addition, it covers error handling and transaction management – what they are and how they can be used effectively. Finally, you’ll learn more about the nuances of database security optimization that will help ensure your system remains safe.

About this online IT course

This Learn SQL Server course is the basis for all SQL Server-related disciplines. Knowing the syntax of Microsoft SQL is critical to further your career in:

  • Database Administration
  • Database Development
  • Business Intelligence
  • Application and Web Development.

We strongly suggest this learn SQL server course to those working in the fields of: Database Administrators, Database Developers and BI professionals who are looking to expand their knowledge base.

Frequently Asked Questions About Learn SQL Server 2019 – Querying SQL Server

What will I learn in the SQL Server 2019 – Querying SQL Server course?

This course aims to upgrade your skills or provide a foundation in SQL Server. You’ll learn how to construct basic Transact-SQL queries and obtain information from tables. The course also covers the development of new data structures, modification or deletion of existing ones, and the application of filtering and sorting techniques across various types of data offered by SQL server. You’ll dive into the use of dynamic tables and cover important topics like error handling, transaction management, and database security optimization.

Who is this course suitable for?

This course is recommended for individuals working in the fields of Database Administration, Database Development, Business Intelligence, Application and Web Development, or anyone who wants to learn SQL Server. It forms the basis for all SQL Server-related disciplines, and knowing the syntax of Microsoft SQL is critical for these fields​​.

What are some key features of SQL Server 2019 that this course might cover?

SQL Server 2019 offers a range of features that this course addresses. These include intelligence across all your data, choice of language and platform, industry-leading performance, secure data platform, unparalleled high availability, and end-to-end mobile BI. You’ll gain insights from querying across your entire data estate, learn about running SQL Server with Windows and Linux containers, understand performance benchmarks, learn about data protection and security, explore high availability and disaster recovery features, and delve into self-service BI on any device.

Is there a trial period for this course?

Yes, you can access this course and over 2,500 hours of on-demand content with the All Access Monthly Subscription. You get a 7-day free trial with no obligation, and you can cancel anytime.

Can I apply the skills learned in this course to other SQL platforms?

Absolutely! Although the course is designed for SQL Server 2019, the core SQL skills you’ll learn are applicable to other SQL platforms as well. SQL syntax and concepts are generally consistent across platforms, even though there may be some platform-specific features or differences in implementation.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft SQL Server 2019 - Querying SQL Server Course Content

Module 1 - Query Tools

  •    1.1 Course Introduction

  •    1.2 Module 1 Introduction

  •    1.3 Intro to Management Studio

  •    1.4 Intro to command-line query tools

Module 2 - Introduction to T-SQL Querying

  •    2.1 Module 2 Introduction

  •    2.2 Introducing T-SQL

  •    2.3 Understanding Sets

  •    2.4 Understanding the Logical Order of Operations in SELECT statements

Module 3 - Basic SELECT Queries

  •    3.1 Module 3 Introduction

  •    3.2 Writing Simple SELECT Statements

  •    3.3 Eliminate Duplicates with DISTINCT

  •    3.4 Using Column and Table Aliases

  •    3.5 Write Simple CASE Expressions

Module 4 - Querying Multiple Tables

  •    4.1 Module 4 Introduction

  •    4.2 Understanding Joins

  •    4.3 Querying with Inner Joins

  •    4.4 Querying with Outer Joins

  •    4.5 Querying with Cross Joins and Self Joins

Module 5 - Sorting and Filtering Data

  •    5.1 Module 5 Introduction

  •    5.2 Sorting Data

  •    5.3 Filtering Data with Predicates

  •    5.4 Filtering with the TOP and OFFSET-FETCH

  •    5.5 Working with Unknown Values

Module 6 - Working with SQL Server Data Types

  •    6.1 Module 6 Introduction

  •    6.2 Writing Queries that return Date and Time Data

  •    6.3 Writing Queries that use Date and Time Functions

  •    6.4 Writing Queries that return Character Data

  •    6.5 Writing Queries that use Character Functions

Module 7 - Using DML to Modify Data

  •    7.1 Module 7 Introduction

  •    7.2 Inserting Records with DML

  •    7.3 Updating Records Using DML

  •    7.4 Deleting Records Using DML

Module 8 - Using Built-In Functions

  •    8.1 Module 8 Introduction

  •    8.2 Writing Queries with Built-In Functions

  •    8.3 Using Conversion Functions

  •    8.4 Using Logical Functions

  •    8.5 Using Functions to Work with NULL

Module 9 - Grouping and Aggregating Data

  •    9.1 Module 9 Introduction

  •    9.2 Using Aggregate Functions

  •    9.3 Using the GROUP BY Clause

  •    9.4 Filtering Groups with HAVING

Module 10 - Using Subqueries

  •    10.1 Module 10 Introduction

  •    10.2 Writing Self-Contained Subqueries

  •    10.3 Writing Correlated Subqueries

  •    10.4 Using the EXISTS Predicate with Subqueries

Module 11 - Using Table Expressions

  •    11.1 Module 11 Introduction

  •    11.2 Using Views

  •    11.3 Using Inline Table-Valued Functions

  •    11.4 Using Derived Tables

  •    11.5 Using Common Table Expressions

Module 12 - Using Set Operators

  •    12.1 Module 12 Introduction

  •    12.2 Writing Queries with the UNION operator

  •    12.3 Using EXCEPT and INTERSECT

  •    12.4 Using APPLY

Module 13 - Using Window Ranking, Offset, and Aggregate Functions

  •    13.1 Module 13 Introduction

  •    13.2 Creating Windows with OVER

  •    13.3 Exploring Window Functions

Module 14 - Pivoting and Grouping Sets

  •    14.1 Module 14 Introduction

  •    14.2 Writing Queries with PIVOT and UNPIVOT

  •    14.3 Working with Grouping Sets

Module 15 - Implementing Error Handling

  •    15.1 Module Introduction

  •    15.2 Implementing T-SQL error handling

  •    15.3 Implementing structured exception handling

Module 16 - Managing Transactions

  •    16.1 Module 16 Introduction

  •    16.2 Transactions and the Database Engine

  •    16.3 Controlling Transactions

  •    16.4 Course Wrap Up

Add a review
Learn SQL Server 2019 - Querying SQL Server Learn SQL Server 2019 - Querying SQL Server
Rating*
0/5
* Rating is required
Your review
* Review is required
Name
* Name is required
4.8
Based on 49 reviews
5 star
78
78%
4 star
22
22%
3 star
0%
2 star
0%
1 star
0%
1-5 of 49 reviews
  1. I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.

  2. The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.

  3. The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!

  4. This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.

Your Training Instructor

James Ring-Howell

James Ring-Howell

Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.

Learn SQL Server 2019 - Querying SQL Server
 

$49.00

OR

Subscribe To All-Access

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Learn SQL Server 2019 – Querying SQL Server

Microsoft SQL Querying SQL Server
Learn SQL Server 2019 – Querying SQL Server
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Take your SQL Server skills to the next level with ITU Online’s Microsoft 70-464: Developing Microsoft SQL Server Databases course. Enroll today!

In this course you will learn logical table design, indexing and query plans. This course focuses on the creation of database objects including views, stored procedures, parameters and functions. Common aspects of procedure coding such as indexes, concurrency, error handling, and triggers are also covered in this course. This course will also teach you how to optimize indexes, ensure data integrity, implement views, stored procedures and functions as well as manage transactions and locks.

$49.00

Learn how to develop scalable and secure web applications with Microsoft ASP .NET MVC in our comprehensive online course.

In this Microsoft ASP .NET MVC online training course you will learn a powerful, patterns-based way to build dynamic websites that gives you full control over markup for enjoyable, agile development. You will learn ASP.NET MVC and its many features that enable fast, TDD-friendly development for creating sophisticated applications that use the latest web standards.

$49.00

Master SQL fundamentals with our Oracle 12c OCP 1Z0-061 course. Learn SQL queries, data manipulation, and database objects. Enroll now!

Oracle Database 12c: SQL Fundamentals provides a multitude of advantages from the re-engineered Oracle Database for Cloud computing. The architecture ensures hardware and software efficiency, superior performance, manageability benefits that lead to quick and effortless cloud provisioning.