Learn MySQL – For Beginners

Learn MySQL – For Beginners, available at $34.99, has an average rating of 4.45, with 27 lectures, based on 2298 reviews, and has 240187 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner Web Developers Interested in Learning to Create & Administer a MySQL Database using PHP or Students interested in learning Structured Query Language (SQL) or Students interested in Learning how to use PhpMyAdmin for Database Administration It is particularly useful for Beginner Web Developers Interested in Learning to Create & Administer a MySQL Database using PHP or Students interested in learning Structured Query Language (SQL) or Students interested in Learning how to use PhpMyAdmin for Database Administration.

Enroll now: Learn MySQL – For Beginners

Summary

Title: Learn MySQL – For Beginners

Price: $34.99

Average Rating: 4.45

Number of Lectures: 27

Number of Published Lectures: 27

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

Course: Learn MySQL – For Beginners
Learn to Create Database Driven Web Applications using MySQL

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.

What you’ll learn – Overview:

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

Key Concepts:

Introduction to Databases
Intro to PhpMyAdmin
PhpMyAdmin Interface Overview
MySQL Security and Root Superuser
MySQL Creating a Database and Table
MySQL Creating a New User
MySQL Database and Table Specific Privileges
MySQL Modifying and Deleting a Database
Introduction to SQL
SQL Statements in PhpMyAdmin
Connect to MySQL Database using PHP
MySQL Database – Import Data
SQL Select
SQL Distinct Keyword
SQL Where Clause
SQL And Operator
SQL Or Operator
SQL Order By
MySQL Insert Into
MySQL Get Last ID
MySQL Prepared Statements
MySQL Delete Records
PHP Header Function
PHP Isset
MySQL Update Records

Your Instructor:

YouAccel is a leading provider in online training, offering courses across numerous industries from IT and Development to Business, Marketing, Design, and Productivity.

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.

Course Curriculum

Chapter 1: MySQL Database Integration

Lecture 1: Introduction to Databases

Lecture 2: Introduction PhpMyAdmin

Lecture 3: PhpMyAdmin Interface Overview

Lecture 4: MySQL Security and Root Superuser

Lecture 5: MySQL Creating a Database and Table

Lecture 6: MySQL Creating a New User

Lecture 7: MySQL Database and Table Specific Privileges

Lecture 8: MySQL Modifying and Deleting a Table

Lecture 9: MySQL Modifying and Deleting a Database

Lecture 10: Introduction to SQL

Lecture 11: SQL Statements in PhpMyAdmin

Lecture 12: Connect to MySQL Database using PHP

Lecture 13: MySQL Database – Import Data

Lecture 14: SQL Select

Lecture 15: SQL Distinct Keyword

Lecture 16: SQL Where Clause

Lecture 17: SQL And Operator

Lecture 18: SQL Or Operator

Lecture 19: SQL Order By

Lecture 20: MySQL Insert Into

Lecture 21: MySQL Get Last ID

Lecture 22: MySQL Insert Multiple Records

Lecture 23: MySQL Prepared Statements

Lecture 24: MySQL Delete Records

Lecture 25: PHP Header Function

Lecture 26: PHP Isset

Lecture 27: MySQL Update Records

Instructors

YouAccel Training
8+ Million Enrollments, 70k+ Reviews. Register Today.

Rating Distribution

1 stars: 48 votes
2 stars: 91 votes
3 stars: 411 votes
4 stars: 815 votes
5 stars: 933 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu