Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Everything About MySQL Database
Rating: 4.2 out of 5(14 ratings)
118 students

Everything About MySQL Database

A guide to work with MySQL and it's syntax, CRUD, data types, transactions, sub selects, views, and store routines.
Created byEric Azimi
Last updated 10/2015
English

What you'll learn

  • Write MySQL queries
  • Create and updating databases and tables
  • Use MySQL built-in functions
  • Store and filter data
  • Update tables with triggers
  • Work with subselects and views
  • Create and use a stored function

Course content

10 sections • 55 lectures • 6h 14m total length

  • Welcome1:00
  • What is MySQL2:28
  • Using The Files3:27
  • Installation Information3:01
  • Setup a Package Manager10:32
  • Setup Working Environment10:46
  • Changing Time Zone for MySQL5:57

Requirements

  • You do not need to know anything but we need need to have Apache (web server), PHP and MySQL setup before we continue and I will show you what to use
  • You need to know why we need database and why we use them
  • You need to know the terms: row, column, record and table within database

Description

MySQL is by far the most popular database management system for small- to medium-sized web projects. Only the proprietary Oracle database and the small embeddable SQLite are more widely deployed. MySQL is named after the eldest daughter of Ulf Michael Widenius, the main author of the original version of MySQL whose daughter's name is My.

MySQL routines the Structured Query Language also known as SQL to define, update and query the database. SQL is used on fundamentally all major relational database systems, on many platforms and in many applications. I will cover the necessary skills to use and program a database using MySQL. It is the nature of database management systems that there is marvellous divergence between how SQL is implemented in each system. Most of this course is keen on showing you how SQL is implemented by MySQL and how it can be used effectively in your database applications.

In this course, I will provide clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. We will start with the basic syntax of SQL as it's implemented by MySQL. I will explain how to use the select statement, and how to create, update, and delete data from your tables. I'll show you specifically where the MySQL version of SQL differs from the standard, and how to get the most out of MySQL specific dialect.

I also will explore the

  • basic syntax,
  • using SQL statements to
    • Create
    • Insert
    • Update
    • And delete data from your tables
  • I will also cover creating a new database from scratch
  • Data types
  • Transactions
  • Subselects
  • Views
  • And stored routines

Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications.

I will cover creating and deleting databases, data types, transactions, sub selects, views, and stored routines. And finally, I will show you a full working CRUD application. CRUD is an acronym for Create, Read, Update and Delete. MySQL is one of the most widely deployed database management systems in the world. Understanding MySQL will serve you well in your database applications.

Who this course is for:

  • If you are familiar with the terms "database" and know their purpose
  • If you know want to know how SQL specifically MySQL works
  • If you are a little familiar with database relationships and why we need them
  • If you would like to know how MySQL works with your programming language of choice such as PHP

Report abuse