The training provides you with the basics of the language and databases. You will not only learn how to use relational databases but also, due to practicing with SQL, how to efficiently process data in databases.

The training is aimed at people who want to learn using databases in SQL language.

1. Introduction to relational databases
   • Database components
   • Database vs Spreadsheet
   • Data storage
   • Database design procedures
   • Database technologies
   • Query language
   • CASE tools
2. Data Storage and extraction
   
   • Database preparation
   • Creating tables
   • Data Input
   • Data visualization
   • Data processing basics
3. Advanced SQL queries
   
   • Data manipulation with SQL
   • Filtering data by text and date
   • Sorting observations
   • Unique values
   • Combining data
   • Removing records
   • Transaction control –  DML, COMMIT
4. SQL*Plus
   
   • Editor– Text editor, EDIT command
   • SQL*PLUS environoment
   • Output formatting- text, numbers, columns
   • SQL scripts- creating, running, parameters
5. Join, Subqueries in Oracle SQL
   • Indexing –B-Tree, Bitmap
   • Table relations– Join, operators
   • Subqueries
6. PL/SQL programs
   • PL/SQL – procedures, trigger functions
   • PL/SQL block design
   • Header, Declaration, Execution and Exception sections
   • PL/SQL procedures design
   • PL/SQL – Variables, constants
   • Conditional execution– IF, loops, Cursors
   • Exception handling – errors, exceptions
7. Data model – ER diagram
   • Data model use
   • Relational integrity – data quality
   • Data model types –Conceptual, logical, physical
   • Entity Relationship Diagram
   • Entity, Attributes, Relationship, Integrity
8. Database design
   • Business specifiactions
   • Entity and attributes, Primary key
   • Data model standards
   • Relationships
9. Normalization
   • Normalization process, determinants
   • First three normal forms
   • Normalization in database model
   • Data Anomalies
   • From logicalto physical model
10. Solving quality problems
    • Choosing data types and missing data management
    • Restricting variables and data tables
    • Resticting primary key, indexes
    • Relationship integrity
11. Additional topics
    • Transfering data between tables
    • Table structure modifications
    • Views