SQL [Level 1]

SQL level 1.png
SQL level 1.png

SQL [Level 1]

545.00

[3 Evening Sessions] Organizations are increasingly finding that their data is becoming an immensely valuable asset. Often, this data is stored in some form of relational database management system (e.g. Oracle, SQL Server, PostgreSQL, etc). However, the data is only valuable if it can be retrieved and manipulated in a way that provides insight. The Structured Query Language (SQL) is the tool that allows users to query and make sense of data stored in a relational database. This course in an introduction to relational databases and how to query data using SQL.

Register by July 30th for early bird pricing of $495. Discount applied at checkout.

Session:
Add to Cart

Prerequisites

  • Participants should be comfortable with basic computer usage and ideally will have some basic experience working with data in either spreadsheets or databases.

Audience

The intended audience of this course is anyone that wants to be able to query data stored in a relational database. The ability to use and understand SQL is a highly-transferable skill that can be invaluable for a variety of technical and non-technical roles from technical support and software testers to business analysts and researchers.

Duration

3 Days (6 - 8p)

CLE: Tues 8/28 - Thurs 8/30

Tech Elevator, 7100 Euclid Ave.

CBUS: Tues 8/28 - Thurs 8/30

Tech Elevator at Rev1 Ventures, 1275 Kinnear Rd.

Learning Objectives

By the end of the course, participants will be able to:

  • Understand how data is stored in relational databases using tables, roles, and columns
  • Understand how data in multiple tables can be related and describe the usages and difference between primary and foreign keys
  • Use a basic SQL SELECT statement to retrieve data from a table
  • Filter data retrieved in a query using a WHERE clause
  • Sort the results of a query using ORDER BY
  • Perform basic transformations on data using functions

Course Topics

  • Relational Databases
  • Tables, rows, and columns
  • Datatypes
  • Table relationships and keys
  • Constraints
  • The SELECT statement
  • Filtering results using the WHERE clause
  • Sorting results using ORDER BY
  • Functions
  • Subqueries