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 MYSQL
        06:00
      • 1.2 Installing MySQL
        07:28
      • 1.3 Accessing The MySQL Monitor
        06:43
      • 1.4 Using PHPmyAdmin
        09:42
    • Section 2 - The Basic Of MYSQL

      1:53:06
      • 2.1 Creating Databases
        06:40
      • 2.2 Deleting Databases
        04:34
      • 2.3 Creating Tables
        07:52
      • 2.4 Listing And Describing Tables
        04:38
      • 2.5 Inserting Records
        09:43
      • 2.6 Selecting Records
        07:06
      • 2.7 Renaming Tables
        01:28
      • 2.8 Auto Increment IDs
        10:03
      • 2.9 Updating Records
        09:12
      • 2.10 Deleting Records
        02:11
      • 2.11 Limiting Records
        08:28
      • 2.12 Ordering Records
        06:39
      • 2.13 Joins
        16:13
      • 2.14 Like Clause
        07:24
      • 2.15 Counting Records
        10:55
    • Section 3 - Introduction To MYSQL And PHP

      11:03
      • 3.1 Introduction To MySQLI
        05:47
      • 3.2 Introduction To PHP Data Objects
        05:16
    • Section 4 - MYSQLI Basics

      1:17:36
      • 4.1 Connecting
        08:58
      • 4.2 Basic Queries
        05:37
      • 4.3 Getting Results
        09:06
      • 4.4 Looping Through Results
        08:25
      • 4.5 Getting Result Counts
        03:43
      • 4.6 Variables In Queries
        08:43
      • 4.7 SQL Injections
        16:23
      • 4.8 Escaping Values
        06:55
      • 4.9 Prepared Statements
        09:46
    • Section 5 - Project Creating A Database Wrapper

      47:10
      • 5.1 Wrapper - Introduction
        04:46
      • 5.2 Creating A Test Database
        02:05
      • 5.3 Basic Functionalities
        18:28
      • 5.4 Adding More Functionalities
        21:51
    • Section 6 - Project Bulding A Contact Form

      19:56
      • 6.1 Contact - Introduction
        01:44
      • 6.2 Creating The Table
        01:07
      • 6.3 Inserting Your Records
        06:11
      • 6.4 Outputting The Data
        10:54
    • {{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.