Description
Duration: 2 days
During this two-day course database professionals looking to implement SQL Server on Linux
This course is geared toward existing database professionals with experience of database systems running on Linux and Linux professionals who are interested in adding database capabilities
Upon course completion, students will be able to:
Describe key capabilities and components of SQL Server on Linux
Describe how to deploy SQL Server on Linux
Describe how to install the additional optional components to SQL Server
Describe how to configure SQL Server on Linux
Describe how to connect and manage SQL server images on Linux
Describe how to migrate databases from other database systems to SQL Server on Linux and provide disaster recovery
Describe the high availability features of SQL Server on Linux
Prerequisites
It is recommended that in addition to a student’s professional experience, students also have technical knowledge in:
Familiarity with the SUSE, Red Hat, or Ubuntu operating system and networking.
Familiarity with the SQL language
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/25/2023 | 12/26/2023 | ||||
| 1/15/2024 | 1/16/2024 | ||||
| 2/5/2024 | 2/6/2024 | ||||
| 2/26/2024 | 2/27/2024 | ||||
| 3/18/2024 | 3/19/2024 | ||||
| 4/8/2024 | 4/9/2024 | ||||
| 4/29/2024 | 4/30/2024 | ||||
| 5/20/2024 | 5/21/2024 | ||||
| 6/10/2024 | 6/11/2024 | ||||
| 7/1/2024 | 7/2/2024 | ||||
| 7/22/2024 | 7/23/2024 | ||||
| 8/12/2024 | 8/13/2024 | ||||
| 9/2/2024 | 9/3/2024 | ||||
| 9/23/2024 | 9/24/2024 | ||||
| 10/14/2024 | 10/15/2024 | ||||
| 11/4/2024 | 11/5/2024 | ||||
| 11/25/2024 | 11/26/2024 | ||||
| 12/16/2024 | 12/17/2024 | ||||
| 1/6/2025 | 1/7/2025 |
Curriculum
Module 1: Introduction to SQL Server on Linux
Lessons
Why is SQL Server on Linux?
SQL Server on Linux capabilities
Containers
Linux SQL Server VM in Azure
Module 2: Deploying SQL Server on Linux
Lessons
Deploying SQL Server on Ubuntu
Deploying SQL Server on SUSE
Deploying SQL Server on Red Hat
Deploying SQL Server containers on Docker
Lab: Deploying SQL Server on Linux
Installing SQL Server
Installing command-line tools
Creating a database
Create a SQL Server 2017 Docker container
Module 3: Installing additional components
Lessons
SQL Server agent
SQL Server full-text search
SQL Server integration services
Lab: Installing additional components
SQL Server agent
SQL Server full-text search
SQL Server integration services
Remove the Azure virtual machine
Module 4: Configuring SQL Server on Linux
Lessons
Configuring SQL Server with mssql-conf
Configure a SQL Server on Linux Docker image
Module 5: Managing Database Solutions for SQL Server for Linux
Lessons
Connecting to SQL Server on Linux
Managing SQL Server on Linux
Lab: Managing SQL Server on Linux
Connect to SQL Server on Linux
Manage SQL Server on Linux
Module 6: Migrating Databases to SQL Server on Linux and Disaster Recovery
Lessons
Backup and restore
Database export and import
SQL Server migration assistant
Bulk copy program
SQL Server integration services
Lab: Migrating databases
Migrate a database with backup and restore
Migrate a database with SQL Server migration assistant
Module 7: High Availability
Lessons
Log shipping
Failover clustering
Availability groups
Lab: High availability
Configure log shipping
Create a read-scale availability group
