Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Mastering SQL Server RDS on AWS
Mastering SQL Server RDS on AWS

Mastering SQL Server RDS on AWS: Let's learn Microsoft SQL Server Administration with AWS RDS from a certified administrator

Arrow left icon
Profile Icon Emar Morrison
Arrow right icon
€8.99 €52.99
Video Nov 2023 3hrs 18mins 1st Edition
Video
€8.99 €52.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Emar Morrison
Arrow right icon
€8.99 €52.99
Video Nov 2023 3hrs 18mins 1st Edition
Video
€8.99 €52.99
Subscription
Free Trial
Renews at €18.99p/m
Video
€8.99 €52.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Key benefits

  • Explore SQL Server database setup, performance optimization, data security, and high availability
  • Indulge in real-world examples and case studies on SQL Server on AWS RDS in practical scenarios
  • Gain the ability to troubleshoot common issues that arise when working with SQL Server on AWS RDS

Description

SQL Server on AWS RDS refers to the deployment of Microsoft SQL Server on Amazon Web Services (AWS) Relational Database Service (RDS), a managed database service that simplifies database administration tasks such as setup, patching, monitoring, and backups. You can use AWS’s cloud infrastructure to host, manage, and scale your SQL Server databases. The course begins with the fundamentals of setting up an RDS instance for SQL Server and creating and managing databases. The course delves into essential aspects such as performance optimization through indexing and query stores. It explores data security measures with backup and disaster recovery solutions, including authentication, authorization, and encryption. We will learn to achieve high availability using Multi-AZ deployments and Read Replicas and gain skills in troubleshooting common issues that may arise when working with SQL Server on AWS RDS. This course equips us with the expertise to manage databases in a cloud environment effectively. Upon completing the course, we will deeply understand deploying, managing, and optimizing SQL Server databases on the AWS RDS platform. With expertise in database setup, performance tuning, data security, and high availability strategies, be well-prepared to work with SQL Server in the cloud.

Who is this book for?

This course is designed to benefit a broad audience, including recent college graduates looking to start a career in database administration, experienced Database Administrators (DBAs) aiming to specialize in SQL Server on AWS RDS, and IT professionals seeking to enhance their skills in cloud-based database management. This course equips individuals at different stages of their careers with the knowledge and practical skills to excel in deploying, managing, and optimizing SQL Server on the AWS RDS platform. Basic familiarity with Microsoft SQL Server is desirable but is not strictly required.

What you will learn

  • Deploy and manage SQL Server databases on AWS RDS
  • Learn performance optimization with indexing and query store
  • Implement data security authentication, authorization, and encryption
  • Set up backup/disaster recovery solutions for SQL Server databases
  • Achieve high availability by Multi-AZ deployments and Read Replicas
  • Learn practical troubleshooting skills for common SQL Server RDS issues

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Nov 29, 2023
Length: 3hrs 18mins
Edition : 1st
Language : English
ISBN-13 : 9781835466704
Category :
Languages :
Tools :

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Nov 29, 2023
Length: 3hrs 18mins
Edition : 1st
Language : English
ISBN-13 : 9781835466704
Category :
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 44.97 200.97 156.00 saved
Mastering SQL Server RDS on AWS
€8.99 €52.99
Hands-On Reactive Programming with Java 12 [V]
€8.99 €120.99
SQL Query Design Patterns and Best Practices
€26.99
Total 44.97 200.97 156.00 saved Stars icon
Banner background image

Table of Contents

11 Chapters
Introduction Chevron down icon Chevron up icon
Getting Started with SQL Server RDS Chevron down icon Chevron up icon
Configuring SQL Server RDS Instance Chevron down icon Chevron up icon
Managing SQL Server RDS Instance Chevron down icon Chevron up icon
Database Creation and Configuration Chevron down icon Chevron up icon
Securing Your SQL Server Chevron down icon Chevron up icon
Backing Up and Restoring Amazon RDS DB with Snapshots Chevron down icon Chevron up icon
Native Backup and Restore in SQL Server Chevron down icon Chevron up icon
Automating SQL Server RDS Processes Chevron down icon Chevron up icon
High Availability and Disaster Recovery Chevron down icon Chevron up icon
Monitoring and Performance Chevron down icon Chevron up icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.