Programming Foundations: Databases
This course provides a solid foundation for getting started with database programming. It covers the essentials of databases, providing a consistent, organized structure for storing and retrieving large amounts of data. The course delves into key terminology such as normal forms, ACID and CRUD, referential integrity, transactions, records, and tables. It also explores the role of keys and unique values in a relational model. The course guides you through designing an optimal system to contain your data, starting with the core tables and relationships. It also teaches you how to write queries to extract necessary data and how to balance the different demands of storage, access, performance, and security. Practical examples and clear explanations are provided throughout the course to help you design databases that can meet the needs of your applications, your data, and your users.
Skills for certificate:
Databases
Database Management Systems
Normalisation
Indexing
Relational Databases (SQL)
Discrete
Mathematics
Problem Solving
Critical Thinking
Programming Foundations: Databases
c09365e0dcab16c1136a527b386b4a9d817a925d3ddede71b1f8c92195dce880
Description
This course provides a solid foundation for getting started with database programming. It covers the essentials of databases, providing a consistent, organized structure for storing and retrieving large amounts of data. The course delves into key terminology such as normal forms, ACID and CRUD, referential integrity, transactions, records, and tables. It also explores the role of keys and unique values in a relational model. The course guides you through designing an optimal system to contain your data, starting with the core tables and relationships. It also teaches you how to write queries to extract necessary data and how to balance the different demands of storage, access, performance, and security. Practical examples and clear explanations are provided throughout the course to help you design databases that can meet the needs of your applications, your data, and your users.
Learning Objectives
- Understanding the benefits of databases and structured data
- Exploring the concept of relational databases
- Learning about keys, unique values, and relationships in databases
- Grasping the concept of ACID and transactions
- Getting started with basic SQL
- Planning and modeling a database
- Understanding the naming conventions for tables
- Learning about columns, data types, and keys
- Creating relationships in databases
- Understanding normalization and denormalization
- Creating a database and tables
- Writing SQL queries and narrowing query results
- Sorting results and using aggregate functions
- Joining tables and modifying data
- Understanding indexes, transactions, and stored procedures
- Learning about access control, compliance, and injection
- Exploring software options for database management