Microsoft SQL Server Administration – 2019



Students will have a thorough understanding of how to maintain and optimize a Microsoft SQL Server 2019 database by taking this course on SQL server administration. It is specifically designed for people who want to learn about the newest capabilities throughout the entire data platform as well as the latest features in SQL Server 2016, 2017, and 2019. The course will equip students with a wide range of management abilities for their own MS SQL Server installation and its databases.

  • 6  Training Hours
  • 41 Videos
  • 6  Topics
  • 75 Practice Questions
SKU: 601956326642 Category:

Self-paced training online training program

Introducing the Ultimate SQL Server Administration Mastery Course! Get ready to unlock the power of SQL Server with our dynamic and immersive training program. Led by the legendary instructor, James Ring-Howell, who brings an impressive 40 years of real-world IT experience to the table, this course is designed to propel your career to new heights.

In this cutting-edge course, you’ll delve into the world of SQL Server like never before. Whether you’re a seasoned database administrator or an ambitious developer, our comprehensive curriculum covers everything you need to know for mastering SQL Server administration. From installation and data storage to advanced data recovery techniques, monitoring, security, and efficient maintenance practices, we’ve got you covered.

But that’s not all! We understand the importance of staying ahead in the industry. That’s why we go the extra mile to provide you with an edge. As part of the program, you’ll gain exclusive insights into the latest trends and emerging technologies in SQL Server administration. Our course materials are regularly updated to keep you abreast of the rapidly evolving landscape, ensuring you’re always one step ahead of the competition.

We know certifications matter, which is why we’ve carefully aligned our course content to help you excel in the prestigious Microsoft SQL Server Administration exams. By immersing yourself in our interactive learning environment, you’ll not only gain the skills required for real-world scenarios, but you’ll also be fully prepared to tackle the certification exams with confidence. Our expertly crafted practice exams and targeted exam tips will give you the competitive advantage you need to succeed.

But it doesn’t stop there. Joining our vibrant community of SQL Server enthusiasts, you’ll have access to a network of like-minded professionals, fostering collaboration, knowledge sharing, and career growth opportunities. Our dedicated support team will be with you every step of the way, ensuring you have a seamless learning experience and are equipped to overcome any challenges you may encounter.

Don’t miss this unparalleled opportunity to become a SQL Server maestro. Enroll in our Ultimate SQL Server Administration Mastery Course today and unlock the door to limitless career possibilities. Let’s embark on this transformative journey together!

  • Install and Configure SQL Server 2019
  • Work with Databases and Storage
  • Plan and Implement a Backup Strategy
  • Restore SQL Server 2019 Databases
  • Import and Export Data
  • Monitor SQL Server 2019
  • Manage SQL Server Security
  • Audit Data Access and Encrypt Data
  • Perform Ongoing Database Maintenance
  • Automate SQL Server 2019 Management
  • Monitor SQL Server 2019 by Using Alerts and Notifications

The Ultimate Microsoft SQL Server 2019 Database Maintenance Course!

Are you ready to unlock the full potential of Microsoft SQL Server 2019? Look no further! Our cutting-edge course is designed to equip you with the knowledge and skills needed to master the art of maintaining SQL Server databases like a pro. Get ready to embark on a thrilling journey that will supercharge your career and propel you to new heights in the world of IT.

What sets this course apart is its focus on the latest and greatest features of SQL Server 2019. Stay ahead of the curve as we delve into the most powerful tools and product enhancements that will revolutionize your database management game. From installation to advanced maintenance techniques, we leave no stone unturned in our quest to transform you into a SQL Server wizard.

Unleash your inner database superhero as you explore a comprehensive range of topics, including data storage, maintenance, recovery, monitoring, security, and server maintenance. Gain mastery over the intricacies of each area and discover how to optimize your SQL Server environment for maximum efficiency and performance. With our hands-on approach, you’ll gain real-world experience that will set you apart from the competition.

