Home / SQL & Data Modeling with PostgreSQL

SQL & Data Modeling with PostgreSQL

SQL & Data Modeling with PostgreSQL is designed to help you understand in project analyze, database design and normalized data follow requirements from clients and Modeling the business flows. Please see the details course offers below,

Course Offer
  1. How Database Structure important
  2. Normalize Database
  3. Manipulate Data
  4. Model your data in the efficiency way
  5. Query and manage data with SQL Function and View
  6. Using new feature like Fast Full-Text Search in RDBMS
  7. Analyze project from Client’s requirements
  8. Flowchart design to model the Business Flows

20% Scholarship

Fee : $ 175.0 $ 140.0

Duration : 50 hours

SQL & Data Modeling with PostgreSQL
Enroll
Course Outline

  • Introduction to Data Modeling
  • ER model, ER Diagrams
  • Notation symbols
  • Using Navicat software
  • Relationships
  • Project Pratical (1)

  • Understand the purpose of normalization
  • First normalization
  • Second and Third normalization
  • Project Practical (2)

  • Data types
  • Data manipulation
  • Queries
  • Fast Full-Text Search in PostgreSQL
  • SQL Function and View
  • Project Practical (3)

  • Collect requirements from clients
  • Modeling the business flows
  • Flowchart design for client confirmation
  • Database ready for database schema
  • Deploy Database Server

  • Analyze Project's Features
  • Prepare database for project
  • Database Server
  • Handle on data availability