Learn MySQL from Scratch | Simplilearn

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.

  • 39 High Quality Lectures
  • 5 Hrs of HQ e-learning content
  • 2 real life Mysql projects
  • Covers Mysqli framework

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.

Contact Us

+1-844-532-7688

(Toll Free)

Request more information

For individuals
For business
Name*
Email*
Phone Number*
Your Message (Optional)
We are looking into your query.
Our consultants will get in touch with you soon.

A Simplilearn representative will get back to you in one business day.

First Name*
Last Name*
Email*
Phone Number*
Company*
Job Title*
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
/index/hidden/ - Never remove this line