Quality Seal Emagister EMAGISTER CUM LAUDE

All-in-One MySQL Suite

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • 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

Compare this course with other similar courses
See all