Archive
DataBase7 writings
Tags
SwsZlwoNqquWTeF9jY34rHR1aarIs3qRlYhaHWKAyGtP12Ud/P4BAp/Inz1if93dfGWw8sSPZs6MhPI4wYLkwBVf79owlvjTWtMBqKhbrDNOfmun8im5BPCRHiwrFyeesrNMv180g7xoXrFEmRul9raG7egb5zf7XyegW6Cnsj4X6dVeScpvetxlWiJvz4zerxM6nuAikKdLEEpja4kT1Avq6oCzPCfK4BQVCSMiO8R0zb4bd5E/v4fXQcm/dNedVDrpt8A0gEWwLMCWydZMKwOpygq47otVjAWuNV86QAhQhxAqSxoA0E39MU87gae/TKBg988viPxdJW7aEMzWfQN1T8XBlMTZiBX01grAzFEzvB/7miFqAU0tvtBrX5/hEIT8xklEbXkewoCtIvgB5odlUi1FAaHqrK03mBb67WeLWu6XQVHZ+YODe0UL5i4Xf4LfWvMcaQK4UJu4WTfacwh8iZwBycKIxrmx4iHMtJZfSrtD2ACDuID4qvcQZdFeZPwxJBQoh4EO+U//mWTFdekBvL6/6JCvoblY6CrUq1hRQcUvJepbSCrA62v1BqnSmL6eUPl/Cop+onbVaJzNS12dqOsJe26jJzJ3RruSl837u0t18WSRKNlNewlt0mPhpOgikPO1IZIumaCMF1cbK3+NnOL4m77U2CUEgLSMGVFZxT0FTHFpoNYx/N7V0qg4TCzuoiLlb5stC7uo1RrjzKTyTDZL7zdeRHf1KytI1MTP5BYoKUgOM7UCBkKxHtzQGQMH6NS0hfk6lvNN/AG3j11LW2kXJoA0VAkNGeR9Aw46+YczXdp4t2E/bzPetCsxJcdQ94V5mDhC8xgQgPzWdQ7/ICgyqrnwMziEYwIebzmT8HKCxCN8TlRK0Jzvz00WdkaFD5I0jOP6Ip5nsFNBYD69thwoLZMKI3URe8o0kxN1LK7aH5u/vxXgfOyxfE9IaYh2LJVHR6Gwf7ATLJZ2Uyaq9PutAbor2ZYaH1N+aM0fKXeo5dtMWXRBT+cnK7/xo8/+bUDGS9j3jAeHUgPnmh45pkUlAFWPyCrERGJry9Sx7LWQ0RIzilhIwOULHwUXuEReNzHMBg0Oq9r9UQBKNhqkoe3s6SifQB+iFgM96Hp4iPerXwTlluXXfOmGlM3yOhNAu3laM6ZqgjRiPQmkEsmfeWInjb2cMklvuio4p/YVX4KqRwfca+fpk7Hs4ynJhUZn3kzYu9ew4WbPS4Oj7W6Pow0GvDBaSMbfcsgy
spring
- ChⅥ Database Application ProgrammingNotes on database application programming; ODBC/JDBC connectivity, the Java Web persistence layer, PL/pgSQL functions and stored procedures, triggers, and cursors.DataBase13 min
- Ch4 - Database Design and ImplementationDatabase design process and strategies, E-R model elements, entity relationship types, weak entities, CDM/LDM/PDM design, functional dependencies, normal forms, denormalization, and SQL implementation with Power Designer.DataBase11 min
- Ch3 - Database Operations With SQLSQL statement types and data types; DDL for databases, tables, and indexes; DML for insert, update, delete; DQL with sorting, grouping, subqueries, joins; and views.DataBase6 min
- Ch2 - the Relational Model of DatabasesRelational model, relation tables, primary keys, foreign keys, compound keys, entity integrity, and referential integrity.DataBase5 min
winter
- Glossary for DatabaseA database glossary covering structured, unstructured, and semi-structured data, plus relational and NoSQL data models.DataBaseGlossary4 min
- Database Basics — Functions & ConstraintsDatabase study notes. This post covers SQL functions and constraints.DataBaseSQL7 min
- Database Basics_Core Concepts & SQL SyntaxDatabase study notes covering core database concepts and basic SQL syntax, including DDL, DML, DQL, and DCL statements.DataBaseSQL14 min