Oracle SQL kursu

Kurs Haqqında

• Introduction to Oracle Database
  • 1 What is Oracle Database? History & Features
  • 2 Oracle Database vs MySQL, PostgreSQL, SQL Server
  • 3 Oracle Editions: Enterprise, Standard, Express
  • 4 Installation & Setup (Linux, Windows, Mac)
  • 5 Oracle SQL*Plus and SQL Developer basics
  • 6 Oracle Database Architecture (instance, database, SGA, PGA)
• SQL Fundamentals
  • 1 Database objects (schemas, tables, views, sequences)
  • 2 Data types: numeric, text, boolean, date/time, BLOB, CLOB
  • 3 DDL (CREATE, ALTER, DROP, TRUNCATE)
  • 4 DML (INSERT, UPDATE, DELETE, SELECT)
  • 5 Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL)
  • 6 Indexes and views (including materialized views)
• Querying Data
  • 1 SELECT basics, WHERE, ORDER BY
  • 2 Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
  • 3 GROUP BY, HAVING
  • 4 Joins: INNER, LEFT, RIGHT, FULL, CROSS
  • 5 Subqueries, Nested Queries
  • 6 Common Table Expressions (CTEs), Inline Views
  • 7 Window Functions (OVER, PARTITION BY, RANK, ROW_NUMBER)
  • 8 Pivoting data (CASE expressions)
• Advanced SQL
  • 1 Complex joins and set operations (UNION, INTERSECT, EXCEPT)
  • 2 Recursive queries (CONNECT BY, WITH clause)
  • 3 Advanced filtering with EXISTS, IN, ANY, ALL
  • 4 Case statements and advanced expressions
  • 5 Full-text search (Oracle Text)
  • 6 Working with LOBs (Large Objects - CLOB, BLOB)
  • 7 Analytic Functions (LEAD, LAG, FIRST_VALUE, LAST_VALUE)
• Database Design & Modeling
  • 1 Normalization (1NF, 2NF, 3NF, BCNF, 4NF)
  • 2 Entity-Relationship (ER) Diagrams
  • 3 Data modeling with Oracle Designer/SQL Developer
  • 4 Indexing strategies: B-tree, Bitmap, Clustered, Reverse
  • 5 Partitioning (Range, List, Hash, Composite)
  • 6 Foreign keys and Referential Integrity
  • 7 Tablespaces, Datafiles, Segments, Extents
  • 8 Sequence objects and identity columns
• Performance & Optimization
  • 1 Query Execution Plans (EXPLAIN PLAN, AUTOTRACE, DBMS_XPLAN)
  • 2 Optimizing Queries (Index usage, Join strategies)
  • 3 Table and index partitioning strategies
  • 4 Optimizing PL/SQL (Bulk collect, FORALL)
  • 5 Parallel Query Execution
  • 6 Oracle Optimizer and statistics gathering (DBMS_STATS, Auto-tuning)
  • 7 Hints in SQL queries
  • 8 Redo log, Archive log, and Database Cache
• PL/SQL Programming Basics
  • 1 Introduction to PL/SQL (block structure, anonymous blocks)
  • 2 Variables, Constants, and Data Types
  • 3 Control Structures (IF, LOOP, CASE, GOTO)
  • 4 Exception handling (EXCEPTION WHEN, RAISE)
  • 5 Cursors: Implicit and Explicit
  • 6 Handling DML operations within PL/SQL
  • 7 Performance tuning in PL/SQL
• Advanced PL/SQL Features
  • 1 Stored Procedures and Functions (parameters, return types)
  • 2 Triggers: DML triggers (BEFORE, AFTER), INSTEAD OF triggers
  • 3 Packages (concepts, benefits, procedures, and functions)
  • 4 Synonyms, Views, and Sequences in PL/SQL
  • 5 Dynamic SQL (EXECUTE IMMEDIATE, DBMS_SQL)
  • 6 Ref Cursors and Cursor Variables
  • 7 Collections (Associative arrays, Nested tables, VARRAY)
  • 8 Bulk operations (BULK COLLECT, FORALL)
• Oracle Database Administration
  • 1 Database Initialization and Configuration (`init.ora`, `spfile.ora`)
  • 2 Managing Oracle Users & Roles (GRANT, REVOKE, CREATE USER)
  • 3 Tablespace management
  • 4 Backup and Recovery (RMAN, Data Pump, Export/Import)
  • 5 Oracle Data Guard and RAC (Real Application Clusters)
  • 6 Oracle Log Management (Redo logs, Archive logs, Flashback)
  • 7 Monitoring Oracle Database performance (V$ views, AWR reports)
  • 8 High Availability and Scalability: Clustered Databases, RAC
• Security & Auditing
  • 1 User authentication and authorization
  • 2 Role-based access control (RBAC) and Privileges
  • 3 Oracle Wallet and Transparent Data Encryption (TDE)
  • 4 Auditing database activities (AUDIT, Fine-grained auditing)
  • 5 Network security (SSL/TLS, Oracle Net Configuration)
  • 6 Data Masking and Redaction
  • 7 Oracle Security Best Practices
• High Availability & Disaster Recovery
  • 1 Oracle Real Application Clusters (RAC)
  • 2 Oracle Data Guard (Physical Standby, Logical Standby)
  • 3 Flashback Technology (Flashback Query, Flashback Table)
  • 4 Data Guard and Oracle GoldenGate
  • 5 Oracle Streams (capture, propagation, apply)
  • 6 Backup & Recovery: RMAN, Oracle Flashback
  • 7 Active Data Guard and Switchover/Failover
• Advanced Oracle Features
  • 1 Oracle Materialized Views
  • 2 Oracle Streams vs GoldenGate
  • 3 Oracle AQ (Advanced Queuing)
  • 4 Oracle Text Search (Full-text search implementation)
  • 5 Oracle Spatial (GIS data, spatial indexes)
  • 6 Oracle OLAP and Data Warehousing
  • 7 Oracle Application Express (APEX)
• Real-World Applications
  • 1 Implementing a Banking System with Oracle (Accounts, Transactions, Balances)
  • 2 Designing a Data Warehouse with Oracle (Star Schema, OLAP cubes)
  • 3 Real-time data replication using Oracle GoldenGate
  • 4 Integrating Oracle Database with Java (JDBC, Hibernate)
  • 5 Using Oracle with Python (cx_Oracle)
  • 6 Oracle and Big Data integration (Hadoop, Oracle Big Data SQL)