Course description

  • What is the course all about?

    The course deals with the fundamentals, working and installation of MySQL and also covers the MySQLi framework. Along with this participants also get to work on two real life projects.

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

    At the end of the training participants are able to:
    • Understand the working of MySQL in the real world
    • Install MySQL
    • Gain knowledge on MySQLi framework
    • Understand working with databases
    • Finish two real life MySQL projects
    • Know how MySQL and PHP work together

  • Who should do this course?

    The course is ideal for aspiring web developers or designers and experienced programmers, web developers and designers.

  • 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 - IntroductionTo MYSQL 29:53
      • 1.1 What Is MYSQL06:00
      • 1.2 Installing MySQL07:28
      • 1.3 Accessing The MySQL Monitor06:43
      • 1.4 Using PHPmyAdmin09:42
    • Section 2 - The Basic Of MYSQL 1:53:06
      • 2.1 Creating Databases06:40
      • 2.2 Deleting Databases04:34
      • 2.3 Creating Tables07:52
      • 2.4 Listing And Describing Tables04:38
      • 2.5 Inserting Records09:43
      • 2.6 Selecting Records07:06
      • 2.7 Renaming Tables01:28
      • 2.8 Auto Increment IDs10:03
      • 2.9 Updating Records09:12
      • 2.10 Deleting Records02:11
      • 2.11 Limiting Records08:28
      • 2.12 Ordering Records06:39
      • 2.13 Joins16:13
      • 2.14 Like Clause07:24
      • 2.15 Counting Records10:55
    • Section 3 - Introduction To MYSQL And PHP 11:03
      • 3.1 Introduction To MySQLI05:47
      • 3.2 Introduction To PHP Data Objects05:16
    • Section 4 - MYSQLI Basics 1:17:36
      • 4.1 Connecting08:58
      • 4.2 Basic Queries05:37
      • 4.3 Getting Results09:06
      • 4.4 Looping Through Results08:25
      • 4.5 Getting Result Counts03:43
      • 4.6 Variables In Queries08:43
      • 4.7 SQL Injections16:23
      • 4.8 Escaping Values06:55
      • 4.9 Prepared Statements09:46
    • Section 5 - Project Creating A Database Wrapper 47:10
      • 5.1 Wrapper - Introduction04:46
      • 5.2 Creating A Test Database02:05
      • 5.3 Basic Functionalities18:28
      • 5.4 Adding More Functionalities21:51
    • Section 6 - Project Bulding A Contact Form 19:56
      • 6.1 Contact - Introduction01:44
      • 6.2 Creating The Table01:07
      • 6.3 Inserting Your Records06:11
      • 6.4 Outputting The Data10:54
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less


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