Overview

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. 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. This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server 2019 database. It is specifically tailored towards individuals who want to gain knowledge on the newest features in SQL server 2016, 2017, and 2019 as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases! Python, which has been around for nearly three decades, is one of the most widely used programming languages in existence. This Python programming course is particularly helpful to data scientists and machine learning professionals, Python stands out due to its ease-of-use – it’s no wonder that universities now make it their go-to language when teaching coding. In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making. 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.

Your Training Instructor

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.

  • 10 Traning Hours
  • 67 Videos
  • 16 Topics
  • 75 Practice Questions

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.

Microsoft SQL Server 2019 – Querying SQL Server Course Outline

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