[100% Off] Database Design & Management: MySQL, Oracle & PostgreSQL| Worth 184,99$

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

Created by True Investment

What Will I 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

Includes:

• 6 hours on-demand video
• Full lifetime access
• Access on mobile and TV
• Certificate of Completion

Last updated 3/2018

Source: www.Udemy.com