OverviewTraining OptionsCourse CurriculumReviewsFAQs

World’s #1 Online Bootcamp

Course Overview

Key Features

  • 8 Hrs of HQ E-Learning Content
  • 96 High Quality Lectures
  • Training for Exam 70-465
  • Covers Database Object Design, Indexing
  • Downloadable Work Files
  • Course Completion Certificate

Training Options

Self-Paced Learning

$ 149

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

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

    Preview

    • Module 01 - Welcome

      32:54Preview
      • 1.1 Introduction
        01:24
      • 1.2 Course Overview
        03:41
      • 1.3 Understanding SQL
        05:03
      • 1.4 Understanding TSQL
        05:34
      • 1.5 SQL Server History
        05:30
      • 1.6 SQL Server Certifications
        05:49
      • 1.7 The 70-465 Exam
        05:53

    • Module 02 - SQL Server 2012 Essentials

      11:45Preview
      • 2.1 SQL Server 2012 Editions
        05:21
      • 2.2 Hardware Requirements
        03:34
      • 2.3 Software Requirements
        02:50

    • Module 03 - Installing SQL Server 2012

      38:10Preview
      • 3.1 Getting a Copy of SQL Server 2012
        05:03
      • 3.2 Understanding Instances
        05:48
      • 3.3 Installing SQL Server 2012 pt. 1
        06:22
      • 3.4 Installing SQL Server 2012 pt. 2
        06:07
      • 3.5 SQL Books Online Goes Online
        04:17
      • 3.6 Downloading Books Online
        04:00
      • 3.7 SSMS Tour
        06:33

    • Module 04 - Designing Database Structure

      49:57Preview
      • 4.1 Determining Business Requirements
        06:00
      • 4.2 Database Types
        05:28
      • 4.3 The Relational Model
        05:46
      • 4.4 Normalization Basics
        05:10
      • 4.5 Basic Architectural Decisions
        04:52
      • 4.6 Understanding File Groups
        03:38
      • 4.7 Understanding Partitioning
        04:24
      • 4.8 Authentication Modes
        03:32
      • 4.9 Windows Authentication
        03:18
      • 4.10 SQL Server Authentication
        05:03
      • 4.11 The SA Account
        02:46

    • Module 05 - Database Object Design

      53:28Preview
      • 5.1 Logical Database Design
        04:29
      • 5.2 Physical Design Implications
        04:08
      • 5.3 Understanding Collation
        04:29
      • 5.4 Linked Servers
        05:15
      • 5.5 Understanding NULLs
        05:35
      • 5.6 ANSI NULLs
        05:56
      • 5.7 Handling Database Growth
        06:08
      • 5.8 Linked Servers or Openrowset
        04:59
      • 5.9 CPU Affinity
        03:54
      • 5.10 Memory Allocation
        03:07
      • 5.11 Managing SQL Server Memory
        05:28

    • Module 06 - Designing Tables

      01:00:23Preview
      • 6.1 Table Basics
        04:56
      • 6.2 Temp Tables
        04:24
      • 6.3 Table Variables
        05:03
      • 6.4 Common Table Expressions
        05:34
      • 6.5 Transaction Basics
        05:19
      • 6.6 Explicit and Implicit Transactions
        05:27
      • 6.7 Transaction Impact on Performance
        03:51
      • 6.8 Planning with Concurrency in Mind
        06:15
      • 6.9 Locking Basics
        04:42
      • 6.10 Lock Types and Escalation
        05:23
      • 6.11 Schema Basics
        05:05
      • 6.12 Creating Schemas
        04:24

    • Module 07 - Indexing

      44:19Preview
      • 7.1 Understanding Indexes
        03:06
      • 7.2 Understanding Data Distribution
        05:53
      • 7.3 Clustered Indexes
        03:28
      • 7.4 Non-Clustered Indexes
        03:00
      • 7.5 Indexing Best Practices
        03:39
      • 7.6 Reorganizing and Rebuilding Indexes
        04:13
      • 7.7 Which Should I Use?
        02:22
      • 7.8 Understanding Index Fragmentation
        03:43
      • 7.9 Understanding Index Internals pt. 1
        05:43
      • 7.10 Understanding Index Internals pt. 2
        03:57
      • 7.11 Understanding Fillfactor
        05:15

    • Module 08 - Programming Objects

      22:33Preview
      • 8.1 Stored Procedure Basics
        05:15
      • 8.2 Advantages of Stored Procedures
        04:37
      • 8.3 Stored Procedure Best Practices
        03:46
      • 8.4 Understanding Views
        04:43
      • 8.5 Understanding Indexed Views
        04:12

    • Module 09 - Database Server Maintenance

      01:05:42Preview
      • 9.1 SQL Server Agent
        04:49
      • 9.2 Understanding Jobs
        03:27
      • 9.3 Understanding Alerts
        03:23
      • 9.4 Understanding Operators
        03:08
      • 9.5 Understanding Schedules
        03:39
      • 9.6 Creating a Job
        04:31
      • 9.7 Database Maintenance Plans
        03:57
      • 9.8 Creating a Maintenance Plan
        06:01
      • 9.9 Maintenance Plan Design Surface
        06:37
      • 9.10 Multiserver Administration
        04:35
      • 9.11 Ensuring Good Database Health
        06:19
      • 9.12 DMVs
        04:57
      • 9.13 SQL Server 2012 DMVs
        04:32
      • 9.14 Getting to Know Your DMVs
        05:47

    • Module 10 - Monitoring Performance

      30:33
      • 10.1 Performance Monitoring Basics
        05:17
      • 10.2 Performance Monitor
        04:00
      • 10.3 Counters To Watch
        05:52
      • 10.4 Monitoring Locks
        06:02
      • 10.5 SQL Server Profiler pt. 1
        03:22
      • 10.6 SQL Server Profiler pt. 2
        06:00

    • Module 11 - Designing Backup Recovery

      32:29Preview
      • 11.1 Backup and Recovery Planning
        05:56
      • 11.2 Transaction Log Basics
        04:44
      • 11.3 Understanding Recovery Models
        04:48
      • 11.4 Setting the Recovery Model
        02:23
      • 11.5 Understanding Database Snapshots
        04:50
      • 11.6 Using Database Snapshots
        04:24
      • 11.7 High Availability Options
        05:24

    • Module 12 - Conclusion

      03:58
      • 12.1 Course Wrap Up
        03:58

    • Module 13 - Credits

      02:38Preview
      • 13.1 About the Author
        02:38

