SQL in Motion
Ben Brumm
49 exercises
  • June 2017
  • ISBN MNLV201702
  • 3h

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

See it. Do it. Learn it! 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.

Table of Contents detailed table of contents

Introduction to SQL

Introduction

What is a database?

What’s inside a database?

Summary

Our example database

Example Database

What is SQL and what can you do with it?

Our sample database and tables

Summary

Setting Up The Software

Setting up your own SQL database

Setting up MySQL

Installing wamp

Setting up the code editor

Installing MySQL workbench

How to connect to your database

Summary

Viewing Data in the Database

How to view data using the select statement

Selecting all data from a table

Understanding some SQL terminology

Limiting your results with the WHERE keyword

Other comparisons in the WHERE clause

Ordering your results with ORDER BY

How to select from multiple tables using joins

What is an inner join?

What is an outer join?

Summary

Inserting, Updating, and Deleting Data

How to add data to your tables using the INSERT statement

How to update data using the UPDATE statement

How to delete data using the DELETE statement

Summary

Functions

What are functions?

How to use basic string functions to manipulate text

How to use basic number functions to work with numbers

How to use basic date functions to manipulate date values

What are aggregate functions and how you can use them?

What the GROUP BY clause does

GROUP BY with joins

What does the HAVING clause do?

Summary

Creating Modifying and Deleting Tables

How and why to create a table

Modifying a table after it is created

How to modify and rename columns

Deleting a table from your database

Summary

Subqueries

What are subqueries and why would I use them?

Limiting by a single value using single subqueries

Limiting by many values using multiple row subqueries

Summary

Vendors and Conclusion

Differences between each vendor’s SQL

Further resources

About the subject

SQL is required knowledge for developers and administrators. Unlike general-purpose programming languages, SQL is purpose-built for setting up, managing, and retrieving data from databases. By mastering a handful of keywords and some basic concepts, you can confidently tackle the most common database tasks, such as defining data tables, combining multiple data sources, and retrieving specific datasets. SQL is the foundation for big commercial databases like Oracle and Microsoft SQL Server, as well as popular open source databases like MySQL or PostgreSQL.

About the video

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. SQL in Motion is packed with exercises to try out, so you can learn SQL by doing SQL. And 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.

Prerequisites

This course is suitable for any beginner-level software developer or administrator.

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

About the instructor

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.


Buy
liveVideo $59.99

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