Course Overview

Key Features

  • 5 complete MySQL courses
  • PHP and MySQL
  • PHP and MySQLi
  • Course Completion Certificate

Training Options

Self-Paced Learning

$ 199

  • Lifetime access to high-quality self-paced e-learning content curated by industry experts
  • 24x7 learner assistance and support

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Course Content

  • Fundamentals of MySQL

    Preview
    • Fundamentals Of MySQL

      01:57:08Preview
      • 1.1 Course Materials
        00:27
      • 1.2 What Is SQL
        02:09
      • 1.3 Setting Up A Database
        04:09
      • 1.4 Introducing phpMyAdmin
        17:57
      • 1.5 Syntax
        04:34
      • 1.6 Tables And Rows
        02:54
      • 1.7 Connecting To A Database
        09:53
      • 1.8 Creating A Table And Columns
        11:53
      • 1.9 Inserting Information
        08:27
      • 1.10 Cleaning Information
        10:18
      • 1.11 Pulling Info From A Database
        06:40
      • 1.12 Where
        04:43
      • 1.13 And Or
        04:49
      • 1.14 Limits And Ordering Data
        04:33
      • 1.15 Updating Rows
        05:51
      • 1.16 Deleting Rows
        06:06
      • 1.17 Secure Your Password
        07:50
      • 1.18 Finishing Upv
        03:55
  • MySQL and PHP Fundamentals

    Preview
    • MySQL And PHP Fundamentals

      54:34Preview
      • 1.1 MySQL An Introduction
        08:54
      • 1.2 Create Database
        09:15
      • 1.3 Inserting Data
        09:57
      • 1.4 SQL Injection
        10:16
      • 1.5 Select Queries Part 1
        09:11
      • 1.6 Select Queries Part 2
        07:01
  • Learn MySQL Database In Under an Hour

    Preview
    • Section 1 - Introduction

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

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

      02:32Preview
      • 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:13Preview
      • 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
  • PHP and MySQLi Database Integration

    Preview
    • Module 1 - Introduction

      01:51Preview
      • 1.1 Introduction
        01:51
    • Module 2 - Database Integration

      56:28Preview
      • 2.1 Database
        05:22
      • 2.2 Connecting
        07:41
      • 2.3 Getting Results
        16:09
      • 2.4 Updating And Deleting
        08:22
      • 2.5 Inserting Records
        09:37
      • 2.6 Binding
        09:17
    • Module 3 - Example Application

      22:06
      • 3.1 Example Application
        22:06
    • Module 4 - The Singleton Pattern

      21:22
      • 4.1 Singleton Part 1
        11:56
      • 4.2 Singleton Part 2
        09:26
  • Learn MySQL From Scratch

    Preview
    • Section 1 - IntroductionTo MYSQL

      29:53Preview
      • 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

      01:53:06Preview
      • 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:03Preview
      • 3.1 Introduction To MySQLI
        05:47
      • 3.2 Introduction To PHP Data Objects
        05:16
    • Section 4 - MYSQLI Basics

      01:17:36Preview
      • 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

Reviews

  • Annabelle Reyes

    Annabelle Reyes

    I have gained immense confidence in my work at the end of the training. Thank you Simplilearn

  • Alexandra Cruz

    Alexandra Cruz

    I am feeling totally satisfied for taking this training as I have got the required domain knowledge

  • Paisley James

    Paisley James

    This is a comprehensive training to learn MySQL concepts. Highly recommendable

Why Online Bootcamp

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

FAQs

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