SQL Server Fundamentals For The Accidental DBA (Video Training) Book/DVD Package

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 youve 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 Developers 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 DBAout of the blue expected to run Microsoft SQL Server efficiently, reliably, and securelywhen 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 youll ever need!

 

Looking for a better way to master todays rapidly changing technologies? Want expert help, but dont have the time or energy to read a book? Cant find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the worlds leading technology experts.

• LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessionsyoull 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

(Computer Bookshops Limited)

Bli först med att recensera och betygsätt boken SQL Server Fundamentals For The Accidental DBA (Video Training) Book/DVD Package - du kan vinna 200 kr varje månad i tävlingen "Månadens recension".

Eric Johnson (Colorado Springs, CO), MCSE, MCDBA, MCSD, CCNP, is a database analyst for a Fortune 500 company. His IT background ranges from operating systems, hardware, and networking to application development. He also holds an MBA. Johnson has spent many years working with Microsoft SQL Server, managing and designing databases of all types. He has delivered many SQL Server training classes and webcasts, and recently presented at TechMentor on SQL Server 2005 Replication, Reporting, and Integration Services. He is VP of Marketing for the Colorado Springs SQL Server Users Group. He wrote Redmond Magazine's series Tour de SQL, and authored A Developer's Guide to Data Modeling for SQL Server.

(Computer Bookshops Limited)

Preface viii

Lesson 1 SQL Server Overview 1

What You Will Learn................................................................................1

We Will Cover................................................................................1

Notes from the Lesson............................................................................1

Lesson 2 Common Uses of SQL Server 3

What You Will Learn................................................................................3

We Will Cover................................................................................3

Notes from the Lesson............................................................................3

Lesson 3 SQL Server Management Studio 5

What You Will Learn................................................................................5

We Will Cover................................................................................6

Notes from the Lesson............................................................................6

Lesson 4 SQL Server Configuration Manager 7

What You Will Learn................................................................................7

We Will Cover................................................................................7

Notes from the Lesson............................................................................8

Lesson 5 SQL Server Profiler 9

What You Will Learn................................................................................9

We Will Cover..............................................................................10

Notes from the Lesson..........................................................................10

Lesson 6 Business Intelligence Development Studio 11

What You Will Learn..............................................................................11

We Will Cover..............................................................................12

Notes from the Lesson..........................................................................12

Lesson 7 Understanding Tables 13

What You Will Learn..............................................................................13

We Will Cover..............................................................................13

Notes from the Lesson..........................................................................13

Lesson 8 Understanding Relationships 15

What You Will Learn..............................................................................15

We Will Cover..............................................................................15

Notes from the Lesson..........................................................................15

Lesson 9 Database Files 17

What You Will Learn...............................................................................

(Computer Bookshops Limited)