Agenda : Oracle Database Fundamental (3 days)

วันที่ 24 มิถุนายน 2561

• 09.00 – 10.30 Introduction
  • Introduction to Database Systems
  • Database Management Systems
  • Oracle Database 11g
  • Relational Database Concept
• 10.45 – 12.00 Retrieving Data Using the SQL SELECT Statement
  • Basic SELECT Statement
  • Using Arithmetic Operators and Arithmetic Expressions
  • Column Aliases
  • Use of concatenation operator, literal character strings, and the DISTINCT keyword
• 13.00 – 14.30 Restricting and Sorting Data
  • Limiting rows with: - The WHERE clause - The comparison conditions using =, <=, BETWEEN, IN, LIKE, and NULL operators - Logical conditions using AND, OR operators
  • Sorting rows using the ORDER BY clause
  • Work shop #1
• 14.45 – 16.00 Using Single-Row Functions to Customize Output
  • Single-row SQL functions
  • Character functions
  • Number functions

วันที่ 25 มิถุนายน 2561

• 09.00 – 10.30 Using Conversion Functions and Conditional Expressions
  • Implicit and explicit data type conversion
  • TO_CHAR, TO_DATE, TO_NUMBER functions
  • Nesting functions
  • General functions: - NVL - NVL2 - NULLIF - COALESCE
• 10.45 – 12.00 Reporting Aggregated Data Using the Group Functions
  • Group functions: - Types and syntax - Use AVG, SUM, MIN, MAX, COUNT - Use DISTINCT keyword within group functions
  • Grouping rows: - GROUP BY clause - HAVING clause
  • Workshop #2
• 13.00 – 14.30 Displaying Data from Multiple Tables
  • Obtaining Data from Multiple Tables
  • Joining Tables with Join Syntax
  • Creating Joins with the ON Clause
• 14.45 – 16.00 Displaying Data from Multiple Tables
  • Self-join
  • Nonequijoins
  • OUTER join:
  • Cartesian product
  • Workshop #3

วันที่ 26 มิถุนายน 2561

• 09.00 – 10.30 Using Subqueries to Solve Queries
  • Subquery : Types, syntax, and guidelines
  • Single-row subqueries
• 10.45 – 12.00 Using Subqueries to Solve Queries
  • Multiple-row subqueries
  • Null values in a subquery
  • Workshop#4
• 13.00 – 14.30 Create Database Objects and Tables
  • Create Database Objects and Tables
  • Manipulating Data - INSERT Statement syntax
• 14.45 – 16.00 Manipulating Data
  • Manipulating Data - UPDATE Statement syntax - DELETE Statement syntax
  • Workshop #5
  • Q & A , Closing speech.