MySQL: A beginner's guide to MySQL

Name: MySQL: A beginner's guide to MySQL
Rating: 4.6 (13 reviews)

MySQL is a complete beginners guide to learning MySQL in plain English.

Created byTrevor Page

Last updated 11/2014

English

What you'll learn

You'll learn how to install a database server on your own computer
You'll learn how to create and manage multiple databases
You'll be able to create, read, update and delete data from your databases
You'll learn how to write advanced queries on your data that can be used in real reports
You will be able to create stored functions and stored procedures
You'll be able to know what kind of database indexes to use depeding on your specific environment

Course content

5 sections • 42 lectures • 9h 45m total length

What is a Database15:29
Rows and Database Keys10:53
Installing your Database System14:31

Relationships10:08
Normalization - Part 111:55
Normalization - Part 214:23
One to Many Relationship10:48
One to One Relationship10:50
Many to Many Relationship11:49
Explore the many-to-many relationship with an author_book join table linking authors and books. Identify parent and child roles and real-world examples such as authors and books.
Database Tools19:15
Database Joins - Part 115:37
learn how to join two database tables using inner and outer joins, including left and right joins, with practical examples using user and address data.
Database Joins - Part 210:08
Database Joins - Part 311:59
Explore when to use inner joins versus outer joins, and master left and right joins with practical syntax and examples, plus how to handle missing address data in users.

Grouping - Part 113:24
Learn to group data by imagining buckets and visualizing categories. Use examples like debit and credit transactions and website traffic by hour to quantify totals and peak times.
Grouping - Part 214:18
Aggregate Functions14:29
Explore aggregate functions and how they operate on grouped data. See how to apply group by to create buckets and calculate max, min, average, sum, and count for each group.
Having Keyword - Part 19:03
learn how to filter by aggregate functions using the having clause after grouping by bank account and transaction type, to identify customers with balances over $80.
Having Keyword - Part 215:35
Ordering7:16
learn how to order data returned by MySQL select queries with order by, using ascending or descending, including multiple columns and placing order by at the end.
Select Into - Part 117:49
Select Into - Part 28:09
Alter Tables19:11
Views17:54
Subqueries - Part 115:33
Subqueries - Part 211:46

Indexes - Part 112:13
Indexes - Part 312:55
Indexes - Part 216:15
Backups - Part 113:55
Backups - Part 216:07
Learn to automate MySQL backups with mysqldump, store backups in safe paths, and schedule daily batch-file backups via task scheduler, then restore from dumps and back up to the cloud.
Stored Procedures and Functions - Part 115:41
Stored Procedures and Functions - Part 218:33
Stored Procedures and Functions - Part 319:59
Stored Procedures and Functions - Part 411:43
How to Read MySQL Documentation16:33

Requirements

You will need to have basic Windows / Mac skills, as installation of software will be required
You will need to install one piece of free software called TOAD for MySQL (We'll show you the exact steps in the course)
Knowledge of programming is a "nice-to-have"

Description

Land Your Dream Programming Job!

Learning about Databases and SQL is a skill that not only benefits Database Administrators, but also programmers too. This course is designed to give programmers a "leg-up" on the competition when it comes to landing a great job in the programming field.

SQL in Plain English

This course is taught by former senior software engineer and teaching expert Trevor Page. His "plain English" teaching style has students around the world jumping for joy as they pick up new and valuable skills with relative ease.

You can learn the mysteries of Databases, how to "talk" to them and what a good Database design looks like. It may seem like voodoo, but with Trevor's help you'll be bragging to all your friends about how you created a relational database with a full spread of tables in third normal form.

Full Walkthroughs (including how to install tools)

Most courses just assume that you will know what tools to use and even how to install them.

Not in this course!Trevor not only teaches you the core course material, but he also takes you step by step through the (sometimes) challenging process of installing a database server on your computer and the tools you’ll need to administer your new databases.

It’s all laid out for you in beautiful HD video and audio!

Security and Automated Backups

One aspect of Databases that always scares newcomers to the SQL party is how to make sure your databases are secure and backed up.

No worries, you’ll learn exactly how to keep your data secure and backed up (automatically) so you’ll always hit the sack with a smile on your face knowing your data is safe!

Who this course is for:

This Databases and SQL course is meant for beginners who have either no prior experience with Databases, or very limited experience. This course isn't meant for those who already have a solid foundation of knowledge in SQL.

MySQL: A beginner's guide to MySQL

What you'll learn

Explore related topics

Course content

Database Basics3 lectures • 41min

The Structured Query Language7 lectures • 1hr 39min

Database Relationships10 lectures • 2hr 7min

Advanced Queries12 lectures • 2hr 44min

Bonus Videos10 lectures • 2hr 34min

Requirements

Description

Who this course is for: