Course description

  • What is the course all about?

    The course gives a complete overview of MySQL setup, working with tables, records, databases, adding and deleting information from the databases.

  • What learning benefits do you get from Simplilearn’s training?

    At the end of the training participants are able to:
    • Understand MySQL architecture
    • Install MySQL
    • Learn database design
    • Gain knowledge of different data types

  • Who should do this course?

    The course is ideal for web developers and people stepping into the database world.

  • 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

    • Section 1 - Introduction

      00:41
      • 1.1 Introduction To MySQL Database
        00:41
    • Section 2 - Getting Started With MySQL

      03:07
      • 2.1 Windows Command Prompt
        00:58
      • 2.2 MySQL Monitor
        02:09
    • Section 3 - Working With Databases

      02:32
      • 3.1 Showing Databases
        00:48
      • 3.2 Creating A Database
        00:48
      • 3.3 Selecting A Database
        00:56
    • Section 4 - Working With Tables

      09:13
      • 4.1 Creating Tables
        01:57
      • 4.2 Showing Tables
        00:53
      • 4.3 Describing Tables
        01:26
      • 4.4 What Is NULL
        01:18
      • 4.5 Adding Table Columns
        03:39
    • Section 5 - Working With Records

      19:45
      • 5.1 Inserting Records
        02:31
      • 5.2 Selecting Records
        03:59
      • 5.3 Counting Records
        02:46
      • 5.4 The WHERE Clause
        02:46
      • 5.5 Searching Records
        03:52
      • 5.6 Updating Records
        01:42
      • 5.7 Deleting Records
        02:09
    • Section 6 - Deleting And Updating

      06:33
      • 6.1 Custom Column Names
        02:09
      • 6.2 Removing Table Columns
        02:08
      • 6.3 Deleting Tables
        01:15
      • 6.4 Deleting Databases
        01:01
    • {{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 this Online 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 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.

    • 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.