Database Technology
Thomas D. Devine
A brief introduction to the database approach. It compares file-based systems with a DBMS, describes schemas, the DBMS environment and its roles, and weighs the advantages and disadvantages of databases.
Loading the book...
Keep reading
-
Next in this topic
SQL Notes for ProfessionalsA practical SQL reference built from real questions and answers. Covers SELECT, joins, GROUP BY, subqueries, window functions, indexes, transactions, and stored procedures with short, ready to run examples.
Verified PDF · Secure download - Introduction to SQL
An open source guide for beginners. You learn to create tables, insert and update data, filter with WHERE, sort and group results, join tables, and back up a MySQL database.
Verified PDF · Secure download - Structured Query Language
A vendor-neutral course on standard SQL. It starts with the relational model and moves through CREATE TABLE, data types, SELECT, joins, grouping, NULL handling, transactions, and views.
Verified PDF · Secure download - Microsoft SQL Server Notes for Professionals
More than 280 pages of T-SQL tips. Topics include data types, common table expressions, window functions, JSON and XML handling, indexes, stored procedures, triggers, and backup and restore.
Verified PDF · Secure download - Oracle Database Notes for Professionals
A hands-on reference for SQL in Oracle. It covers joins, hierarchical queries, string and date functions, sequences, partitioning, indexes, and the basics of PL/SQL.
Verified PDF · Secure download