ORACLE/SQL SERVER

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

Module Covers...

  • Working with Databases: Introduction to SQL, Select, INsert, Update, Delete, Alter, Drop, Dates, Numbers, Conversion, & Transformation, Strings, Table, Views, Grouping & Having, Indexes, Clusters, Sequences, Table-spaces, Oracle Security, Introduction to PL/SQL, Cursors, Procedures, Functions, Packages, Trigers, Exception Handling, Types, Object, Views, Methods, Collectors