Intro to SQL

FREE EVENT
Sorry to reschedule...

Would you like to learn how to use SQL?
Would you like a project to add to your resume?

Join us on May 18th as we explore this database programming language.

Please bring your laptop, and DO THE PRE-EVENT HOMEWORK. (https://ibm.box.com/v/intro-to-sql)

The documents we will be using are here:
https://ibm.box.com/s/qp3d5c5zg8j1zdj7dn8ip5wfyjc3ayd0

https://ibm.box.com/s/fxnbhe16clthnm6htwhi2ssabwqjpzsr

Let's learn about SQL
Here's what we will be covering:

1. CREATE TABLE

2. SELECT STATEMENTS
   a. SELECT * FROM
   b. SELECT c1,c2 FROM
   c. SELECT WHERE
   d. COUNT
   e. LIMIT
   f. ORDER BY ASC, DESC
   g. BETWEEN
   h. IN
   i. LIKE
   j. SELECT DISTINCT FROM
   k. GROUP BY

3. JOIN - OVERVIEW
   a. INNER JOIN
   b. LEFT JOIN
   c. RIGHT JOIN

4. UPDATE TABLE
   a. INSERT INTO – VALUES
   b. INSERT INTO WHERE
   c. UPDATE
   d. DELETE FROM WHERE
   e. TRUNCATE TABLE