PostgreSQL Database Veritabanı Sorgulama Eğitimi

• Lab 2.1. The SQL Execution Environment
• Lab 2.2. The Anatomy of a SELECT Statement

• Learn to Restrict and Sort Data
• Lab 3.1. The WHERE Clause
• Lab 3.2. The ORDER BY Clause

• Data Types
• Reading Syntax Diagrams
• Lab 4.1. Character Functions
• Lab 4.2. Number Functions
• Lab 4.3. Miscellaneous Single-Row Functions
• Usage of Single-Row Functions to Customize Output

• Data Management in different Time Zones
• Lab 5.1. Applying PostgreSQL’s Date Format Models
• Lab 5.2. Performing Date and Time Math
• Lab 5.3. Understanding the TIMESTAMP and TIME ZONE Data Types
• Lab 5.4. Performing Calculations with the Interval Data Types
• Lab 5.5. Converting from One Data Type to Another

• Aggregate Data Using the Group Functions
• Lab 6.1. Aggregate Functions
• Lab 6.2. The GROUP BY and HAVING Clauses

• Display Data From Multiple Tables Using Joins
• Lab 7.1. The Two-Table Join
• Lab 7.2. Joining Three or More Tables

• Use Sub-queries to Solve Queries
• Retrieve Data Using Sub-queries
• Lab 8.1. Simple Subqueries
• Lab 8.2. Correlated Subqueries
• Lab 8.3. Inline Views and Scalar Subquery Expressions
• Lab 8.4. ANY, SOME and ALL Operators in Subqueries

• The SET Operators
• Lab 9.1. The Power of UNION and UNION ALL
• Lab 9.2. The EXCEPT and INTERSECT Set Operators

• Lab 10.1. Outer Joins
• Lab 10.2. Self-Joins

• Data Manipulation Statements
• Use of DDL Statements to Create and Manage Tables
• Other Schema Objects
• Management of Schema Objects
• Lab 11.1. Creating Data and Transaction Control
• Lab 11.2. Updating and Deleting Data
• Lab 11.3. The SQL Developer Data Tab

• Lab 12.1. Creating and Dropping Tables
• Lab 12.2. Altering Tables and Manipulating Constraints

• Lab 13.1. Indexes
• Lab 13.2. Sequences
• Lab 13.3. Views

• Lab 14.1. The PostgreSQL Data Dictionary Views
• Lab 14.2. Scripting and Reporting

Lab 15.1. Users, Privileges, Roles and Synonyms

• Lab 16.1. Regular Expressions
• Lab 16.2. Hierarchical Queries

• Lab 17.1. Advanced SQL Concepts, Analytical Functions and the WITH Clause
• Lab 17.2. ROLLUP and CUBE Operators

• Lab 18.1. The PostgreSQL Optimizer and Writing Effective SQL Statements

• The Window Function Concepts and Syntax
• Lab 19.1. Using Window Functions

• Lab 20.1. Loops
• Lab 20.2. Cursors
• Lab 20.3. Exceptions

• Types of PL/PGSQL Block
• Lab 21.1. Unnamed Block(Anonymous Blocks)  -- Nested Subprograms
• Lab 21.2. Named Block(Procedure, Function) -- Stored Subprograms