Programming Foundations: Databases
Created By
Scott Simpson via LinkedIn Learning
- 1-2 hours worth of material
- LinkedIn Learning
- English
Course Overview
Learn the fundamentals of database programming. Find out how to build a database, define relationships, and write queries.
Course Circullum
Introduction
- Why use a database?
- What you should know
- Understanding databases: Benefits of spreadsheets
- Understanding databases: Benefits of structured data
- Relational databases
- Keys and unique values
- Relationships
- ACID and transactions
- Basic SQL
- Modeling and planning a database
- Naming tables
- Columns and data types
- Numbers and other types
- Primary and foreign keys
- Creating relationships
- One-to-many relationships
- Many-to-many relationships
- One-to-one relationships
- Relationship rules and referential integrity
- Normalization
- First normal form
- Second normal form
- Third normal form
- Denormalization
- Creating a database
- Creating tables
- Writing SQL queries
- Narrowing query results
- Sorting results
- Aggregate functions
- Joining tables
- Modifying data
- Indexes, transactions, and stored procedures
- Access control, compliance, and injection
- Software options
- Next steps
Item Reviews - 3
Submit Reviews
This Course Include:
Introduction
- Why use a database?
- What you should know
- Understanding databases: Benefits of spreadsheets
- Understanding databases: Benefits of structured data
- Relational databases
- Keys and unique values
- Relationships
- ACID and transactions
- Basic SQL
- Modeling and planning a database
- Naming tables
- Columns and data types
- Numbers and other types
- Primary and foreign keys
- Creating relationships
- One-to-many relationships
- Many-to-many relationships
- One-to-one relationships
- Relationship rules and referential integrity
- Normalization
- First normal form
- Second normal form
- Third normal form
- Denormalization
- Creating a database
- Creating tables
- Writing SQL queries
- Narrowing query results
- Sorting results
- Aggregate functions
- Joining tables
- Modifying data
- Indexes, transactions, and stored procedures
- Access control, compliance, and injection
- Software options
- Next steps
- Provider:LinkedIn Learning
- Certificate:Certificate Available
- Language:English
- Duration:1-2 hours worth of material
- Language CC: