Everything About MySQL Database

A guide to work with MySQL and it's syntax, CRUD, data types, transactions, sub selects, views, and store routines.
4.7 (3 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.
65 students enrolled
Instructed by Hassan Azimi Development / Databases
$19
$20
5% off
Take This Course
  • Lectures 55
  • Length 6.5 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 10/2015 English

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

What are the 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

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

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: Introduction
Welcome
Preview
01:00
What is MySQL
02:28
Using The Files
03:27
Installation Information
03:01
Setup a Package Manager
10:32
Setup Working Environment
10:46
Changing Time Zone for MySQL
05:57
Section 2: MySQL Syntax
SELECT, Keyword, Expressions and Functions
Preview
05:45
Row Selection
07:15
Column Selection
03:24
ORDER BY ASC and DESC
04:06
WHERE Clause
05:40
LIKE and IN Clauses
04:30
REGEXP and RLIKE
09:56
Using INSERT INTO to Insert Data
03:50
Using UPDATE SET to Update Data
02:56
DELETE and DROP
03:49
Strings
04:55
What is NULL?
05:24
Section 3: Creating Database
CREATE and USE DATABASE
Preview
05:57
Using Tables
09:49
Using Indexes
08:48
Using Constraints
05:17
AUTO_INCREMENT, PRIMARY KEY and SERIAL
09:12
FOREIGN KEY
16:35
ALTER TABLE
06:32
Section 4: Data Types
Data Type Introduction
Preview
05:16
Numeric Types
10:19
String Types
03:31
DATE and TIME Types
06:01
BIT
02:57
BOOLEAN Types
04:57
ENUM and SET
04:56
Section 5: Functions
String Function
10:49
Numeric Functions
12:48
Date and Time Functions
08:21
Time Zone Support
03:33
DTAE_FORMAT Function
05:48
Grouping Functions
09:39
Conditional Function
08:10
Section 6: Transactions
How To Use Transactions?
06:37
Transactions and Performance
04:00
Section 7: Triggers
Using TRIGGER
06:33
Using TRIGGER Preventing Auto Update
09:38
Triggers and Transactions
05:49
Section 8: Views and Subselects
How To Use Subselect and SUBSTR?
10:21
Searching Within a Result Set
09:54
How To Create VIEWs?
08:29
How To Create JOIN VIEW?
06:03
Section 9: Routines
What Are Routines?
02:44
MySQL Functions
08:54
MySQL Procedures
12:36
Section 10: PHP Data Objects
What is PDO?
11:31
PDO and Prepared Statement
05:56
PHP and CRUD Application
07:34

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Hassan Azimi, Software Engineer and Web Developer

Hi My name is Hassan Azimi and I am a software engineer and a web developer. My second job is to produce videos about technology and computers for people all over the world. I have first class degree with Honours one of the top universities in London and I am working towards the best technologies about software, coding and he web. I understand most of the programming languages mainly web based languages. I continuously enjoy learning new technologies exclusively programming languages by watching tutorials instead of reading books and this is not mean I don't read books at all. Subsequently, reading a lot of books about computers and watching more video lectures about programming and web developing, I educated a lot of new subjects and I decided to make the professional tutorials. I am obsessed with everything about computers and fascinated by everything about programming which leads me to build things like a puzzle. By reading books I noticed they do not have that impression, sense and excitement similar to videos. I do not mean they are useless, what I mean is they are far away from fun, practical, excitement and walking through each lesson. I noticed something else and that was lack of video tutorials about computing for Persians and Farsi speaking people and that must be because of low Internet speed and Internet censorship. I found Udemy is not censored in Iran but YouTube is and that was a great news for me, which made my students asking me to find a way to allow them to download my videos. I am sure some people do not learn only by reading as some people do. Most people who computing is their career are practical people rather than people with humanity subjects, one them is myself. I am a practical person, I learn by watching. Therefore, I decided to make video tutorials. Today I am the only best Persian tutorial source for all Persians and the only one who makes really professional tutorials with great video and audio quality. If you watch my tutorials you will notice I really care about every single video tutorials I make and I have so much respect to Udemy academy which I think it is one of the best ideas.

Ready to start learning?
Take This Course