by Steve Perry | Released March 2017 | ISBN: 9781491982327

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 have a good understanding of the world's dominant relational database management systems developed by Oracle, Sybase, Microsoft, and IBM. 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 systemsSteve 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". Show and hide more Publisher resources Download Example Code

1. Introduction
   • Welcome To The Course 00:04:40
   • About The Author 00:02:04
2. Creating A Database
   • What Is A Relational Database? 00:08:13
   • What Is MySQL? 00:06:57
   • Installing A Local Implementation Of MySQL 00:06:10
   • Creating And Removing Tables 00:08:17
   • Data Types 00:05:32
   • What Is A Primary Key? 00:05:28
   • Creating Indexes 00:06:08
   • Modifying Table Structures 00:03:22
   • Adding Data To A Table 00:03:05
   • Changing Data In A Table 00:05:47
   • Removing Data From A Table 00:03:24
3. Querying Data From A Database
   • Retrieving Data From A Table 00:02:50
   • Restricting Rows With The Where Clause 00:03:17
   • Using Mathematical And Text Expressions 00:04:45
   • Sorting Results 00:04:28
   • Comparison Operators 00:02:41
   • Logical Operators 00:06:30
   • Dealing With Null Values 00:02:43
   • What Is A Foreign Key? 00:03:55
   • Joins With The Using Clause 00:05:33
   • Joins With The On Clause 00:03:51
4. Using Functions And Summarizing Data
   • Aggregate Functions 00:07:29
   • Single Row Functions 00:09:13
   • Using The Group By Clause 00:03:54
   • Using The Having Clause 00:02:24
5. Advanced Database Queries
   • Many To Many Relationships 00:07:36
   • Join Multiple Tables With The Using Clause 00:05:51
   • Join Multiple Tables With The On Clause 00:03:11
   • Eliminating Duplicate Rows From The Results 00:03:57
   • Using The Like Operator For Pattern Matching 00:04:34
   • Using The In Operator 00:02:08
   • How Subqueries Work 00:04:56
   • Subqueries With The In Operator 00:05:27
   • Creating And Using Views 00:07:44
   • Combining SQL Results 00:03:55
6. Conclusion
   • Legacy SQL Techniques 00:06:38
   • Wrap Up And Thank You 00:03:32
Show and hide more