Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn MySQL - For Beginners
Rating: 4.3 out of 5(2,421 ratings)
242,058 students

Learn MySQL - For Beginners

Learn to Create Database Driven Web Applications using MySQL
Last updated 7/2019
English

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

1 section27 lectures1h 27m total length
  • Introduction to Databases2:40
  • Introduction PhpMyAdmin2:35
  • PhpMyAdmin Interface Overview1:12
  • MySQL Security and Root Superuser5:02
  • MySQL Creating a Database and Table5:24
  • MySQL Creating a New User5:33
  • MySQL Database and Table Specific Privileges3:05
  • MySQL Modifying and Deleting a Table4:30
  • MySQL Modifying and Deleting a Database4:07
  • Introduction to SQL1:35
  • SQL Statements in PhpMyAdmin4:05
  • Connect to MySQL Database using PHP5:02
  • MySQL Database - Import Data1:43
  • SQL Select2:27
  • SQL Distinct Keyword1:45
  • SQL Where Clause1:40
  • SQL And Operator1:42
  • SQL Or Operator1:01
  • SQL Order By1:36
  • MySQL Insert Into6:29
  • MySQL Get Last ID1:27
  • MySQL Insert Multiple Records1:44
  • MySQL Prepared Statements2:45
  • MySQL Delete Records7:49
  • PHP Header Function1:17
  • PHP Isset2:35
  • MySQL Update Records7:07

Requirements

  • Basic knowledge of PHP
  • Basic Computer Skills

Description

Course: Learn MySQL - For Beginners
Learn to Create Database Driven Web Applications using MySQL

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.

What you'll learn - Overview:

  • 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

Key Concepts:

  • Introduction to Databases

  • Intro to PhpMyAdmin

  • PhpMyAdmin Interface Overview

  • MySQL Security and Root Superuser

  • MySQL Creating a Database and Table

  • MySQL Creating a New User

  • MySQL Database and Table Specific Privileges

  • MySQL Modifying and Deleting a Database

  • Introduction to SQL

  • SQL Statements in PhpMyAdmin

  • Connect to MySQL Database using PHP

  • MySQL Database - Import Data

  • SQL Select

  • SQL Distinct Keyword

  • SQL Where Clause

  • SQL And Operator

  • SQL Or Operator

  • SQL Order By

  • MySQL Insert Into

  • MySQL Get Last ID

  • MySQL Prepared Statements

  • MySQL Delete Records

  • PHP Header Function

  • PHP Isset

  • MySQL Update Records

Your Instructor:

YouAccel is a leading provider in online training, offering courses across numerous industries from IT and Development to Business, Marketing, Design, and Productivity.

The courses can be taken at one's own pace and are offered at several levels including beginner, intermediate and advanced. Online courses are also compatible with any mobile device for the ultimate in convenience.

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