お問い合わせを送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
予約を送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
コース概要
Introduction to Relational Databases and PostgreSQL
- What is a relational database
- Overview of PostgreSQL and its ecosystem
- Use cases and advantages of PostgreSQL
Installing and Configuring PostgreSQL and PGAdmin
- Installing PostgreSQL on Windows/Linux
- Installing and using PGAdmin for GUI access
- Creating connections and managing users
Understanding PostgreSQL Architecture
- PostgreSQL server components and memory usage
- Database cluster structure and file layout
- Processes and services
Creating and Structuring Databases
- Creating databases and tables
- Understanding data types
- Using PGAdmin to manage database objects
Writing Basic SQL Queries
- Using SELECT, WHERE, ORDER BY, LIKE, BETWEEN, and NULL
- Sorting and filtering query results
Using GROUP BY and HAVING
- Grouping rows and calculating aggregates
- Filtering groups with HAVING
Working with Complex Conditions
- Using EXISTS, IN, ANY, ALL
- Nesting subqueries
JOIN Operations in PostgreSQL
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
- SELF JOIN and use cases
Using Built-in SQL Functions
- Mathematical functions
- String manipulation functions
- Date and time operations
Data Manipulation Statements
- INSERT: inserting new rows
- UPDATE: modifying existing data
- DELETE: removing rows from tables
Working with Views
- Creating and querying simple views
- Views with subselects
- Benefits and limitations of views
Introduction to the Timescale Extension
- What is TimescaleDB and when to use it
- Installing and enabling Timescale extension
- Creating hypertables and inserting time-series data
Summary and Next Steps
要求
- An understanding of basic IT and data concepts
- No prior SQL or database experience is required
- Familiarity with using software tools on Windows/Linux is helpful
Audience
- Database beginners and analysts
- Developers starting with PostgreSQL
- Professionals managing or exploring relational databases
14 時間
お客様の声 (1)
advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)
