SQL: Fundamentals of Querying

During this course, students will connect to a database, query the database, modify the query and then save and execute the saved query. You will search using a simple condition; compare column values, search using multiple conditions, search for a range of values and null values and retrieve data based on patterns. Perform date calculations, calculate other data and manipulate string values. Sort and group data; filter the grouped data and summarize grouped data. Combine results of two queries; retrieve data by joining tables, check for unmatched records, and retrieve information from a table using joins. Customize and save the query result and generate an HTML report.

SQL: Advanced

During this Advanced level the student will s earch based on an unknown value and on multiple unknown values. Compare a value with unknown values. Search based on the existence of records. Generate output using correlated subqueries. Filter grouped data within subqueries. Perform multiple-level subqueries. Insert, modify and delet data. Create a simple table and a table with constraints. Add or drop table columns. Add or drop constraints. Modify the column definition and delete tables. Create a view, manipulate data in views and modify and drop views. Create and drop indexes. Rollback transactions and commit transactions.