MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Foundations of Programming: Databases

Course Summary

Discover how a database can benefit both you and your architecture, whatever the programming language, operating system, or application type you use.       


  • +

    Course Syllabus

    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
       Creating 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
     


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

4 - 5 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top