Structured Query Language (SQL) Level 1

Gain hands-on practice using a standard structured query language (SQL).

• Use the WHERE clause in a SELECT statement to retrieve filtered data from a relational database 
• Apply aggregate, date and string functions to data retrieved from a relational database 
• Use the ORDER BY, GROUP BY and HAVING clauses to retrieve data from a relational database 
• Use a self-join operation to retrieve data from a single data source or a variety of operators, or subqueries to retrieve data from multiple data sources 
• Use the INSERT, UPDATE, DELETE and TRUNCATE commands to manipulate data in a table 
• Revise a relational database by creating, altering and dropping tables and views