- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
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
10 Training Hours
67 On-demand Videos
Closed Captions
16 Topics
75 Prep Questions
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 DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.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
Rating*
0/5
* Rating is required
Your review
* Review is required
Name
* Name is required
Email
* Email is required
1-5 of 49 reviews
Sorry, no reviews match your current selections
Your Training Instructor
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.
$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
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.
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.
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.
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!
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.