Programming Foundations: Databases

Description

In this course, you will learn :

• Discover the role that keys and unique values play in a relational model.
• Learn how to create the best system for storing your data, beginning with the tables and relationships at the heart of your database.
• Learn how to write queries to extract the data you require, as well as how to balance the various demands of storage, access, performance, and security.

Syllabus :

1. Database Foundations

• Relational databases
• Keys and unique values
• Relationships
• ACID and transactions
• Basic SQL

 

2. Tables

• Modeling and planning a database
• Naming tables
• Columns and data types
• Numbers and other types
• Primary and foreign keys

 

3. Relationships

• Creating relationships
• One-to-many relationships
• Many-to-many relationships
• One-to-one relationships
• Relationship rules and referential integrity

 

4. Database Optimization

• Normalization
• First normal form
• Second normal form
• Third normal form
• Denormalization

 

5. Querying a Database

• Creating a database
• Creating tables
• Writing SQL queries
• Narrowing query results
• Sorting results
• Aggregate functions
• Joining tables
• Modifying data

 

6. Querying a Database

• Indexes, transactions, and stored procedures
• Access control, compliance, and injection
• Software options

Show more