Introduction

What This Book is About

This book will cover the basics of SQL, and should help introduce beginners to SQL concepts. It is also a good documentation source when forgetting how the basic SQL syntax works.

Contributing

This book is open source, so please feel free to visit the github repository to help contribute! If you notice any typos or errors in this book, you can clone the repo and open a pull request with the new and improved changes, or simply just open a new issue. Any contribution is greatly appreciated and it will help make this book better for those reading it after you!

License

This book is currently licensed under a Creative Commons license. For more information, read more on the official Creative Commons website.

---

Here is the example database that will be used throughout the book:

Movies

mID	Title	Year	Director
101	Top Gun	1986	Tony Scott
102	Titanic	1997	James Cameron
103	The Lion King	1994	Rob Minkoff
104	Gravity	2013	Alfonso Cuaron
105	Harry Potter	2001	<null>
106	Cast Away	2000	Robert Zemeckis
107	Spider Man	2002	Sam Raimi
108	The Godfather	1972	Francis Coppola

User

uID	Name
201	James Dean
202	Chris Anderson
203	Ashley Burley
204	Ralph Truman
205	Gordon Maximus
206	Sarah Rodgriguez
207	Darrel Sherman
208	Lisa Jackson

Review

uID	mID	Rating	ratingDate
201	101	2	2014-03-09
201	101	4	2014-03-02
202	104	4	<null>
203	107	2	2014-03-24
204	103	4	2014-03-17
204	104	2	2014-03-13
205	108	3	2014-03-24
206	102	3	2014-03-02
207	104	5	<null>
207	106	4	2014-03-07
207	102	5	2014-03-26
208	105	2	2014-03-13