All-in-One MySQL Suite
Course
Online
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.
Reviews
This centre's achievements
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
- 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
- Fundamentals Of MySQL
- 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
- MySQL And PHP Fundamentals
- 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
- Section 1 - Introduction
- 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
- Module 1 - Introduction
- 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
- Section 1 - IntroductionTo MYSQL
All-in-One MySQL Suite