2015
Lynda
Simon Allardice
3:11
English
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 your data. Plus, learn to juggle the competing demands of storage, access, performance, and security—management tasks that are critical to your database's success.
Introduction
Welcome
What you need to know
1. Understanding Databases
What are databases?
Exploring databases and database management systems
2. 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)
3. Database Modeling: Tables
Introduction to database modeling
Planning your database
Identifying columns and selecting data types
Choosing primary keys
Using composite keys
4. 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
5. Database Modeling: Optimization
Understanding normalization
First normal form
Second normal form
Third normal form
Database denormalization
6. Database Modeling: Querying
Creating SQL queries
Structuring the WHERE clause
Sorting query results
Using aggregate functions
Joining tables
Inserting, updating, and deleting
The data definition language
7. Database Modeling: Indexing and Optimization
Understanding indexes
Understanding write conflicts
Understanding stored procedures and injection attacks
8. Database Options
Desktop databases
Relational database management systems
Object-based and XML-based databases
NoSQL databases
Conclusion
Final thoughts
Download File Size:519.83 MB
|
