17 Aug Database programming with Python
The exam is all choice, and we will have two hours. I want someone who can only be available at that time, and I will provide more information later is needed. If you are familiar with the topic below please bid, and this are the topics that covers this exam. thank you
- Introduction to Databases
1.1 Database basics
1.2 Database systems
1.3 Query languages
1.4 Database design and programming
1.5 MySQL
2. Relational Databases
2.1 Relational model
2.2 Tables, columns, and rows
2.3 Null values
2.4 Primary and foreign keys
2.5 Referential integrity
2.6 Inner and outer joins
2.7 View tables
2.8 Normal form
2.9 Relational algebra
3. Database Design
3.1 Entities, relationships, and attributes
3.2 Discovery
3.3 Cardinality
3.4 Independent and dependent entities
3.5 Supertype and subtype entities
3.6 Implementing entities
3.7 Implementing relationships
3.8 Implementing attributes
3.9 Normalization
4. Structured Query Language
4.1 Introduction to SQL
4.2 Creating and dropping databases
4.3 Creating and dropping tables
4.4 Primary and foreign key constraints
4.5 Column constraints
4.6 Inserting, updating, and deleting rows
4.7 Selecting rows
4.8 Selecting rows: Additional capabilities
4.9 Functions
4.10 Subqueries
6. Transaction Management
6.1 Transactions
6.2 Schedules
6.3 Concurrency
6.4 Recovery
6.5 Transactions with SQL
7. Database Architecture
7.1 MySQL architecture
7.2 Cloud databases
7.3 Distributed databases
7.4 Replicated databases
8. Complex Data Types
8.1 Simple and complex types
8.2 Collection types
8.3 Document types
8.4 Spatial types
8.5 Object types
9. Database Programming
9.1 Programming languages
9.2 Embedded SQL
9.3 Procedural SQL
9.4 Application programming interfaces
9.5 Database programming with Python
