SQL Server: Configuring and modifying a database on SQL

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 28 lectures (2h 35m) | Size: 1.19 GB
Discover all the subtleties and pitfalls to avoid when creating and configuring a database

What you’ll learn:
Discover all the subtleties and pitfalls to avoid when creating and configuring a database

Requirements
Installation of SQL server on his station + management studio (SSMS)

Description
Do you know that a bad choice of your AUTOGROW of your BDD, can make your performance on your server drop? Yes it’s not a myth ?

Have you ever heard of the TRUSWORTHY or DB_CHAINING option on your database?

In this course we will see that it is possible to enable a myriad of options, when creating a DB on SQL server.

This course aims firstly, to make you discover these options, and then to help you avoid the pitfalls when activating certain options.

So why watch my course?

Changing the parallelism (MAXDOP) of a database

Creating, configuring and modifying a database (Creating a database by attaching a file etc…)

Learn the utility and activation of the Query Store

Learn the use and activation of the BROKER service

The impact of changing the owner of a database

What is TARGET RECOVERY Time?

And many other modules in this 3 hour course.

Why get into SQL administration?

SQL is one of the most actively sought after skills in the job market.

Administering SQL Server today is a full-time job.

In addition, SQL Server, by its simplicity, allows you to quickly gain skills on specific subjects.

If you are a Tech Lead, a developer, a future DBA, or any other profession that will tackle SQL, then this course is for you ?

I also made sure that the videos were no longer than 10 minutes, so that it wouldn’t be too boring ?

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 (DBA)
BI consultants who work on other technologies than SQL Server (Oracle etc…)