Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Programming Foundations: Databases

via LinkedIn Learning

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. Querying a Database
  • Indexes, transactions, and stored procedures
  • Access control, compliance, and injection
  • Software options
Conclusion
  • Next steps

Taught by

Scott Simpson

Reviews

4.7 rating, based on 3 Class Central reviews

4.7 rating at LinkedIn Learning based on 4777 ratings

Start your review of Programming Foundations: Databases

  • Profile image for Aryan Singh
    Aryan Singh
    Very nice explanation in an easy and efficient way, with a good platform to study well to gain knowledge as well as certificates and here I am leaving a review for who are confused to learn here don't think just join the class and learn.
  • Pavithra Vinayagamoorthy
    Excellent learning course. For the beginners it will be useful. All the basic details are explained in cleared way so that everyone can understand easily. For students this course will be suggested
  • Adapala Chaitanya Krishna
    a good platform to study good to gain knowledfe as well as certificates and here i am leaving a review for who are confused to learn here.dont think just join the class and learn

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.