Free Udemy Courses
Trending

Learn MySQL – For Beginners

PUBLISHER :- YouAccel Training

LANGUAGE :- English

PRIZE :- 86.84$ 0$

Learn MySQL – For Beginners

WHO CAN ACCESS THIS COURSE :-

  • 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 ARE YOUR REQUIREMENTS FOR THIS COURSE ?

  • Basic knowledge of PHP
  • Basic Computer Skills

WHAT YOU ARE GOING TO LEARN FROM THIS COURSE ?

  • 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

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 CONTENT

  • 1 section • 27 lectures • 1h 27m total length

MySQL Database Integration27 lectures • 1hr 28min

  • Introduction to DatabasesPreview02:40
  • Introduction PhpMyAdminPreview02:35
  • PhpMyAdmin Interface Overview01:12
  • MySQL Security and Root Superuser05:02
  • MySQL Creating a Database and Table05:24
  • MySQL Creating a New User05:33
  • MySQL Database and Table Specific Privileges03:05
  • MySQL Modifying and Deleting a TablePreview04:30
  • MySQL Modifying and Deleting a Database04:07
  • Introduction to SQL01:35
  • SQL Statements in PhpMyAdmin04:05
  • Connect to MySQL Database using PHP05:02
  • MySQL Database – Import Data01:43
  • SQL Select02:27
  • SQL Distinct Keyword01:45
  • SQL Where Clause01:40
  • SQL And Operator01:42
  • SQL Or Operator01:01
  • SQL Order By01:36
  • MySQL Insert Into06:29
  • MySQL Get Last ID01:27
  • MySQL Insert Multiple RecordsPreview01:44
  • MySQL Prepared Statements02:45
  • MySQL Delete Records07:49
  • PHP Header Function01:17
  • PHP Isset02:35
  • MySQL Update Records07:07

HOW TO MAKE MONEY ONLINE & TIPS AND TRICKS

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Close
Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker