<p>Have you been hearing about data, databases and SQL and wondering what it's all about? Or perhaps you have just gotten a new job and need to learn SQL fast. This book is for you.</p>

Learn SQL (using MySQL) in One Day and Learn It Well

Preface

Welcome to SQL and thank you so much for picking up my book. I sincerely hope that this book can help you master SQL fast and introduce you to the exciting world of databases.

Introduction

Now that we have a basic understand of MySQL, let’s start learning some SQL commands.

Defining the Database

In the previous chapter, we learned to create and use a database. In this chapter, we’ll learn to add tables to our database. We’ll also learn to alter and delete the tables if necessary. This is a relatively long chapter, so take your time to slowly go through it.

Defining Tables

In the previous two chapters, we learned to create, alter and drop our databases and tables. In this chapter, we’ll learn to insert data into our tables. We’ll also learn to update and delete data.

Inserting, Updating and Deleting Data

In this chapter, we’ll learn to select data from our database. This is a relatively large topic, so we’ll be splitting it into three chapters.

Selecting Data Part 1

In the previous chapter, we learned quite a few keywords that we can use to select data from our tables.

Selecting Data Part 2

We’ve covered quite a few data selection concepts in the last two chapters. Those two chapters focused mainly on selecting data from a single table.

Selecting Data Part 3

In the last three chapters, we learned to write some pretty complex SELECT statements to get information from our databases.

Views

In this chapter, we’ll talk about another interesting feature in MySQL - triggers.

Triggers

Congratulations on making it this far! We’ve covered most of the fundamental concepts in SQL.

Variables and Stored Routines

Now that we know how to write basic stored routines, let us move on to a slightly more advanced concept.

Control Flow Tools

Cool! We’ve come to the final chapter before the project.

Cursors

Great! We’ve covered all the fundamental concepts of MySQL. We are now ready to start working on our project. You are strongly encouraged to work through this project to help you gain a stronger grasp of the concepts covered.

Community Questions