SQL [Level 1]
SQL [Level 1]
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.
Interested in this topic?
Fill out the form below to receive more information.
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.
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
Tables, rows, and columns
Table relationships and keys
The SELECT statement
Filtering results using the WHERE clause
Sorting results using ORDER BY
Participants should be comfortable with basic computer usage and ideally will have some basic experience working with data in either spreadsheets or databases.