|
via Udemy |
Go to Course: https://www.udemy.com/course/learn-the-job-of-dba-on-sql-server-2019/
Certainly! Here’s a detailed review and recommendation for the Coursera course on SQL Server: --- **Course Review and Recommendation: Mastering SQL Server for Database Reliability and Security** If you're looking to advance your career as a Database Administrator or simply want to gain comprehensive knowledge of SQL Server, this course is an excellent choice. Offering a balanced mix of practical demonstrations and theoretical insights, it equips learners with the skills needed to build, optimize, and secure powerful database servers. **Course Content & Structure:** Spanning over 17 hours of engaging content, the course is thoughtfully divided into multiple chapters, each focusing on crucial aspects of SQL Server management: - **Performance Optimization:** Learn about indexing strategies and their implementation to boost database performance. - **Backup & Restore:** Master the intricacies of safeguarding data through reliable backup and restore procedures. - **Advanced TSQL:** Explore complex functions like partitioning and ROW_NUMBER to write more efficient queries. - **Data Integrity & Corruption Detection:** Discover methods to automatically detect and minimize data corruption. - **Database Design & Configuration:** Understand the subtleties of creating and configuring robust databases, avoiding common pitfalls. - **System Databases & Constraints:** Delve into the utility of system databases and the importance of constraints like Primary Keys and Foreign Keys. - **Concurrency & Isolation Levels:** Learn about different transaction isolation modes and their implications. - **Triggers, Synonyms, and Sequences:** Get introduced to advanced objects that enhance database functionality. - **Latest Features in SQL Server 2016:** Gain insights into recent innovations such as Row-Level Security (RLS), Data Discovery & Management (DDM), and temporal data. - **Security & Administration:** Develop a strong understanding of security best practices to set up a safe, reliable database environment. - **Interview Preparation:** End with a simulated interview to boost confidence, covering common questions SQL professionals face. Future chapters will also cover topics like SQL Azure, performance improvements for stored procedures, and setting up enhanced security measures. **Highlights:** - The course covers all SQL Server versions up to SQL Server 2019, ensuring relevance regardless of your current environment. - Each video is concise, under 10 minutes, maintaining engagement and facilitating easier learning. - Mix of demo-heavy content and theory, with the showcase videos designed for practical understanding. - Perfect for those preparing for Microsoft certifications or aiming to stand out in job interviews. **Pros:** - Well-structured, comprehensive curriculum from basics to advanced topics. - Suitable for beginners and experienced users looking to deepen their understanding. - Real-world focus with practical demos. - Affordable and flexible online learning. **Cons:** - The course heavily emphasizes demonstrations; learners seeking more in-depth theoretical explanations may need supplementary resources. - Some chapters, like Azure and performance optimization, are upcoming, so continuous learning will be necessary to stay current. **Final Recommendation:** This course is highly recommended for anyone aspiring to become a proficient SQL Server DBA or looking to enhance their database management skills. Its practical approach, covering everything from performance tuning to security, makes it invaluable for both career advancement and certification exam preparation. With a positive feedback rating (4.4/5 from other courses), the instructor clearly delivers quality content that can significantly elevate your SQL expertise. **Bottom Line:** If you want a thorough, well-organized, and practical course to master SQL Server, this is an investment worth making. --- Let me know if you'd like a shorter summary or additional specific details!
Learn in this course, how to build a robust, secure and reliable database server! DBA SQL server is nowadays a full time assured job, it is an extremely sought after job in the working world.************ This course is broken down into several chapters *****************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. (3 hrs of class).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).6th chapter: We will discuss the utility of System DBs, as well as the creation and utility of constraints (PK,FK etc...).7th chapter: We will see the different modes of isolation (READ COMMITED, UNCOMMITED, SERIALIZABLE...) that can be set up on a BDD.8th chapter: Discover triggers, synonyms, the sequences and the IDENTITY on your tables.9th chapter: A big chapter on what's new in SQL Server 2016. Such as RLS, DDM, and temporal data.10th chapter: Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn how to set up a robust and secure SQL server.******* And at the end of the course take a virtual interview to prepare for your future interview on SQL *******Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.You go to an interview, you don't really know what to review beforehand, this is a summary of the most frequently asked questions.For example: What is a primary key ? what is an index? What is the difference between OLAP and OLTP ? Do you know the COALLESCE function ? or how do you remove duplicates with your query ?Courses that will arrive during the year 202110th chapter: Let's go together on SQL Azure!!!11th chapter: How to improve your performance on your stored procedures.12th 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 17 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:)