Take this
course

Software Development / Big Data & Analytics

MySQL PHP Database Essentials - Add a Database to your Site

Learn the fundamentals of MySQL databases and phpMyAdmin and how to connect database to your PHP code

Description

MySQL Database Tutorial for beginners to help better understand PHP connections. Learn how to interact with PHP code to connect to Databases. Create a database with both phpmyadmin and PHP code. Object oriented connections MySQLi and MySQL. How to create a database MySQL How to drop MySQL databases Different MySQL data types How to insert connect to MySQL using PHP Output Database content into PHP and web code. Selectors wildcards and custom selection options. JOIN tables GROUP tables Avoid SQL injections Create update insert and delete database content. MySQL is the most popular relational database used across the internet today. We show you how to setup and use a database for your website. Perfect for anyone who wants to understand how to use MYSQL This course is designed to be easy to follow along, its encouraged to practice the code being presented through out the course. Resources, source code, and everything you need to learn to try MYSQL code is provided. This step by step course shows you the code you need to know. Learn about mysql databases and its core concepts and much more..... We walk you through step by step with detailed explanations of code and more.
Full details

Curriculum

  • Learning MYSQL
    Introduction
    3:55
    cpanel course resources introduction
    3:31
    Options
    4:19
    Download Course Resources
    PHPmyadmin create a table
    6:36
    Connect to database
    10:11
    Connect Object Oriented Method
    2:53
    Download MySQL Source Code
    Create a database with PHP
    3:47
    DROP database
    3:11
    Download MySQL Source Code 2
    Create Table Datatypes
    6:57
    Download MySQL Source Code 3
    DataTypes
    MySQL Object vs Procedural Connections
    9:34
  • MYSQL Database interaction
    Insert Data
    7:08
    Fetch Array Select
    4:24
    Download MySQL Source Code 4
    Insert array list data
    6:28
    Selectors wildcards and LIKE
    4:05
    Download MySQL Source Code 5
    Sort order
    3:00
    Joining Tables
    6:44
    DELETE records
    2:37
    UPDATE table
    2:48
    GROUPING rows
    3:56
    Download MySQL Source Code 6
    COUNTING ROWs
    4:18
    Download MySQL Source Code 7
    Clean avoid SQL injections
    2:37
    Download MySQL Source Code 8
    Download MySQL Source Code 9

Skills

  • Database
  • MySQL
  • PHP Tool

Similar Courses

More Courses by this Instructor