Skip to content

Latest commit

 

History

History
executable file
·
89 lines (75 loc) · 4.1 KB

README.md

File metadata and controls

executable file
·
89 lines (75 loc) · 4.1 KB

Introduction to Databases


Syllabus

Entity-Relationship Models and Diagrams. Entity Types and Attributes. Relationships. Relational Databases. Keys, Integrity. Relational Algebra. Formal Query Languages. SQL. Programmatic Databases Access. NoSQL Databases. RDF Triplestores. API Access

Detailed Program:

Day Topic Activities
Class 1 Introduction, Syllabus, Evaluation, Integrated Development Environment Users creation
Class 2 Basic Concepts, Representation. Abstraction. Structured and Unstructured Data
Class 3 Types and Architecture of Databases. Relational and non-Relational Databases
Class 4 Data Modeling: Diagrams, Relations, Schemas, Restrictions. Data Modeling Tools Data Modeling Exercises
Class 5 Data Modeling: Table Normalization Data Modeling Exercises
Class 6 Data Modeling: Conceptual, Logical, Physical Data Modeling Exercises
Class 7 SQL language: Standards, implementations, Relational Algebra
Class 8 Introduction to RDBMS MySQL Hands On MySQL CLI
Class 9 SQL language SQL practice
Class 10 SQL language SQL practice
Class 11 SQL language SQL practice
Class 12 SQL language Regular Expressions
Class 13 SQL language SQL practice
Class 14 SQL language SQL practice
--- Evaluation ---
Class 15 Programmatic access to Databases Python programming
Class 16 Programmatic access to Databases Python programming
Class 17 Programmatic access to Databases Python programming
Class 18 Programmatic access to Databases Python programming - SQLite
Class 19 Programmatic access to Databases Python programming - SQLite
Class 20 Introduction to RDBMS Postgres Hands On Postgres CLI
Class 21 Programmatic access to Databases Python programming - Postgres
Class 22 Programmatic access to Databases Python programming - Interface with Pandas
Class 23 Programmatic access to Databases Python programming - Interface with Pandas
Class 24 Programmatic access to Databases Python programming - Interface with Pandas
Class 25 Programmatic access to Databases Python programming - Interface with Pandas
Class 26 Cloud Databases - DoltHub
Class 27 Cloud Databases - DoltHub
Class 28 NoSQL Databases
Class 29 NoSQL Databases MongoDB practice
Class 30 NoSQL Databases MongoDB practice
Class 31 NoSQL Databases Elastic Search
--- Evaluation ---
--- --- ---