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