Flash Player 10 or higher is required.
Please download the Flash Player and install the latest version before continuing.
Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Overview
SQL Server Fundamentals for the Accidental DBA
Eric Johnson
For power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training.
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. Learn at your own pace through realistic hands-on examples that walk you through every step!
SQL Server MVP and expert Eric Johnson is a database analyst who has spent many years working with Microsoft SQL Server. He is author of A Developer’s Guide to Data Modeling for SQL Server (Addison-Wesley, 2008) and the forthcoming Windows Essential Business Server 2008 Unleashed (Sams). Eric is currently the President of the Colorado Springs SQL Server Users Group.
“Are you an accidental DBA–out of the blue expected to run Microsoft SQL Server efficiently, reliably, and securely–when nobody ever taught you how? From installation to backup/restore, indexing to scheduling to memory management, expert Eric Johnson will give you all the personal, practical DBA training you’ll ever need!”
Looking for a better way to master today’s rapidly changing technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading technology experts.
LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessions–you’ll learn key skills in as little as fifteen minutes!
Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.
Follow along as your trainer shows how to perform all the critical tasks needed to manage either SQL Server 2005 or SQL Server 2008
Eric Johnson, MCSE, MCDBA, MCSD, a database analyst for a Fortune 500 company, has spent many years working with Microsoft SQL Server. Honored by Microsoft as a SQL Server MVP, he has taught many SQL Server training classes, and is the President of the Colorado Springs SQL Server Users Group.
System Requirements
Operating System: Windows 98, 2000, XP, or Vista; Mac OS X; versions of Linux with the Flash 8 Player or later.
Multimedia: DVD drive, an 800x600 or higher display, and a sound card with speakers.
Computer: 500MHz or higher, 128MB RAM or higher.
$69.99 USA / $83.99 CANADA
SQL Server
Subscriber Reviews
Average Rating: 
Based on 20 Ratings
"Architect" - by Woobad on 16-NOV-2012
Reviewer Rating:
Very helpful. I highly recommending it to non DBA admins.
Report as Inappropriate
"Great video!" - by Chris on 26-JUL-2012
Reviewer Rating:
Great video training! For the new admin or to refresh your skills.
Report as Inappropriate
"SQL Server Fundamentals for the Acccidental DBA" - by Jose Ayala on 16-JUL-2012
Reviewer Rating:
I think this is an excellent introduction to SQL Server, and I gave 5 stars to the trainer. This is my first training in SQL Server and now I have a general idea of eveything is possible to do with this software. I understand how difficult is to put such a broad suject in only 33 lessons, but the trainer did a great job on this as well.
Of course, I will need to practice on the SQL Server Express version that I downloaded from the Microsoft Website, while get the developer version which I bought. This will help to practice and become familiar with the real software. The trainer is excellent and converts a very dificult subject into easy lessons to follow. I wish he creates other courses. I will do more training on my goal towards certification. After this training and having this general view, I will start focusing on the details on the certification book from Microsoft for the exam 70-433.
Report as Inappropriate
"Great Overview of SQL 2008" - by jrm263 on 10-MAR-2012
Reviewer Rating: 
I recently have landed a role where I'll be managing a SQL 2008 database and had very little experience prior. I was looking for a good overview video to get me jumpstarted onto a path as a DBA. This video provided me just that.
Report as Inappropriate
"Bravo!" - by rmccollum on 05-APR-2011
Reviewer Rating:
Great presentation of the workings for the new MS T-SQL dba. Great Job Eric.
Report as Inappropriate
Browse Similar Topics
Top Level Categories:
Information Technology & Software Development
Vendor
Sub-Categories:
Information Technology & Software Development > Databases
Databases > Microsoft SQL Server
Vendor > Microsoft
Table of Contents
Chapter/Selection | Time | |
|---|---|---|
LiveLessons Introduction | ||
 | 00:02:06 | |
Section 1: SQL Server Overview | ||
 | 00:01:32 | |
| 00:08:11 | |
| 00:04:27 | |
Section 2: SQL Server Tools | ||
| 00:01:51 | |
| 00:16:48 | |
| 00:09:32 | |
| 00:09:47 | |
| 00:06:01 | |
Section 3: Relational Database Basics | ||
| 00:01:48 | |
| 00:11:54 | |
| 00:10:16 | |
Section 4: Understanding SQL Server Databases | ||
| 00:01:39 | |
| 00:14:17 | |
| 00:09:31 | |
| 00:09:22 | |
Section 5: Server Configuration | ||
| 00:01:45 | |
| 00:04:35 | |
| 00:05:14 | |
Section 6: Backing Up SQL Server Databases | ||
| 00:01:47 | |
| 00:16:19 | |
| 00:17:08 | |
Section 7: Restoring SQL Server Databases | ||
| 00:01:36 | |
| 00:12:31 | |
| 00:09:47 | |
Section 8: SQL Server Security | ||
| 00:01:56 | |
| 00:13:26 | |
| 00:05:52 | |
| 00:08:41 | |
| 00:11:48 | |
Section 9: Transact-SQL Basics | ||
| 00:01:56 | |
| 00:24:46 | |
| 00:14:12 | |
Section 10: Advanced Programmability | ||
| 00:01:54 | |
| 00:09:44 | |
| 00:11:09 | |
| 00:09:32 | |
| 00:12:49 | |
| 00:10:47 | |
Section 11: Indexing | ||
| 00:01:44 | |
| 00:07:27 | |
| 00:13:10 | |
| 00:06:01 | |
Section 12: Application Security | ||
| 00:01:50 | |
| 00:11:16 | |
| 00:11:53 |