⚡⚡ 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 🙂