در این آموزش تصویری با پیاده سازی SQL Server روی Amazon RDS آشنا می شوید.
این دوره آموزشی محصول موسسه Pluralsight است.

سرفصل های دوره:

  • Amazon RDS چیست؟
  • معرفی Amazon RDS
  • نحوه ایجاد کسب و کار
  • کار با ماژول ها
  • نحوه ساخت پایگاه داده SQL Server
  • نحوه ذخیره سازی داده ها
  • ایجاد SQL Server در RDS از طریق کنسول AWS
  • پیکربندی SQL Server
  • پیکربندی SQL Server در RDS از طریق خط فرمان
  • مدیریت SQL Server در Amazon RDS
  • نحوه اتصال SQL به RDS
  • نحوه اتصال به شبکه
  • اتصال به دیتابیس با SSMS و Excel
  • نحوه کارکرد در RDS
  • مشاهده گزارش ها
  • کار با دستورات SQL
  • نحوه انتقال داده ها در SQL Server
  • نحوه برنامه نویسی پایگاه داده
  • نحوه انتقال داده ها با BCP
  • استفاده از پایگاه داده های SQL
  • نحوه پشتیبان گیری از پایگاه داده
  • نحوه کاهش هزینه ها
  • نحوه بازیابی داده ها
  • نحوه کار با RDS
  • استقرار SQL Server
  • کار با arounds
  • ایجاد یک سرور در RDS
  • بررسی محدودیت ها برنامه
  • و…

عنوان دوره: Pluralsight Implementing SQL Server on Amazon RDS
سطح: متوسط
مدت زمان: 2 ساعت و 20 دقیقه
نویسنده: Warner Chaves


Pluralsight Implementing SQL Server on Amazon RDS

Warner Chaves
2h 20m

A guide for database administrators to implement SQL Server on Amazon RDS
Amazon is one of the biggest providers of cloud computing in the world. Part of their offering is the database cloud service known as Amazon RDS. In this course, we'll cover what these service can do, the option and configuration choices for SQL Server, and the differences from the on-premises SQL Server that you already know.

What Is Amazon RDS?
9m 30s
Introducing Amazon RDS
1m 44s
What Is Database as a Service?
4m 45s
The Business Value of RDS
1m 25s
Module Summary
1m 34s
Building Your SQL Server on Amazon RDS
33m 34s
What's in This Module?
0m 49s
Planning Your Deployment
2m 18s
Pricing and Instance Choices
3m 51s
Storage and Networking
8m 10s
Demo: Create Your SQL Server on RDS through the AWS Console
6m 14s
Configuring Your SQL Server in RDS
3m 7s
Demo: Configure Your SQL Server in RDS through the AWS Console
4m 44s
Demo: Configure SQL Server in RDS through the AWS Command Line
3m 15s
Module Summary
1m 2s
Connecting and Managing SQL Server on Amazon RDS
24m 49s
What's in This Module?
1m 1s
Connecting to SQL in RDS
2m 32s
Demo: Verify Network Connectivity
3m 1s
Demo: Connecting with SSMS and Excel
2m 10s
The RDS Admin User
2m 0s
Demo: Working as RDS Admin
3m 25s
Working with the SQL Agent
1m 4s
Demo: SQL Agent Functionality in RDS
3m 21s
Viewing SQL Server Logs in RDS
1m 40s
Demo: Viewing SQL Logs on the AWS Web Console
1m 49s
Demo: Viewing SQL Logs through SQL Commands
2m 3s
Module Summary
0m 36s
Moving Data in and Out of SQL Server on RDS
21m 50s
What's in This Module?
0m 45s
Tools to Move Data
2m 46s
Demo: Scripting Your Database
4m 43s
Which Tool to Use
1m 5s
Demo: Moving Data with the Import/Export Wizard
3m 25s
Demo: Moving Data with the BCP Utility
3m 9s
SQL Database Migration Wizard
0m 55s
Demo: Migrate Using the SQL Database Migration Wizard
4m 7s
Module Summary
0m 51s
Configuring Backups and High Availability
29m 57s
What's in This Module?
0m 53s
Backup Settings and Cost
3m 2s
Restore and Recovery Models
2m 6s
Demo: Verify and Modify Backup Settings
3m 42s
Demo: Restoring to a Point in Time
3m 24s
Working with RDS Snapshots
3m 1s
Demo: Creating a Snapshot of Your SQL Server
1m 51s
Demo: Restoring Your SQL Server from a Snapshot
2m 54s
SQL Server Multi-AZ Deployment
3m 22s
Demo: Enabling Multi-AZ Deployment
2m 39s
Demo: Failing over a Multi-AZ deployment
2m 6s
Module Summary
0m 53s
Known Service Limitations
20m 20s
What's in This Module?
0m 40s
Main Limitations and Work-arounds
6m 7s
Demo: Create a Linked Server to RDS
4m 7s
Demo: Set up Transactional Replication to RDS
7m 53s
Other Limitations
0m 40s
Module Summary
0m 50s