Database Design & Management: MySQL, Oracle & PostgreSQL

This is share svg Chia sẻ với mọi người

Database Design & Management: MySQL, Oracle & PostgreSQL

Database Design & Management: Semantic Modeling, Data Analysis, DATA MANAGEMENT In MySQL, MS SQL, Oracle & PostgreSQL

Bạn sẽ học được:

  • 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

Yêu cầu:

  1. No Prior Knowledge Or Work Is Necessary To Take This Course.
  2. Pen And Paper For Precious Notes
Database Design & Management: MySQL, Oracle & PostgreSQL

Cùng chuyên mục Development

JavaScript and ES6 Challenges - Do you know JavaScript?

Solve different JavaScript challenges yourself. Destructuring, hoisting, , IIFEs, closures, classes, let and much more




Build an Angular and Spring MVC Web Application

Full stack development with Angular and Spring MVC

Miễn phí



Net DevOps: Cisco Python, Automation, NETCONF, SDN, Docker

Learn Cisco Network DevOps: ACI, Ansible, Python, SDN, Kubernetes, Docker, Containers, NETCONF, includes free labs!

Miễn phí




Nhớ like Fanpage bạn nhé

Tham gia để cùng chia sẻ và nhận hàng ngàn khóa học miễn phí từ Udemy hàng ngày.

Like Fanpage