AzureFeeds

One of the most popular courses that we used to run in person was a SQL Server Administration course. Yesterday, I recently finished converting the course to an online format, and it was a big job.

I’ve had many people asking if we had this type of course. Administration is such an important skill.

Not just a single version course

We were also determined to stay with our tradition of making multi-version courses. We won’t just teach you about SQL Server 2022. Even though we’ve updated content to that version, we’ve included content for all relevant previous versions, and we show the progression across the versions.

We know that most admins and developers need to know their way around several versions.

Who is it for?

• Have you worked with SQL Server? Are you an accidental DBA?
• Do you need to manage one or more servers but feel underprepared?
• Are you familiar with SQL Server security?
• Do you understand file structures, file groups, and compression?
• Can you automate regular tasks securely?
• Are you ready to move beyond the basics and learn from an expert?

If any of these relate to you, this course is tailor-made for you! Join us for detailed instruction, engaging practical exercises, and quizzes designed to reinforce your learning.

The new course is here:

SQL Server Administration for Developers and DBAs

Course Content

The course is really comprehensive and the modules are:

• Getting started
• Core concepts
• Planning for SQL Server installation
• Installing SQL Server
• Managing SQL Server databases
• Planning a backup and recovery strategy
• SQL Server backup and recovery types
• Implementing a backup strategy
• Implementing a recovery strategy
• Managing users and roles
• Managing server and database permissions
• Auditing SQL Server databases
• Table and index structures
• Table partitioning
• Table compression and columnstores
• Automating management with SQL Server Agent
• Configuring database mail
• Using alerts and notifications for monitoring
• Automating routine database maintenance
• Importing and exporting SQL Server data
• Governing resources
• Introduction to advanced and related concepts
• Next steps

It has loads of demos, quizzes, and labs for you to complete if you’d like.

Availability

The course is available today, and you’ll find the course, along with all our other courses at:

https://sqldownunder.com/training/

NOTE: if you are an SDU Insider (which you can become by downloading SDU Tools or any of our free eBooks from the Free Stuff section on our web site), you’ll already know that there is introductory pricing until the end of the month to celebrate the launch of the course.

The post SQL Server Administration for Developers and DBAs – new online on-demand course now available! appeared first on The Bit Bucket.