Updated on Apr, 2024
Language - English
Nice good
MySQL Course - For Beginners
Learn to Create Database Driven Web Applications using MySQL
Development,Web Development,MySQL,Programming
Lectures -28
Duration -1 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
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
What will you learn in this course:
- 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
What are the prerequisites for this course?
- Basic Computer Skills
Curriculum
Check out the detailed breakdown of what’s inside the course
MySQL Database Integration
27 Lectures
-
Introduction to MySQL Databases
02:40
02:40
-
Introduction PhpMyAdmin
02:35
02:35
-
PhpMyAdmin Interface Overview
01:12
01:12
-
MySQL Security and Root Superuser
05:02
05:02
-
MySQL Creating a Database and Table
05:24
05:24
-
MySQL Creating a New User
05:33
05:33
-
MySQL Database and Table Specific Privileges
03:05
03:05
-
MySQL Modifying and Deleting a Table
04:30
04:30
-
MySQL Modifying and Deleting a Database
04:07
04:07
-
Introduction to SQL
01:35
01:35
-
SQL Statements in PhpMyAdmin
04:05
04:05
-
Connect to MySQL Database using PHP
05:02
05:02
-
MySQL Database - Import Data
01:43
01:43
-
SQL Select
02:27
02:27
-
SQL Distinct Keyword
01:45
01:45
-
SQL Where Clause
01:40
01:40
-
SQL And Operator
01:42
01:42
-
SQL Or Operator
01:01
01:01
-
SQL Order By
01:36
01:36
-
MySQL Insert Into
06:28
06:28
-
MySQL Get Last ID
01:27
01:27
-
MySQL Insert Multiple Records
01:44
01:44
-
MySQL Prepared Statements
02:45
02:45
-
MySQL Delete Records
07:49
07:49
-
PHP Header Function
01:17
01:17
-
PHP Isset
02:34
02:34
-
MySQL Update Records
07:06
07:06
Instructor Details
YouAccel
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now