SQL DBA Beginner - SQL Server Architecture

The SQL DBA course is structured to lay your hands on REAL WORLD Projects.

You MUST already know the basics of SQL Language to get the best of this course.

Next steps

-Start off with several projects during the course of the training
-First will be to build your own infrastructure in a virtualized -environment (Clustered environment)
-Build your cloud infrastructure using Amazon Web services
-Build a High Availability Solution (always on)

-In the course you will learn configuration best practices and the exact things you MUST do when you get a job
-Knowing the above will allow you to speak freely about your experience at the interview
-Build all other Microsoft technologies on your environment and learn the differences between them
-Mirroring
-Log shipping
-Replication (Transactional, Merge, Peer-to-Peer)
-Clustering
-On your environment you will engage with below:
Security
-TDE
-SSL
-Logins/Users
Performance
-Indexes
-Troubleshooting Locking and Deadlocks
-Wait states
-Transaction logs (VLF)
Recovery Strategies
-Filegroup recovery Tablespace recovery
-Page recovery
-Database recovery
Auditing
-Database and Server Audit Specifications
-Automation
-Ola Halengren (Backups)
-Ola Halengren (Index Management)
-Maintenance Plans
Documentation
-Real world examples of Documentation

[giriyadav]

Awesome....Really Helpful for beginners.
Thanks for sharing this video.
Can you please forward me all entire training video's for learning SQL Server Admin.

Thanks again.
Very much helpful and looking for all videos as well.

[gbengadara]

thank you for this powerful video, I will like to finish the remaining topics you mentioned in this video, I checked you out on Linkedin, but could not message you ...I tried the website out as well it is not working I also emailed you. Please kindly reach out when you get ou Sir

[titoq.]

thanks for uploading this video, and do you have the links of more courses of this training?

[najju]

HI, I HAVE JUST BEEN LOOKING FOR VIRTUALIZED ENVIRONMENT WHICH YOU HAVE MENTIONED AT THE END OF THE VIDEO... I HAVE LEFT YOU A MAIL REGARDING THE SAME, PLEASE DO GET IN TOUCH WITH ME.. THANKS AND A WONDERFUL VIDEO FOR BEGINNERS TO LEARN SQL INTERNAL ARCH....

[Komeexe]

Wow!!! Good job. Do you have SQL dba training videos for a complete novice.

Thanks

[HOSANNA-HOUSE]

this is very good, please i need this training how can i get it