Course Details
Comprehensive PostgreSQL
Database
Created On
July 05, 2023Description
Comprehensive Database Administration and Management PostgreSQL, or Postgres, is a powerful open-source relational database management system known for its reliability, extensibility, and adherence to standards. It offers advanced features, supports SQL, and has a vibrant open-source community. PostgreSQL is widely used in various applications due to its scalability and flexibility.
Overview
This course covering comprehensive training in PostgreSQL, database exploration, relational database understanding, and diverse PostgreSQL operations. Gain practical skills for careers in database administration, data engineering, and software development. Master PostgreSQL's power and meet the growing demand for PostgreSQL expertise.
Features
- On demand recorded videos
- Quiz in every module
- Real-time Project
- Assignment in all modules
- Completion Certificate
- Course material
- Course resources
What you'll learn
- Exploring Databases: "Database Discovery"
- Relational Database Insight
- Importance of PostgreSQL: "PostgreSQL's Significance"
- Versatile PostgreSQL Operations
Prerequisites
Curriculum
- 11 modules
Course Introduction: "Welcome to PostgreSQL"
Target Audience: PostgreSQL Course"
Overview of PostgreSQL Course Content"
Course Outcome
History of PostgreSQL
Notable Features of PostgreSQL"
PostgreSQL Download and Installation
PostgreSQL Server
Introduction to Database: Database Introduction
Create Database: Database Creation
Connecting Database: Database Connection
DROP Database: Database Deletion
Introduction to Table: Table Introduction
Create Table: Table Creation
INSERT Data: Data Insertion
SELECT Data: Data Retrieval
DELETE Record: Record Deletion
Update Table: Table Updates
Truncate Table: Table Truncation
Drop Table: Table Deletion
Schema
Table Space
WHERE Clause: Condition Filtering
GROUP BY Clause: Grouping Data
ORDER Clause: Sorting Data
HAVING Clause: Conditional Group Filtering
DISTINCT Clause: Unique Values
Introduction to ALTER table: Modifying Tables
ADD a column: Column Addition
DROP a column: Column Removal
Rename column: Column Renaming
Rename Table: Table Renaming
ADD Constraint: Constraint Addition
Introduction to Constraint and all the constraint info: Understanding Constraints
Foreign key Constraint: Referential Integrity Constraint
Operators Introduction
Comparison Operators in PostgreSQL
BETWEEN Operator in PostgreSQL
NOT BETWEEN Operator in PostgreSQL
NOT Operator in PostgreSQL
LIKE Operator in PostgreSQL
OR Operator in PostgreSQL
AND Operator in PostgreSQL
LIMIT Operator in PostgreSQL
IN Operator in PostgreSQL
UNION Operator in PostgreSQL
INTERSECT Operator in PostgreSQL
Postgres JOINS Introduction
Inner Join in PostgreSQL
Full Outer Join in PostgreSQL
Left Join in PostgreSQL
Right Join in PostgreSQL
Cross Join in PostgreSQL
Natural Join in PostgreSQL
Views
Introduction to database roles management:
Database Role
Attributes of Roles
Built-in Roles
Introduction to Database Backup
Database Backup Process
Database Backup with pgAdmin
Database Restore with Command Line
Database Restore with pgAdmin
Instructors
Skoliko Faculty
- 11 Modules
- 8 Hours
- Database
Login to Purchase the Course