Programming Foundations: Databases
4.0 /5- Offered byLinkedin Learning
Programming Foundations: Databases at Linkedin Learning Overview
Duration | 2 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Programming Foundations: Databases at Linkedin Learning Highlights
- Earn a sharable certificate
- 7 quizzes
- Access on tablet and phone
Programming Foundations: Databases at Linkedin Learning Course details
- This course provides the foundation learner need to get started in database programming
- Explore the terminology: normal forms, ACID and CRUD, referential integrity, transactions, records, and tables
- Learn what role keys and unique values play in a relational model
- Discover how to design the best system to contain learner's data, starting with the tables and relationships at the core of database
Programming Foundations: Databases at Linkedin Learning Curriculum
Introduction
Why use a database?
What you should know
Understanding databases: Benefits of spreadsheets
Understanding databases: Benefits of structured data
Database Foundations
Relational databases
Keys and unique values
Relationships
ACID and transactions
Basic SQL
Tables
Modeling and planning a database
Naming tables
Columns and data types
Numbers and other types
Primary and foreign keys
Relationships
Creating relationships
One-to-many relationships
Many-to-many relationships
One-to-one relationships
Relationship rules and referential integrity
Database Optimization
Normalization
First normal form
Second normal form
Third normal form
Denormalization
Querying a Database
Creating a database
Creating tables
Writing SQL queries
Narrowing query results
Sorting results
Aggregate functions
Joining tables
Modifying data
Further Database Topics
Indexes, transactions, and stored procedures
Access control, compliance, and injection
Software options
Conclusion
Next steps
Programming Foundations: Databases at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?