SQL Server Fundamentals for the Accidental DBA LiveLessons (Video Training)
Home > Computing and Information Technology > Databases > Database software > SQL Server Fundamentals for the Accidental DBA LiveLessons (Video Training): (LiveLessons)
SQL Server Fundamentals for the Accidental DBA LiveLessons (Video Training): (LiveLessons)

SQL Server Fundamentals for the Accidental DBA LiveLessons (Video Training): (LiveLessons)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

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.  SQL Server

Table of Contents:
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..............................................................................17 We Will Cover..............................................................................18 Notes from the Lesson..........................................................................18 Lesson 10 The Transaction Log 19 What You Will Learn..............................................................................19 We Will Cover..............................................................................19 Notes from the Lesson..........................................................................19 Lesson 11 Understanding System Databases 21 What You Will Learn..............................................................................21 We Will Cover..............................................................................21 Notes from the Lesson..........................................................................21 Lesson 12 Processor Settings 23 What You Will Learn..............................................................................23 We Will Cover..............................................................................24 Notes from the Lesson..........................................................................24 Lesson 13 Memory Settings 25 What You Will Learn..............................................................................25 We Will Cover..............................................................................26 Notes from the Lesson..........................................................................26 Lesson 14 Backing Up Databases 27 What You Will Learn..............................................................................27 We Will Cover..............................................................................28 Notes from the Lesson..........................................................................28 Lesson 15 Scheduling Backups 29 What You Will Learn..............................................................................29 We Will Cover..............................................................................29 Notes from the Lesson..........................................................................29 Lesson 16 Restoring Databases 31 What You Will Learn..............................................................................31 We Will Cover..............................................................................31 Notes from the Lesson..........................................................................31 Lesson 17 Restoring System Databases 33 What You Will Learn..............................................................................33 We Will Cover..............................................................................33 Notes from the Lesson..........................................................................33 Lesson 18 Managing Logins 35 What You Will Learn..............................................................................35 We Will Cover..............................................................................35 Notes from the Lesson..........................................................................35 Lesson 19 Managing Users 37 What You Will Learn..............................................................................37 We Will Cover..............................................................................37 Notes from the Lesson..........................................................................37 Lesson 20 Database Roles 39 What You Will Learn..............................................................................39 We Will Cover..............................................................................39 Notes from the Lesson..........................................................................39 Lesson 21 Ownership Chaining 41 What You Will Learn..............................................................................41 We Will Cover..............................................................................41 Notes from the Lesson..........................................................................41 Lesson 22 Data Manipulation Language 43 What You Will Learn..............................................................................43 We Will Cover..............................................................................43 Notes from the Lesson..........................................................................43 Lesson 23 Data Definition Language 45 What You Will Learn..............................................................................45 We Will Cover..............................................................................45 Notes from the Lesson..........................................................................45 Lesson 24 Stored Procedures 47 What You Will Learn..............................................................................47 We Will Cover..............................................................................47 Notes from the Lesson..........................................................................47 Lesson 25 Functions 49 What You Will Learn..............................................................................49 We Will Cover..............................................................................49 Notes from the Lesson..........................................................................49 Lesson 26 Views 51 What You Will Learn..............................................................................51 We Will Cover..............................................................................51 Notes from the Lesson..........................................................................51 Lesson 27 Triggers 53 What You Will Learn..............................................................................53 We Will Cover..............................................................................53 Notes from the Lesson..........................................................................53 Lesson 28 CLR Integration 55 What You Will Learn..............................................................................55 We Will Cover..............................................................................55 Notes from the Lesson..........................................................................55 Lesson 29 Indexing Overview 57 What You Will Learn..............................................................................57 We Will Cover..............................................................................57 Notes from the Lesson..........................................................................57 Lesson 30 Working with Indexes 59 What You Will Learn..............................................................................59 We Will Cover..............................................................................59 Notes from the Lesson..........................................................................59 Lesson 31 Included Columns 61 What You Will Learn..............................................................................61 We Will Cover..............................................................................61 Notes from the Lesson..........................................................................61 Lesson 32 Application Security 63 What You Will Learn..............................................................................63 We Will Cover..............................................................................63 Lesson 33 Abstraction Layers 65 What You Will Learn..............................................................................65 We Will Cover..............................................................................65 Notes from the Lesson..........................................................................

About the Author :
Eric S. Johnson, is the co-founder of Consortio Services and the primary Database Technologies Consultant; he is also a Microsoft SQL Server MVP. He has been recognized by Microsoft as an MVP for his expertise in SQL Server. 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. Since IT is really just a way to support business processes, he also acquired his MBA in 2004. All in all, he has more than 10 years of experience with IT, a great 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. In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users Group. He has published works from technical magazine articles for the likes of Redmond Magazine to authoring books such as A Developer’s Guide to Data Modeling for SQL Server, published by Addison-Wesley.


Best Sellers


Product Details
  • ISBN-13: 9780321602770
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison-Wesley Educational Publishers Inc
  • Height: 231 mm
  • No of Pages: 80
  • Spine Width: 27 mm
  • Width: 194 mm
  • ISBN-10: 0321602773
  • Publisher Date: 26 Mar 2009
  • Binding: SF
  • Language: English
  • Series Title: LiveLessons
  • Weight: 328 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
SQL Server Fundamentals for the Accidental DBA LiveLessons (Video Training): (LiveLessons)
Pearson Education (US) -
SQL Server Fundamentals for the Accidental DBA LiveLessons (Video Training): (LiveLessons)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

SQL Server Fundamentals for the Accidental DBA LiveLessons (Video Training): (LiveLessons)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!