Tags
Language
Tags

Learn the in-demand job of DBA SQL Server(18 hours of class)

Posted By:
Learn the in-demand job of DBA SQL Server(18 hours of class)

Learn the in-demand job of DBA SQL Server(18 hours of class)
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 227 lectures (17h 55m) | Size: 8.7 GB

Learn in this 18-hour course how to build a reliable and secure robust SQL server 2019

What you'll learn:
Build a robust, reliable, secure, and powerful SQL server.
Approach and deepen the BACKUP and RESTORE (2 hours of lessons)
Address security and privileges (2 hours of lessons)
Detect and resolve corruption on a database (2 hour course).
Learn the intricacies and pitfalls to avoid when creating a database (2 hour course)
We will see the different isolation modes (READ UNCOMMITED,SNAPSHOT,READ COMMITED…)
Learn the constraints on tables (CHECK, UNIQUE, PK, FK, DEFAULT)
Learn SEQUENCES and IDENTITY
Address the functionalities of the Systems Database (Master, TEMPDB, Msbd, resource)
A big chapter on new SQL Server 2016 features. Like RLS, DDM, and temporal data.
Let's talk about performance by discussing indexing and its implementation (3 hours of lessons)
Improve the performance of your stored procedures
Let's tackle TSQL at a slightly more advanced level, through the partitioning functions (ROW_NUMBER etc …)

Requirements
Just a computer under Windows, the installation of your environment is explained in this course.

Description
Learn in this course, how to build a robust, secure and reliable database server!

DBA SQL server is nowadays a full time assured job, it is an extremely sought after job in the working world.

************ This course is broken down into several chapters *****************

1st chapter: Let's talk about performance by discussing indexing and its implementation. (3 hrs of class).

2nd chapter: This 2:30 chapter will teach you all the intricacies of BACKUP and RESTORE on SQL Server. (3 hrs of class).

3rd chapter: Let's approach TSQL at a slightly more advanced level, through partitioning functions (ROW_NUMBER etc…).

4th chapter: Find out how to easily and automatically detect corruption ,with minimum data loss. (3 hr course).

5th chapter : Discover all the subtleties and pitfalls to avoid, when creating and configuring a database. (3 h of class).

6th chapter: We will discuss the utility of System DBs, as well as the creation and utility of constraints (PK,FK etc…).

7th chapter: We will see the different modes of isolation (READ COMMITED, UNCOMMITED, SERIALIZABLE…) that can be set up on a BDD.

8th chapter: Discover triggers, synonyms, the sequences and the IDENTITY on your tables.

9th chapter: A big chapter on what's new in SQL Server 2016. Such as RLS, DDM, and temporal data.

10th chapter : Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn how to set up a robust and secure SQL server.

******* And at the end of the course take a virtual interview to prepare for your future interview on SQL *******

Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.

You go to an interview, you don't really know what to review beforehand, this is a summary of the most frequently asked questions.

For example : What is a primary key ? what is an index? What is the difference between OLAP and OLTP ? Do you know the COALLESCE function ? or how do you remove duplicates with your query ?

Courses that will arrive during the year 2021

10th chapter: Let's go together on SQL Azure!!!

11th chapter: How to improve your performance on your stored procedures.

12th chapter: Come and find out how to set up security on a SQL Server. (2 hr course).

Important points about this course:

This course covers all SQL Server versions, even SQL Server 2019.

This online course is 15 hours 30 minutes of demo and 30 minutes of theory. The theory is in the classes, not in this course :)

I made sure that the videos, were not too sappy, and that they were no longer than 10 minutes.

Taking this course, will help you to stand out technically from your colleagues, or during a job interview.

Taking this course will, greatly enable you to pass your Microsoft certifications. Look at the average of my other courses (4.4/5), and you will see that my courses are quality courses :)

Who this course is for
Future Database Administrators (DBAs)
BI consultants working on technologies other than SQL Server (Oracle etc…)
Students who want to start using SQL