OverviewTraining OptionsCourse CurriculumReviewsFAQs

World’s #1 Online Bootcamp

Course Overview

Key Features

  • 8 Hrs of HQ E-Learning Content
  • 98 High Quality Lectures
  • Training for Exam 70-464
  • Topics on XML, TSQL, FILESTREAM
  • Downloadable Work Files
  • Course Completion Certificate

Training Options

Self-Paced Learning

$ 99

  • 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

  • Microsoft SQL Server 2012 Development (Exam 70-464)

    Preview

    • Module 01 - Introduction

      29:06Preview
      • 1.1 Welcome
        01:10
      • 1.2 Course Overview
        04:04
      • 1.3 Understanding QL
        04:26
      • 1.4 Understanding TSQL
        05:11
      • 1.5 SQL Server History
        04:06
      • 1.6 Microsoft SQL Server Certifications
        06:00
      • 1.7 Programmability Enhancements for 2012
        04:09

    • Module 02 - SQL Server 2012 Essentials

      10:28
      • 2.1 SQL Server 2012 Editions
        03:33
      • 2.2 Hardware Requirements
        03:43
      • 2.3 Software Requirements
        03:12

    • Module 03 - Installing SQL Server

      24:30Preview
      • 3.1 Getting Your Hands on SQL Server 2012
        02:37
      • 3.2 Installing SQL Server 2012
        05:36
      • 3.3 Validate a SQL Server Installation pt. 1
        03:55
      • 3.4 Validate a SQL Server Installation pt. 2
        03:54
      • 3.5 Uninstalling SQL Server 2012
        04:01
      • 3.6 SQL Books Online Goes Online
        04:27

    • Module 04 - SQL Server Basics

      01:22:30Preview
      • 4.1 SQL Server Instances
        04:06
      • 4.2 SQL Server Configuration Manager
        03:50
      • 4.3 SQL Server Management Studio
        05:36
      • 4.4 Understanding Databases
        05:06
      • 4.5 Table Basics
        05:09
      • 4.6 Understanding Primary Keys
        06:22
      • 4.7 Understanding Data Types
        04:34
      • 4.8 Understanding Normalization
        05:52
      • 4.9 Understanding Foreign Keys
        05:10
      • 4.10 Creating a Database
        03:53
      • 4.11 Database Types
        07:41
      • 4.12 Understanding Transaction Logs
        05:37
      • 4.13 Refreshing Intellisense
        03:42
      • 4.14 Understanding Schemas
        03:20
      • 4.15 Four Part Naming
        03:21
      • 4.16 Understanding Synonyms pt. 1
        04:32
      • 4.17 Understanding Synonyms pt. 2
        04:39

    • Module 05 - Working with Tables

      01:48:37Preview
      • 5.1 Attaching Adventureworks Sample DB
        04:25
      • 5.2 Database Diagrams
        05:43
      • 5.3 Working with Diagrams
        05:57
      • 5.4 Table Design Basics
        06:41
      • 5.5 Creating Tables Graphically
        04:40
      • 5.6 Creating Tables with TSQL
        04:31
      • 5.7 Altering Tables
        04:07
      • 5.8 Understanding Temporary Tables
        06:20
      • 5.9 Understanding Table Variables
        04:40
      • 5.10 Temp Table vs. Table Variable
        04:32
      • 5.11 GUIDs and SQL Server pt. 1
        03:59
      • 5.12 GUIDs and SQL Server pt. 2
        03:25
      • 5.13 NEWID() and NEWSEQUENTIALID()
        04:47
      • 5.14 Understanding Table Partitioning
        05:28
      • 5.15 Database Files
        04:38
      • 5.16 Understanding Filegroups
        04:41
      • 5.17 Working with BLOBs
        05:10
      • 5.18 FILESTREAM Basics
        05:53
      • 5.19 Using FILESTREAM
        03:39
      • 5.20 FileTable Basics
        04:36
      • 5.21 Understanding Constraints
        06:12
      • 5.22 Creating Constraints
        04:33

    • Module 06 - Indexes

      53:14Preview
      • 6.1 Index Basics
        04:33
      • 6.2 Clustered Indexes
        04:18
      • 6.3 Nonclustered Indexes
        05:53
      • 6.4 Pages and Extents
        05:36
      • 6.5 Understanding Fill Factor
        06:29
      • 6.6 Creating Indexes Graphically
        06:07
      • 6.7 Creating Indexes with TSQL
        06:29
      • 6.8 Optimizing Indexes
        04:12
      • 6.9 Reorganizing and Rebuilding Indexes
        05:27
      • 6.10 Checking Index Fragmentation
        04:10

    • Module 07 - Programming Objects

      01:21:20Preview
      • 7.1 Understanding Stored Procedures
        05:20
      • 7.2 Creating Stored Procedures
        05:48
      • 7.3 Using Parameters with SPs
        05:17
      • 7.4 Using Temp Tables with SPs
        06:28
      • 7.5 Types of Stored Procedures
        05:13
      • 7.6 Understanding Transactions
        05:36
      • 7.7 Explicit and Implicit Transactions
        06:27
      • 7.8 Using Explicit Transactions
        05:38
      • 7.9 Transactions and Locking
        04:31
      • 7.10 Creating Views
        06:17
      • 7.11 Partitioned Views
        05:55
      • 7.12 Common Partitioned View Usage
        03:47
      • 7.13 View Options
        04:59
      • 7.14 Understanding Functions
        04:05
      • 7.15 Scalar Function Example
        05:59

    • Module 08 - Concurrency and Locking

      22:53Preview
      • 8.1 Understanding Concurrency
        05:28
      • 8.2 Normalization and Concurrency
        05:12
      • 8.3 Transaction Isolation Levels
        06:02
      • 8.4 Monitoring and Managing Locking
        06:11

    • Module 09 - Optimization

      44:55Preview
      • 9.1 SQL Server Profiler
        04:18
      • 9.2 Creating a Trace pt. 1
        06:08
      • 9.3 Creating a Trace pt. 2
        04:49
      • 9.4 Querying a Trace Table
        06:39
      • 9.5 Database Engine Tuning Advisor
        03:44
      • 9.6 Query Execution Plans
        05:30
      • 9.7 Understanding Query Hints
        04:15
      • 9.8 Using System Views
        05:54
      • 9.9 Using Performance Monitor
        03:38

    • Module 10 - Working with XML Data

      13:06Preview
      • 10.1 XML Basics
        04:15
      • 10.2 Relational vs. XML Data
        03:32
      • 10.3 Retrieving XML from Relational Data
        05:19

    • Module 11 - Conclusion

      03:58
      • 11.1 Course Wrap Up
        03:58

    • Module 12 - Credits

      02:39Preview
      • 12.1 About the Author
        02:39

Contact Us

1-844-532-7688

( Toll Free )

Reviews

  • Adalynn Ferguson

    Adalynn Ferguson

    I had a great learning experience through Simplilearn’s online training course. I would surely recommend this course to my peers.

  • Alexia Herrera

    Alexia Herrera

    This SQL Server course from Simplilearn helped me to get hands-on knowledge on how to develop MS SQL with ease. This course is for all those aspirants who wish to be SQL Server expert.

  • Jayla Nichols

    Jayla Nichols

    I found this course from Simplilearn to be comprehensive, and practical. I highly recommend it for SQL Server training and more!

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.