Microsoft SQL Server 2012 Admin (Exam) Course - Video Tutorials

3,200.00

Microsoft SQL Server 2012 Admin (Exam) Course - Video Tutorials - Full Course detail mentioned below.


MCSE: SQL Server 2012 certification will qualify you for such jobs as database analyst and database designer. It demonstrates broad skill sets in building and administrating enterprise-scale data solutions both on-premises and in cloud environments. 

To become certified in MCSE: Windows Server 2012 you must pass five exams, mentioned below.

  • Querying Microsoft SQL Server 2012 (Exam 70-461)
  • Microsoft SQL Server 2012 Admin (Exam 70-462)
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463)
  • Microsoft SQL Server 2012 Development (Exam 70-464)
  • Designing Database Solutions for Microsoft SQL Server 2012 (Exam 70-465) 

With over 41.5 hours and 499 video tutorials in this bundle, This is very useful to pass these essential exams.


Syllabus Detail

Querying Microsoft SQL Server 2012 (Exam 70-461)

  • Introduction

    Welcome (01:11)

    Course Overview (03:35)

    Understanding SQL (04:22)

    Understanding TSQL (03:21)

    SQL Server History (04:49)

    Microsoft SQL Server Certifications (02:51)


    Getting Set Up

    Getting SQL Server 2012(03:36)

    Installing SQL Server 2012(05:42)

    Attaching the Sample Database (04:04)

    Getting SQL Books Online Locally (03:34)

    Code Examples (01:41)

    SQL Server 2012 Management Studio

    SSMS Tour (06:09)

    Graphical Queries (05:10)

    SSMS Options (04:38)

    Query Results Options(03:12)

    Database Diagrams (05:18)

    Creating Database Objects

    Table Design Basics (03:54)

    Creating a Table (05:41)

    Altering Tables (06:09)

    Dropping Tables (04:21)

    Understanding Views (04:24)

    Creating Views pt. 1 (04:44)

    Creating Views pt. 2 (06:12)

    Dropping Views (02:40)

    Understanding Constraints (05:17)

    Creating Constraints (05:07)

    Understanding Triggers (05:00)

    Trigger Options (04:04)

    Inserted and Deleted Tables (02:55)

    Creating Triggers (05:40)


    Basic Select Queries

    The Basic Select Statement (06:43)

    Select Statement Structure (03:56)

    The FROM Clause (03:27)

    The WHERE Clause (04:23)

    WHERE Clause Example (04:32)

    The ORDER BY Clause (03:55)

    ORDER BY Example (05:22)

    The GROUP BY Clause pt. 1 (05:56)

    The GROUP BY Clause pt. 2 (05:46)

    The HAVING Clause (05:42)

    The Power of LIKE (04:03)


    More Advanced Select Statements

    Using Distinct (04:44)

    Column Aliasing (05:34)

    Using the Top Option (04:02)

    Top Option Example (05:01)

    Using the OFFSET-FETCH Option (05:02)

    Understanding NULLs (05:24)

    Working with NULLs (03:42)

    Using the Case Statement (05:29)

    SELECT INTO (03:27)

    The UNION Statement (05:56)

    Using INTERSECT (05:23)

    Using EXCEPT (06:18)

    Understanding Synonyms (03:21)

    Creating and Using Synonyms (02:38)

    Using Concatenation (04:00)

    Dynamic Queries pt. 1 (04:49)

    Dynamic Queries pt. 2 (05:55)

    INSERT Into (04:09)


    SQL Server 2012 Data Types

    Understanding GUIDs (05:50)

    NEWID() vs. NEWSEQUENTTIALID() (05:09)

    Using GUIDs (05:13)

    Data Type Basics (05:44)

    Numerical Data Types (04:50)

    Character Data Types (04:49)

    Date and Time Data Types (04:06)

    Binary Data Types (03:02)


    Using Joins

    Understanding Joins (03:58)

    Table Aliasing (02:42)

    Inner Joins (06:46)

    Outer Joins (04:41)

    Cross Joins (04:28)

    The Merge Statement pt. 1 (05:36)

    The Merge Statement pt. 2 (05:07)


    Querying Metadata

    Catalog Views (05:55)

    Information Schema Views (04:12)

    System Stored Procedures (05:06)

    Inserts / Updates / Deletes

    The Basic INSERT Statement (03:17)

    INSERT Examples (05:17)

    The Basic UPDATE Statement (02:39)

    UPDATE Examples (04:42)

    The Basic DELETE Statement (02:53)

    DELETE Examples (03:39)

    Using @@ROWCOUNT (05:03)

    Subqueries

    Scalar Subqueries (03:42)

    Multi-Valued Subqueries (04:23)

    Correlated Subqueries (05:16)


    Table Expressions

    Understanding Temporary Results Sets (03:21)

    Understanding Derived Tables (04:22)

    Understanding Common Table Expressions(02:43)

    Using CTEs (04:15)

    Understanding Temporary Tables (04:32)

    Table Variables (05:29)

    Temporary Table or Table Variable? (02:48)


    Stored Procedures

    Understanding Stored Procedures (04:14)

    Creating a Stored Procedure (04:10)

    Using Input Parameters (05:33)

    Stored Procedure Return Codes (04:06)

    Stored Procedure Permissions (02:53)


    Functions

    Understanding Functions (03:40)

    Built-in Functions (04:13)

    Scalar Functions Example (05:30)

    Table Valued Functions Example pt. 1 (05:30)

    Table Valued Functions Example pt. 2 (04:51)


    Transactions

    Understanding Concurrency (03:52)

    Understanding Transactions (04:36)

    Coding Explicit Transactions (04:44)

    Transactions and Locking (04:30)


    Conclusion

    Course Wrap Up (03:13)

    Credits

    About the Author (02:39)


    Microsoft SQL Server 2012 Admin (Exam 70-462)

    Introduction

    Welcome (01:23)

    Course Overview (04:14)

    Understanding SQL (04:01)

    Understanding TSQL (04:25)

    SQL Server History (05:48)

    Microsoft SQL Server Certifications (04:09)


    Improvements in 2012

    SQL Server 2012 Enhancements (05:17)

    Availability Enhancements(06:00)

    Manageability Enhancements (05:26)

    Programmability Enhancements (04:16)

    Scalability and Performance Enhancements (05:11)

    Security Enhancements(06:35)

    SQL Server 2012 Essentials

    SQL Server 2012 Editions(04:53)

    Licensing for 2012 (04:04)

    Hardware Requirements(05:08)

    Software Requirements(04:07)

    Installation Options pt. 1(05:53)

    Installation Options pt. 2(04:38)

    What Was Left Behind?(04:09)


    Installing SQL Server 2012

    SQL Server Services (05:15)

    SQL Reporting Services (04:24)

    SQL Server Integration Services (04:15)

    SQL Server Analysis Services (04:36)

    Installing SQL Server 2012 (06:57)

    Validate a SQL Server Installation pt. 1 (04:38)

    Validate a SQL Server Installation pt. 2 (02:43)

    Uninstalling SQL Server (04:37)

    SQL Server Instances (04:21)

    SQL Server Configuration Manager (04:43)

    SQL Server Service Accounts (05:15)

    Attaching Adventureworks Sample DB (04:23)

    Database Diagrams (05:13)

    SQL Server Basics

    Understanding Databases (05:07)

    Understanding Tables (05:53)

    Understanding Primary Keys (04:29)

    Understanding Data Types pt. 1 (06:39)

    Understanding Data Types pt. 2 (07:35)

    Understanding Normalization (06:58)

    Creating a Database (06:18)

    Database Types (06:02)

    System Databases pt. 1 (07:08)

    System Databases pt. 2 (07:06)

    Resource Database (04:57)

    Database Files (04:29)

    Understanding Transaction Logs (05:31)

    Understanding Schemas (04:10)

    Understanding Synonyms (04:05)

    Managing SQL Server 2012

    SSMS or TSQL (06:50)

    Table Change Gotcha (02:52)

    Using MMC Snap-Ins (05:27)

    Graphical Queries (06:41)

    Authentication Modes (06:12)

    Understanding Linked Servers (06:35)

    Hiding System Objects (03:21)


    Automating SQL Server 2012

    SQL Server Agent (05:54)

    Configuring SQL Server Agent (05:58)

    Understanding Automated Administration(04:51)

    Understanding Jobs (06:21)

    Understanding Schedules (06:32)

    Understanding Operators (06:43)

    Understanding Alerts (07:03)

    Multiserver Administration (06:39)

    Using the Maintenance Plan Wizard (06:31)

    Using Maintenance Plan Design (06:24)


    Indexes

    Understanding Indexes (05:09)

    Clustered Indexes (05:56)

    Non-Clustered Indexes (05:04)

    New Index Features in 2012 (06:17)

    What Should Be Indexed (06:10)

    Too Much of a Good Thing (07:38)

    Database Engine Tuning Advisor (04:28)


    Performance and Monitoring

    Monitoring Basics (05:35)

    Monitoring Events (03:10)

    Dedicated Administrator Connection (05:55)

    Using System Monitor (05:54)

    What to Monitor (06:01)

    Data Collector (06:00)

    SQL Server Standard Reports (04:29)

    SQL Server Best Practice Analyzer (03:15)

    SQL Server Profiler pt. 1 (03:35)

    SQL Server Profiler pt. 2 (06:48)

    Pages and Extents (05:51)

    Understanding FillFactor (05:44)

    Linked Server vs. Openrowset (03:24)


    SQL Server Security

    Principals and Securables (04:08)

    Principal and Securable Hierarchy (03:35)

    Securing SQL Server (06:29)

    Understanding Permissions (03:53)

    Understanding Roles (05:17)

    Fixed Server-Level Roles (03:25)

    Database Level Roles (03:18)

    Backup and Recovery Planning (06:30)

    Understanding Recovery Models (06:24)

    Performing Backups and Restores (06:29)

    Availability Options (06:50)

    Scripting SQL Server 2012

    Using sqlcmd (04:13)

    Using PowerShell (02:53)

    Course Wrap Up (03:42)

    Credits

    About the Author (02:39)


  • Backup / Recovery / Availability

    • Backup and Recovery Planning (06:30)
    • Understanding Recovery Models (06:24)
    • Performing Backups and Restores (06:29)
    • Availability Options (06:50)
    • Scripting SQL Server 2012
    • Using sqlcmd (04:13)
    • Using PowerShell (02:53)
  • Conclusion

    • Course Wrap Up (03:42)
    • Credits
    • About the Author (02:39)

 

Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463)

