MP4 | Video: h264, 1280x720 | 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
RequirementsInstallation of SQL server on his station + management studio (SSMS)
DescriptionDo 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 forFuture Database Administrators (DBA)
BI consultants who work on other technologies than SQL Server (Oracle etc...)
DOWNLOAD:
- Citación :
https://rapidgator.net/file/4ab2f09640c678f438c1ba0c60bdc1d7/7afdj.SQL.Server.Configuring.and.modifying.a.database.on.SQL.part1.rar.html
https://rapidgator.net/file/891039a32945d9db8b1ded4881ba7f43/7afdj.SQL.Server.Configuring.and.modifying.a.database.on.SQL.part2.rar.html
https://uploadgig.com/file/download/7be6a8d1e0c3554C/7afdj.SQL.Server.Configuring.and.modifying.a.database.on.SQL.part1.rar
https://uploadgig.com/file/download/1c4b60D46b5fa90d/7afdj.SQL.Server.Configuring.and.modifying.a.database.on.SQL.part2.rar