Brainmatics

Oracle Database 11g: SQL Fundamentals I

Popularity : author-post-ratingauthor-post-ratingauthor-post-ratingauthor-post-ratingauthor-post-rating

Sampai saat ini Oracle database merupakan pemain utama di bidang database. Oracle terus berkembang dengan mengakuisisi beberapa produk dan perusahaan.

Training Oracle Database 11g: SQL Fundamentals I merupakan langkah awal dalam memperoleh sertifikasi Oracle Certified Associate Database 11g. Pada training ini, Anda akan mempelajari teknik Structure Quary Language (SQL) secara menyeluruh pada Oracle Database 11g. Anda juga dibekali bagaimana menghadapi ujian sertifikasi Oracle Database 11g: SQL Fundamentals I.

 

OBJECTIVES

 

AUDIENCE

 

PREREQUISITES

 Tidak ada kemampuan khusus yang dipersyaratkan

 

CONTENT

1. Oracle Server Technologies and the Relational Paradigm

1.1. Position the Server Technologies
1.2. Understand Relational Structures
1.4. Use the Client Tools
1.5. Create the Demonstration Schemas

2. Data Retrieval Using the SQL SELECT Statement List the Capabilities of SQL SELECT Statements

2.1. List the Capabilities of SQL SELECT Statements
2.2. Execute a Basic SELECT Statement

3. Restricting and Sorting Data

3.1. Limit the Rows Retrieved by a Query
3.2. Sort the Rows Retrieved by a Query
3.3. Ampersand Substitution

4. Single-Row Functions

4.1. Describe Various Types of Functions Available in SQL
4.2. Use Character, Number, and Date Functions in SELECT Statements

5. Using Conversion Functions and Conditional Expressions

5.1. Describe Various Types of Conversion Functions Available in SQL
5.2. Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Function
5.3. Apply Conditional Expression in a SELECT Statement

6. Reporting Aggregated Data Using the Group Functions

6.1. Describe the Group Functions
6.2. Identify the Available Group Functions
6.3. Group Data Using the GROUP BY Clause
6.4. Include or Exclude Grouped Rows Using the HAVING Clause

7. Displaying Data from Multiple Tables

7.1. Write SELECT Statements to Access Data from More Than One Table Using Equijoins and No equijoins
7.2. Join a Table to Itself Using a Self-Join
7.3. View Data that Does Not Meet a Join Condition by Using Outer Joins
7.4. Generate a Cartesian Product of Two or More Tables

8. Using Subqueries to Solve Problems

8.1. Devine Subqueries
8.2. Describe the Types of Problems That the Subqueries Can Solve
8.3. List the Types of Subqueries
8.4. Write Single-Row and Multiple-Row Subqueries

9. Using the Set Operators

9.1. Describe the Set Operators
9.2. Use a Set Operator to Combine Multiple Queries into a Single Query
9.3. Control the Order of Rows Returned

10. Manipulating Data

10.1. Describe Each Data Manipulation Language (DML) Statement
10.2. Insert Rows into Table
10.3. Update Rows in a Table
10.4. Delete Rows from Table
10.5. Control Transactions

11. Using DDL Statements to Create and Manage Tables

11.1. Categorize the Main Database Objects
11.2. Review the Table Structure
11.3. List the Data Types That Are Available for Columns
11.4. Create a Simple Table
11.5. Explain How Constraints Are Created

12. Creating Other Schema Objects

12.1. Create Simple and Complex Views
12.2. Retrieve Data from Views
12.3. Create Private and Public Synonyms
12.4. Create, Maintain, and Use Sequences
12.5. Create and Maintain Indexes

 

INSTRUCTOR

Ananias Ardiles Sembiring. Lahir di Pematang Siantar, 3 September 1983. Menyelesaikan pendidikan S1 di ITB pada tahun 2007, telah tersertifikasi OCP, dan OCA. Berpengalaman menjadi Database Administrator selama 7 tahun, dan berpengalaman mengajar Oracle selama 5 tahun di beberapa lembaga training di Jakarta.

 

 

Mohammad Yoga Rimaldo. Menamatkan pendidikan tinggi jurusan Teknik Informatika di Institut Teknologi Telkom Bandung pada tahun 2012. Memiliki berbagai sertifikasi internasional seperti : Oracle Database 11g Administrator Certified Associate , Oracle Database 11g Certified Professional , Oracle Database SQL Certified Expert , VMWare Certified Instructor 5 , dan berbagai sertifikasi lainnya dibidang IT. Saat ini aktif sebagai pengajar / trainer diberbagai Perusahaan BUMN dan BUMS Nasional, untuk materi training berbasis Oracle Database dan VMware virtualization.