MySQL Fundamentals

Learn to create database driven web applications using MySQL
Enroll Now $199 $19.99

Why Enroll?

Check out just a few key highlights for:
MySQL Fundamentals.

7,977 Students

Join a community of other students taking this course.

Duration

Each lecture is recorded in HD 1920x1080p with clear audio.

4.8/5 Stars

All courses are rated by fellow community members.

More Benefits

Learning with YouAccel has several exciting benefits.

Clear HD Video

All YouAccel courses are recorded and produced in 1920x1080p HD Quality.

Live Support

Have a question? Contact our support team at any time using our chat feature, or built-in messaging console.

Certification

All YouAccel courses come with a Certificate of Completion. This helps Showcase your proficiency in a subject to prospective employers.

Lifetime Access

All YouAccel courses include lifetime on-demand access. Class lecture are also available for offline viewing.

Community

Join a community of over 600,000 learners. Connect & Communicate through YouAccel's networking tools.

Job Pool

YouAccel's integration with Indeed makes it easy to search through thousands of jobs and apply with just a click.

Course Outline

A comprehensive list of all sections & lectures for this course can be found below.

Section 1: Introduction

Course Objectives - 00:37 [Play]

Introduction to Databases - 02:40 [Play]

Introduction PhpMyAdmin - 02:36

PhpMyAdmin Interface Overview - 01:13

MySQL Security and Root Superuser - 05:03

MySQL Creating a Database and Table - 05:24

MySQL Creating a New User - 05:34

MySQL Database and Table Specific Privileges - 03:05

MySQL Modifying and Deleting a Table - 04:31

MySQL Modifying and Deleting a Database - 04:08

Introduction to SQL - 01:35

SQL Statements in PhpMyAdmin - 04:05

Connect to MySQL Database using PHP - 05:03

MySQL Database - Import Data - 01:43

SQL Select - 02:27

SQL Distinct Keyword - 01:45

SQL Where Clause - 01:40

SQL And Operator - 01:43

SQL Or Operator - 01:01

SQL Order By - 01:37

MySQL Insert Into - 06:29

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:35

MySQL Update Records - 07:07

Course Description

This course is part-eight of the nine-part Web Development Masterclass Series.

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 Prerequisites: Internet and Web Development Fundamentals, HTML Fundamentals, CSS Fundamentals, JavaScript Fundamentals, jQuery Fundamentals, Bootstrap Fundamentals, PHP Fundamentals

MySQL Fundamentals

All course reviews are written by students who have completed the course or are currently enrolled.

Course Instructor - Youaccel

youaccel
Teaching 93 Courses

youaccel is currently teaching 93 courses. All courses are currently open for enrollment.

574,171 Enrollments

youaccel currently has 574,171 global enrollments across 93 courses that are active on the platform.

4.5 Star Rating

youaccel has an average rating of 4.5/5 stars, across 93 courses.

YouAccel is a leading provider in online training, offering courses across numerous industries from IT and Development to Business, Marketing, Design, and Productivity. The e-learning experience provided by YouAccel is Dynamic. Each course is streamed in High Definition with corresponding assignments, quizzes, and exams that are delivered and graded electronically. All YouAccel courses are taught by certified educators that have numerous years of work experience in the field for which they provide instruction. 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. Taking the experience to a new personalized level, live communication with instructors is available through an online messaging console. All courses come with a certificate of completion and no age restrictions apply.



All Courses include a 30-Day Satisfaction Guarantee.

You have nothing to lose. Give the course a try. If it's not what you expected, get a full refund within 30 days of purchase.