|
|
RDBMS Concepts and Oracle 8i (PDF 568P)
by
Manonmaniam sundaranar
university
File Type :PDF
Number of Pages :568
Description
This note covers the following topics: rdbms definitions, basic
concepts, data, database, database user, database system, database modeling,
entity relationship model, entity, attributes, relationships, mapping
cardinalities, rdbms concepts, object based data models, oltp, dss, transaction,
large database management control, data concurrency, data consistency, data
integrity, normalization, redundancy and inconsistent dependency, first normal
form, second normal form, third normal form, denormalization, codds rule, data
integrity, keys, client server architecture, clients, servers, types of servers,
multithreaded server architecture, advantages of clientserver computing, front
ends, open clients, odbc support, character based clients, gui based clients,
generation of languages, sql, sql command classification, data types, create
view manipulate data, data integrity, adding constraints, expressions, scalar
functions, aggregate functions, joins tables, sub queries, correlated sub query,
inline query, pseudo columns, privileges, database objects, synonyms, sequences,
understanding database structure, access methodologies, introduction to plsql,
plsql architecture, declares variables, control structures, iteration control,
understanding cursors, types of cursors, cursor variables for using constrained
cursors, exceptions, errors, user defined exceptions, unloaded exceptions,
introduction to subprograms, procedures to parameters, functions of notations,
procedures vs functions, packages, specification, package body, overloading
package, triggers, creating triggers, cascading triggers, mutating and
constraining tables, enabling and disabling triggers, why objects, oops and
object concepts, oracle supported data types, collection types, object views,
member functions, using order method, introduction to dba, open cursor, execute,
oracle dba, java strategies, jdbc, java with sql, java virtual machine, java
stored procedures, java strategies, jdbc, java with sql, java virtual machine,
java stored procedures, introduction to forms, using forms builder, form
wizards, creation of forms, property class, visual attributes, library, alerts,
object libraries, editors, master detail form, creation of master detail form,
triggers, validations, working with lov objects, using multiple canvases, types
of canvas, object groups, parameters, record groups, stacked canvas, tab canvas,
horizontal toolbar canvas, list item, using menu, saving compiling and
attaching, checked enabled menu items, introduction to reports, types of
reports, tabular reports, break report, master detail report, matrix report,
report triggers, introduction to graphics, using graphics builder, creating a
graph|
|
 |
|
|
|
|
|
