->
Lynda - Programming Foundations: Databases (2015) - 412845
Lynda - Programming Foundations: Databases (2015)
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.


Table of Contents

  • Introduction
  • 1. Understanding Databases
  • 2. Database Fundamentals
  • 3. Database Modeling: Tables
  • 4. Database Modeling: Relationships
  • 5. Database Modeling: Optimization
  • 6. Database Modeling: Querying
  • 7. Database Modeling: Indexing and Optimization
  • 8. Database Options
  • Conclusion
  • Lynda - Programming Foundations: Databases (2015)


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss