MySQL, SQL and Stored Procedures from Beginner to Advanced

A beginners' guide to MySQL queries, database design, transactions and stored procedures.
4.4 (201 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.
1,568 students enrolled
Instructed by John Purcell IT & Software / Other
$19
$30
37% off
Take This Course
  • Lectures 136
  • Length 18.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 5/2016 English

Course Description

This course will take you from beginner in SQL and MySQL to an advanced level. Whether you're a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions, user permissions, triggers and stored procedures, this course can help you.

Database skills are highly in demand in the I.T. industry; everything from websites to multiplayer games are likely to make use of some kind of database.

MySQL is a free, industrial-strength relational database, very widely used all over the world. In fact, the MySQL Community Server (which this course covers to an advanced level) is the world's most popular open-source database, used by millions of websites.


Master Advanced MySQL Features, Starting from the Ground Up

In this course you'll begin by learning the basics of creating, querying and adding data to databases using SQL with MySQL. As the course progresses, we'll move on to advanced features, vital for getting the most out of MySQL, including transactions, indexes, isolation levels, views, triggers and stored procedures.

You'll learn how to create powerful and efficient databases using SQL, how to read and create EER diagrams, how to understand and implement table relationships like "many to many" and "one to many", and even how to design databases visually using the free MySQL Workbench client tool.

By the end of the course you'll understand MySQL's powerful features to a greater level than probably most professional software developers, and you'll have an understanding of SQL that will help you get to grips with any relational database. You'll be able to create and query your own databases and use transactions, stored procedures, constraints, indices, views and other features to ensure your database is efficient and secure.

What are the requirements?

  • You will need to download and install the free MySQL Server Community Edition and the free MySQL Workbench

What am I going to get from this course?

  • Create, query and update databases
  • Use triggers, views and stored procedures
  • Understand transactions and database isolation levels.
  • Understand database users and security.

What is the target audience?

  • This course teaches you MySQL from the very beginning.
  • No prior knowledge is required, other than basic knowledge of your computer.
  • By the end of the course you will be able to use MySQL to an advanced level.

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
Introducing MySQL
Preview
07:14
Section 2: Getting Started
Installing MySQL and the Workbench
Preview
06:20
Using the Command Line
Preview
07:10
Creating Tables
Preview
09:30
Multiple Columns, int and Data Types
Preview
04:47
Null Values and Not Null
Preview
08:25
Mysql Storage Engines and Configuration
Preview
13:04
SQL Modes
Preview
13:43
Deleting All the Data in a Table
Preview
04:24
Primary Keys
Preview
08:10
Auto Increment
Preview
05:12
Narrowing Down Select Statements
Preview
05:48
Section 3: Importing and Exporting Data
Exporting and Importing Data
07:06
Exporting Using the Command Line
05:48
Importing Using the Command Line
04:31
Section 4: MySQL Operators
Some Test Data
03:09
Comparison Operators
12:43
Logical Operators
12:47
018 Exclusive Or
07:46
Exercises Part 1
06:19
Solutions Part 1
13:44
Section 5: Update, Order and Limit
Beginning Update Statements
06:18
Order By
04:49
Limiting Results
03:48
Section 6: MySQL Data Types
Mysql Types
03:14
Text Types
13:01
Floating Point Types and Ints
11:30
The Bit Type
06:11
Bool
08:48
Blobs
04:48
Time, Date and Year
11:23
Timestamp and Datetime
08:54
Enumerations
06:45
Brackets and Conditions Revisited
09:47
Exercises 2
05:33
Solutions 2
08:27
Section 7: Aggregate Functions and Grouping
The distinct keyword
06:22
Counting Distinct Values
06:12
Aggregate Functions
05:10
Arithmetic in MySQL
03:51
The Health Survey Dataset
05:54
Group By
09:48
Having- Restricting Groups By Aggregate Functions
07:00
Exercises 3
07:57
Solutions 3
08:18
Section 8: Foreign Keys and Multiple Tables
Naming Columns and Tables
06:13
Foreign Keys
11:57
ER Diagrams
08:17
Joins and Cartesian Products
10:20
Inner Joins
05:47
Left and Right Outer Joins
07:49
Joins on Multiple Tables
05:38
Querying Chains of Tables
04:39
One to Many and One to One
04:48
Many to Many
13:26
Joining Tables to Themselves
13:21
Restrict Foreign Keys
12:03
Cascade Foreign Keys
14:17
Exercises 4
05:02
Solutions 4
12:05
Section 9: Combining Queries
Union and Union All
10:00
Subqueries with "in"
07:00
Inline Views
08:00
Section 10: Altering Schemas
Adding Columns
04:33
Adding Foreign Keys
08:22
Adding Indexes
05:38
Indexes on Multiple Columns
04:12
Section 11: Users and Privileges
Creating Users
08:35
Granting Privileges
09:19
Section 12: Views
Creating a Simple View
08:13
View Algorithms
11:00
With Check Option
07:14
Section 13: Locks and Transactions
Exclusive Table Locks
10:02
Shared Table Locks
04:32
Using Variables
06:38
Setting Variables with Selects
03:34
A Select-Update Example
09:29
Fixing Select-Updates with Table Locks
06:43
ACID
05:32
A Simple Transaction
11:08
Start Transaction
04:33
InnoDB Row Locking and Isolation
06:59
ACID Isolation Levels
09:40
Serializable and Row vs Table Locking
12:11
Demonstrating the Other Isolation Levels
09:53
Rolling Back to Savepoints
07:58
The Account Transfer Problem
08:37

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

John Purcell, Software Development Trainer

After working as a software developer and contractor for over 14 years for a whole bunch of companies including CSC, Proquest, SPSS and AT&T in the UK and Netherlands, I decided to work full-time as a private software trainer. I now live in the beautiful city of Budapest, Hungary, from where I run the website Cave of Programming.

Ready to start learning?
Take This Course