This course will teach students everything they need to know about SQL (Structured Query Language) in order to be fully functional in a relational database environment. Students will learn the syntax for issuing the various select, insert, update and delete statements (including data joins and subqueries). They will also learn how to create and drop the various database objects.

SQL 101 is ideal for report builders, business analysts and technical users with little or zero SQL experience.

Topics covered:

---

1. What is SQL?
2. The Select statement
3. SQL Functions
4. The Where clause
5. The Order By clause
6. The Group By clause
7. Subqueries
8. The Join clause
9. The Insert, Update and Delete statements
10. Commit and Rollback
11. The Union, Intersect and Minus operators
12. Creating, Modifying and Dropping database objects
13. Introduction to Security and Protecting your Data
14. Introduction to the SQL Power Wabit BI Tool