All-in-One MySQL Suite

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Want to speak to an Advisor about this course?

Important information

Typology Course
Methodology Online
  • Course
  • Online
Description

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.

Important information

Opinions

There are no opinions on this course yet

What you'll learn on the course

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

Achievements for this centre

2016