Tutorialspoint

Learn MySQL - For Beginners

Learn to Create Database Driven Web Applications using MySQL

Course Description

Welcome to the PHP & MySQL Certification Course for Beginners.

This course offers a comprehensive guide to learning how to code in PHP. We also explore integrating MySQL Databases into your PHP Projects for dynamic, user driven functionality.

We start with PHP basics, including variable declaration and data output. The lessons then transition into working with objects, conditional statements, loops, functions, arrays, form validation, sorting, and much more.

After the PHP Section, students learn to unleash the true power of dynamic page development with MySQL database integration. We start with table creation and user management. From there we progress into commonly used SQL statements for database administration. Students are also taught how to create database connections and to execute SQL statements directly from PHP scripts. Our coding style keeps script security, and execution efficiency in mind at all times.

If you are interested in embarking into the world of PHP Development with Database integration, don’t wait another second. Enrol today in this exciting new course.

Who this course is for:

  • Beginner developers who are interested in learning the foundations of PHP.
  • Students who want to integrate MySQL Databases into their PHP Web Applications.
  • Students who want to learn to code in PHP.
  • Students who want to learn how to execute SQL Statements, directly from PHP.

Goals

  • 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

Prerequisites

  • Basic Computer Skills
Show More

Curriculum

  • Introduction to MySQL Databases
    02:40
    Preview
  • Introduction PhpMyAdmin
    02:35
    Preview
  • PhpMyAdmin Interface Overview
    01:12
    Preview
  • 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 Table
    04:30
  • 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:28
  • MySQL Get Last ID
    01:27
  • MySQL Insert Multiple Records
    01:44
  • MySQL Prepared Statements
    02:45
  • MySQL Delete Records
    07:49
  • PHP Header Function
    01:17
  • PHP Isset
    02:34
  • MySQL Update Records
    07:06
Feedbacks
5.0
Course Rating
100%
0%
0%
0%
0%

    Feedbacks (1)

  • HARSHA VARDHAN
    HARSHA VARDHAN

    Nice good

Learn MySQL - For Beginners
This Course Includes
  • 1 hours
  • 27 Lectures
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate