Skip to main content

Click on either image to download your desired application

Click on either image to download your desired application

Learn MySQL - For Beginners

 

Learn MySQL - For Beginners

Learn MySQL - For Beginners

Learn to Create Database Driven Web Applications using MySQL

Rating: 4.1 out of 5

4.1  (1,705 ratings)

195,145 students

Created by YouAccel Training

Last updated 07/2019

English


What you'll learn

  1. MySQL Database Administration
  2. PhpMyAdmin Fundamentals
  3. MySQL Security and Root Superuser
  4. Create Tables
  5. Creating Users
  6. Modifying Database Privileges
  7. Modifying & Deleting Tables
  8. Modifying & Deleting Databases
  9. SQL Fundamentals
  10. SQL Statements in PhpMyAdmin
  11. Database Connections
  12. MySQL Import & Export Data
  13. Updating Data in MySQL DB


Course content

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


Requirements

  • Basic knowledge of PHP
  • Basic Computer Skills


Enroll now


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


Instructor: YouAccel Training

6+ Million Enrollments, 70k+ Reviews. Register Today.

YouAccel Training

4.3 Instructor Rating

65,309 Reviews

1,447,823 Students

50 Courses

Labels:

Comments

Post a Comment

Popular posts from this blog

Learn to Host Multiple Domains on one Virtual Server

  Learn to Host Multiple Domains on one Virtual Server Setup and Host Multiple Sites on one Server using Digital Ocean. Setup Virtual Hosts and Secure all Domains with SSL. Rating: 4.4 out of 5 4.4   (573 ratings) 110,491 students Created by YouAccel Training Last updated 8/2018 English What you'll learn Deploy and Configure Virtual Servers Create and attach Floating IP's to Digital Ocean Droplets Install Ubuntu on a Virtual Server Configure Apache, MySQL, PHP and PhpMyAdmin on a Virtual Server Setup a basic, cost effective hosting service for clients Host Multiple websites on a single server Configure Name Servers, DNS Zone Files and Virtual Host files Secure multiple domains on a single server with SSL Certificates Access and test server configurations through a web proxy Modify MySQL Authentication methods Course content 5 sections • 15 lectures • 1h 13m total length Requirements Students will require an internet connection and PC or MAC Computer System. FTP Agent such...
Post a Comment
Read more

Complete Inventory Management in Microsoft Excel &TALLY ERP9

  Complete Inventory Management in Microsoft Excel &TALLY ERP9 Inventory,StockControl,Inventory Control,Microsoft Excel inventory ,Stock Calculation,Inventory Valuation,LIFO,FIFO,WACC Rating: 4.1 out of 5 4.1  (220 ratings) 37,639 students Created by A.M.A.M Mubeen Last updated 5/2021 English What you'll learn What Is Inventory? What Are The Types Of Inventory? What Is Inventory Management? What Are The Objectives For Inventory Management? What Is The Inventory Valuation? What Are The Types Of Inventory Valuation? What Is The First In First Out (FIFO) Inventory Valuation Method? What Is The Last In First Out (LIFO) Inventory Valuation Method? What Is The Weighted Average Cost/Price Inventory Valuation Method? How To Create The Item List Table For Inventory Management In Microsoft Excel? How To Create The Inventory In , Out , Status Table In Microsoft Excel? How To Apply The Formulas For The Inventory In , Out , Status Table In Microsoft Excel? How To Enter The Inventory Tr...
Post a Comment
Read more

Raise your vibrations - by developing self awareness

  Raise your vibrations - by developing self awareness Develop higher self awareness and emotional intelligence Rating: 4.2 out of 5 4.2  (11 ratings) 2,894 students Created by Tara Khanom Last updated 2/2021 English What you'll learn What is the self consist of What does self awareness means How to work out passion, core values and personal strength Better understand the self Benefit of raising awareness level Different brain waves and mental state How to access higher levels of consciousness Developing higher levels of emotional intelligence How do we understand ourselves at a deeper level How calming the minds allows us to access deepest wisdom within us How to strengthen our personal qualities and become unshakeable Requirements Anyone want to engage more with life and live it fully Just an interest in self development Enroll now Description This course is great for anyone who has a burning desire to change their life for the better, who want to embrace their highest self ...
Post a Comment
Read more

Get Traffic for your Website




Contact Form

Name

Email *

Message *

Earn Free CyptoCurrencies from this app

Earn Free CyptoCurrencies from this app
Click on the image to download the app