Topics

• Arrays
• Concurrent Programming (Threads)
• Getting started with MySQL
• Table Creation
• Getting started with primefaces
• Getting started with jdbc
• Comment Mysql
• ALTER TABLE
• Creating a database connection
• PreparedStatement
• Statement batching
• TRIGGERS
• SELECT
• Hello Primefaces
• Drop Table
• EXTENSION dblink and postgres_fdw
• JSF Annotations
• Postgres Tip and Tricks
• ResultSet
• JDBC - Statement Injection
• Regular Expressions
• SELECT
• ResultSetMetaData

Examples

• Getting Started
• Table creation with Primary Key
• Installing PrimeFaces
• Creating a connection
• CREATE TABLE FROM SELECT
• Adding comments
• Show Table Structure
• ALTER COLUMN OF TABLE
• Basic usage of a prepared statement
• Batch insertion using PreparedStatement
• Batch execution using Statement
• Basic Trigger
• SELECT by column name
• SELECT all columns (*)
• SELECT with WHERE
• SELECT with LIKE (%)
• SELECT with Alias (AS)
• Hello Primefaces
• SELECT with DISTINCT
• Drop Table
• SELECT with CASE or IF
• Extention dblink
• Extention FDW
• Introduction to annotations
• Managed bean scope annotation
• DATEADD alternative in Postgres
• Comma seperated values of a column
• Delete duplicate records from postgres table
• ResultSet
• Statement & SQL Injection evil
• SELECT with BETWEEN
• REGEXP / RLIKE
• Foreign Data Wrapper
• SELECT using WHERE
• ResultSetMetaData