Databases A Beginner's GuideEssential Database Skills--Made Easy! Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner's Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you'll discover how to implement logical design using normalization, transform the logical design into a physical database, and handle data and process modeling. You'll also get details on database security, online analytical processing (OLAP), connecting databases to applications, and integrating XML and object content into databases. Designed for Easy Learning
|
Other editions - View all
Common terms and phrases
added allow application attributes called changes Chapter City clause client column complete components concepts connected constraints contains correct answers course create Customer database database design database user DBMS defined delete detail developed diagram displayed document EMPLOYEES entity example exercise exist Figure foreign key function identifier implemented insert invoice join language logical methods Microsoft Access multiple normal form Note NULL Number object operating options Oracle panel particular performance physical placed primary key privileges Product programming provides query RDBMS record relational relational database relationship responses returned rows rules schema SELECT server shown in Figure shows simple specification SQL Server SQL statement standard statement Step stored transaction unique update