Školení PostgreSQL implementace

Délka: 3 dny
Cena: 9000 Kč

Kurz PostgreSQL implementace osnova:

• Database Fundamentals
• Database Normalization
• Installing & Configuring PostgreSQL
• Using the psql Client
• Understanding PostgreSQL Data Types
  • Numeric data types
  • Character types
  • Binary data types
  • Date & time types
  • Boolean values
  • Array types
  • Other data types
• Understanding & managing sequence numbers
• Creating tables (DDL)
  • Using CREATE TABLE
  • NOT NULL constraints
  • PRIMARY KEY constraints
  • FOREIGN KEY constraints
• Modifying tables (ALTER TABLE)
  • Creating & managing indexes
  • Creating indexes
  • Indexes on expressions
  • Partial indexes
• Data manipulation language (DML)
  • Inserting data
  • Using COPY to perform data loads
  • Using DELETE to remove rows
  • Updating data using UPDATE
• Retrieving information from tables using SELECT
• Performing table joins
  • Cross joins
  • Inner joins
  • Outer joins
  • Natural joins
• Restricting selections using the WHERE clause
• Joining tables with WHERE
• Using ORDER BY to sort query results
• Limiting rows returned using LIMIT
• Computing summary values
• Using the GROUP BY clause
• Using the HAVING clause
• Using DISTINCT to eliminate duplicates
• Using UNION, INTERSECT and EXCEPT to join SELECT Results
• Pattern matching using LIKE
• Conditional expressions
  • The CASE statement
  • The COALESCE function
  • The NULLIF function
• Subquery expressions
  • The EXISTS expression
  • The IN (and NOT IN) expression
• Working with array values
• Performing type casting and conversion
• PostgreSQL functions
  • Numeric functions
  • Character functions
  • Session information functions
• Transactions and concurrency
• Understanding PostgreSQL data types
  • Numeric data types
    • Integer data types
    • Floating point types
    • Serial types
  • Character types
  • Binary data types
  • Date & time values
  • Boolean values
  • Array types
  • Other data types
• Understanding sequences
• Creating & managing indexes
  • Understanding PostgreSQL indexes
  • Partial indexes
  • Indexes on expressions
• Using COPY to load data
• Working with Array Values
• Advanced SQL Functions
  • Using Common Table Expressions (CTE)
  • Using Window Functions
  • Using Regular Expressions
  • Using Recursive Queries
• Writing triggers & stored procedures with PL/pgSQL
  • Variables in procedures
  • Performing loop operations
  • The PERFORM and EXECUTE statements
  • Triggers in PostgreSQL
• Using the PostgreSQL query optimizer
  • Analyzing & optimizing queries
  • Viewing execution plans with EXPLAIN
  • Understanding PostgreSQL query operators
• Improving query performance

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs