Microsoft SQL Server 2019 eLearning Bundle Course

Course Overview

This Microsoft SQL Server 2019 eLearning Bundle includes these 3 courses:

  • Microsoft SQL Server 2019 – Querying SQL Server
  • Microsoft SQL Server 2019 Database Design
  • Microsoft SQL Server 2019 Administration

Course Topics

Microsoft SQL Server 2019 – Querying SQL Server – 10 hrs 5 min

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.

 

Microsoft SQL Server 2019 Database Design – 6 hrs 22 min

This course focuses on skills necessary to architect well-performing databases in SQL Server. It covers the principles and the practical tools necessary to understand and create all of the objects you would need to have a complete database. This includes a discussion of tables, data integrity, and indexes. As well as basic programming, file storage, and full-text searching. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups. You will learn the benefits and the requirements for generating useful indexes in both OLTP (transactional) and OLAP (reporting) databases. Another major benefit of business-focused RDBMS (Relational Database Management Systems) is the use of enforced relationships and constraints.

This course will cover all the standard techniques to maintain consistent quality data in your database using referential integrity and various types of automatic data validations. One way of increasing both security and performance in a database is using stored procedures, functions, and triggers. You will learn what each of these objects is and how to write the T-SQL code to generate them. We will also cover the use of SQL Management Studio to perform these various operations using visual tools where possible. At the end of the course, you should be able to create a highly functional business database.

 

Microsoft SQL Server 2019 Administration – 6 hrs 24 min

With this course, students can learn about SQL Server installation, data storage, data recovery, monitoring, security, and maintenance. Instructor James Ring-Howell brings with him over 40 years of applicable IT experience and has taught technical courses for over two decades.

This Microsoft SQL Server 2019 Admin course is specifically for obtaining working IT skills and is not certification-specific training.

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.