Key features

MONEY BACK GUARANTEE

How this works :

At Simplilearn, we greatly value the trust of our patrons. Our courses were designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Self Placed Learning :

Raise refund request within 7 days of purchase of course. Money back guarantee is void if the participant has accessed more than 25% content.

  • Training for Microsoft® 98-364 exam
  • 6 hours of High Quality e-Learning content
  • 18 end of chapter quizzes
  • 3 Database Fundamentals Simulation Exams
  • 19 Live Demos
  • High Passrate

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 Introduction02:00
    • 01 - Database Fundamentals Introduction 19:12
      • 1.1 Database Fundamentals03:24
      • 1.2 Introduction To Databases04:12
      • 1.3 Sql Storage04:43
      • 1.4 Most Common Database Objects03:18
      • 1.5 Sql Language03:35
      • 1.7 Quiz
    • 02 - Working with Database Objects 59:59
      • 2.1 Working With Database Objects00:30
      • 2.2 Introduction To Data Types05:50
      • 2.3 Demo Working with Tables10:49
      • 2.4 Working with Tables06:28
      • 2.5 Demo Working with Views05:48
      • 2.6 Working with Views05:16
      • 2.7 Creating Stored Procedures06:06
      • 2.8 Demo Creating Stored Procedures07:11
      • 2.9 Demo Working with Functions06:51
      • 2.10 summary01:00
      • 2.11 Working with Functions04:10
      • 2.12 Quiz
    • 03 - Working with Data 1:04:52
      • 3.1 Database Fundamentals00:57
      • 3.2 Demo Querying Data07:30
      • 3.3 Querying Data12:01
      • 3.4 Advanced Query12:53
      • 3.5 Demo Advanced Query13:49
      • 3.6.Demo Inserting Data03:36
      • 3.7 Inserting Data03:20
      • 3.8 Demo Updating Data03:07
      • 3.9 Updating Data01:55
      • 3.10 Deleting Data02:36
      • 3.11 Demo Deleting Data02:38
      • 3.12 Summary00:30
      • 3.13 Quiz
    • 04 - Using Constraints 48:35
      • 4.1 Database Fundamentals00:47
      • 4.2 Demo Index Maintenance04:01
      • 4.3 Demo Using Key08:57
      • 4.4 Working With Keys05:53
      • 4.5 Understanding Data Storage06:10
      • 4.6 Clustered Index03:13
      • 4.7 Demo Clustered Index03:11
      • 4.8 Using Nonclustered Indexes03:58
      • 4.9 Normalization11:52
      • 4.10 Summary00:33
      • 4.11 Quiz
    • 05 - Database Security 55:45
      • 5.1 Database Fundamentals01:18
      • 5.2 Demo Working with server logins07:49
      • 5.3 Server Logins10:48
      • 5.4 Database Users01:48
      • 5.5 Demo Database Users05:13
      • 5.6 Demo Schema Introduction03:11
      • 5.7 Schema Introduction03:00
      • 5.8 Demo Using roles03:50
      • 5.9 Server and Database Roles09:55
      • 5.10 Demo Working with Permissions08:08
      • 5.11 Summary00:45
      • 5.12 Quiz
    • 06 - Disaster Recovery 36:31
      • 6.1 Database Fundamentals00:38
      • 6.2 Introduction to Disaster Recovery11:11
      • 6.3 Database Backup08:19
      • 6.4 Database Restore06:02
      • 6.5 Demo Restoring the database03:14
      • 6.6 Demo Database Backup06:39
      • 6.7 Summary00: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.