Learn SQL in One Day and Learn It Well. SQL for Beginners with Hands-on Project

✍ Scribed by Chan Jamie

• Publisher: Learn Coding Fast
• Year: 2018
• Tongue: English
• Leaves: 175
• Category: Library

✦ Table of Contents

Chapter 1: Introduction
What is SQL?
Getting Ready to Code
Installing MySQL applications
Launching MySQL Workbench
Writing our first MySQL code
Comments
Chapter 2: Defining the Database
How to Use this Book
Creating the Database
Using the Database
Deleting the Database
Chapter 3: Defining Tables
Creating Tables
Specifying Columns
Specifying Table Constraints
Altering Tables
Table Names
Columns and Table Constraints
Deleting Tables
Chapter 4: Inserting, Updating and Deleting Data
Inserting Data
Updating Data
Deleting Data
Constraints
Chapter 5: Selecting Data Part 1
Basic Select Syntax
Selecting Everything
Filtering Columns
Using Aliases
Filtering Rows
LIMIT
DISTINCT
WHERE clause
Subqueries
Sorting Rows
Chapter 6: Selecting Data Part 2
What is a Function?
MySQL Functions
Aggregate Functions
GROUP BY
HAVING
Chapter 7: Selecting Data Part 3
Joins
Unions
Chapter 8: Views
What is a view?
Creating a View
Altering a View
Deleting a View