PCSY155

DATES:

1. SQL and Relational Database Management Systems
   • Examine the concepts and terminology of a RDMS: Relational Database Management System.
   • Review and expand upon the concepts specific to the environment of the client organizations sending the students for the training.
2. SQL Datatypes
   • Display columns with a variety of datatypes and recognize datatype errors.
   • Code a series of SELECT statements which retrieve data with a variety of datatypes.
   • Perform calculations on a character string column.
   • Display datatype information from the system catalog.
3. Creating and Modifying Database Objects
   • Utilize the procedures required for creating tables, views, and indexes.
   • Create a simple table with an index.
   • Load sample data into the new table.
4. Altering and Destroying Objects
   • Utilize the procedures for altering the properties and columns of a table.
   • Add a new column to the table created previously.
5. Data Manipulation
   • Modify the data into an existing table.
   • Add, update, and delete rows in a table.
   • Handle operations that have been rejected by the database.
6. Transactions and Locks
   • Recognize the consequences of locks and deadly embrace.
   • While running multiple statements, force the system into a deadly embrace.
   • Monitor the locks and ensuing error condition.
7. Retrieving Data
   • Code simple and complex SQL queries.
   • Code SQL which calculates derived columns, uses complex conditions, performs a single join, and performs a subquery.
8. Multi-table Queries
   • Code intermediate and more complex SQL queries.
   • Code SQL that joins multiple tables using multiple types of joins.
   • Code SQL to perform multi-level sub queries from two and three tables.
9. SQL Functions
   • Utilize functions for string and date manipulation.
   • Extract a string from a column, produce a proper name from a string, and translate the values.
   • Determine the number of days between dates and display the date in a variety of formats.
10. SQL Operators
    • Code SQL using a variety of operators.
    • Extract data based on pattern masking.
    • Code several complex conditions including inline tables.
11. Procedural Extensions
    • Recognize how to use stored procedures and pass parameters.
    • Code and invoke a stored procedure without and with arguments.
    • Code and invoke a stored procedure returning a single value.
    • Code and invoke a stored procedure returning a resultset.
12. ANSI Extensions
    • Acquire familiarity with ANSI extensions.

↓