on-demand course

SQL in Motion

with Benjamin Brumm

May 2017

Intermediate

2h 59m

English

Manning Publications

Closed Captioning available in English

Watch now

Unlock full access

Includes

Earns Badge

Course outline

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

Content preview from SQL in Motion

Deleting a table from your database

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

SQL Hacks

Andrew Cumming, Gordon Russell

SQL: Beyond the Basics

Guy Vaccaro

SQL in a Nutshell, 3rd Edition

Kevin Kline

Selecting Data from Multiple Tables

John Deardurff

Publisher Resources

ISBN: 10000MNLV201702Other Supplemental Content Publisher Website Purchase Link

SQL in Motion

with Benjamin Brumm

Introduction to SQL

Our example database

Setting Up The Software

Viewing Data in the Database

Inserting, Updating, and Deleting Data

Functions

Creating Modifying and Deleting Tables

Subqueries

Vendors and Conclusion

Content preview from SQL in Motion

Deleting a table from your database

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

SQL Hacks

SQL: Beyond the Basics

SQL in a Nutshell, 3rd Edition

Selecting Data from Multiple Tables

Publisher Resources

Introduction to SQL

Our example database

Setting Up The Software

Viewing Data in the Database

Inserting, Updating, and Deleting Data

Functions

Creating Modifying and Deleting Tables

Subqueries

Vendors and Conclusion

Content preview from SQL in Motion

Deleting a table from your database

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

SQL Hacks

SQL: Beyond the Basics

SQL in a Nutshell, 3rd Edition

Selecting Data from Multiple Tables

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.