Welcome

  • Introduction (00:50)
  • Course Overview (02:19)
  • SQL Server Basics (04:19)
  • Database Types (04:03)
  • Terminology (05:33)
  • SQL Server 2012 Certification (04:43)
  • About the 70-463 Exam(03:01)


Getting Set Up

  • System Hardware Requirements (04:19)
  • System Software Requirements (03:32)
  • Getting the Software (04:09)
  • Installing SQL Server 2012 pt. 1 (05:52)
  • Installing SQL Server 2012 pt. 2 (06:01)
  • Installing SQL Server 2012 pt. 3 (04:10)
  • Verifying the Installation(03:56)
  • Attaching the Sample Database pt. 1 (02:55)
  • Attaching the Sample Database pt. 2 (04:00)
  • Exploring the Sample Database (04:53)
  • Downloading Books Online(04:24)
  • TechNet and MSDN (04:25)


Data Warehouse Basics

  • Data Usage Challenges(04:18)
  • Understanding Normalization (04:20)
  • Normalized Structure Challenges (05:32)
  • Star Schema Basics (04:31)
  • Snowflake Schema Basics(05:37)
  • Understanding Granularity(04:27)
  • Auditing and Lineage(05:08)
  • Simple DW Example (06:18)


Creating a Data Warehouse

  • Understanding Fact Tables (02:52)
  • Understanding Dimensions pt. 1 (06:21)
  • Understanding Dimensions pt. 2 (03:47)
  • Dimension Column Types (05:15)
  • Understanding SCDs pt. 1 (05:30)
  • Understanding SCDs pt. 2 (06:24)
  • Understanding SCDs pt. 3 (05:37)
  • Creating Our DW Database (05:11)
  • Identifying Our Dimensions (03:16)
  • Identifying Our Fact Table (03:13)
  • Understanding Indexes (06:28)
  • Indexing the Data Warehouse (04:59)
  • Understanding Indexed Views (04:30)
  • Creating an Indexed View (06:32)
  • Understanding Data Compression (05:28)
  • Using Partitions (06:15)
  • Data Lineage pt. 1 (04:40)
  • Data Lineage pt. 2 (04:59)
  • Creating Our Dimensions (05:52)
  • Creating Our Fact Table (01:55)
  • Creating Our Relationships (05:39)


