Course Description

  • What is the course all about?

    SQL Server Certification is the most coveted credential for SQL server users which authenticate their knowledge and skills to optimize the use of SQL Server 2012 to the fullest. Simplilearn offers various SQL Server Online Certification Trainings which can be chosen depending upon the specific usage of the SQL Server 2012.

  • Who should do this certification?

    Solution developers, Database developers, Architects and IT Professionals who want to understand new features and capabilities in SQL Server 2012 are best suited for the certification training.

  • What are the career benefits in-store for you?

    • Globally recognized standard for IT professionals that validates their expertise with the Microsoft SQL Server training and certifications
    • Demonstrate your broad skill sets in building and administrating enterprise-scale data solutions
    • Add real value to your professional development

  • Why Simplilearn?

    • Simplilearn is the World’s Largest Certification Training Provider, with over 500,000+ professionals trained globally
    • Trusted by the Fortune 500 companies as their learning provider for career growth and training
    • 2000+ certified and experienced trainers conduct trainings for various courses across the globe
    • All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt
    • Accredited, Approved and Recognized as a training organization, partner, education provider and examination center by globally renowned names like Project Management Institute of USA, APMG, CFA Institute, GARP, ASTQB, IIBA and others

Course Preview

    • 00 - Introduction

      02:00
      • 0.1 Introduction
        02:00
    • 01 - Database Fundamentals Introduction

      19:12
      • 1.1 Database Fundamentals
        03:24
      • 1.2 Introduction To Databases
        04:12
      • 1.3 Sql Storage
        04:43
      • 1.4 Most Common Database Objects
        03:18
      • 1.5 Sql Language
        03:35
      • 1.7 Quiz
    • 02 - Working with Database Objects

      59:59
      • 2.1 Working With Database Objects
        00:30
      • 2.2 Introduction To Data Types
        05:50
      • 2.3 Demo Working with Tables
        10:49
      • 2.4 Working with Tables
        06:28
      • 2.5 Demo Working with Views
        05:48
      • 2.6 Working with Views
        05:16
      • 2.7 Creating Stored Procedures
        06:06
      • 2.8 Demo Creating Stored Procedures
        07:11
      • 2.9 Demo Working with Functions
        06:51
      • 2.10 summary
        01:00
      • 2.11 Working with Functions
        04:10
      • 2.12 Quiz
    • 03 - Working with Data

      1:04:52
      • 3.1 Database Fundamentals
        00:57
      • 3.2 Demo Querying Data
        07:30
      • 3.3 Querying Data
        12:01
      • 3.4 Advanced Query
        12:53
      • 3.5 Demo Advanced Query
        13:49
      • 3.6.Demo Inserting Data
        03:36
      • 3.7 Inserting Data
        03:20
      • 3.8 Demo Updating Data
        03:07
      • 3.9 Updating Data
        01:55
      • 3.10 Deleting Data
        02:36
      • 3.11 Demo Deleting Data
        02:38
      • 3.12 Summary
        00:30
      • 3.13 Quiz
    • 04 - Using Constraints

      48:35
      • 4.1 Database Fundamentals
        00:47
      • 4.2 Demo Index Maintenance
        04:01
      • 4.3 Demo Using Key
        08:57
      • 4.4 Working With Keys
        05:53
      • 4.5 Understanding Data Storage
        06:10
      • 4.6 Clustered Index
        03:13
      • 4.7 Demo Clustered Index
        03:11
      • 4.8 Using Nonclustered Indexes
        03:58
      • 4.9 Normalization
        11:52
      • 4.10 Summary
        00:33
      • 4.11 Quiz
    • 05 - Database Security

      55:45
      • 5.1 Database Fundamentals
        01:18
      • 5.2 Demo Working with server logins
        07:49
      • 5.3 Server Logins
        10:48
      • 5.4 Database Users
        01:48
      • 5.5 Demo Database Users
        05:13
      • 5.6 Demo Schema Introduction
        03:11
      • 5.7 Schema Introduction
        03:00
      • 5.8 Demo Using roles
        03:50
      • 5.9 Server and Database Roles
        09:55
      • 5.10 Demo Working with Permissions
        08:08
      • 5.11 Summary
        00:45
      • 5.12 Quiz
    • 06 - Disaster Recovery

      36:31
      • 6.1 Database Fundamentals
        00:38
      • 6.2 Introduction to Disaster Recovery
        11:11
      • 6.3 Database Backup
        08:19
      • 6.4 Database Restore
        06:02
      • 6.5 Demo Restoring the database
        03:14
      • 6.6 Demo Database Backup
        06:39
      • 6.7 Summary
        00:28
      • 6.8 Quiz
    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

    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 and practice tests along 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.