To provide the knowledge and skills required to formulate queries and to update a database using the SQL language.
Developers (other than supervisors), Web specialists and those working in networking positions (other than security).
Knowledge of conceptual data modeling (Course BD101).
- Databases and SQL
- Data definition
- Creating and modifying objects: CREATE, ALTER and DROP
- Updating data: INSERT, UPDATE and DELETE
- Transactions and procedural SQL
- Querying data with the SELECT command
- Inner joins and outer joins
- Self joins: joining a table with itself
- Nested queries
- Sorting results: ORDER BY
- Aggregation functions: COUNT, MIN, MAX and AVG
- Grouping with GROUP BY and HAVING
- Set operations: union, intersection and difference
- Data manipulation functions
- Transactions: COMMIT and ROLLBACK
- Controlling access to data: GRANT, REVOKE and DENY