About Course

PostgreSQL — Version 1

EgyTutor progression rule: complete the Part Quiz with a score above 70% (71% minimum) before the next Part unlocks.

تحميل هذا الباب / Download this Chapterنسخة كاملة للدراسة بدون إنترنت، مع الأسئلة والإجابات والصور المتاحة.

Course Content

Part 1: Part 1: PostgreSQL Foundations — Unit A: Part 1: PostgreSQL Foundations

  • Lesson 1: What PostgreSQL Is
  • Lesson 2: Relational Database Concepts
  • Lesson 3: Connecting to PostgreSQL
  • Lesson 4: Creating Databases and Schemas
  • Lesson 5: Your First SQL Statements
  • PostgreSQL — Version 1 — Part 1 — Formal Quiz

Part 2: Part 2: Tables, Data Types, and Constraints — Unit A: Part 2: Tables, Data Types, and Constraints

Part 3: Part 3: Selecting and Filtering Data — Unit A: Part 3: Selecting and Filtering Data

Part 4: Part 4: Aggregation and Grouping — Unit A: Part 4: Aggregation and Grouping

Part 5: Part 5: Joins and Relationships — Unit A: Part 5: Joins and Relationships

Part 6: Part 6: Subqueries, CTEs, and Set Operations — Unit A: Part 6: Subqueries, CTEs, and Set Operations

Part 7: Part 7: Advanced SQL and Window Functions — Unit A: Part 7: Advanced SQL and Window Functions

Part 8: Part 8: Data Modification and Transactions — Unit A: Part 8: Data Modification and Transactions

Part 9: Part 9: Indexes and Query Performance — Unit A: Part 9: Indexes and Query Performance

Part 10: Part 10: PostgreSQL-Specific Features — Unit A: Part 10: PostgreSQL-Specific Features

Part 11: Part 11: Functions, Security, and Administration — Unit A: Part 11: Functions, Security, and Administration

Part 12: Part 12: Database Design and Final Project — Unit A: Part 12: Database Design and Final Project

Student Ratings & Reviews

No Review Yet
No Review Yet
تحميل هذا الباب / Download this Chapterنسخة كاملة للدراسة بدون إنترنت، مع الأسئلة والإجابات والصور المتاحة.