To ensure your success, we’ve crafted this course with your needs in mind. No matter your background, our prerequisite-friendly approach caters to beginners and experienced professionals alike. Basic knowledge of the Microsoft Windows operating system and Transact-SQL is recommended, but fear not if you’re a newbie—we’ll guide you every step of the way.

But wait, there’s more! We’re committed to your long-term success, which is why our course offers the added bonus of exam preparation. By completing this training, you’ll be well-equipped to tackle the Microsoft SQL Server 2019 certification exams with confidence. Open doors to exciting career opportunities as you showcase your expertise to employers and stand out in a competitive job market.

Join us on this exhilarating journey to become a Microsoft SQL Server 2019 maintenance maestro. Whether you’re a seasoned professional seeking to upgrade your skills or a budding enthusiast eager to make your mark, this course is your ticket to success. Enroll today and unlock a world of possibilities with the power of SQL Server 2019 at your fingertips!

Course Outline:

Module 1: Installation
SQL Admin Intro

Module 2: Data Storage
Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving Database Files

Module 3: Data Recover
Intro to Data Recovery
Understanding SQL Server Recovery Models
Planning a Backup Strategy
Backing up Databases and Transaction Logs
Using SSMS For Backup
Understanding the Restore Process
How to Restore a Database
Using SSMS To Restore
T-SQL Backup and Restore
Advanced Restore Scenarios
Introduction to Transferring Data
Importing and Exporting Table Data
Copying or Moving a Database

Module 4: Monitoring
Introduction to Monitoring SQL Server
Dynamic Management Views and Functions
Server Reports
System Performance Monitor
Tracing SQL Server Workload Activity
Extended Events
Database Tuning Advisor

Module 5: Security
Introduction to SQL Server Security
Managing Server-Level Security
Managing Database-Level Security
Row Level Security (RLS) Using Policies
Database Security Tools
Contained Database
Auditing Data Access in SQL Server
Implementing Transparent Data Encryption

Module 6: Maintenance
Introduction to Maintenance
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Automating SQL Server Management
Monitoring SQL Server Errors
Configuring Database Mai

Frequently Asked Questions About Microsoft SQL Server Administration

What will I learn in this course?

In our comprehensive online course, you will gain a deep understanding of how to effectively maintain and optimize Microsoft SQL Server databases. This course focuses on the latest features in SQL Server versions 2016, 2017, and 2019. By the end of the course, you will have acquired a solid skill set for efficiently managing your own SQL Server environment and its databases.

Who is this course intended for?

This online training course is primarily designed for individuals responsible for administering and maintaining SQL Server databases. Whether it’s their main job responsibility or a significant part of their role, this course will provide practical IT skills specifically related to SQL Server 2019. However, anyone interested in gaining knowledge and skills in this area can also benefit from the course.

Can I try it before I buy it?

Absolutely! We offer a 7-day free trial of the All Access Monthly Subscription, starting today. This trial provides you with access to the SQL Server Administration course, as well as over 2,500 hours of on-demand content. If you find that the course is not what you’re looking for, you can easily cancel your subscription within the 7-day trial period.

How long will this online training course take?

This training course is designed to be completed in approximately 6 hours. However, it is a self-paced training, allowing you to learn at your own comfortable pace. You have the flexibility to take more time if needed, ensuring a thorough understanding of the material.

Who is the instructor for this course?

The course is led by James Ring-Howell, a highly experienced professional with over 40 years of relevant IT experience. James has been teaching technical courses for over two decades, making him an excellent instructor to guide you through this SQL Server Administration course.

What are some of the specific topics covered in this training course?

This training course covers a wide range of essential topics, including the installation and configuration of SQL Server 2019, working with databases and storage, planning and implementing backup strategies, restoring SQL Server 2019 databases, importing and exporting data, monitoring SQL Server 2019, managing SQL Server security, and auditing data access. These topics will equip you with the necessary skills to effectively administer and maintain SQL Server databases.

Your Training Instructor

James Ring-Howell

Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.