Contact Us

1-844-532-7688

( Toll Free )

Reviews

  • Gracelyn Burgess

    Gracelyn Burgess

    Such an awesome Course. I searched various resources; subscribed the training in many other sites but never came across such an awesome, precise and to-the- point explanation. Thank you Simplilearn!

  • Helen Goodman

    Helen Goodman

    The topics presented especially are very well explained. Keep up the good work!

  • Elle Adkins

    Elle Adkins

    This course did take a lot of the mystery out of the SQL Server. It was very informative & covered a lot of ground.

prevNext

Why Online Bootcamp

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

FAQs

  • How do I enroll for the Online training?

    You can enroll for the training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

    1. Visa debit/credit card
    2. American express and Diners club card
    3. Master Card, or
    4. Through PayPal

  • What will I get along with this training?

    You will have access to the online e-learning with the training.

  • Can I cancel my enrollment? Do I get a refund?

    Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

  • Do you provide any course completion certificate?

    Yes, we offer course completion certificate after you successfully complete the training program.

  • Where and how can I access the e-learning content? Are there any limitations?

    Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

  • I am not able to access the online course. Whom should I contact for a solution?

    Please raise a request via our Help and Support portal to have your issue resolved.

  • Do you provide money back guarantee for the training programs?

    Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

  • Do you provide any course completion certificate?

    Yes, we offer course completion certificate after you successfully complete the training program.

  • I want to know more about the training program. Whom do I contact?

    Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.