Nguồn ngoài

Introduction to Database Systems

Engineering

Nhà xuất bản: LibreTexts
Nguồn: LibreTexts
Ngôn ngữ: EN
Danh mục: Công nghệ thông tin

Đọc trực tuyến Tải PDF (nguồn mở)

Mục lục· 118 mục

01: Introduction to Database Systems and SQL
1.01: Introduction and Background
1.02: Limitations of Conventional File Processing
1.03: Data Redundancy
1.04: Data Accuracy
1.05: Data Security
1.06: Advantages of Databases
1.07: Costs and Risks of Database Approach
1.08: Components of a Database Environment
1.09: Database Systems Development Life Cycle
1.10: Single-User and Multi-user Database Applications
1.11: Concise Summary
1.12: Extended Resources
1.13: References
02: Data Modelling
2.01: What is a Database Model
2.02: Data Abstraction
2.03: Data Abstraction Layer
2.04: Schemas
2.05: Database Classification Types
03: The Relational Data Model
3.01: Relational Model Explained
3.02: Entities
3.03: Attributes
3.04: Keys
3.05: Nulls
3.06: Relationships
04: Integrity Rules Constraints and Functional Dependencies
4.01: Constraints and Intergrity
4.02: Business Rules
4.03: Relationship Types
4.04: Functional Dependencies
05: ER Modeling
5.01: Relationships
06: Relationship Diagram for Data Analysis-ER and SQL
6.01: Introduction and Background
6.02: Understanding the Importance of Data Modeling
6.03: Naming and Definitions
6.04: Modeling
6.05: Business Intelligence Systems and Data Warehouse
6.06: Introduction to Structure Query Language (SQL)
6.07: Submitting SQL Statement to the DBMS
6.08: Concise Summary
6.09: Extended Resources
6.10: References
07: Mapping ER to Schema Normalization
7.01: Introduction and Background
7.02: List five properties of relations
7.03: Define first (1NF) second (2NF) and third normal (3NF) form
7.04: State Two Properties of Candidate Keys
7.05: Concise Summary
7.06: Extended Resources
7.07: References
08: SQL and ER
8.01: Introduction and Background
8.02: Define a Database Using SQL Data Definition Language
8.03: Write a single table query in SQL
8.04: Establish referential integrity using SQL
8.05: Concise Summary
8.06: Extended Resources
8.07: References
09: SQL - Structured Query Language
9.01: What is SQL
9.02: CREATE a Database
9.03: Optional Column Constraints
9.04: Table Constraints
9.05: Few Final Tidbits
10: SQL Data Manipulation Language
10.01: Introduction
10.02: SELECT Statement
10.2.01: SELECT with WHERE criteria
10.2.02: Wildcard in LIKE clause
10.2.03: SELECT statement with ORDER BY clause
10.2.04: SELECT statement with GROUP BY clause
10.2.05: Restricting rows with HAVING
10.03: INSERT statement
10.3.01: Specific INSERT Examples
10.04: DELETE Statement
10.05: UPDATE statement
10.06: DELETE Statement
10.07: Built-in Functions
10.7.01: Aggregate functions
10.7.02: Conversion function
10.7.03: Date function
10.7.04: Mathematical Functions
10.7.05: Joining Tables
11: Client Server Architecture
11.01: Introduction and Background to Client Server Systems and Multi-tier Architecture
11.02: Three Components of Client Server Systems
11.03: Two-tier and Three-tier Architectural Distinctions
11.04: Connecting to databases in three-tier applications
11.05: Concise Summary
11.06: Extended Resources
11.07: References
12: Physical Database Design and Database Security
12.01: Introduction
12.02: Background
12.03: Physical DB Design Process
12.04: Data Partitioning
12.05: Describe Three Types of File Organization
12.06: Translate a Database Model into Efficient Structures
12.6.01: Designing a Database for Optimal Query Performance
12.07: Concise Summary
12.08: Extended Resources
12.09: References
13: Data Warehouse
13.01: Introduction and Background
13.02: Concise Summary
13.03: Extended Resources
13.04: References
14: Virtual Desktop and Implementing SQL Queries
14.01: Introduction and Background
14.02: Connect to a virtual desktop
14.03: Constructing a Database
14.04: Implementing SQL Queries
14.05: Concise Summary
14.06: Extended Resources
14.07: References