PostgreSQL - Beginners To Master
About Course
Are you new to PostgreSQL or need a refresher ?
SQL course covering basic to advanced SQL topics for SQL Database (PostgreSQL). Beginner friendly SQL training
What Will You Learn ?
- Knowledge of all the essential SQL commands
- Become competent in using sorting and filtering commands in SQL
- Enhance the performance of your Database by using Views and Indexes
- Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
- Master SQL's most popular string, mathematical and date-time functions
- Solid understanding of SQL
Course Content
- Basic Linux commands
- File command, File transfer
- Disk usage
- File permission & compression
- Process related
- Crontab, Shell script
- SSH Login
- Linux keyboard shortcut
- System Information
- Directory Navigation
- SQL Overview, SQL commands, SQL RDBMS Concepts
- Retrieving Data Using SELECT Statement
- Clauses
- Restricting And Sorting Data
- Single Row Functions
- Multiple row Functions
- General Functions
- Date functions
- Conversion Functions
- Join
- Subquery
- Set Operator
- Constraints
- Database Objects
- Introduction
- PostgreSQL System Architecture
- Installation
- PostgreSQL Database Cluster
- Command Line Interface
- PostgreSQL Configuration
- Creating and Managing Databases, Schemas, Users, Tablespaces
- PostgreSQL Data Dictionary
- Log Management
- PostgreSQL Security [ pg_hba.conf]
- Backup and Recovery
- WAL Archiving
- MVCC
- Routine Maintenance
- Data Movement
- Streaming Replication
- Database & Server Monitoring
Enquire
Key Points
- Certification
- Skill Development
- Practical Experience
- Industry-Relevant Knowledge
- Networking Opportunities
- Portfolio Building
- Lifelong Learning
- Job Placement Assistance
- Personality developmet with efficient soft skill
Requiremnets
- Basic Computer Skills.
- Understanding of Relational Databases.
- SQL Fundamentals.
- Learn Basic Database Design.
- Basic Command Line Skills.
Audience
- This course is meant for TOTAL beginners in PostgreSQL
- No programming experience is needed at all.
Course Instructor
