SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons

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