8+ Hours of Video Instruction
A comprehensive guide to provisioning, managing, and securing SQL Server 2017 databases
Overview
In this video, database analyst and trainer Eric Johnson gives you the tools you need to manage SQL Server in your environment. You learn about the new features in SQL Server 2017, including running SQL Server on Linux. You also learn how to provision and secure Azure databases, design SQL Server tables, and …
8+ Hours of Video Instruction
A comprehensive guide to provisioning, managing, and securing SQL Server 2017 databases
Overview
In this video, database analyst and trainer Eric Johnson gives you the tools you need to manage SQL Server in your environment. You learn about the new features in SQL Server 2017, including running SQL Server on Linux. You also learn how to provision and secure Azure databases, design SQL Server tables, and tune and optimize SQL. The video wraps up by showing you how to manage data recovery and implement high-availability databases.
Throughout the video, Eric explains the concepts and methodologies of managing SQL Server databases and then puts techniques into practice with visual demonstrations. With Eric as your guide, follow his detailed steps and get hands-on practice to become a more experienced--and more efficient-- database adminstrator.
About the Instructor
Eric Johnson has been working with SQL Server since 1998 when he started doing administration on version 6.5. For over 20 years, Eric has done everything with the product from administrator to development to database design. He has recorded several video tutorials about SQL Server, including Introduction to SQL Server 2016 Integration Services (SSIS) LiveLessons and SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons published by Pearson. Eric has worked with Microsoft on developing their certification exams on SQL Server and was a SQL Server MVP for 5 years.
Skill Level
All levels
Learn How To
Who Should Watch This Video
These video lessons are for database administrators, architects, and developers, and performance tuning experts
Requirements
Understanding of the Windows operating system
An IT background
Previous experience with SQL Server not required
Introduction
SQL Server 2017 Administration Inside Out: Introduction
Lesson 1: Installing and Using SQL Server Administration and Development Tools
Learning objectives
1.1 Understand the Installation Center
1.2 Find the tools installed with the SQL Server
1.3 Use the performance and reliability monitoring tools
1.4 Understand SQL Server Management Studio
1.5 Understand SQL Server Data Tools
Lesson 2: Introducing Database Server Components
Learning objectives
2.1 Configure server memory
2.2 Setup database files
2.3 Configure network settings
2.4 Setup SQL Server security
Lesson 3: Provisioning SQL Server SQL Databases
Learning objectives
3.1 Install a new instance
3.2 Make post-installation server configuration changes
3.3 Install and configure database features
3.4 Create SQL Server databases
Lesson 4: Provisioning Azure SQL Databases
Learning objectives
4.1 Understand Microsoft Azure and database-as- a-service concepts
4.2 Provision a logical SQL Server
4.3 Provision a database
4.4 Setup security in Azure SQL databases
Lesson 5: Implementing and Managing SQL Server User Security and Permissions
Learning objectives
5.1 Understand logins and users
5.2 Setup permissions in SQL Server
5.3 Migrate SQL Server logins
Lesson 6: Securing the Server and Data
Learning objectives
6.1 Handle encryption in SQL Server
6.2 Setup row level security
6.3 Understand data masking
6.4 Configure SQL Server audits
Lesson 7: Understanding and Designing SQL Server Tables
Learning objectives
7.1 Review table design
7.2 Understand special table types
7.3 Create views
7.4 Use change tracking
7.5 Understand Change Data Capture
Lesson 8: Performance Tuning and Optimizing SQL
Learning objectives
8.1 Understand isolation levels
8.2 Use execution plans
8.3 Configure clustered indexes
8.4 Configure non-clustered indexes
8.5 Use index statistics
8.6 Understand parallelism
Lesson 9: Developing, Deploying, and Managing Data Recovery
Learning objectives
9.1 Understand data recovery fundamentals
9.2 Understand backup devices
9.3 Understand different types of backups
9.4 Create and verify backups
9.5 Restore a database
9.6 Define a backup and recovery strategy
Lesson 10: Implementing SQL Server High Availability and Disaster Recovery
Learning objectives
10.1 Review high availability and disaster recovery technologies
10.2 Setup SQL Server log shipping
10.3 Use SQL replication for high availability
10.4 Read secondary database copies
Lesson 11: Managing and Monitoring SQL Server Databases
Learning objectives
11.1 Monitor database backups
11.2 Deal with database corruption
11.3 Setup index maintenance
11.4 Configure statistics updates
11.5 Cleanup history
11.6 Shrink databases
11.7 Monitor database activity
11.8 Use performance monitor
11.9 Monitor database logs
11.10 Use resource governor
Lesson 12: Automating SQL Server Administration
Learning objectives
12.1 Understand the components of SQL Server automated administration
12.2 Setup database maintenance plans
12.3 Configure multi-server administration
12.4 Use PowerShell to automate SQL Server administration
Summary
SQL Server 2017 Administration Inside Out: Summary