What you'll learn
Identify and use correct syntax when writing SQL retrieval queries.
Learn, practice, and apply job-ready skills in less than 2 hours
Receive training from industry experts
Gain hands-on experience solving real-world job tasks
Build confidence using the latest tools and technologies
About this Guided Project
In this project you will learn to identify and use correct syntax when writing SQL retrieval queries. Through hands-on activities in SQLiteStudio, you will gain experience with the SQL syntax used to display specific columns, filter for specific rows, and determine the sequence of those columns and rows in query output. Familiarity with SQL syntax is a marketable skill for both Information Technology professionals and non-IT super users.
Learn step-by-step
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
•Describe basic SQL syntax rules along with requirements for the names of tables, and the naming and data type requirements for table columns (fields).
•Use the SELECT command and FROM clause to control the columns that are displayed and the order in which they display in query output.
•Limit the rows retrieved by an SQL query by applying the WHERE clause with one or more conditions.
•Use the ORDER BY clause to modify the sort order of the rows returned from an SQL retrieval query.
•Code an SQL retrieval query that uses the JOIN command to retrieve data rows from tables that are related via a common column.