Database Design & Management: MySQL, Oracle & PostgreSQL
Database Design & Management: Semantic Modeling, Data Analysis, DATA MANAGEMENT In MySQL, MS SQL, Oracle & PostgreSQL
3.67 (43 reviews)
2,412
students
6 hours
content
Mar 2018
last update
$19.99
regular price
What you will learn
The Entity Relationship (= ER) Model
The Relational Data Model
Logical Database Design
Relational Algebra (an algebraic query Language For The Relational Model)
MYSQL, PostgreSQL
Querying and Manipulating Data
SQL Data Definition Language
Single Block Queries
Aggregation
Transaction Management and Concurrency Control
Database Access from a Programming Language: JDBC 5
Data Management
Data Storage and Indexing
File Organization and Indexes
Tree-structured Indexing: B+-trees
Hash-based Indexing
Indexes in PostgreSQL
Query Evaluation, optimization & Plans in PostgreSQL
Functional Dependencies and Normalization
System Development Life Cycle
Preparing Written Documentation, Visual Materials
Database Design
Database Development Process
Relational database design using ERD
Normalizing database designs
Object-relational design using EERD
Advanced SQL
The DBMS lifecycle
Screenshots
Related Topics
1587120
udemy ID
3/8/2018
course created date
7/19/2019
course indexed date
Bot
course submited by