Relational Database

Object & Data Labs
Saratoga, California, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Database Management systems are designed to manage large bodies of information. The management of data involves both the definition of structures for the storage of information and the provision of mechanisms for the manipulation of information. In addition, the database system must provide for the safety of the information stored, despite system crashes or attempts to unauthorized access. If data is to be shared among several users, the system must avoid possible anomalous results.

Database Design is the process of developing data base structures from user requirements for data. It starts with requirements analysis, which identifies user needs for data. It then proceeds by translating these user requirements into first a conceptual, then a physical, data base design. The resulting design must satisfy user needs in terms of completeness, integrity, performance, constraints, and other factors.

In this course you will gain an understanding of both the fundamentals of relational databases and relational database design. It is scheduled to be highly interactive and problems will be solved throughout the class hours. A mini-workshop will be presented in the classroom on the fifth day for the students to get a good understanding of the database design process.

What will you learn

A background on database management
The ANSI-SCHEMA 3 level architecture
Understanding the Entity/Relationship Model
Relational Database Theory
SQL & SQL Queries
File Structures, Indexing and Hashing
Query Processing & Query Optimization
Crash Recovery
Concurrency Control/Transaction Processing
Security and Integrity
Database Planning & Information Engineering
Database Analysis
Logical Design
Conceptual Design
Physical Design
The role of the Database Administrator
...''

Phone:1.866.313.5768

School Address:

Object & Data Labs
20076 Ljepava Drive
Saratoga, CA 95070 USA

Jobs & Resumes: Saratoga
Houses & Roommates: Saratoga

Advanced SQL Techniques for Oracle & SQL Server Analysts
Oracle 11i: System Administration
Oracle Applications 11i: Workflow 2.6
SQL Server Reporting Services
Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database
Delivering Business Intelligence Using Microsoft SQL Server 2005
ETL Solutions Using Microsoft SQL Server 2005 Integration Services
OLAP Solutions Using Microsoft SQL Server 2005 Analysis Services (SSAS)

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.