by | Released December 2008 | ISBN: 9780321601421

SQL Server Fundamentals for the Accidental DBAEric JohnsonFor 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 2008Eric 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 RequirementsOperating 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 CANADASQL Server Show and hide more

1. LiveLessons Introduction
   • LiveLessons Introduction 00:02:07
2. Section 1: SQL Server Overview
   • Learning Objectives 00:01:32
   • 1: Understanding SQL Server 00:08:11
   • 2: Common Uses of SQL Server 00:04:27
3. Section 2: SQL Server Tools
   • Learning Objectives 00:01:51
   • 3: SQL Server Management Studio 00:16:49
   • 4: SQL Server Configuration Manager 00:09:32
   • 5: SQL Server Profiler 00:09:48
   • 6: Business Intelligence Development Studio 00:06:01
4. Section 3: Relational Database Basics
   • Learning Objectives 00:01:49
   • 7: Understanding Tables 00:11:54
   • 8: Understanding Relationships 00:10:17
5. Section 4: Understanding SQL Server Databases
   • Learning Objectives 00:01:39
   • 9: Database Files 00:14:17
   • 10: The Transaction Log 00:09:32
   • 11: Understanding System Databases 00:09:23
6. Section 5: Server Configuration
   • Learning Objectives 00:01:45
   • 12: Processor Settings 00:04:36
   • 13: Memory Settings 00:05:15
7. Section 6: Backing Up SQL Server Databases
   • Learning Objectives 00:01:47
   • 14: Backing Up Databases 00:16:20
   • 15: Scheduling Backups 00:17:08
8. Section 7: Restoring SQL Server Databases
   • Learning Objectives 00:01:36
   • 16: Restoring Databases 00:12:31
   • 17: Restoring System Databases 00:09:48
9. Section 8: SQL Server Security
   • Learning Objectives 00:01:57
   • 18: Managing Logins 00:13:27
   • 19: Database Users 00:05:52
   • 20: Database Roles 00:08:42
   • 21: Ownership Chaining 00:11:48
10. Section 9: Transact-SQL Basics
    • Learning Objectives 00:01:56
    • 22: Data Manipulation Language 00:24:47
    • 23: Data Definition Language 00:14:13
11. Section 10: Advanced Programmability
    • Learning Objectives 00:01:55
    • 24: Stored Procedures 00:09:44
    • 25: Functions 00:11:10
    • 26: Views 00:09:33
    • 27: Triggers 00:12:50
    • 28: CLR Integration 00:10:47
12. Section 11: Indexing
    • Learning Objectives 00:01:44
    • 29: Indexing Overview 00:07:28
    • 30: Working with Indexes 00:13:10
    • 31: Included Columns 00:06:02
13. Section 12: Application Security
    • Learning Objectives 00:01:50
    • 32: Application Security 00:11:16
    • 33: Abstraction Layers 00:11:53
Show and hide more