MySQL PHP Database Essentials add a Database to your site

Learn the fundamentals of MySQL databases and phpMyAdmin and how to connect database to your PHP code
4.4 (21 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
6,479 students enrolled
$19
$75
75% off
Take This Course
  • Lectures 33
  • Length 2 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

Learning MySQL and phpmyadmin

NEW course December 2015!

MySQL Database Tutorial for beginners to help better understand PHP connections. Learn how to interact with PHP code to connect to Databases.

  • Create a database with both phpmyadmin and PHP code.
  • Object oriented connections MySQLi and MySQL.
  • How to create a database MySQL
  • How to drop MySQL databases
  • Different MySQL data types
  • How to insert connect to MySQL using PHP
  • Output Database content into PHP and web code.
  • Selectors wildcards and custom selection options.
  • JOIN tables
  • GROUP tables
  • Avoid SQL injections

Create update insert and delete database content.

MySQL is the most popular relational database used across the internet today. We show you how to setup and use a database for your website.

Perfect for anyone who wants to understand how to use MYSQL

This course is designed to be easy to follow along, its encouraged to practice the code being presented through out the course. Resources, source code, and everything you need to learn to try MYSQL code is provided.

This step by step course shows you the code you need to know. Learn about mysql databases and its core concepts and much more.....

We walk you through step by step with detailed explanations of code and more.

  • quick lessons get right to the point
  • fully covered topics with real world examples
  • source files downloadable to work along
  • challenges and lessons and code samples
  • code snippets
  • Links to top resources to save time
  • 30 day money back guarantee
  • new course material added regularly
  • trusted name in education since 2002
  • full HD easy to read source coding
  • quick response support to students
  • regular discussions

Everything you need to know is included in this course. Learn at your own pace, lifetime access to this course. Regualr updates and more.

What are the requirements?

  • computer
  • database access server access
  • basic PHP understanding
  • desire to learn

What am I going to get from this course?

  • learn to apply MySQL database to your web applications
  • PHP and MySQL interacting together
  • create update insert and delete database content
  • setup databases
  • create tables and databases

What is the target audience?

  • Learn how to apply MySQL to a website
  • use MySQL as a database solution
  • basic programming skills to interact with databases

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Learning MYSQL
MySQL course introduction
Preview
03:54
MySQL cpanel course resources introduction
03:30
MySQL options
04:18
mySQL Course Resources
5 pages
MySQL PHPmyadmin create a table
06:35
MYSQL connect to database
10:10
MYSQL connect Object Oriented Method
02:52
MYSQL Source
1 page
MYSQL create a database with PHP
03:46
MYSQL DROP database
03:10
MYSQL Source 2
1 page
MYSQL Create Table Datatypes
06:56
MYSQL Source 3
1 page
mySQL DataTypes
2 pages
MYSQl Object vs Procedural Connections
09:33
Section 2: MYSQL Database interaction
MySQL Insert Data
Preview
07:07
Source Code for Previous Lecture
1 page
MySQL Fetch Array Select
04:23
MYSQL Source 4
1 page
MySQL Insert array list data
06:27
MySQL selectors wildcards and LIKE
04:04
MYSQL Source 5
1 page
MySQL Sort order
02:59
MySQL joining tables
06:43
MYSQL Source 8
1 page
MySQL DELETE records
02:36
MySQL UPDATE table
02:47
MySQL GROUPING rows
03:55
MYSQL Source 6
1 page
MySQL COUNTING ROWs
04:17
MYSQL Source 7
1 page
MySQL clean avoid sql injections
02:36
MySQL Source 9
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Laurence Svekis, Instructor, 18+yrs Web Experience

I'm here to help you learnachieve your dreams, come join me on this amazing adventure today

Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.

"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998.  I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."

"Learning, understanding with a strong passion for education.  The internet has provided us with new opportunities to expand and share knowledge."

Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online.  Technology connects us all in many ways.  It opens up doors to those who embrace it and learn how to make those connections real.

"My courses are designed to help you achieve your goals, learn and update skills"

Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications.  Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO

"Understanding technology provides a means to better connect with users.  It also opens so many doors.   Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"

Ready to start learning?
Take This Course