SitePoint
Blog
Forum
Library
Login
Join Premium
Toggle sidebar
Learn SQL (using MySQL) in One Day and Learn It Well
Toggle community discussions
Close
Content
Files
Bookmarks
Preface
Learn SQL (using MySQL) in One Day and Learn It Well
Preface
1
Introduction
What is SQL?
Getting Ready to Code
Writing our first MySQL code
Comments
Defining the Database
How to Use this Book
Creating the Database
Using the Database
Deleting the Database
Defining Tables
Creating Tables
Altering Tables
Deleting Tables
Inserting, Updating and Deleting Data
Updating Data
Deleting Data
Constraints
Selecting Data Part 1
Basic Select Syntax
Selecting Everything
Filtering Columns
Filtering Rows
Sorting Rows
Selecting Data Part 2
What is a Function?
MySQL Functions
Aggregate Functions
Selecting Data Part 3
Joins
Unions
Views
What is a view?
Creating a View
Deleting a View
Triggers
What is a Trigger?
Creating a Trigger
Deleting a Trigger
Variables and Stored Routines
Variables
Stored Routines
Stored Procedures
Stored Functions
Deleting Stored Routines
Control Flow Tools
IF statement
CASE statement
WHILE statement
REPEAT statement
LOOP statement
Cursors
What is a Cursor?
Example
Project
About the Project
Creating the Database
Using the Database
Adding Tables
Inserting Data
Trigger
Stored Function
Testing the Database
Appendix A: Tables for companyHR
Appendix B: Tables for sportsDB
Appendix C: Suggested Solution for Project
sportsDB.sql
test.sql
Open text modal
Community Questions
Close