Learn MySQL - For Beginners
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
Course content
27 lectures • 1hr 28minMySQL Database Integration
- Preview02:40
- Preview02:35
- 01:12PhpMyAdmin Interface Overview
- 05:02MySQL Security and Root Superuser
- 05:24MySQL Creating a Database and Table
- 05:33MySQL Creating a New User
- 03:05MySQL Database and Table Specific Privileges
- Preview04:30
- 04:07MySQL Modifying and Deleting a Database
- 01:35Introduction to SQL
- 04:05SQL Statements in PhpMyAdmin
- 05:02Connect to MySQL Database using PHP
- 01:43MySQL Database - Import Data
- 02:27SQL Select
- 01:45SQL Distinct Keyword
- 01:40SQL Where Clause
- 01:42SQL And Operator
- 01:01SQL Or Operator
- 01:36SQL Order By
- 06:29MySQL Insert Into
- 01:27MySQL Get Last ID
- Preview01:44
- 02:45MySQL Prepared Statements
- 07:49MySQL Delete Records
- 01:17PHP Header Function
- 02:35PHP Isset
- 07:07MySQL Update Records
Requirements
- Basic knowledge of PHP
- Basic Computer Skills
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.
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
Instructor
![YouAccel Training](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 28,186 Reviews
- 680,529 Students
- 31 Courses
Mission Statement:
To facilitate a comprehensive online learning environment for students.
Company Overview
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 Udemy's online messaging console. All courses come with a certificate of completion and no age restrictions apply.