Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...

SQL syntax and best practices. ... Inquire about creating tables, adding data, altering table structures and backing up databases to become proficient in database administration.

SQL SELECT statement. The SELECT statement tells the query optimizer what data to return, what tables to look in, what relations to follow, and what order to impose on the returned data.