EventsIT  Introduction to SQL on Oracle Database

Introduction to SQL on Oracle Database

Senin - Selasa, 5 - 6 Oktober 2020, pukul 09:00 - 16:30 WIB
Hotel di Jakarta Selatan, Jakarta
Bonus : Souvenir dan Flashdisk

Database menjadi bagian sangat penting pada perusahaan, dimana setiap aktivitas kegiatan yang dilakukan semua tersimpan kedalam database yang terintegrasi. Database Oracle mendominasi industri perbankan dan perusahaan-perusahaan besar. Sepuluh bank top dunia menggunakan database Oracle untuk melakukan bisnis mereka. Mereka menyediakan kombinasi tinggi tingkat teknologi dan solusi bisnis yang terintegrasi. Database oracle dapat menyimpan data dalam jumlah yang sangat besar dan memiliki ketahanan serta security internal di dalamnya.

Keuntungan lain yang tidak kalah penting yang ditawarkan oleh database Oracle adalah kehandalan mereka. Oracle adalah database yang memberikan kinerja yang sangat baik ketika ditantang dengan tugas-tugas berat. Seperti Tes ASAM (Association for Standardization of Automation and Measuring Systems), yang merupakan alat penting yang digunakan untuk memastikan integritas data yang tersimpan. Tes ini penting karena dapat diandalkan penyimpanan data adalah tujuan utama dari database. Dengan demikian, database Oracle telah terbukti memberikan integritas yang tinggi penyimpanan data.

Pelatihan ini bertujuan agar peserta mendapatkan dasar-dasar pengetahuan tentang oracle database pemahaman teknis yang lebih mendalam tentang relational database management system (ORDBMS). Peserta juga dapat bekerja dalam lingkungan SQL *Plus untuk mengeksekusi statement SQL dan untuk tujuan formatting dan reporting data mentah basis data.

OBJECTIVES

Setelah mengikuti pelatihan ini peserta diharapkan mampu untuk :

  1. Mengenal lingkungan database oracle.
  2. Dapat menggunakan statement DDL,DML didalam database oracle.
  3. Dapat melakukan query dasar dan advanced ke dalam database oracle.
  4. Dapat menggunakan fungsi konversi dan ekspresi kondisi.
  5. Dapat menggunakan subqueries untuk memecahkan masalah yang kompleks.
  6. Dapat menampilkan laporan data dari hasil fungsi grup.

