DBA - Oracle Database: Pemula sampai Mahir

Learn Oracle Database 18c and become a proficient Database Administrator (DBA)! This comprehensive course guides you through the essentials of using a Relational Database Management System (RDBMS) with Oracle 18c.

Here's a detailed look at the topics covered:

• SQL Fundamentals with Oracle 18c: Master the core of data manipulation with a thorough introduction to SQL.
• Setting Up Your Development Environment: Learn to configure your workspace for effective Oracle database development.
• Installing Oracle 18c Express Edition: Get hands-on experience by installing and configuring Oracle 18c Express Edition.
• Database Tools: Explore and utilize essential database editor tools including DataGrid, SQL/Plus, Oracle Database Developer, and Navigate.
• SQL Commands: Deep dive into fundamental SQL commands, including:
  • Data Retrieval: SELECT statement, Column Aliases, Concatination, NULL values, DISTINCT.
  • Filtering Data: WHERE clause, Relational Comparison Predicate, IN Predicates, BETWEEN Predicates, NULL Condition, EXISTS Predicates, NOT Predicates, Logical Predicates.
  • Data Sorting: ORDER BY clause.
  • SQL Functions: Single Row Functions, Group Functions.
• Joining Tables: Learn to combine data from multiple tables using various join types: Natural Join, Cartesian Products, Inner Join, Outer Join, Self Join.
• Subqueries: Master the use of subqueries – single row, multiple rows, and pairwise subqueries – for complex data retrieval.
• Pagination with Subqueries: Implement pagination techniques using subqueries for efficient data display.
• Data Manipulation (DML): Perform data modifications with DML statements.
• Transaction Control (TCL): Manage data integrity using TCL for transaction control. Learn to:
  • Create, Alter, Drop Tables.
  • Use Constraints, Truncate, and Purge commands.
  • Manage Sequences and Views.
  • Implement Indexing strategies (B-Tree Index, Function Based Index, Bitmap Index) and drop indexes.
• Advanced Queries: Combine data using UNION and MERGE statements.
• PL/SQL: Develop stored procedures and functions with PL/SQL, including:
  • Variables and Constants.
  • Functions.
  • Flow Control statements.
  • Cursors.
  • Stored Procedures and Triggers.
• User and Schema Management: Learn to manage users, schemas, and privileges.
• Role Management: Implement role-based access control.
• Case Study: Enterprise Scala Application: Apply your knowledge in a real-world case study focused on building an enterprise Scala application.
• Database Design (ERD): Understand the principles of designing Entity-Relationship Diagrams (ERD).

Who is this course for?

• Individuals looking to learn Relational Database Management Systems (RDBMS) with Oracle Database.
• Those preparing for the Oracle Certified Associate Program (OCA-1Zo-071) certification.
• Aspiring Database Administrators (DBA) specializing in Oracle 18c.

This course utilizes practical case studies relevant to today's job market, providing valuable hands-on experience.