SQL in Motion

SQL in Motion

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 2h 59m | 605 MB

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
Table of Contents

01 Introduction
02 What is a database
03 What’s inside a database
04 Summary
05 Example database
06 What is SQL and what can you do with it
07 Our sample database and tables
08 Summary
09 Setting up your own SQL database
10 Setting up MySQL
11 Installing WAMP
12 Setting up the code editor
13 Installing MySQL workbench
14 How to connect to your database
15 Summary
16 How to view data using the SELECT statement
17 Selecting all data from a table
18 Understanding some SQL terminology
19 Limiting your results with the WHERE keyword
20 Other comparisons in the WHERE clause
21 Ordering your results with ORDER BY
22 How to select from multiple tables using joins
23 What is an inner join
24 What is an outer join
25 Summary
26 How to add data to your tables using the INSERT statement
27 How to update data using the UPDATE statement
28 How to delete data using the DELETE statement
29 Summary
30 What are functions
31 How to use basic string functions to manipulate text
32 How to use basic number functions to work with numbers
33 How to use basic date functions to manipulate date values
34 What are aggregate functions and how you can use them
35 What the GROUP BY clause does
36 GROUP BY with joins
37 What does the HAVING clause do
38 Summary
39 How and why to create a table
40 Modifying a table after it is created
41 How to modify and rename columns
42 Deleting a table from your database
43 Summary
44 What are subqueries and why would I use them
45 Limiting by a single value using single subqueries
46 Limiting by many values using multiple row subqueries
47 Summary
48 Differences between each vendor’s SQL
49 Further resources