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

HOMEPAGE

https://www.lynda.com/SQL-tutorials/Programming-Foundations-Databases/784293-2.html