London College Of Online Learning

HOME >> IT CERTIFICATIONS >> DATABASES, MICROSOFT >> Microsoft SQL Server 2019 Database Design

£59.00

Duration: 6 Hours 22 Minutes

37 Course Videos

Microsoft SQL Server 2019 Database Design

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.

Key Learning Topics In This Course:

Design and Implement Tables.
Ensure Data Integrity through Constraints.
Describe indexes, including Optimized and Columnstore indexes
Design and Implement Stored Procedures.
Design and Implement User Defined Functions.
Respond to data manipulation using triggers.
Store and Query Blobs and Text Documents.

Course Videos

This course contains the following modules and videos. Click the down arrow to view video details.

Module 1 - Designing and Building Tables

Module 2 - Enforcing Data Integrity

Module 3 - Indexing

Module 4 - Stored Procedures, Functions, and Triggers

Module 5 - Blob and Filestream Data

Module 6 - Full-Text Search

Module 7 - Azure vs On-Prem

Our Learning System Includes

Instructor Led Lectures

All of our IT Courses recreate a real time class experience with a highly qualified and experienced instructor delivering the course’s theories and concepts on screen. All of our lectures are pre-recorded and available to the user 24/7. They can easily be paused, repeated, rewound and fast-forwarded.

Visual Presentations

We understand that all students are different when it comes to learning, therefore different types of delivery mediums are needed in order to achieve success for students. Taking that into account, we deliver our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimisation & Progress Tracking

Our courses are optimised for all mobile devices allowing users to learn on the go whenever they have spare time and wish to do so. Users can access their courses from anywhere and their progress is completely tracked and recorded delivering peace of mind to each and every user.

Practice Quizzes and Exams

Our custom practice exams prepare students for their exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure that they are confident on the topic they are learning.

World Class Learning Management System

We provide the next generation Learning Management System (LMS) to all of our students. This is an experience that combines the feature set of traditional LMS with advanced functionality designed to make learning management easy and online learning engaging from the student’s perspective.