Learn Database Systems with Implementation and ExamplesThe main motivation behind writing this book is to teach the basic concepts of database systems through concrete and practical knowledge and examples without too many wordy and useless pages. The book is made deliberately concise and short covering the main aspects of databases that you have to master and gain either for industrial or academic purposes. The main chapters includes within this book are: Introduction to Databases, Database Design, SQL: Structured Query Language, SQL: Structured Query Language, SQL Transactions, Procedures & Triggers, Object Relational Databases, Databases & Java Programming, Solutions & Answers. The book website can be accessed at: http: //www.LearnDB.com |
Contents
Introduction to Databases | 1 |
Database Design | 19 |
Structured Query Language | 39 |
Advanced SQL Queries | 63 |
SQL Transactions | 85 |
Procedures Triggers | 93 |
Object Relational Databases | 111 |
Databases Java Programming | 133 |
Solutions Answers | 141 |
Common terms and phrases
aggregate functions ALTER TABLE application attribute Candidate Key clause clients WHERE name clients_id clients.name column constraint CREATE OR REPLACE CREATE TABLE CREATE TYPE cursor data model data types database design database management system database model database system database table DBMS DBMSs DECLARE DEFAULT defined DELETE DELIMITER E-R Diagram EasyPHP entity example executed Find the number following SQL statement foreign key Hector Garcia-Molina HSQLDB implementation InnoDB INSERT instance int not null integrity invoked isolation level keyword loop MEMBER FUNCTION methods MSQL MySQL nested table number of clients number of countries o_time operator Oracle Oracle database ORDBMS orders.amount FROM clients parameter PhoneBook phpMyAdmin PL/SQL primary key programming language relational database relationship REPLACE TYPE retrieve SELECT clients.clients_id SELECT count SELECT statement shown SQL trigger SQLLite stored procedure String syntax table1 total FROM orders transaction UPDATE account SET VARCHAR variable VARRAY What’s the difference