Data Flow Using SSIS

  • SSIS Basics (06:04)
  • Getting SQL Server Data Tools (05:42)
  • Getting Visual Studio (06:35)
  • Using the Import Export Wizard (05:23)
  • SSIS Development Overview (05:46)
  • Data Movement Planning (03:56)
  • Simple SSIS Example pt. 1 (06:09)
  • Simple SSIS Example pt. 2 (05:48)
  • Using Connection Managers (06:42)
  • Data and Control Flow (04:01)
  • Understanding Containers (06:43)
  • Understanding Groups (04:42)
  • Data Conversion Task (05:02)
  • Customer Dimension Load Considerations(04:03)
  • Loading the Customer Dimension pt. 1 (06:50)
  • Loading the Customer Dimension pt. 2 (06:10)
  • Loading the Customer Dimension pt. 3 (06:07)
  • Loading the FactInternetSales Table pt. 1(06:16)
  • Loading the FactInternetSales Table pt. 2(06:15)


Design and Implement Data Flow

  • Creating a Data Flow Task (06:24)
  • Data Flow Source Adapters (06:19)
  • Data Flow Destination Adapters (05:56)
  • Row or Batch Processing (04:06)


Advanced Control Flow

  • Using Variables pt. 1 (05:59)
  • Using Variables pt. 2 (04:19)
  • Understanding Variable Scope (03:20)
  • Property Parameterization pt. 1 (06:11)
  • Property Parameterization pt. 2 (04:33)
  • Parameters vs. Variables (03:14)
  • Understanding Expressions pt. 1 (05:32)
  • Understanding Expressions pt. 2 (06:23)
  • Package and Task Transactions pt. 1 (06:20)
  • Package and Task Transactions pt. 2 (06:12)


