PostgreSQL for Developers - WEBINAR

PostgreSQL for Developers - WEBINAR

Durasi :

6 Pertemuan  x 3 Jam 

Slot Jadwal (Pilih):

(09.00 - 12.00 OnTime)

(13.00 - 15.00 OnTime)

(19.30 – 22.30 OnTime)

Break Time : 30 Menit

Senin – Sabtu (Everyday)

Media :

Webinar Online

Google Hangout Group Conversation

Fasilitas :

Online Toolkit, Softcopy Module, Sertifikat (soft/hardcopy)

BIAYA ONLINE WEBINAR - KLIK

 

 

 

Silabus PostgreSQL for Developers - WEBINAR

 

Deskripsi :

This PostgreSQL training course is ideal for those looking to migrate to PostgreSQL This PostgreSQL training course was designed for specifically for developers with SQL knowledge and experience and focuses on the features and functionality that are specific to PostgreSQL. Attendees will learn how to apply their SQL knowledge and experience to the PostgreSQL platform.

Materi Bahasan :

Topics include:

§  Installing & managing PostgreSQL

§  Overview of PostgreSQL database

§  Using the psql client

§  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

 

REGISTRASI SEKARANG  - KLIK

 

Atau hubungi Admin untuk informasi lebih lanjut :
Tel/WA : 0838-0838-0001 , info@purnamaAcademy.com

 

PERINGATAN :

STOP CORONA/ COVID-19 , LAKUKAN SOCIAL DISTANCING , JAGA KEBERSIHAN TANGAN, MAKAN BERGIZI , OLAHRAGA &  #DIAMDIRUMAH

 

 



Post a Comment

0 Comments