by Ben Brumm | Released May 2017 | ISBN: None

"The concepts are covered at a comfortable pace and the methods used to demonstrate those concepts make learning the subject very easy." James Bishop, Web Developer SQL in Motion introduces the SQL database language through high-quality video-based lessons and built-in exercises so you can put what you learn into practice. Almost every technical career requires you to interact with a database at some point. Structured Query Language, or SQL, provides a standard vocabulary for working with the most common databases, including Oracle, Microsoft SQL Server, and others. SQL in Motion guides you through your first steps with SQL, teaching you the basics of setting up a database and retrieving information from it. Using the popular (and FREE!) MySQL database, you'll explore 3 hours of easy-to-follow video lessons. You can rest easy knowing you're in the hands of SQL expert and experienced instructor Ben Brumm. If you've never touched a database before, or you're looking to refresh your SQL skills, SQL in Motion is the perfect place to get moving fast. What you will learn: Setting up your SQL database Understanding SQL terms and keywords Creating, modifying, and deleting tables Making the most of subqueries Essential everyday best practices The vendors of SQL, and their differences This course is suitable for any beginner-level software developer or administrator. Ben Brumm has been working with SQL for over a decade as a database consultant. An expert in Oracle and MySQL, Ben is an accomplished author of various Udemy courses and has obtained the Oracle SQL Expert certification. A good starting point if you need to learn to use SQL quickly. Peter White, Enterprise Architect A great introductory course for those exploring MySQL's implementation of the SQL language. Ruben Leon, Web Developer Show and hide more

1. Introduction to SQL
   • Introduction 00:01:57
   • What is a database? 00:04:13
   • What's inside a database? 00:02:56
   • Summary 00:00:35
2. Our example database
   • Example database 00:01:56
   • What is SQL and what can you do with it? 00:02:25
   • Our sample database and tables 00:01:19
   • Summary 00:00:29
3. Setting Up The Software
   • Setting up your own SQL database 00:03:04
   • Setting up MySQL 00:04:20
   • Installing WAMP 00:03:39
   • Setting up the code editor 00:02:20
   • Installing MySQL workbench 00:01:35
   • How to connect to your database 00:03:04
   • Summary 00:00:33
4. Viewing Data in the Database
   • How to view data using the SELECT statement 00:08:00
   • Selecting all data from a table 00:02:39
   • Understanding some SQL terminology 00:02:47
   • Limiting your results with the WHERE keyword 00:05:13
   • Other comparisons in the WHERE clause 00:03:11
   • Ordering your results with ORDER BY 00:06:59
   • How to select from multiple tables using joins 00:08:09
   • What is an inner join? 00:04:16
   • What is an outer join? 00:07:57
   • Summary 00:02:28
5. Inserting, Updating, and Deleting Data
   • How to add data to your tables using the INSERT statement 00:07:03
   • How to update data using the UPDATE statement 00:03:48
   • How to delete data using the DELETE statement 00:03:08
   • Summary 00:00:52
6. Functions
   • What are functions? 00:06:44
   • How to use basic string functions to manipulate text 00:03:20
   • How to use basic number functions to work with numbers 00:02:36
   • How to use basic date functions to manipulate date values 00:03:19
   • What are aggregate functions and how you can use them? 00:02:32
   • What the GROUP BY clause does 00:03:46
   • GROUP BY with joins 00:03:07
   • What does the HAVING clause do? 00:03:32
   • Summary 00:00:52
7. Creating Modifying and Deleting Tables
   • How and why to create a table 00:09:43
   • Modifying a table after it is created 00:05:31
   • How to modify and rename columns 00:03:17
   • Deleting a table from your database 00:02:58
   • Summary 00:00:45
8. Subqueries
   • What are subqueries and why would I use them? 00:07:12
   • Limiting by a single value using single subqueries 00:04:32
   • Limiting by many values using multiple row subqueries 00:05:36
   • Summary 00:00:54
9. Vendors and Conclusion
   • Differences between each vendor's SQL 00:04:30
   • Further resources 00:04:07
Show and hide more