Women Who Code Cleveland presents: Introduction to SQL

Work in progress: Google Slides

This workshop focuses on composing SQL queries for READING data from a database. This is valuable for those interested in Data Analysis.


the following may be helpful for Mac users

# unzip to convert to tar
unzip -d dvdrental

What will be covered in this workshop?

Why SQL?

SQL or Structured Query Language is a way to access relational data stored in a database. Relational data preceeds SQL, but both started in the 70s, and have dominated the market ever since.

A benefit to using a database and SQL is its persistence feature, meaning any updates or changes made to the database will be consistent among all users (humans, and other creatures).

Data is powerful

Think of your favorite apps.

Think of decision makers, like business owners and project managers.

Think of Researchers.

SQL Notes

We will be answering questsions about the DVD Rental database such as:

SQL can be used to create, read, update, and delete databases AND database permissions, adminstered through ROLES and USERS.

Here are some commands for manipulating databases:

UPDATE - updates data in a database

DELETE - deletes data from a database

INSERT INTO - inserts new data into a database

CREATE DATABASE - creates a new database

ALTER DATABASE - modifies a database

CREATE TABLE - creates a new table

ALTER TABLE - modifies a table

DROP TABLE - deletes a table

CREATE INDEX - creates an index (search key)

DROP INDEX - deletes an index

Jobs in Cleveland Ohio that require SQL

and more:


WWC Data Science Track Events: