Sharing MySQL, Oracle And PostgreSQL Database Design And Management Course
Database design and management: Semantic modeling, Data analysis, Data management in MySQL, MS SQL, Oracle & PostgreSQL. What will you learn: + Entity relationship model (= ER) + Relational data model + Logic database design + Relational algebra (an algebra query language for a relational model) + MYSQL, PostgreSQL + Query and data manipulation + SQL data definition language + Single Block Queries + Aggregation (Aggregation). + Transaction Management and Concurrency Control. + Access database from programming language: JDBC 5. + Data management. + Store and index data. + Organize files and indexes. + Indexing tree structure: B + -trees + Indexing based on hashes. + PostgreSQL index + Evaluation, optimization and query plan in PostgreSQL. + Functional Dependencies and Normalization. + System Development Life Cycle. + Database design + Database development process + Relational database design by ERD. + Standardizing database design + Designing object relation using EERD + Advanced SQL. + DBMS life cycle
LINK ONEDRIVE:
Pass Winrar: http://nhasachtinhoc.blogspot.com