SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons

SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons

by Eric Johnson
Released November 2016
Publisher(s): Pearson
ISBN: 0134619722

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

6+ Hours of Video Instruction

Help non-DBAs learn the critical skills they need to manage SQL Servers.

Description

SQL Server is installed behind many third-party applications and behind Microsoft development tools such as Visual Studio. System administrators and developers alike are increasingly responsible for working with and managing SQL Server with no prior exposure or background. Further, they need to understand thebasics of relational databases and technologies, such as indexing and stored procedures, to effectively develop applications. This video covers SQL Server from their perspectives and gives them what they need to manage these instances.

SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons is for power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training. Eric Johnson shows you how to perform the essential DBA tasks with SQL Server 2016, even if you’ve never had any DBA training. In these lessons, you learn at your own pace through realistic hands-on examples that walk you through every step. While these lessons are taught on SQL Server 2016 and use the latest tools and features, most of what you learn can be applied to earlier versions as well. If you are an accidental DBA–expected to run Microsoft SQL Server efficiently, reliably, and securely, when nobody ever taught you how--then this is the video for you. From backup/restore to indexing to scheduling to memory management, you get all the personal, practical DBA training you’ll ever need.

Skill Level
  • Beginner
  • Intermediate

Topics Covered

Fully up-to-date for SQL Server 2016 including:
  • The SQL Server 2016 Management tools
  • Updates to SQL Server 2016 Security
  • Guidance for producing better code for communicating with SQL Server
  • Crucial topics like indexing, query plans, and the execution cache
  • Basic skills and knowledge needed to maintain SQL Server
  • Programmability objects in SQL Server and how the use of each is appropriate
  • Relational databases and how to go about accessing and storing data in a relational database

Who Should Take this Course?
  • Any developer or admin who has been given the responsibility of managing SQL Server
  • Also a good study resource for IT professionals pursuing SQL Certification

Course Requirements
  • Basic IT Skills
  • Intermediate knowledge of Microsoft Windows
  • Understand Windows Services
  • Familiarity with Installing and Managing Applications


About LiveLessons Video Training

The LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons

Table of contents

  1. Introduction
    1. SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons: Introduction
  2. Lesson 1: SQL Server Overview
    1. 1.0 Learning objectives
    2. 1.1 Understand SQL Server
    3. 1.2 Use SQL Server in your Enterprise
  3. Lesson 2: The SQL Server Management Tools
    1. 2.0 Learning objectives
    2. 2.1 Understand SQL Server Management Studio
    3. 2.2 Use Configuration Manager to manage settings
    4. 2.3 Develop with SQL Server data tools
    5. 2.4 Capture traces with SQL Server Profiler
  4. Lesson 3: Relational Database Basics
    1. 3.0 Learning objectives
    2. 3.1 Understand how tables are used in database
    3. 3.2 Understand how to manage relationships between tables
  5. Lesson 4: Server Configuration
    1. 4.0 Learning objectives
    2. 4.1 Configure SQL Server processor settings
    3. 4.2 Configure SQL Server memory settings
  6. Lesson 5: Configuring Databases
    1. 5.0 Learning objectives
    2. 5.1 Create tables in a SQL Server database
    3. 5.2 Understand how SQL Server uses database files
  7. Lesson 6: Backup SQL Server Databases
    1. 6.0 Learning objectives
    2. 6.1 Choose an appropriate backup type
    3. 6.2 Backup databases using the GUI
    4. 6.3 Script and automate database backups
  8. Lesson 7: Restore SQL Server Databases
    1. 7.0 Learning objectives
    2. 7.1 Choose a restore type based on your backups
    3. 7.2 Restore a backup using the GUI
    4. 7.3 Restore backups of System databases
  9. Lesson 8: Server Security
    1. 8.0 Learning objectives
    2. 8.1 Manage logins in SQL Server
    3. 8.2 Understand and use the appropriate Server Roles
    4. 8.3 Understand other server level permissions
  10. Lesson 9: Database Security
    1. 9.0 Learning objectives
    2. 9.1 Configure users in a database
    3. 9.2 Configure appropriate database roles
    4. 9.3 Understand the other database level permissions
  11. Lesson 10: T-SQL
    1. 10.0 Learning objectives
    2. 10.1 Use data manipulation language to make changes to data
    3. 10.2 Use data definition language to manage objects in SQL Server
  12. Lesson 11: Advanced Programmability
    1. 11.0 Learning objectives
    2. 11.1 Understand stored procedures and know when they are used
    3. 11.2 Understand functions and know when they are used
    4. 11.3 Create views based on your underlying tables
    5. 11.4 Create triggers to update data when events occur
    6. 11.5 Understand CLR integration and how you can use it with functions and stored procedures
  13. Lesson 12: Configuring SQL Server Indexes
    1. 12.0 Learning objectives
    2. 12.1 Understand the types of indexes
    3. 12.2 Use indexes to improve database performance
    4. 12.3 Understand when to use covering indexes
  14. Lesson 13: Application Security
    1. 13.0 Learning objectives
    2. 13.1 Set up application security
    3. 13.2 Create an abstraction layer
  15. Summary
    1. SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons: Summary

Product information

  • Title: SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons
  • Author(s): Eric Johnson
  • Release date: November 2016
  • Publisher(s): Pearson
  • ISBN: 0134619722