Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA

Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA

Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA

Class on Demand Video Download: SQL Server Fundamentals for the Accidental DBA

Show MoreLess


Now Viewing:

No Longer Available

Product Highlights

  • Instructor: Eric Johnson
  • 1Description

The video download SQL Server Fundamentals for the Accidental DBA from Class on Demand is useful for power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training. Instructor Eric Johnson shows you how to perform every essential DBA task with SQL Server 2005 and SQL Server 2008, even if you’ve never had any DBA training. You will learn at your own pace through realistic hands-on examples that walk you through every step. It covers topics from installation to backup/restore and indexing to scheduling to memory management.

Lessons (Run Time)

Section 1: SQL Server Overview (00:11:58)

Course Introduction (2:09)
Overview (1:35)
1: Understanding SQL Server (8:14)

Section 2: SQL Server Tools (00:48:40)

Learning Objectives (1:53)
2: Common Uses of SQL Server (4:29)
3: SQL Server Management Studio (16:50)
4: SQL Server Configuration Manager (9:34)
5: SQL Server Profiler (9:51)
6: Business Intelligence Development Studio (6:03)

Section 3: Relational Database Basics (00:24:09)

Learning Objectives (1:52)
7: Understanding Tables (11:57)
8: Understanding Relationships (10:20)

Section 4: Understanding SQL Server Databases (00:34:58)

Learning Objectives (1:42)
9: Database Files (14:19)
10: The Transaction Log (9:33)
11: Understanding System Databases (9:24)

Section 5: Server Configuration (00:11:42)

Learning Objectives (1:47)
12: Processor Settings (4:39)
13: Memory Settings (5:16)

Section 6: Backing Up SQL Server Databases (00:35:21)

Learning Objectives (1:49)
14: Backing Up Databases (16:22)
15: Scheduling Backups (17:10)

Section 7: Restoring SQL Server Databases (00:24:02)

Learning Objectives (1:39)
16: Restoring Databases (12:34)
17: Restoring System Databases (9:49)

Section 8: SQL Server Security (00:41:54)

Learning Objectives (1:58)
18: Managing Logins (13:28)
19: Database Users (5:54)
20: Database Roles (8:43)
21: Ownership Chaining (11:51)

Section 9: Transact-SQL Basics (00:41:01)

Learning Objectives (1:59)
22: Data Manipulation Language (24:48)
23: Data Definition Language (14:14)

Section 10: Advanced Programmability (00:56:13)

Learning Objectives (1:58)
24: Stored Procedures (9:47)
25: Functions (11:13)
26: Views (9:34)
27: Triggers (12:51)
28: CLR Integration (10:50)

Section 11: Indexing (00:28:33)

Learning Objectives (1:46)
29: Indexing Overview (7:31)
30: Working with Indexes (13:13)
31: Included Columns (6:03)

Section 12: Application Security (00:25:07)

Learning Objectives (1:52)
32: Application Security (11:19)
33: Abstraction Layers (11:56)

About the Presenter

Eric Johnson (MCSE, MCDBA, MCSD, CCNP) is a co-founder of Consortio Services, and the primary Database Technologies Consultant. His background in information technology is diverse, ranging from operating systems and hardware to specialized applications and development. He has even done his fair share of work on networks and has also acquired his MBA. In his 10 years of experience with IT, a large amount of which has been working with Microsoft SQL Server, Eric has managed and designed databases of all shapes and sizes.

He has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. He has also presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. He also does a good deal of writing, including the recent four-part series, Tour de SQL, published in Redmond magazine. In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users' Group.

Table of Contents
  • 1Description
Instructor Eric Johnson
Run Time 6:23:38
Be the first to review this item
See any errors on this page? Let us know.