Learn MySQL - For Beginners

Focused View

YouAccel Training

1:27:57

4 View

1. Introduction to Databases.mp4

02:40

2. Introduction PhpMyAdmin.mp4

02:35

3. PhpMyAdmin Interface Overview.mp4

01:12

4. MySQL Security and Root Superuser.mp4

05:02

5. MySQL Creating a Database and Table.mp4

05:24

6. MySQL Creating a New User.mp4

05:33

7. MySQL Database and Table Specific Privileges.mp4

03:05

8. MySQL Modifying and Deleting a Table.mp4

04:30

9. MySQL Modifying and Deleting a Database.mp4

04:07

10. Introduction to SQL.mp4

01:35

11. SQL Statements in PhpMyAdmin.mp4

04:05

12. Connect to MySQL Database using PHP.mp4

05:02

13. MySQL Database - Import Data.mp4

01:43

14. SQL Select.mp4

02:27

15. SQL Distinct Keyword.mp4

01:45

16. SQL Where Clause.mp4

01:40

17. SQL And Operator.mp4

01:42

18. SQL Or Operator.mp4

01:01

19. SQL Order By.mp4

01:36

20. MySQL Insert Into.mp4

06:29

21. MySQL Get Last ID.mp4

01:27

22. MySQL Insert Multiple Records.mp4

01:44

23. MySQL Prepared Statements.mp4

02:45

24. MySQL Delete Records.mp4

07:49

25. PHP Header Function.mp4

01:17

26. PHP Isset.mp4

02:35

27. MySQL Update Records.mp4

07:07

Description

Learn to Create Database Driven Web Applications using MySQL

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

Who is this 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

What You Need to Know?

Basic knowledge of PHP

Basic Computer Skills

More details

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.
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

User Reviews

Rating

average 0

Total votes0

Focused display

YouAccel was founded in 2015 with the mission to be one of the most interactive e-learning platforms on the web. YouAccel is now a leading provider in online training, serving a global audience of over 2 million passionate learners. This includes 6+ Million enrollments, across 50 best-selling courses. YouAccel offers courses across numerous industries from Programming & IT 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. Taking the experience to a new personalized level, free support is available to all students who register for a course. All courses come with a certificate of completion and no age restrictions apply.YouAccel strongly believes that the future of online learning will be through open community-based initiatives, where everyone’s voice is equally heard. This is exactly what YouAccel strives to achieve – an inclusive environment, where students have control over the direction of course content. YouAccel courses are continuously updated based on feedback from students and engaged community members. YouAccel instructors encourage communication at every step of the learning process. To date, hundreds of contributors around the globe have invested both time and resources, to ensure YouAccel courses meet the highest level of quality. YouAccel instructors are world renowned and many of them have been featured in mainstream publications such as Forbes, Mashable, Entrepreneur, and PBS among others.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.