Data Services

  • Data Quality Services Overview (04:07)
  • Implementing DQS (03:40)
  • Master Data Services Overview (04:07)


Custom Code in SSIS

  • Script Task Basics (02:45)
  • Using a Script pt. 1 (05:56)
  • Using a Script pt. 2 (06:15)
  • Using a Script pt. 3 (05:13)
  • Configuring Script Tools (04:04)


Deploying Packages

  • Deploying SSIS Packages (02:27)
  • Creating the SSISDB Catalog (04:14)
  • Deploying a Project (04:01)
  • Executing a Package (05:00)
  • Scheduling a Package (05:58)

Conclusion

  • Course Wrap Up (04:26)
  • Credits
  • About the Author (02:39)

Microsoft SQL Server 2012 Development (Exam 70-464)

Introduction

Welcome (01:10)

  • Course Overview (04:04)
  • Understanding SQL (04:26)
  • Understanding TSQL (05:11)
  • SQL Server History (04:06)
  • Microsoft SQL Server Certifications (06:00)
  • Programmability Enhancements for 2012(04:09)


SQL Server 2012 Essentials

  • SQL Server 2012 Editions(03:33)
  • Hardware Requirements(03:43)
  • Software Requirements(03:12)


Installing SQL Server

  • Getting Your Hands on SQL Server 2012 (02:37)
  • Installing SQL Server 2012(05:36)
  • Validate a SQL Server Installation pt. 1 (03:55)
  • Validate a SQL Server Installation pt. 2 (03:54)
  • Uninstalling SQL Server 2012 (04:01)
  • SQL Books Online Goes Online (04:27)


