YoVDO

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

Creating Programmatic SQL Database Objects
Microsoft 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