Learn MySQL - For Beginners (With Free Certificate)

Learn to Create Database Driven Web Applications using MySQL

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


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.

Course Content

  • Introduction to Databases
  • Introduction 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 Table
  • 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 Insert Multiple Records
  • MySQL Prepared Statements
  • MySQL Delete Records
  • PHP Header Function
  • PHP Isset
  • MySQL Update Records

 

 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

 

Requirements

  • Basic knowledge of PHP
  • Basic Computer Skills

This course includes:

  • 1.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion


ENROLL NOW

Coupon Code: YOUACCEL99907

This Coupon code will expires soon