SQL Server 2017 Administration Inside Out

SQL Server 2017 Administration Inside Out

by Eric Johnson
Released January 2018
Publisher(s): Microsoft Press
ISBN: 1509307826

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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

  • Install SQL Server administration and development tools
  • Configure server memory and network settings
  • Provision SQL Server databases, including Azure databases
  • Manage user security and permissions
  • Secure servers and data
  • Design SQL Server tables
  • Configure clustered and non-clustered indexes
  • Create and verify backups and restore a database
  • Implement high availability and disaster recovery

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

Table of contents

  1. Introduction
    1. SQL Server 2017 Administration Inside Out: Introduction
  2. Lesson 1: Installing and Using SQL Server Administration and Development Tools
    1. Learning objectives
    2. 1.1 Understand the Installation Center
    3. 1.2 Find the tools installed with the SQL Server
    4. 1.3 Use the performance and reliability monitoring tools
    5. 1.4 Understand SQL Server Management Studio
    6. 1.5 Understand SQL Server Data Tools
  3. Lesson 2: Introducing Database Server Components
    1. Learning objectives
    2. 2.1 Configure server memory
    3. 2.2 Setup database files
    4. 2.3 Configure network settings
    5. 2.4 Setup SQL Server security
  4. Lesson 3: Provisioning SQL Server SQL Databases
    1. Learning objectives
    2. 3.1 Install a new instance
    3. 3.2 Make post-installation server configuration changes
    4. 3.3 Install and configure database features
    5. 3.4 Create SQL Server databases
  5. Lesson 4: Provisioning Azure SQL Databases
    1. Learning objectives
    2. 4.1 Understand Microsoft Azure and database-as- a-service concepts
    3. 4.2 Provision a logical SQL Server
    4. 4.3 Provision a database
    5. 4.4 Setup security in Azure SQL databases
  6. Lesson 5: Implementing and Managing SQL Server User Security and Permissions
    1. Learning objectives
    2. 5.1 Understand logins and users
    3. 5.2 Setup permissions in SQL Server
    4. 5.3 Migrate SQL Server logins
  7. Lesson 6: Securing the Server and Data
    1. Learning objectives
    2. 6.1 Handle encryption in SQL Server
    3. 6.2 Setup row level security
    4. 6.3 Understand data masking
    5. 6.4 Configure SQL Server audits
  8. Lesson 7: Understanding and Designing SQL Server Tables
    1. Learning objectives
    2. 7.1 Review table design
    3. 7.2 Understand special table types
    4. 7.3 Create views
    5. 7.4 Use change tracking
    6. 7.5 Understand Change Data Capture
  9. Lesson 8: Performance Tuning and Optimizing SQL
    1. Learning objectives
    2. 8.1 Understand isolation levels
    3. 8.2 Use execution plans
    4. 8.3 Configure clustered indexes
    5. 8.4 Configure non-clustered indexes
    6. 8.5 Use index statistics
    7. 8.6 Understand parallelism
  10. Lesson 9: Developing, Deploying, and Managing Data Recovery
    1. Learning objectives
    2. 9.1 Understand data recovery fundamentals
    3. 9.2 Understand backup devices
    4. 9.3 Understand different types of backups
    5. 9.4 Create and verify backups
    6. 9.5 Restore a database
    7. 9.6 Define a backup and recovery strategy
  11. Lesson 10: Implementing SQL Server High Availability and Disaster Recovery
    1. Learning objectives
    2. 10.1 Review high availability and disaster recovery technologies
    3. 10.2 Setup SQL Server log shipping
    4. 10.3 Use SQL replication for high availability
    5. 10.4 Read secondary database copies
  12. Lesson 11: Managing and Monitoring SQL Server Databases
    1. Learning objectives
    2. 11.1 Monitor database backups
    3. 11.2 Deal with database corruption
    4. 11.3 Setup index maintenance
    5. 11.4 Configure statistics updates
    6. 11.5 Cleanup history
    7. 11.6 Shrink databases
    8. 11.7 Monitor database activity
    9. 11.8 Use performance monitor
    10. 11.9 Monitor database logs
    11. 11.10 Use resource governor
  13. Lesson 12: Automating SQL Server Administration
    1. Learning objectives
    2. 12.1 Understand the components of SQL Server automated administration
    3. 12.2 Setup database maintenance plans
    4. 12.3 Configure multi-server administration
    5. 12.4 Use PowerShell to automate SQL Server administration
  14. Summary
    1. SQL Server 2017 Administration Inside Out: Summary

Product information

  • Title: SQL Server 2017 Administration Inside Out
  • Author(s): Eric Johnson
  • Release date: January 2018
  • Publisher(s): Microsoft Press
  • ISBN: 1509307826