SQL Server 2012: Database Administration - LearnItFirst

1 SQL Server 2012 : Database AdministrationCOURSE 171 5+ Days of instructor-led training 2013 LLC All rights is one of the most trusted names in the IT training industry. Founded in 2004, LearnItFirst now boasts a training library of more than 3,200 instructor-led training videos spanning nearly 800 hours!h Database Engine Analysis Services Reporting Services Integration ServicesCOURSE 171 This course is a comprehensive, soup-to-nuts DBA course for Microsoft SQL Server 2012 . Coverage includes installation planning and deployment, security, backup and recovery, Database management, jobs and automation, and the basics of performance monitoring for DBAs. There are more than 200 videos and the total time is well over 50 hours of training. This course is currently in production with new videos being added weekly. This course also makes extensive use of LearnItFirst s video exercises which include complete walk-throughs of the solutions (and come with the fi les containing both the problems and the solutions).

2 WHAT S INCLUDED IN THIS COURSE 16 chapters of Database Administration training Equivalent to 5+ days of live classroom training Course fi les (.sql, .pdf, .xml, exercises, and more) Hands-on labs and exercises (with sample databases) Highest quality audio and video Three ways to watch:1. Download to your computer2. Mobile devices - watch on your iPhone, iPad, Android device, DVDWHO IS THIS COURSE FOR?People who have had some exposure to SQL Server but who have not undergone a full SQL Server 2012 DBA class. This is not a beginner-level course nor is an advanced course; it is intended for the beginner-to-intermediate and/or someone coming from another system (such as Oracle, DB2, or MySQL) who wants to learn how to administer a SQL Server . PRICING AND MULTI-USER LICENSINGL earnItFirst s courses are priced on a per-user, per-course basis.

3 Site licenses, training vouchers, volume discounts, and our Buy 3, Get 1 Free packages are also available. For more information, please visit our website: Server 2012 : Database AdministrationCOURSE 171 5+ Days of instructor-led training 2013 LLC All rights reservedCOURSE CHAPTER LISTINGThis 16-chapter course covers all facets of SQL Server 2012 Database Administration including planning, installation/upgrade, Database creation, fi le management, security, backup and recovery, automation, mainte-nance, performance, and much more! 01 - Course Introduction 02 - Editions, Licensing, and What s New in SQL Server 2012 03 - Installing and Upgrading to SQL 2012 04 - Using the Tools and Confi guring SQL Server 2012 05 - Creating and Managing Databases 06 - Security in SQL Server 2012 07 - SQL Server 2012 Backup and Recovery 08 - Automating Your SQL Server 09 - Database Maintenance 10 - SQL Server 2012 Performance Monitoring 11 - Virtualizing Your SQL Server 2012 Instance 12 - VLDBs, SANs, SSDs, Partitioning Strategies and More 13 - Managing SQL Server 2012 with PowerShell 14 - A Guide to Moving and Copying Databases 15 - SQL Server Replication 16 - Miscellaneous Administration TopicsFREQUENTLY ASKED QUESTIONS What is the quality of the video/audio?

4 The quality is excellent with sharp video and superb sounding audio. We output high quality, 1024x768 video with CD quality audio. Our videos are recorded and mixed in a professional studio so that you get the highest quality possible. How do I access the videos? For immediate access to your course, you can download the videos from our website. If you d like, a DVD copy is available as well. Do I have to have internet access to watch the videos? No! You only need internet access only to download the videos (unless you choose the DVD, which requires no internet connection). How long are the videos? Each video typically ranges between 10 and 20 minutes and is meant to cover a specifi c topic. This makes it easy to re-use the course later when you need to review a particular Server 2012 : Database AdministrationCourse 171 2013 LLC All rights reservedVIDEOS IN THIS COURSE (cont.)

5 :Viewed?Chapter 1: Course - Course Introduc on - What Is Covered in this Course? - How to Use this Course Eff ec - How this Course is - How the Exercises Are Designed to Help - Opera ng Systems, SQL Server Edi ons, and Diff - Professional Development for SQL Server : What s Next?Chapter 2: Why SQL Server 2012 ? - Edi ons of SQL Server - The Express and Web Edi - 32-Bit or 64-Bit: Which One Should You Choose? - Licensing SQL Server 2012 : The - Licensing SQL Server 2012 : CPUs and Core Factors2. 6 - Licensing SQL Server 2012 : Virtualiza on and - Sizing Up New Hardware and Choosing Your SQL Server Edi on2 .8 - What s New in SQL Server 2012 for DBAs: Overview2 .9 - The History of SQL ServerChapter 3: Installing and Upgrading to SQL Server - Decisions You Have to - Decisions You Have to Make: Hardware Benchmarking3 .3 - Decisions You Have to Make: Requirements, Architecture, - Decisions You Have to Make: Security - What DBAs Need to Know About RAID - Decisions You Have to Make: File - Decisions You Have to Make: Service Accounts, Domain - Decisions You Have to Make: Instance Names, Mul ple Instances, Colla - Se ng Up the Domain User and Managed Service - Installing an Instance of SQL Server - Installing a Named Instance and A First Look at What s - A Quick Look at Management Studio and Other Tools SQL Server 2012 : Database AdministrationCourse 171 2013 LLC All rights reservedVIDEOS IN THIS COURSE (cont.)

