All-in-One MySQL Suite

Course

Online

Price on request

Description

  • Type

    Course

  • Methodology

    Online

Simplilearn is the World’s Largest Certification Training Provider, with over 400,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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2017
2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

  • MySQL

Course programme

Course Preview
  • Fundamentals of MySQL
    • Fundamentals Of MySQL
      • 1.1 Course Materials
      • 1.2 What Is SQL
      • 1.3 Setting Up A Database
      • 1.4 Introducing phpMyAdmin
      • 1.5 Syntax
      • 1.6 Tables And Rows
      • 1.7 Connecting To A Database
      • 1.8 Creating A Table And Columns
      • 1.9 Inserting Information
      • 1.10 Cleaning Information
      • 1.11 Pulling Info From A Database
      • 1.12 Where
      • 1.13 And Or
      • 1.14 Limits And Ordering Data
      • 1.15 Updating Rows
      • 1.16 Deleting Rows
      • 1.17 Secure Your Password
      • 1.18 Finishing Upv
  • MySQL and PHP Fundamentals
    • MySQL And PHP Fundamentals
      • 1.1 MySQL An Introduction
      • 1.2 Create Database
      • 1.3 Inserting Data
      • 1.4 SQL Injection
      • 1.5 Select Queries Part 1
      • 1.6 Select Queries Part 2
  • Learn MySQL Database In Under an Hour
    • Section 1 - Introduction
      • 1.1 Introduction To MySQL Database
    • Section 2 - Getting Started With MySQL
      • 2.1 Windows Command Prompt
      • 2.2 MySQL Monitor
    • Section 3 - Working With Databases
      • 3.1 Showing Databases
      • 3.2 Creating A Database
      • 3.3 Selecting A Database
    • Section 4 - Working With Tables
      • 4.1 Creating Tables
      • 4.2 Showing Tables
      • 4.3 Describing Tables
      • 4.4 What Is NULL
      • 4.5 Adding Table Columns
    • Section 5 - Working With Records
      • 5.1 Inserting Records
      • 5.2 Selecting Records
      • 5.3 Counting Records
      • 5.4 The WHERE Clause
      • 5.5 Searching Records
      • 5.6 Updating Records
      • 5.7 Deleting Records
    • Section 6 - Deleting And Updating
      • 6.1 Custom Column Names
      • 6.2 Removing Table Columns
      • 6.3 Deleting Tables
      • 6.4 Deleting Databases
  • PHP and MySQLi Database Integration
    • Module 1 - Introduction
      • 1.1 Introduction
    • Module 2 - Database Integration
      • 2.1 Database
      • 2.2 Connecting
      • 2.3 Getting Results
      • 2.4 Updating And Deleting
      • 2.5 Inserting Records
      • 2.6 Binding
    • Module 3 - Example Application
      • 3.1 Example Application
    • Module 4 - The Singleton Pattern
      • 4.1 Singleton Part 1
      • 4.2 Singleton Part 2
  • Learn MySQL From Scratch
    • Section 1 - IntroductionTo MYSQL
      • 1.1 What Is MYSQL
      • 1.2 Installing MySQL
      • 1.3 Accessing The MySQL Monitor
      • 1.4 Using PHPmyAdmin
    • Section 2 - The Basic Of MYSQL
      • 2.1 Creating Databases
      • 2.2 Deleting Databases
      • 2.3 Creating Tables
      • 2.4 Listing And Describing Tables
      • 2.5 Inserting Records
      • 2.6 Selecting Records
      • 2.7 Renaming Tables
      • 2.8 Auto Increment IDs
      • 2.9 Updating Records
      • 2.10 Deleting Records
      • 2.11 Limiting Records
      • 2.12 Ordering Records
      • 2.13 Joins
      • 2.14 Like Clause
      • 2.15 Counting Records
    • Section 3 - Introduction To MYSQL And PHP
      • 3.1 Introduction To MySQLI
      • 3.2 Introduction To PHP Data Objects
    • Section 4 - MYSQLI Basics
      • 4.1 Connecting
      • 4.2 Basic Queries
      • 4.3 Getting Results
      • 4.4 Looping Through Results
      • 4.5 Getting Result Counts
      • 4.6 Variables In Queries
      • 4.7 SQL Injections
      • 4.8 Escaping Values
      • 4.9 Prepared Statements
    • Section 5 - Project Creating A Database Wrapper
      • 5.1 Wrapper - Introduction
      • 5.2 Creating A Test Database
      • 5.3 Basic Functionalities
      • 5.4 Adding More Functionalities
    • Section 6 - Project Bulding A Contact Form
      • 6.1 Contact - Introduction
      • 6.2 Creating The Table
      • 6.3 Inserting Your Records
      • 6.4 Outputting The Data

All-in-One MySQL Suite

Price on request