Foundations of Programming: Databases

Discover how a database can benefit both you and your architecture, whatever the programming language, operating system, or application type you use. In this course, explore options that range from personal desktop databases to large-scale geographically distributed database servers and classic relational databases to modern document-oriented systems and data warehouses—and learn how to choose the best solution for you. Author Simon Allardice covers key terminology and concepts, such as normalization, “deadly embraces” and “dirty reads,” ACID and CRUD, referential integrity, deadlocks, and rollbacks. The course also explores data modeling step by step through hands-on examples to design the best system for our data. Plus, learn to juggle the competing demands of storage, access, performance, and security—management tasks that are critical to your database’s success.

Topics include:

• What is a database?
• Why do you need a database?
• Choosing primary keys
• Identifying columns and selecting data types
• Defining relationships: one-to-one, one-to-many, and many-to-many
• Understanding normalization
• Creating queries to create, insert, update, and delete data
• Understanding indexing and stored procedures
• Exploring your database options

Table of content

Introduction

• Welcome
• What you need to know

Understanding Databases

• What are databases?
• Exploring databases and database management systems

Database Fundamentals

• The features of a relational database
• Exploring unique values and primary keys
• Defining table relationships
• Describing many-to-many relationships
• Transactions and the ACID test
• Introduction to Structured Query Language (SQL)

Database Modeling: Tables

• Introduction to database modeling
• Planning your database
• Identifying columns and selecting data types
• Choosing primary keys
• Using composite keys

Database Modeling: Relationships

• Creating relationships
• Defining one-to-many relationships
• Exploring one-to-one relationships
• Exploring many-to-many relationships
• Understanding relationship rules and referential integrity

Database Modeling: Optimization

• Understanding normalization
• First normal form
• Second normal form
• Third normal form
• Database denormalization

Database Modeling: Querying

• Creating SQL queries
• Creating the WHERE clause
• Sorting query results
• Using aggregate functions
• Joining tables
• Inserting, updating, and deleting
• The data definition language

Database Modeling: Indexing and Optimization

• Understanding indexes
• Understanding write conflicts
• Understanding stored procedures and injection attacks

Database Options

• Desktop databases
• Relational database management systems
• Object-based and XML-based databases
• NoSQL databases

Conclusion

• Final thoughts

Letitbit.net 

1. http://bit.ly/1cYX0rF
2. http://bit.ly/1oRHh6b
3. http://bit.ly/N9VjRH