6 :Viewed?Chapter 3: Installing and Upgrading to SQL Server 2012 (cont.) - Exercise 01: Preparing Your Environment to Install SQL Server - Exercise 02: Installing SQL Server - Other Things You Can Do to Op mize Your SQL Server Installa - Installing Service Packs, Hot Fixes, and Cumula ve - How to Use Product Updates to Slipstream a SQL Server 2012 Installa - Upgrading to SQL Server 2012 - - Upgrading to SQL Server 2012 - Running the Upgrade AdvisorChapter 4: Using the Tools and Confi guring SQL Server - An Overview of Which Tools Perform Which Func - SQL Server Management Studio - - SQL Server Management Studio - Connec ons, Templates, and - SQL Server Management Studio - Tips and - SQL Server Confi gura on Manager, SQL Server Data Tools, and Books - How to Confi gure SQL Server 2012 - Service Accounts and Service - How to Confi gure SQL Server 2012 - Network Protocols, Networking, and - How to Confi gure SQL Server 2012 - Confi gure Memory - How to Confi gure SQL Server 2012 - Confi gure CPU - How to Confi gure SQL Server 2012 - Security Se ngs, Audi ng, Connec on Op ons - How to Confi gure SQL Server 2012 - Even More Confi gura ons!

7 - How to Make SQL Server Confi gura on - Using SSMS, sp_confi gure, and ALTER Server - Exercise 01: Confi gure Your SQL Server to Accept Remote Connec - Exercise 02: Confi gure Your SQL Server Using SSMS and - The SQL Server and Windows Error - First Look at SQL Server Profi ler and the Default - Other Tools Worth KnowingChapter 5: Creating and Managing - SQL Server Databases: The Data File and the Transac on - The System Databases in SQL Server 2012 SQL Server 2012 : Database AdministrationCourse 171 2013 LLC All rights reservedVIDEOS IN THIS COURSE (cont.):Viewed?Chapter 5: Creating and Managing Databases (cont.) - The Types of Databases in a Typical SQL Server 2012 - Crea ng a Database : The - Crea ng a Database Using SSMS and - Crea ng a Database : Sizing and Confi guring Database - Expanding a - Filegroups and Working with Mul ple Data and Log - Crea ng and Expanding Databases with Mul ple Files and - What Happens When the Transac on Log is 100% Full?

8 - Database Confi gura on Op ons, Part - Database Confi gura on Op ons, Part - Changing Database Confi gura ons and Compa bility - Exercise 01: Planning the Course - Exercise 02: Crea ng and Modifying the Course - How to Delete and Empty Files in a - A aching and Detaching SQL Server 2012 - Suggested Changes a er an - How and Why You Want to Enable Instant File Ini aliza - Tempdb Data File Considera onsChapter 6: Security in SQL Server - The Principle of Least - Reducing the A ack Surface - The SQL Server Security - Logins Installed by SQL Server and How to Create SQL - How to Create Windows Logins and Windows Group - Server Roles and - Scope and - Crea ng and Assigning Server Roles and Assigning Server -Scoped - Account Lockout, Password Policies, and Enabling and Disabling - Exercise 01: Crea ng Logins and Assigning - User Accounts in SQL Server 2012 SQL Server 2012 : Database AdministrationCourse 171 2013 LLC All rights reservedVIDEOS IN THIS COURSE (cont.)

9 :Viewed?Chapter 6: Security in SQL Server 2012 (cont.) - The Mysteries of the dbo - Crea ng and Viewing User - Database Roles in SQL Server - Applica on Roles in SQL Server - Crea ng and Assigning Database - Exercise 02: Crea ng Users and Assigning - Gran ng Table, View and Rou ne - Schemas, Name Resolu on, and Object - How to Assign Database - Ownership: What It Is And How It - Broken Ownership Chains in SQL Server - Impersona on in SQL Server - Exercise 03: Managing and Tes ng - Exercise 04: Impersona on and Stored - When a Windows User Who Belongs to a Group Creates an - Dealing with Orphaned Users - Part - Dealing with Orphaned Users - Part - Quick Hits: SQL Server - Quick Hits: Policy-Based Management (PBM) - Quick Hits: Par ally Contained - Quick Hits: Trustworthy, Cross Database Ownership ChainingChapter 7.

10 SQL Server 2012 Backup and - How the Transac on Log - The Types of SQL Server Backups and Permissions - Recovery - What are Bulk Opera ons in SQL Server ? - The BULK_LOGGED Recovery - How to Change the Recovery - Exercise 01: Recovery - The Types of SQL Server Backups and Permissions RequiredSQL Server 2012 : Database AdministrationCourse 171 2013 LLC All rights reservedVIDEOS IN THIS COURSE (cont.):Viewed?Chapter 7: SQL Server 2012 Backup and Recovery (cont.) - How to Take SQL Server Backups in - Viewing the Contents of Backup - Managing Backup History in SQL - Backup - Exercise 02: Compression and - Exercise 03: Taking Full and Diff eren al - More About How the Transac on Log - How to Backup the Transac on - The Basics of Restoring a SQL Server - Developing Backup Strategies, Part - Developing Backup Strategies, Part - Example Restore Scenarios and Crash - How Changing the Recovery Model Aff ects Backup - Strategies With the Full and Bulk Logged Recovery - How Changing to BULK_LOGGED Aff ects Backup - A How-to Guide to Performing Bulk - Copy Only - Emergency!