💾Python & Databases

TO DO

DB Lesson Contents

• Data vs Information

• Information System vs Database

  • Why have a database?

• Transaction States + Updates

  • Maintaining data consistency and integrity

• Database Transaction

• Concurrency in Data Sharing Situation

• Validation vs Verification of Data

• DBMS vs RDBMS

  • DBMS functions + tools

  • DBMS promotes data security

• Schema

  • Three Levels: Conceptual, Logical, Physical

• Data Dictionary (A2.6 - A2.8)

• Relationship within Database

  • One-to-one

  • One-to-many

  • many-to-many

• Redundant Data

• Referential Integrity in a normalized database

  • 1NF

  • 2NF

  • 3NF

  • Characteristics of a normalized database

• ERD Diagram

• Role of a DB administrator

• End Users interacting with a Database

• Different methods of DB recovery

• How does integrated database systems function?

• Real Life uses of databases (stock control, police records, health records, employee data)

• Privacy of Personal Data and responsibility of the holder

  • Governing agencies right to access such data

• Data matching vs Data mining

SQL Course:

• ACID

  • Atomicity

  • Consistency

  • Isolation

  • Durability

• Query vs Update

  • How does a query provide view of a database

    • Query Use

      • Boolean Operators (AND, OR, NOT)

      • Parameter Queries

      • Derived Fields (Making new dynamic columns)

• Database Terms

  • Table

  • Record

  • Field

  • Primary Key

  • Secondary Key

  • Foreign Key

  • Candidate Key

  • Composite Primary Key

  • Inner Join

• Evaluate the appropriateness of the different data types.

• Problem Solving:

  • Generating 3NF database