hgducharme
SQL Basics

Updated a year ago

SQL Basics


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 fork 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