SQL Server Basics

  • SQL Server Instances (04:06)
  • SQL Server Configuration Manager (03:50)
  • SQL Server Management Studio (05:36)
  • Understanding Databases (05:06)
  • Table Basics (05:09)
  • Understanding Primary Keys (06:22)
  • Understanding Data Types (04:34)
  • Understanding Normalization (05:52)
  • Understanding Foreign Keys (05:10)
  • Creating a Database (03:53)
  • Database Types (07:41)
  • Understanding Transaction Logs (05:37)
  • Refreshing Intellisense (03:42)
  • Understanding Schemas (03:20)
  • Four Part Naming (03:21)
  • Understanding Synonyms pt. 1 (04:32)
  • Understanding Synonyms pt. 2 (04:39)


Working with Tables

  • Attaching Adventureworks Sample DB (04:25)
  • Database Diagrams (05:43)
  • Working with Diagrams (05:57)
  • Table Design Basics (06:41)
  • Creating Tables Graphically (04:40)
  • Creating Tables with TSQL (04:31)
  • Altering Tables (04:07)
  • Understanding Temporary Tables (06:20)
  • Understanding Table Variables (04:40)
  • Temp Table vs. Table Variable (04:32)
  • GUIDs and SQL Server pt. 1 (03:59)
  • GUIDs and SQL Server pt. 2 (03:25)
  • NEWID() and NEWSEQUENTIALID() (04:47)
  • Understanding Table Partitioning (05:28)
  • Database Files (04:38)
  • Understanding Filegroups (04:41)
  • Working with BLOBs (05:10)
  • FILESTREAM Basics (05:53)
  • Using FILESTREAM (03:39)
  • FileTable Basics (04:36)
  • Understanding Constraints (06:12)
  • Creating Constraints (04:33)


Indexes

  • Index Basics (04:33)
  • Clustered Indexes (04:18)
  • Nonclustered Indexes (05:53)
  • Pages and Extents (05:36)
  • Understanding Fill Factor (06:29)
  • Creating Indexes Graphically (06:07)
  • Creating Indexes with TSQL (06:29)
  • Optimizing Indexes (04:12)
  • Reorganizing and Rebuilding Indexes (05:27)
  • Checking Index Fragmentation (04:10)


Programming Objects

  • Understanding Stored Procedures (05:20)
  • Creating Stored Procedures (05:48)
  • Using Parameters with SPs (05:17)
  • Using Temp Tables with SPs (06:28)
  • Types of Stored Procedures (05:13)
  • Understanding Transactions (05:36)
  • Explicit and Implicit Transactions (06:27)
  • Using Explicit Transactions (05:38)
  • Transactions and Locking (04:31)
  • Creating Views (06:17)
  • Partitioned Views (05:55)
  • Common Partitioned View Usage (03:47)
  • View Options (04:59)
  • Understanding Functions (04:05)
  • Scalar Function Example (05:59)


Concurrency and Locking

  • Understanding Concurrency (05:28)
  • Normalization and Concurrency (05:12)
  • Transaction Isolation Levels (06:02)
  • Monitoring and Managing Locking (06:11)


Optimization

  • SQL Server Profiler (04:18)
  • Creating a Trace pt. 1 (06:08)
  • Creating a Trace pt. 2 (04:49)
  • Querying a Trace Table (06:39)
  • Database Engine Tuning Advisor (03:44)
  • Query Execution Plans (05:30)
  • Understanding Query Hints (04:15)
  • Using System Views (05:54)
  • Using Performance Monitor (03:38)


Working with XML Data

  • XML Basics (04:15)
  • Relational vs. XML Data (03:32)
  • Retrieving XML from Relational Data (05:19)


Conclusion

  • Course Wrap Up (03:58)
  • Credits
  • About the Author (02:39)

 

Designing Database Solutions for Microsoft SQL Server 2012 (Exam 70-465) 

Welcome

  • Introduction (01:24)
  • Course Overview (03:41)
  • Understanding SQL (05:04)
  • Understanding TSQL (05:35)
  • SQL Server History (05:30)
  • SQL Server Certifications(05:53)
  • The 70-465 Exam (05:57)

