0
  • No products in the cart.
Cart Total:$0.00

Microsoft SQL Server 2019 – Querying SQL Server

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. You will learn how to write queries that return data from tables as well as create, update, or delete data in a database.

$39.99

SKU: IT-microsoft-sql-2019-querying Categories: , , , , ,
Description

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. You will learn how to write queries that return data from tables as well as create, update, or delete data in a database.

These queries will allow filtering and sorting and effectively use the various data types provided by SQL Server. This course also covers the use of dynamic tables of various sorts which can allow a more sophisticated SQL user to hide implementation details from other end users accessing data from reporting tools. Finally, the course will provide details on the what and how of error handling and transaction management. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

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.

Course Outline

Microsoft SQL Server 2019 – Querying SQL Server Course Content

Download Course Outline

1.1 Course Introduction

1.2 Module 1 Introduction

1.3 Intro to Management Studio

1.4 Intro to command-line query tools

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

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

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

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

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

7.1 Module 7 Introduction

7.2 Inserting Records with DML

7.3 Updating Records Using DML

7.4 Deleting Records Using DML

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

9.1 Module 9 Introduction

9.2 Using Aggregate Functions

9.3 Using the GROUP BY Clause

9.4 Filtering Groups with HAVING

10.1 Module 10 Introduction

10.2 Writing Self-Contained Subqueries

10.3 Writing Correlated Subqueries

10.4 Using the EXISTS Predicate with Subqueries

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

12.1 Module 12 Introduction

12.2 Writing Queries with the UNION operator

12.3 Using EXCEPT and INTERSECT

12.4 Using APPLY

13.1 Module 13 Introduction

13.2 Creating Windows with OVER

13.3 Exploring Window Functions

14.1 Module 14 Introduction

14.2 Writing Queries with PIVOT and UNPIVOT

14.3 Working with Grouping Sets

15.1 Module Introduction

15.2 Implementing T-SQL error handling

15.3 Implementing structured exception handling

16.1 Module 16 Introduction

16.2 Transactions and the Database Engine

16.3 Controlling Transactions

16.4 Course Wrap Up

Your Training Instructor

James Ring-Howell
Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

Related Products

$39.99

Course features:

10 Hrs 5 Min

67 Videos

1 Year Access

Available on Web