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

Learn SASS: from beginner to expert

Everything you need to know about SASS. Level up your CSS and get better results faster with SASS!




Getting Started with React Hooks

Master React Hooks, the next evolution of the popular React library for building dynamic front end interfaces




How to become a Game Artist, Designer, or Developer!

Everything you need to know to start & succeed in the game industry or as a indie game developer.

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