SQL Server 2012 Essentials

  • SQL Server 2012 Editions(05:25)
  • Hardware Requirements(03:34)
  • Software Requirements(02:50)


Installing SQL Server 2012

  • Getting a Copy of SQL Server 2012 (05:03)
  • Understanding Instances(05:50)
  • Installing SQL Server 2012 pt. 1 (06:23)
  • Installing SQL Server 2012 pt. 2 (06:09)
  • SQL Books Online Goes Online (04:18)
  • Downloading Books Online(04:01)
  • SSMS Tour (06:35)
  • Designing Database Structure
  • Determining Business Requirements (06:00)
  • Database Types (05:28)
  • The Relational Model (05:47)
  • Normalization Basics (05:12)
  • Basic Architectural Decisions (04:54)
  • Understanding File Groups (03:39)
  • Understanding Partitioning (04:25)
  • Authentication Modes (03:33)
  • Windows Authentication (03:18)
  • SQL Server Authentication (05:05)
  • The SA Account (02:46)


Database Object Design

  • Logical Database Design (04:29)
  • Physical Design Implications (04:08)
  • Understanding Collation (04:30)
  • Linked Servers (05:15)
  • Understanding NULLs (05:35)
  • ANSI NULLs (05:57)
  • Handling Database Growth (06:10)
  • Linked Servers or Openrowset (04:59)
  • CPU Affinity (03:54)
  • Memory Allocation (03:07)
  • Managing SQL Server Memory (05:28)


Designing Tables

  • Table Basics (04:57)
  • Temp Tables (04:25)
  • Table Variables (05:03)
  • Common Table Expressions (05:34)
  • Transaction Basics (05:39)
  • Explicit & Implicit Transactions (06:04)
  • Transaction Impact on Performance (03:51)
  • Planning with Concurrency in Mind (06:49)
  • Locking Basics (05:05)
  • Lock Types & Escalation (05:27)
  • Schema Basics (05:23)
  • Creating Schemas (04:35)

Indexing

  • Understanding Indexes (03:21)
  • Understanding Data Distribution (06:33)
  • Clustered Indexes (03:48)
  • Non-Clustered Indexes (03:19)
  • Indexing Best Practices (03:39)
  • Reorganizing & Rebuilding Indexes (04:13)
  • Which Should I Use? (02:22)
  • Understanding Index Fragmentation (03:43)
  • Understanding Index Internals pt. 1 (05:44)
  • Understanding Index Internals pt. 2 (03:57)
  • Understanding Fillfactor (05:15)

Programming Objects

  • Stored Procedure Basics (05:20)
  • Advantages of Stored Procedures (04:38)
  • Stored Procedure Best Practices (03:46)
  • Understanding Views (04:43)
  • Understanding Indexed Views (04:12)


Database Server Maintenance

  • SQL Server Agent (04:49)
  • Understanding Jobs (03:27)
  • Understanding Alerts (03:23)
  • Understanding Operators (03:08)
  • Understanding Schedules (03:39)
  • Creating a Job (04:31)
  • Database Maintenance Plans (03:58)
  • Creating a Maintenance Plan (06:01)
  • Maintenance Plan Design Surface (06:38)
  • Multiserver Administration (04:35)
  • Ensuring Good Database Health (06:20)
  • DMVs (04:58)
  • SQL Server 2012 DMVs (04:32)
  • Getting to Know Your DMVs (05:50)


Monitoring Performance

  • Performance Monitoring Basics (05:17)
  • Performance Monitor (04:00)
  • Counters To Watch (05:52)
  • Monitoring Locks (06:02)
  • SQL Server Profiler pt. 1 (03:22)
  • SQL Server Profiler pt. 2 (06:01)


Designing Backup & Recovery

  • Backup & Recovery Planning (06:03)
  • Transaction Log Basics (04:44)
  • Understanding Recovery Models (04:48)
  • Setting the Recovery Model (02:23)
  • Understanding Database Snapshots (04:50)
  • Using Database Snapshots (04:25)
  • High Availability Options (05:24)


Conclusion

  • Course Wrap Up (03:58)
  • Credits
  • About the Author (02:38)


Reviews