Introduction to Relational Databases and SQL

3 days
A3 - Version:3.3
Description
This course will introduce database concepts and terminology. Main course objective lies in learning to understand a real world data processing problem, describing processes and implementing them into a relational database structures.
Intended audience
Information technology personnel wishing to refresh their databse knowledge and terminology. Programmers working with databases wishing to upgrade their database skills and get an in depth understanding of database features and conventions.
▼Expand All

  • What is a Database?
    • Databases
    • The database engine
    • The user interface
    • The logical model and the physical model of the database

  • Data Modeling
    • "universe of discourse"
    • ENTITY RELATION DIAGRAM (ERD)
    • normalization rules
    • relational model (table model).

  • Converting the ERD to a Table Design
    • ERD to tables
    • ERD to columns
    • Relational Model.

  • The Select Query
    • what is SQL
    • SQL's various groups of statements
    • the SELECT statement

  • Update, Insert, Delete
    • Insert
    • Update
    • Delete

  • Data Definition Language
    • DDL introduction
    • DDL commands in SQL
  • None
  • Understanding the universe of discourse
  • Learning to design an ERD
  • Learning ways of implementing design on a database system
  • Getting familiar with database features
Contact Us
03-6176666
03-6176677 info@sela.co.il

SEND