Oracle and SQL

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

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

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

2. Data Modeling with E/R Diagrams

• Database modeling and entity/relationship diagrams
• E/R modeling tools
• Oracle data types

3. Oracle 11g Database – Introduction

• Introduction to Oracle Database (Oracle 11g Express Edition) – Installing and Configuring;
• Oracle Database XE Web Based Administration; Oracle SQL Developer, SQL*Plus

4. 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

5. 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

6. Introduction to Oracle PL/SQL

• Introduction to PL/SQL
• Stored procedures and functions
• Packages
• Cursors
• Transactions

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