1 online resource#x1E
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
No coin nor oath required. For personal study only.
โฆ 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
๐ SIMILAR VOLUMES
<b>New Book by Best-Selling Author Jamie Chan. Learn C# Programming Fast with a unique Hands-On Project. Book 3 of the Learn Coding Fast Series.</b><br /><br />Have you always wanted to learn computer programming but are afraid it'll be too difficult for you? Or perhaps you know other programming la
(2nd Edition: Covers Object Oriented Programming) Learn Python Fast and Learn It Well. Master Python Programming with a unique Hands-On Project<br /><br />Have you always wanted to learn computer programming but are afraid it'll be too difficult for you? Or perhaps you know other programming languag
(2nd Edition: Covers Object Oriented Programming) Learn Python Fast and Learn It Well. Master Python Programming with a unique Hands-On Project<br /><br />Have you always wanted to learn computer programming but are afraid it'll be too difficult for you? Or perhaps you know other programming languag
<strong><font face="verdana" color="blue">Master C# Programming with a unique Hands-On Project</font></strong> <br><br> <p>Have you always wanted to learn computer programming but are afraid it'll be too difficult for you? Or perhaps you know other programming languages but are interested in learn