Home > Store > Data > SQL Server

SQL Server 2012 Fundamentals for the Accidental DBA: A Guide to SQL Server for Developers and Systems Administrators, (Video Training), Downloadable:

Downloadable Video

  • Your Price: $119.99
  • List Price: $149.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Register your product to gain access to bonus material or receive a coupon.

Buy Lessons

DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec. Requires the free QuickTime Player software.

Lesson 1

Lesson 1: SQL Server Overview, Downloadable Version

A quick overview of SQL Server for the uninitiated and a look at where you might find SQL Server in use in your environment.

Duration: 00:15:40  File Size: 27 MB

Lesson 2

Lesson 2: The Tools, Downloadable Version

A look at where you might find SQL Server in use in your environment, an overview of using the Configuration Manager to manage various aspects of your services and a look at SQL Server Profiler and its usefulness in gathering data about SQL Server instances. Also includes a brief look at the Business Intelligence development tool, SQL Server Data Tools.

Duration: 00:42:37  File Size: 134 MB

Lesson 3

Lesson 3: Relational Database Basics, Downloadable Version

An introduction to tables and how they are used in a SQL Server Database and a look at relationship between tables in an RDBMS.

Duration: 00:36:30  File Size: 142 MB

Lesson 4

Lesson 4: Understanding SQL Server Databases, Downloadable Version

This lesson includes a look at how SQL Server manages the various files that make up databases, a closer look at the Transaction Log to help you understand its importance to SQL Server Databases and will teach some things about the system databases and why each is important.

Duration: 00:39:15  File Size: 108 MB

Lesson 5

Lesson 5: Server Configuration, Downloadable Version

An overview of the various configuration options available on you SQL Server instances.

Duration: 00:12:01  File Size: 43 MB

Lesson 6

Lesson 6: Backing Up SQL Server Databases, Downloadable Version

A kickstart discussion on backups, covering the various type available and a look at how to schedule your backup to create on going hands off maintenance.

Duration: 00:40:01  File Size: 163 MB

Lesson 7

Lesson 7: Restoring SQL Server Databases, Downloadable Version

Learn about the tools necessary to restore SQL Server backups. A look at restoring system databases and the special steps required when doing so.

Duration: 00:27:49  File Size: 84 MB

Lesson 8

Lesson 8: Server Security, Downloadable Version

A look at the basics of SQL Server instance level security.

Duration: 00:13:31  File Size: 41 MB

Lesson 9

Lesson 9: Database Security, Downloadable Version

A lesson on SQL Server database security; the creation and management of Database Users; using SQL Server roles to manage database security; and a look at ownership chaining and why it is important to your security configuration.

Duration: 00:37:28  File Size: 113 MB

Lesson 10

Lesson 10: T-SQL, Downloadable Version

An introduction to t-sql by covering Data Manipulation Language and Data Definition Language providing you with the know-how to create and manage object with t-sql.

Duration: 00:38:27  File Size: 141 MB

Lesson 11

Lesson 11: Advanced Programmability, Downloadable Version

This Lesson on Advanced Programmability offers a look at stored Procedures and how they allow you to "store" code that can be run against your databases; an overview of the various types of functions and discussion about how each can be used; a look at views and how they can provide a different way of looking at your data; a discussion about the various types of triggers and when each should be used; and a look at how to enable and utilize CLR code in your SQL Server environment.

Duration: 00:59:42  File Size: 210 MB

Lesson 12

Lesson 12: Indexing, Downloadable Version

This lesson will get you started on SQL Server indexing and discuss how you mange them on your SQL Servers. It will also explore how you can use included columns to help your indexes better find what they need.

Duration: 00:29:20  File Size: 79 MB

Lesson 13

Lesson 13: Application Security, Downloadable Version

This lesson begins with a conceptual lesson covering some real world options for implementing a security strategy and then discusses a framework for managing SQL Server databases and access through the use of abstraction layers.

Duration: 00:27:50  File Size: 91 MB

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2014
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-321-93458-X
  • ISBN-13: 978-0-321-93458-1

6+ Hours of Video Instruction

Overview

Helping 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 the basics 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 2012 Fundamentals for the Accidental DBA LiveLessons is for power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training. In it, SQL Server MVP Eric Johnson shows you how to perform the essential DBA tasks with SQL Server 2012, even if you’ve never had any DBA training. In these lessons, you will learn at your own pace through realistic hands-on examples that walk you through every step. If you are an accidental DBA—out of the blue expected to run Microsoft SQL Server efficiently, reliably, and securely—when nobody ever taught you how, then this is the video for you. From installation to backup/restore, indexing to scheduling to memory management, you get all the personal, practical DBA training you’ll ever need.

