Phu Xuan University Library
|
PXU E-LIB
Sign in
Introduction to Database Systems

External

Introduction to Database Systems

Engineering
Publisher
LibreTexts
Source
LibreTexts
Language
EN
Category
Information Technology
Read online Download PDF (open licence)
Contents· 118 sections
  1. 01: Introduction to Database Systems and SQL
  2. 1.01: Introduction and Background
  3. 1.02: Limitations of Conventional File Processing
  4. 1.03: Data Redundancy
  5. 1.04: Data Accuracy
  6. 1.05: Data Security
  7. 1.06: Advantages of Databases
  8. 1.07: Costs and Risks of Database Approach
  9. 1.08: Components of a Database Environment
  10. 1.09: Database Systems Development Life Cycle
  11. 1.10: Single-User and Multi-user Database Applications
  12. 1.11: Concise Summary
  13. 1.12: Extended Resources
  14. 1.13: References
  15. 02: Data Modelling
  16. 2.01: What is a Database Model
  17. 2.02: Data Abstraction
  18. 2.03: Data Abstraction Layer
  19. 2.04: Schemas
  20. 2.05: Database Classification Types
  21. 03: The Relational Data Model
  22. 3.01: Relational Model Explained
  23. 3.02: Entities
  24. 3.03: Attributes
  25. 3.04: Keys
  26. 3.05: Nulls
  27. 3.06: Relationships
  28. 04: Integrity Rules Constraints and Functional Dependencies
  29. 4.01: Constraints and Intergrity
  30. 4.02: Business Rules
  31. 4.03: Relationship Types
  32. 4.04: Functional Dependencies
  33. 05: ER Modeling
  34. 5.01: Relationships
  35. 06: Relationship Diagram for Data Analysis-ER and SQL
  36. 6.01: Introduction and Background
  37. 6.02: Understanding the Importance of Data Modeling
  38. 6.03: Naming and Definitions
  39. 6.04: Modeling
  40. 6.05: Business Intelligence Systems and Data Warehouse
  41. 6.06: Introduction to Structure Query Language (SQL)
  42. 6.07: Submitting SQL Statement to the DBMS
  43. 6.08: Concise Summary
  44. 6.09: Extended Resources
  45. 6.10: References
  46. 07: Mapping ER to Schema Normalization
  47. 7.01: Introduction and Background
  48. 7.02: List five properties of relations
  49. 7.03: Define first (1NF) second (2NF) and third normal (3NF) form
  50. 7.04: State Two Properties of Candidate Keys
  51. 7.05: Concise Summary
  52. 7.06: Extended Resources
  53. 7.07: References
  54. 08: SQL and ER
  55. 8.01: Introduction and Background
  56. 8.02: Define a Database Using SQL Data Definition Language
  57. 8.03: Write a single table query in SQL
  58. 8.04: Establish referential integrity using SQL
  59. 8.05: Concise Summary
  60. 8.06: Extended Resources
  61. 8.07: References
  62. 09: SQL - Structured Query Language
  63. 9.01: What is SQL
  64. 9.02: CREATE a Database
  65. 9.03: Optional Column Constraints
  66. 9.04: Table Constraints
  67. 9.05: Few Final Tidbits
  68. 10: SQL Data Manipulation Language
  69. 10.01: Introduction
  70. 10.02: SELECT Statement
  71. 10.2.01: SELECT with WHERE criteria
  72. 10.2.02: Wildcard in LIKE clause
  73. 10.2.03: SELECT statement with ORDER BY clause
  74. 10.2.04: SELECT statement with GROUP BY clause
  75. 10.2.05: Restricting rows with HAVING
  76. 10.03: INSERT statement
  77. 10.3.01: Specific INSERT Examples
  78. 10.04: DELETE Statement
  79. 10.05: UPDATE statement
  80. 10.06: DELETE Statement
  81. 10.07: Built-in Functions
  82. 10.7.01: Aggregate functions
  83. 10.7.02: Conversion function
  84. 10.7.03: Date function
  85. 10.7.04: Mathematical Functions
  86. 10.7.05: Joining Tables
  87. 11: Client Server Architecture
  88. 11.01: Introduction and Background to Client Server Systems and Multi-tier Architecture
  89. 11.02: Three Components of Client Server Systems
  90. 11.03: Two-tier and Three-tier Architectural Distinctions
  91. 11.04: Connecting to databases in three-tier applications
  92. 11.05: Concise Summary
  93. 11.06: Extended Resources
  94. 11.07: References
  95. 12: Physical Database Design and Database Security
  96. 12.01: Introduction
  97. 12.02: Background
  98. 12.03: Physical DB Design Process
  99. 12.04: Data Partitioning
  100. 12.05: Describe Three Types of File Organization
  101. 12.06: Translate a Database Model into Efficient Structures
  102. 12.6.01: Designing a Database for Optimal Query Performance
  103. 12.07: Concise Summary
  104. 12.08: Extended Resources
  105. 12.09: References
  106. 13: Data Warehouse
  107. 13.01: Introduction and Background
  108. 13.02: Concise Summary
  109. 13.03: Extended Resources
  110. 13.04: References
  111. 14: Virtual Desktop and Implementing SQL Queries
  112. 14.01: Introduction and Background
  113. 14.02: Connect to a virtual desktop
  114. 14.03: Constructing a Database
  115. 14.04: Implementing SQL Queries
  116. 14.05: Concise Summary
  117. 14.06: Extended Resources
  118. 14.07: References