Programming Foundations: Databases
Offered By: LinkedIn Learning
Course Description
Overview
Learn the fundamentals of database programming. Find out how to build a database, define relationships, and write queries.
Syllabus
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
Taught by
Scott Simpson
Related Courses
Creating Programmatic SQL Database ObjectsMicrosoft via edX Web Programming with Python
Udemy C# Programlama Dili : Temel, Orta, İleri Seviye
Udemy (100+ Saat) Aranan Programcı Olma Kamp Kursu| Python,Java,C#
Udemy Visual C# and ADO.NET Programming
Udemy