New to SQL Server: Learning resources

Tutorials, quickstarts, and other educational resources meant to teach you to work with SQL Server on Linux for users who are familiar with Linux.

Module 1: Basics of SQL Server

Training

• What is a database?
• System databases
• Database files
• What is a table?
• Indexes

Module 2: Plan SQL Server on Linux

Training

• Editions and features
• Supported platforms
• Frequently asked questions

Module 3: Install/deploy & connect

Training

• Red Hat
• SUSE
• Ubuntu
• Container
• Tools overview
• Azure Data Studio (tool)
• Write basic Transact-SQL (T-SQL)

Module 4: Configure SQL Server on Linux

Training

• Change default port
• Set default paths
• Set trace flags
• Join domain
• Load sample data
• Migrate

Module 5: Configure business continuity

Training

• Business continuity options
• Deploy Pacemaker Cluster
• Configure availability group

Module 6: Monitor and tune

Training

• Performance dashboard
• Query store
• DMVs
• Additional learning - Performance features of SQL Server on Linux