Author(s): Chan Jamie
Publisher: Learn Coding Fast, Year: 2018
ISBN: 1731039662
Title: Learn SQL in One Day and Learn It Well. SQL for Beginners with Hands-on Project
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
can\'t find your book? poke me at https://t.me/tradingforall_telegram , buy 2 eBooks and get 1 free, we offer also book collection digital copy selling’s, English, Engineering, etc. just tell us which book series you want.