Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Learn the job of DBA on SQL Server 2019

Learn in this 10-hour course how to build a reliable and secure robust SQL server 2019
0.0
0.0/5
(0 reviews)
2 students
Created by O.Thuillier | SQL | Postgres | Powershell| MySQL | Administration,TSQL, and SQL Server performance.

10.0

CourseMarks Score®

10.0

Freshness

N/A

Feedback

9.5

Content

Platform: Udemy
Price: $11.99
Video: 10h 9m
Language: English
Next start: On Demand

Top SQL courses:

Detailed Analysis

CourseMarks Score®

10.0 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 4/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

We analyzed factors such as the rating (0.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.5 / 10
Video Score: 9.1 / 10
The course includes 10h 9m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 4 hours 29 minutes of 253 SQL courses on Udemy.
Detail Score: 9.8 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
93 resources.
0 exercise.
0 test.

Table of contents

Description

⚡⚡ Would you like to benefit from this course for a price between 10 and 15 euros ? Then send me an email to [email protected] ⚡⚡
✔ This course will greatly help you to pass the Microsoft certifications: 70-462,70-764 and 70-765 concerning the administration of a SQL server.
✔ DBA SQL server is nowadays a full time assured job, it is an extremely sought after job in the working world.
✔Learn in this course, how to build a robust, secure and reliable database server!
✔This course is broken down into several chapters which are:
•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.
•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).
Courses that will arrive during the year 2021
•6th chapter: Let’s go together on SQL Azure!!!
•7th chapter: We will discuss the utility of System DBs, as well as the creation and utility of constraints (PK,FK etc…).
•8th chapter: We will see the different modes of isolation that can be set up on a BDD.
•9th chapter: Discover triggers, synonyms, temporary tables and variables.
•10th chapter: Replication will be discussed.
•11th chapter: A big chapter on what’s new in SQL Server 2016. Such as RLS, DDM, and temporal data.
•12th chapter: How to improve your performance on your stored procedures.
•13th 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 8 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 🙂

Requirements

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

You will 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 …)

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

How much does the Learn the job of DBA on SQL Server 2019 course cost? Is it worth it?

The course costs $11.99. And currently there is a 87% discount on the original price of the course, which was $94.99. So you save $83 if you enroll the course now.
The average price is $17.8 of 253 SQL courses. So this course is 33% cheaper than the average SQL course on Udemy.

Does the Learn the job of DBA on SQL Server 2019 course have a money back guarantee or refund policy?

YES, Learn the job of DBA on SQL Server 2019 has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Learn the job of DBA on SQL Server 2019 course, but there is a $83 discount from the original price ($94.99). So the current price is just $11.99.

Who is the instructor? Is O.Thuillier | SQL | Postgres | Powershell| MySQL | Administration,TSQL, and SQL Server performance. a SCAM or a TRUSTED instructor?

O.Thuillier | SQL | Postgres | Powershell| MySQL | Administration,TSQL, and SQL Server performance. has created 11 courses that got 12 reviews which are generally positive. O.Thuillier | SQL | Postgres | Powershell| MySQL | Administration,TSQL, and SQL Server performance. has taught 145 students and received a 5.0 average review out of 12 reviews. Depending on the information available, O.Thuillier | SQL | Postgres | Powershell| MySQL | Administration,TSQL, and SQL Server performance. is a TRUSTED instructor.

More info about the instructor, O.Thuillier | SQL | Postgres | Powershell| MySQL | Administration,TSQL, and SQL Server performance.

Join the masterclass SQL Server course !
DBA, consultant and trainer on SQL Server technology for more than 15 years now, SQL is not for me a tool to work, but it has become a passion.I am MSCA and MCT on SQL Server products.I worked in many companies, including in particular at TF1 (first french channel) for 5 years on the most critical part the antenna part.I thus pass on to you through my numerous courses my knowledge, and especially my experience, collected over these long years.

10.0

CourseMarks Score®

10.0

Freshness

N/A

Feedback

9.5

Content

Platform: Udemy
Price: $11.99
Video: 10h 9m
Language: English
Next start: On Demand

Students are also interested in

Other courses by ​O.Thuillier | SQL | Postgres | Powershell| MySQL | Administration,TSQL, and SQL Server performance.

Get this widget on your website (for course creators):

Learn the job of DBA on SQL Server 2019 rating
Copy this code and paste it to your website:
<a href="https://coursemarks.com/course/learn-the-job-of-dba-on-sql-server-2019/" target="_blank" title="Learn the job of DBA on SQL Server 2019 on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/100.svg" width="200px" alt="Learn the job of DBA on SQL Server 2019 rating"/></a>