Managers, superintendents, supervisors and officers in the Application designers and developers, database administrators and operators
Goals
Explain the difference between SQL, PL/SQL and SQL PLUS.
Write basic SQL queries to retrieve desired data.
Use DML statements (insert, update, and delete).
Use DDL statements (create, alter, and drop).
Use transaction control statements to commit, rollback, and create save points.
Write advanced queries.
Write scripts to do queries and display SQL*PLUS reports.
Control access to your database objects.
Write a PL/SQL block using all elements of block structure.
Write PL/SQL statements using lexical units, declared variables, and assignment statements.
Use control structures to loop, branch, and jump.
Use PL/SQL named exceptions and user-defined exceptions.
Use explicit cursors
Change Account Password
Email Invalid
Please check your inbox for a verification code
Please fill out this field
* Passwords don't match
* Password must be at least 8 characters long * Password must contain at least one lowercase letter * Password must contain at least one uppercase letter * Password must contain at least one digit