Programming Foundations: Databases

Offered By: LinkedIn Learning

Tags

Databases Courses SQL Courses Relational Databases Courses Normalization Courses Database Programming Courses

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

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. Further Database Topics

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

Conclusion

Next steps

Taught by

Scott Simpson

Related Courses

Statistics for Genomic Data Science
Johns Hopkins University via Coursera Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam Database Systems Concepts and Design
Georgia Institute of Technology via edX Introduction to Data Modeling
Microsoft via edX Введение в базы данных
St. Petersburg State Polytechnic University via Stepik