SQL in Motion

SQL in Motion

by Benjamin Brumm
Released May 2017
Publisher(s): Manning Publications
ISBN: 10000MNLV201702

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.



About the Technology

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.



What's Inside

  • 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 Reader

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



About the Author

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.



Quotes
The concepts are covered at a comfortable pace and the methods used to demonstrate those concepts make learning the subject very easy.
- James Bishop

A good starting point if you need to learn to use SQL quickly.
- Peter White

A great introductory course for those exploring MySQL's implementation of the SQL language.
- Ruben Leon

Table of contents

  1. Introduction to SQL
    1. Introduction
    2. What is a database?
    3. What's inside a database?
    4. Summary
  2. Our example database
    1. Example database
    2. What is SQL and what can you do with it?
    3. Our sample database and tables
    4. Summary
  3. Setting Up The Software
    1. Setting up your own SQL database
    2. Setting up MySQL
    3. Installing WAMP
    4. Setting up the code editor
    5. Installing MySQL workbench
    6. How to connect to your database
    7. Summary
  4. Viewing Data in the Database
    1. How to view data using the SELECT statement
    2. Selecting all data from a table
    3. Understanding some SQL terminology
    4. Limiting your results with the WHERE keyword
    5. Other comparisons in the WHERE clause
    6. Ordering your results with ORDER BY
    7. How to select from multiple tables using joins
    8. What is an inner join?
    9. What is an outer join?
    10. Summary
  5. Inserting, Updating, and Deleting Data
    1. How to add data to your tables using the INSERT statement
    2. How to update data using the UPDATE statement
    3. How to delete data using the DELETE statement
    4. Summary
  6. Functions
    1. What are functions?
    2. How to use basic string functions to manipulate text
    3. How to use basic number functions to work with numbers
    4. How to use basic date functions to manipulate date values
    5. What are aggregate functions and how you can use them?
    6. What the GROUP BY clause does
    7. GROUP BY with joins
    8. What does the HAVING clause do?
    9. Summary
  7. Creating Modifying and Deleting Tables
    1. How and why to create a table
    2. Modifying a table after it is created
    3. How to modify and rename columns
    4. Deleting a table from your database
    5. Summary
  8. Subqueries
    1. What are subqueries and why would I use them?
    2. Limiting by a single value using single subqueries
    3. Limiting by many values using multiple row subqueries
    4. Summary
  9. Vendors and Conclusion
    1. Differences between each vendor's SQL
    2. Further resources

Product information

  • Title: SQL in Motion
  • Author(s): Benjamin Brumm
  • Release date: May 2017
  • Publisher(s): Manning Publications
  • ISBN: 10000MNLV201702