Learn MySQL - For Beginners
4.2 (707 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
59,707 students enrolled

Learn MySQL - For Beginners

Learn to Create Database Driven Web Applications using MySQL
4.2 (707 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
59,707 students enrolled
Created by YouAccel Training
Last updated 7/2019
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • MySQL Database Administration
  • PhpMyAdmin Fundamentals
  • MySQL Security and Root Superuser
  • Create Tables
  • Creating Users
  • Modifying Database Privileges
  • Modifying & Deleting Tables
  • Modifying & Deleting Databases
  • SQL Fundamentals
  • SQL Statements in PhpMyAdmin
  • Database Connections
  • MySQL Import & Export Data
  • Updating Data in MySQL DB
Course content
Expand 27 lectures 01:27:57
+ MySQL Database Integration
27 lectures 01:27:57
PhpMyAdmin Interface Overview
01:12
MySQL Security and Root Superuser
05:02
MySQL Creating a Database and Table
05:24
MySQL Creating a New User
05:33
MySQL Database and Table Specific Privileges
03:05
MySQL Modifying and Deleting a Database
04:07
Introduction to SQL
01:35
SQL Statements in PhpMyAdmin
04:05
Connect to MySQL Database using PHP
05:02
MySQL Database - Import Data
01:43
SQL Select
02:27
SQL Distinct Keyword
01:45
SQL Where Clause
01:40
SQL And Operator
01:42
SQL Or Operator
01:01
SQL Order By
01:36
MySQL Insert Into
06:29
MySQL Get Last ID
01:27
MySQL Prepared Statements
02:45
MySQL Delete Records
07:49
PHP Header Function
01:17
PHP Isset
02:35
MySQL Update Records
07:07
Requirements
  • Basic knowledge of PHP
  • Basic Computer Skills
Description

Students learn to integrate and administer MySQL databases as part of PHP web application development.

The course begins with an in-depth look into PhpMyAdmin to create, delete and modify databases. We also explore security considerations and user privileges.

Next, students learn to build connections to existing databases in PHP, and execute commands using several essential SQL statements.

Who this course is for:
  • Beginner Web Developers Interested in Learning to Create & Administer a MySQL Database using PHP
  • Students interested in learning Structured Query Language (SQL)
  • Students interested in Learning how to use PhpMyAdmin for Database Administration