Learn MySQL - For Beginners

Learn to Create Database Driven Web Applications using MySQL

4.39 (1347 reviews)
Udemy
platform
English
language
Web Development
category
students
1.5 hours
content
Jul 2019
last update
regular price

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

Description

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.

Screenshots

Learn MySQL - For BeginnersLearn MySQL - For BeginnersLearn MySQL - For BeginnersLearn MySQL - For Beginners

Content

MySQL Database Integration
Introduction to Databases
Introduction 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 Table
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 Insert Multiple Records
MySQL Prepared Statements
MySQL Delete Records
PHP Header Function
PHP Isset
MySQL Update Records

Reviews

Anupam
10 March 2021
This short and comprehensive course is ideal for a beginner in MySQL. If you are beginner in MySQL definitely give it a shot
Gastón
31 January 2021
I am taking it to review mysql, the instructor explains each instruction of the MySQL queries, what I don't like is that the code already has it pre-written when it seems to me that he should write it while explaining to the class, and the second thing is that the words in both the browser and the text editor look very, very small, you have to get close to the screen even to read, I recommend zooming in on the screen so as not to make it difficult to read the code. It would also be highly recommended that the instructor leave the code in the resources to be able to download them. The rest of the course seemed good to me. Greetings.
Alejandro
27 October 2020
Poca informacion sobre sql y los videos son de pesima calidad de audio, unos se escuchan bien, otros muy bajos y otros muy altos
shashibhushan
22 September 2020
This course helpful for me. It's give to new learning experience for me. I good to take forward in career
Vanessa
14 September 2020
Der Screenshare war zum Teil etwas verschwommen/schwer lesbar. Zoomen hätte hier geholfen. Inhaltlich sehr basic, aber das stand ja im Titel. Ich konnte definitiv auch noch etwas dazulernen, auch wenn ich SQL vorher schon kannte
Milka
24 August 2020
Es un curso que te explica lo básico y está muy claro. Quizás explica un poco lento pero igual te permite entenderlo bien y procesarlo de a poco.
Dharan
21 August 2020
I'm a beginner in SQL and DataBase and it's quite good this course to understand how a database works and using of PhpMyAdmin with Graphical interface.
Kenilkumar
24 July 2020
yes,it was good course cover with basic operation of sql and this course remind me all my old knowledge about mysql.thanking you.
Thushar
2 July 2020
This is one of the best explanation i was ever seen about MySQL. I strongly recommend this course to everyone who are really have interest about Database Management. Thanks to Udemy.......
Soham
1 July 2020
Very vague and doesn't really focus on the development it's like they're teaching just because we paid them doesn't tell you how to install the requirements or anything. A total waste of money and time.
Duc
8 June 2020
This is a section of a bigger course and the instructor should cover how to install and set up PhpMyAdmin environment as well.
Lito
7 June 2020
Actually, this is my first time taking the subject on PhpMyAdmin and mySQL. I want to learn more on these topics and I think this course is definitely for me. Thank you so much.
Wilson
2 June 2020
Ha sido genial estoy tomando 2 cursos y me he enamorado de UDEMY con una interfaz muy llamativa y fácil de usar, la infinidad de cursos etc. La recomiendo.
Kenny
8 September 2019
The explanation skipped information relevant for a beginner to fully catch up with the meanings and flow.
Azamat
30 July 2019
It was good, but I think, it'd be more effective, if author will give some kind of problems, or homework, or examples, that we have to solve. But regardless, course is good!

Charts

Price

Learn MySQL - For Beginners - Price chart

Rating

Learn MySQL - For Beginners - Ratings chart

Enrollment distribution

Learn MySQL - For Beginners - Distribution chart

Coupons

DateDiscountStatus
9/27/2019100% OFF
expired
11/17/2019100% OFF
expired
1/13/2020100% OFF
expired
2/21/2020100% OFF
expired
3/4/2020100% OFF
expired
3/16/2020100% OFF
expired
4/28/2020100% OFF
expired
5/22/2020100% OFF
expired
5/26/2020100% OFF
expired
6/5/2020100% OFF
expired
6/23/2020100% OFF
expired
6/28/2020100% OFF
expired
7/14/2020100% OFF
expired
7/22/2020100% OFF
expired
7/25/2020100% OFF
expired
8/19/2020100% OFF
expired
9/11/2020100% OFF
expired
9/27/2020100% OFF
expired
9/29/2020100% OFF
expired
10/16/2020100% OFF
expired
10/26/2020100% OFF
expired
10/30/2020100% OFF
expired
11/28/2020100% OFF
expired
12/25/2020100% OFF
expired
1/22/2021100% OFF
expired
1/27/2021100% OFF
expired
1/29/2021100% OFF
expired
2/19/2021100% OFF
expired
2/25/2021100% OFF
expired
3/19/2021100% OFF
expired
3/22/2021100% OFF
expired
4/8/2021100% OFF
expired
4/23/2021100% OFF
expired
5/10/2021100% OFF
expired
5/28/2021100% OFF
expired
6/19/2021100% OFF
expired
6/30/2021100% OFF
expired
7/11/2021100% OFF
expired
7/20/2021100% OFF
expired
8/2/2021100% OFF
expired
8/21/2021100% OFF
expired
9/2/2021100% OFF
expired
9/28/2021100% OFF
expired
9/30/2021100% OFF
expired
10/10/2021100% OFF
expired

Related Topics

2337814
udemy ID
4/25/2019
course created date
4/27/2019
course indexed date
Bot
course submited by
TwitterTelegramTelegram