Programming Foundations: Databases

Programming Foundations: Databases
Programming Foundations: Databases
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 25m | 341 MB

Once you get beyond basic programming, you’ll need a database. Databases provide a consistent, organized structure for storing and retrieving large amounts of data. They allow programmers to build more complex applications that can take orders, process payments, make recommendations, authenticate users, and more. This course provides the foundation you 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 your data, starting with the tables and relationships at the core of your database. Find out how to write queries to extract the data you need, and how to juggle the different demands of storage, access, performance, and security. Instructor Scott Simpson provides practical examples and clear explanations that will help you design databases that can withstand the needs of your applications, your data, and your users.

Topics include:

  • Relational databases
  • Keys and unique values
  • Planning a database
  • Creating tables
  • Defining relationships
  • Normalization and denormalization
  • Writing queries
  • Sorting results
  • Joining tables
  • Modifying data
Table of Contents

1 Why use a database
2 What you should know
3 Understanding databases Benefits of spreadsheets
4 Understanding databases Benefits of structured data
5 Relational databases
6 Keys and unique values
7 Relationships
8 ACID and transactions
9 Basic SQL
10 Modeling and planning a database
11 Naming tables
12 Columns and data types
13 Numbers and other types
14 Primary and foreign keys
15 Creating relationships
16 One-to-many relationships
17 Many-to-many relationships
18 One-to-one relationships
19 Relationship rules and referential integrity
20 Normalization
21 First normal form
22 Second normal form
23 Third normal form
24 Denormalization
25 Creating a database
26 Creating tables
27 Writing SQL queries
28 Narrowing query results
29 Sorting results
30 Aggregate functions
31 Joining tables
32 Modifying data
33 Indexes, transactions, and stored procedures
34 Access control, compliance, and injection
35 Software options
36 Next steps