SYLLABUS

  • Introducing Database Oracle
    • Overview oracle database
    • Certification track
    • Communicating with a RDBMS Using SQL
    • SQL Statement
  • Using DDL Statements to Create and Manage Tables
    • Database Objects
    • Naming Rules
    • CREATE TABLE Statement
    • Data Types
    • Including Constraints
    • NOT NULL Constraint
    • UNIQUE Constraint
    • PRIMARY KEY Constraint
    • FOREIGN KEY Constraint: Keywords
    • CHECK Constraint
    • ALTER TABLE Statement
    • Read-Only Tables
    • Dropping a Table
  • Manipulating Data
    • Data Manipulation Language
    • Adding a New Row to a Table
    • INSERT Statement Syntax
    • Changing Data in a Table
    • UPDATE Statement Syntax
    • Removing a Row from a Table
    • DELETE Statement
    • TRUNCATE Statement
    • Advantages of COMMIT and ROLLBACK Statements
  • Retrieving Data Using the SQL SELECT Statement
    • Capabilities of SQL SELECT Statements
    • Basic SELECT Statement
    • Selecting All Columns
    • Selecting Specific Columns
    • Writing SQL Statements
    • Arithmetic Expressions
    • Using Arithmetic Operators
    • Defining a Null Value
    • Null Values in Arithmetic Expressions
    • Defining a Column Alias
    • Using Column Aliases
    • Concatenation Operator
    • Literal Character Strings
    • Using Literal Character Strings
    • Duplicate Rows
    • Displaying the Table Structure
    • Using the DESCRIBE Command
  • Restricting and Sorting Data
    • Limiting Rows Using a Selection
    • Limiting the Rows That Are Selected
    • Using the WHERE Clause
    • Character Strings and Dates
    • Comparison Operators
    • Range Conditions Using the BETWEEN Operator
    • Membership Condition Using the IN Operator
    • Pattern Matching Using the LIKE Operator
    • Combining Wildcard Characters
    • Using the NULL Conditions
    • Defining Conditions Using the Logical Operators
    • Using the AND, OR, NOT Operator
    • Rules of Precedence
    • Using the ORDER BY Clause
    • Sorting
  • Using Single-Row Functions to Customize Output
    • SQL Functions
    • Two Types of SQL Functions
    • Single-Row Functions
    • Character Functions
    • Case-Conversion Functions
    • Character-Manipulation Functions
    • Number Functions
    • Using the ROUND, TRUNC, MOD Function
    • Working with Dates
    • RR Date Format
    • Using the SYSDATE Function
    • Arithmetic with Dates
    • Using Arithmetic Operators with Dates
    • Date-Manipulation Functions
    • Using Date Functions
    • Using ROUND and TRUNC Functions with Dates
  • Using Conversion Functions and Conditional Expressions
    • Conversion Functions
    • Implicit and Explicit Data Type Conversion
    • Using the TO_CHAR Function with Dates
    • Elements of the Date Format Model
    • Using the TO_CHAR Function with Dates
    • Using the TO_CHAR Function with Numbers
    • Using the TO_NUMBER and TO_DATE Functions
    • Nesting Functions
    • General Functions
    • NVL Function
    • Conditional Expressions
    • CASE Expression
    • Using the CASE Expression
    • DECODE Function
    • Using the DECODE Function
  • Displaying Data from Multiple Tables
    • Obtaining Data from Multiple Tables
    • Types of Joins
    • Qualifying Ambiguous Column Names
    • Creating Natural Joins
    • Creating Joins with the USING Clause
    • Joining Column Names
    • Retrieving Records with the USING Clause
    • Using Table Aliases with the USING Clause
    • Creating Joins with the ON Clause
    • Retrieving Records with the ON Clause
    • Joining a Table to Itself
    • Self-Joins Using the ON Clause
    • INNER Versus OUTER Joins
    • LEFT OUTER JOIN
    • RIGHT OUTER JOIN
    • FULL OUTER JOIN
    • Cartesian Products
  • Reporting Aggregated Data Using the Group Functions
    • What Are Group Functions
    • Types of Group Functions
    • Group Functions: Syntax
    • Using the AVG, SUM, MIN, MAX, COUNT Functions
    • Using the DISTINCT Keyword
    • Group Functions and Null Values
    • Creating Groups of Data
    • Creating Groups of Data: GROUP BY Clause Syntax
    • Using the GROUP BY Clause
    • Grouping by More than One Column
    • Using the GROUP BY Clause on Multiple Columns
    • Illegal Queries Using Group Functions
    • Restricting Group Results
    • Restricting Group Results with the HAVING Clause
    • Using the HAVING Clause
  • Using Subqueries to Solve Queries
    • Using a Subquery to Solve a Problem
    • Subquery Syntax
    • Types of Subqueries
    • Single-Row Subqueries
    • Executing Single-Row Subqueries
    • Using Group Functions in a Subquery
    • The HAVING Clause with Subqueries
    • Multiple-Row Subqueries
    • Null Values in a Subquery
  • Using the Set Operators
    • Set Operators
    • UNION Operator
    • UNION ALL Operator
    • INTERSECT Operator
    • MINUS Operator
    • Matching the SELECT Statements
    • Using the ORDER BY Clause in Set Operations

AUDIENCE TARGET (Intermediate Level)

  • IT/Technical Staff :
    Software Developer/Programmer, Software Consultant, System Analyst, System Administrator, Database Administrator.
  • High School Graduate

DURATION :

2 Hari.

TRAINING METHOD :

  1. 25% Theory
  2. 75% Practices (Case study)
  3. Dynamic and interactive training presentation
Biaya :
Rp 4.500.000,-/peserta

Rp 4.350.000,-/peserta (Group 2 orang)
Rp 4.200.000,-/peserta (Group min. 3 orang)

Facilities : Full AC Room with Proyektor/LCD, Lunch / day, 2x Coffee break / day, Certificate, Training Modules, Softcopy Module & Training Kit

Course Leader :


Introduction to SQL on Oracle Database

Schedule
Events IT:

ISO-IEC 20000 Foundation

Jakarta, 8 - 10 Juni 2020 64 clicks

IT Balanced Scorecard (IT BSC)

Jakarta, 8 - 10 Juni 2020 61 clicks

Project Management with Primavera and QSB Software

Jakarta, 8 - 10 Juni 2020 162 clicks

ISO 27001 Foundation

Jakarta, 9 - 11 Juni 2020 54 clicks

MYSQL Database Administration

Jakarta, 9 - 11 Juni 2020 170 clicks
Training Service

Rose
rose@tds-solution.com
HP & WA : 0813 8201 2413

Zulfa
trainingservice01@tds-solution.com
HP & WA : 0857 7331 5631

Telp.: 021-2780 6606

Stats