About the Instructor

Eric Johnson (MCSE, MCDBA, MCSD, CCNP) is co-founder of Consortio Services, and the company’s primary Database Technologies Consultant. His background in information technology is diverse—ranging from operating systems and hardware, specialized applications and development to a fair amount of work on networks. Since IT is really just a way to support business processes, he also acquired an MBA. In total, he has more than 15 years IT experience, with a good number of those dedicated to working with Microsoft SQL Server. Eric has managed and designed databases of all shapes and sizes and has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. Most recently, he presented at TechMentor on SQL Server Replication, Reporting Services, and Integration Services. He also does a good deal of writing, including the four-part series "Tour de SQL" published in Redmond magazine and the book A Developer’s Guide to Data Modeling for SQL Server (Addison-Wesley, 2008). In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users’ Group.

Skill Level

  • Beginner
  • Intermediate

Topics Covered

  • You will obtain an understanding of SQL Server in order to produce better code for communicating with SQL Server.
  • You will gain an understanding of crucial topics like indexing, query plans, and the execution cache.
  • You will attain the basic skills and knowledge needed to maintain SQL Server.
  • You will understand all the programmability objects in SQL Server and how the use of each is appropriate.
  • You will secure an understanding of 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

Table of Contents:

Introduction to SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons

Lesson 1 SQL Server Overview

1.1 Understanding SQL Server

1.2 SQL Server Uses

Lesson 2 The Tools

2.1 SQL Server Management Studio

2.2 Configuration Manager

2.3 Profiler

2.4 SQL Server Data Tools

Lesson 3 Relational Database Basics

3.1 Tables

3.2 Relationships

Lesson 4 Understanding SQL Server Databases

4.1 Database Files

4.2 Transaction Log

4.3 Understanding System Databases

Lesson 5 Server Configuration

5.1 Basic SQL Server Configuration

Lesson 6 Backing Up SQL Server Database

6.1 Backup Types

6.2 Scheduling Backups

Lesson 7 Restoring SQL Server Databases

7.1 Restore Type

7.2 Restoring System Databases

Lesson 8 Server Security

8.1 Server Security

Lesson 9 Database Security

9.1 Users

9.2 Database Roles

9.3 Ownership Changing

Lesson 10 T-SQL

10.1 Basic Data Manipulation Language

10.2 Basic Data Definition Language

Lesson 11 Advanced Programmability

11.1 Stored Procedures

11.2 Functions

11.3 Views

11.4 Triggers

11.5 CLR Integration

Lesson 12 Indexing

12.1 Index Overview

12.2 Working with Indexes

12.3 Included Columns

Lesson 13 Application Security

13.1 How to Set Up Security

13.2 Understanding Abstraction Layers


Summary of SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons

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, VMware 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 http://www.pearsonitcertification.com/imprint/series_detail.aspx?ser=2185116

Sample Content

Table of Contents

Introduction to SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons

Lesson 1 SQL Server Overview

1.1 Understanding SQL Server

1.2 SQL Server Uses

Lesson 2 The Tools

2.1 SQL Server Management Studio

2.2 Configuration Manager

2.3 Profiler

2.4 SQL Server Data Tools

Lesson 3 Relational Database Basics

3.1 Tables

3.2 Relationships

Lesson 4 Understanding SQL Server Databases

4.1 Database Files

4.2 Transaction Log

4.3 Understanding System Databases

Lesson 5 Server Configuration

5.1 Basic SQL Server Configuration

Lesson 6 Backing Up SQL Server Database

6.1 Backup Types

6.2 Scheduling Backups

Lesson 7 Restoring SQL Server Databases

7.1 Restore Type

7.2 Restoring System Databases

Lesson 8 Server Security

8.1 Server Security

Lesson 9 Database Security

9.1 Users

9.2 Database Roles

9.3 Ownership Changing

Lesson 10 T-SQL

10.1 Basic Data Manipulation Language

10.2 Basic Data Definition Language

Lesson 11 Advanced Programmability

11.1 Stored Procedures

11.2 Functions

11.3 Views

11.4 Triggers

11.5 CLR Integration

Lesson 12 Indexing

12.1 Index Overview

12.2 Working with Indexes

12.3 Included Columns

Lesson 13 Application Security

13.1 How to Set Up Security

13.2 Understanding Abstraction Layers

Summary of SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons  

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership