Querying PostgreSQL Databases
Duration : 3 Days (24 Hours)
Querying PostgreSQL Databases Course Overview:
TrainCrest’s “Querying PostgreSQL Databases” course provides comprehensive training in intermediate-level SQL querying using PostgreSQL, a powerful open-source relational database management system. PostgreSQL, often referred to as Postgres, is known for its ACID compliance and is compatible with various platforms. This RDBMS is fully transactional and primarily adheres to the SQL:2008 standard. Notably, PostgreSQL boasts extensible features, including data types, functions, operators, aggregates, index methods, procedural languages, and a wide array of third-party extensions, making it a versatile and robust choice for database management.
Intended Audience:
- Database Administrators
- Database Developers
- Data Analysts
- Software Engineers
- IT Professionals
- Data Scientists
- System Administrators
- Students and Learners
- Professionals in Transition
- Business Analysts
Learning Objectives of Querying PostgreSQL Databases:
- An Introduction to concepts of database and RDBMS
- Introduction to SQL and PostgreSQL
- Querying, Filtering and Retrieving Data
- Creating Tables and Ensuring Data Integrity
- Manipulating Data in Tables
- Working with Views, Subqueries and Functions
- Introduction to PostgreSQL Server
a. Overview
b. History
c. PostgreSQL Internals - Introduction to SQL Language
a. Writing SQL Queries
b. Structure of SQL Queries - Working with Data Types
- Working with Built-In-Functions
- Querying and Filtering Data
a. Where Clause
b. NULL Values
c. ORDER BY
d. DISTINCT - Working with Type Conversions and Operators
a. Logical, Mathematical, Comparison, Bit String Operators
b. UNION and UNION All - Working with Joins
- Working with Group and Aggregation
- Working with Windows Function
- Working with Views, Sub Query Expressions and Common Table Expressions
- Working with Functions
- Querying Metadata of PostgreSQL
a. System Information Functions
b. System Administration Functions - Introduction to DML
- Introduction to Indexes and Collations
- Introduction of PGADMIN III
Querying PostgreSQL Databases Course Prerequisites:
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows/Linux operating system and its core functionality.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!