SQL Programming

SQL Programming

Public courses

£1900

- Anyone can join the training
- Course outline as presented on the website
- Small groups, 3-10 people

Private courses

Price set individually

- Training workshop just for your team
- You choose date and location of the training
- Course outline tailored to your needs

About the training

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.

Who is this training for?

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

What will I learn?

  • Create, use and modify tables in database
  • Manipulate data in database
  • Use index and combine data from different tables, subqueries
  • Create procedures, loops and conditional execution with PL/SQL
  • Design database structure
  • Solve data related problems in database
  • Design efficient queries

Course outline

  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

Course Curriculum

Curriculum is empty

Instructors


Send an enquiry

I am interested in


 

Enquire about the private (on-site) training course

I am interested in


 

Enquire about the public training course
 

I am interested in


 
Szybki kontakt