Курсът е подходящ за хора без начални познания по програмиране.

Програма на курса

  1. Relational Databases – Fundamental Concepts
  • Basic database concepts: RDBMS, tables, relationships, multiplicity, primary keys, foreign keys, E/R diagrams, normalization, constraints, indexes, views, triggers, stored procedures, transactions
  1. Data Modeling with E/R Diagrams
  • Database modeling and entity/relationship diagrams
  • E/R modeling tools
  • Oracle data types
  1. Oracle 11g Database – Introduction
  • Introduction to Oracle Database (Oracle 12 Express Edition) – Installing and Configuring;
  • Oracle Database XE Web Based Administration; Oracle SQL Developer, SQL*Plus
  1. Introduction to SQL – Basics
  • SQL language – introduction
  • SELECT statement
  • Restrictions: WHERE clause
  • Ordering: ORDER BY clause
  • Set operations: UNION / INTERSECT / MINUS
  • Table joins: NATURAL, INNER, OUTER, FULL, CROSS joins
  1. Introduction to SQL – Advanced Topics
  • Aggregate functions, GROUP BY and HAVING
  • Built-in SQL functions
  • DML: INSERT, UPDATE and DELETE statements
  • DDL: CREATE, ALTER, DROP
  • Execution plan and query analysis / optimization
  • Creating and using sequences
  1. Introduction to Oracle PL/SQL
  • Introduction to PL/SQL
  • Stored procedures and functions
  • Packages
  • Cursors
  • Transactions

За записване и/или въпроси, свържете се с нас.