Course delivered in English
Lessons: 5
Livello: Foundational
Access: Free Online Course (Audit)

This course takes approx 1,5 hours to complete

Course Path

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

1. Describe basic SQL syntax rules along with requirements for the names of tables, and the naming and data type requirements for table columns (fields).
2. Use the SELECT command and FROM clause to control the columns that are displayed and the order in which they display in query output.
3. Limit the rows retrieved by an SQL query by applying the WHERE clause with one or more conditions.
4. Use the ORDER BY clause to modify the sort order of the rows returned from an SQL retrieval query.
5. Code an SQL retrieval query that uses the JOIN command to retrieve data rows from tables that are related via a common column.