Brainmatics

Oracle Database: 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. Versi terakhir dari Oracle database Server sampai saat ini adalah Oracle 11g.

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

 

CONTENT

1. Oracle Server Technologies and the Relational Paradigm

    1.1. Position the Server Technologies
    1.2. Understand Relational Structures
    1.3. Summarize the SQL Language
    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

 OPERATING SYSTEM

  1. Windows

 

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.