Introduction to MySQL

Video description

This course teaches you how to create a stand-alone MySQL database and how to add, change, delete, and query data within that database. You'll develop a basic understanding of relational databases and gain hands-on experience with the typical software tools application developers, business analysts, and database report writers use to create and work with MySQL databases.

When you complete this course, not only will you know how to use MySQL, you'll also …

Introduction to MySQL

Video description

Become familiar with relational databases and the distinctions between SQL and MySQL
Gain hands-on experience creating and querying MySQL databases
Discover how to use functions, create indexes, and summarize data
Understand how to do complex SQL queries and optimize a database's performance
Explore comparison and logical operators, pattern matching, joins, and subqueries
Know how to modify database data using SQL, and how to create and use views
Learn the processes and software used in the world's leading RDMS systems

Steve Perry teaches database design, MySQL, and the web development stack at Palomar College near San Diego. He's worked in IT and software development since 1977, holds a Master's degree in Education with an emphasis on adult education and online training, and is the author of multiple O'Reilly titles, including "Learning SQL For Oracle" and "Dynamic Web Design with PHP and MySQL".

Publisher resources

Download Example Code

Introduction

Welcome To The Course

About The Author

Creating A Database

What Is A Relational Database?

What Is MySQL?

Installing A Local Implementation Of MySQL

Creating And Removing Tables

Data Types

What Is A Primary Key?

Creating Indexes

Modifying Table Structures

Adding Data To A Table

Changing Data In A Table

Removing Data From A Table

Querying Data From A Database

Retrieving Data From A Table

Restricting Rows With The Where Clause

Using Mathematical And Text Expressions

Sorting Results

Comparison Operators

Logical Operators

Dealing With Null Values

What Is A Foreign Key?

Joins With The Using Clause

Joins With The On Clause

Using Functions And Summarizing Data

Aggregate Functions

Single Row Functions

Using The Group By Clause

Using The Having Clause

Advanced Database Queries

Many To Many Relationships

Join Multiple Tables With The Using Clause

Join Multiple Tables With The On Clause

Eliminating Duplicate Rows From The Results

Using The Like Operator For Pattern Matching

Using The In Operator

How Subqueries Work

Subqueries With The In Operator

Creating And Using Views

Combining SQL Results

Conclusion

Legacy SQL Techniques

Wrap Up And Thank You

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.