Udemyintermediatezh

老程序员带您学SQL第3篇:Oracle数据库

Learn Oracle database management & SQL. Master Oracle-specific SQL, MySQL functions, stored procedures & functions. Ideal for programmers, data analysts, & DBAs.

5.0(7)
32students
4h 10m
Certificate
东升 关
东升 关技术专家,技术顾问,技术图书作家,金牌讲师

Course Content

老程序员带您学SQL第3篇:Oracle数据库 is an intermediate-level Udemy course taught by 东升 关. It runs 4h 10m, is taught in Chinese, and includes a certificate of completion. Learners rate it 5.0 out of 5 from 7 reviews, with 32 students enrolled. It is a paid course, last updated October 2024.

Oracle Database Management: Installation, Administration & Development

This course provides a comprehensive guide to managing and developing with Oracle databases. Learn essential skills for database administrators and developers alike.

Oracle Database Installation & Configuration

  • Oracle Database Versions: An overview of the main Oracle database versions available.
  • Oracle 21c Quick Install & Configuration: A step-by-step guide to installing and configuring Oracle 21c using the quick installation method.
    • Download Oracle 21c Quick Install: Learn where to download the necessary files.
    • Windows Installation: Detailed instructions for installing Oracle 21c on a Windows platform.
    • Remote Access Configuration: Setting up remote access to your Oracle database.

Daily Oracle Database Administration

  • **SQLPlus Fundamentals:* Master the use of SQL*Plus, the command-line interface for interacting with Oracle databases.
    • Login Strings: Understanding and utilizing login strings for database connections.
    • User Management: Learn how to create, modify, and manage database users.
    • Viewing User Information: Retrieving current user details and privileges.
    • Executing Script Files: Running SQL scripts for automated database tasks.
  • Oracle SQL Developer: Utilize the powerful Oracle SQL Developer tool for database management.
    • Download & Installation: Download and install Oracle SQL Developer.
    • Database Connection Configuration: Configuring connections to your Oracle database within SQL Developer.
    • Table Management: Creating, altering, and dropping tables.
    • Data Management: Inserting, updating, and deleting data within tables.
    • SQL Execution: Executing SQL queries and scripts through the SQL Developer interface.

Advanced SQL in Oracle

  • Sequences: Learn to generate unique, sequential numbers for primary keys and other purposes.
    • Creating Sequences: Defining and creating sequences.
    • Using Sequences: Retrieving values from sequences.
    • Modifying Sequences: Altering sequence properties.
    • Deleting Sequences: Removing sequences.
  • Identify Columns: Understanding and utilizing identify columns for data retrieval.
  • Hierarchical Relationships & Recursive Queries: Querying data with hierarchical structures.
    • Hierarchical Data: Understanding and representing hierarchical data models.
    • Recursive Queries: Writing queries to traverse hierarchical data.
  • Limiting Result Sets: Controlling the number of rows returned by a query.

Oracle Database Development with PL/SQL

  • PL/SQL Fundamentals: Introduction to PL/SQL, Oracle's procedural extension to SQL.
    • Anonymous Code Blocks: Executing PL/SQL code within SQL statements.
    • Cursors: Working with cursors to process data row by row.
  • Stored Procedures: Creating reusable blocks of PL/SQL code.
    • Creating Stored Procedures: Writing and deploying stored procedures.
    • Deleting Stored Procedures: Removing stored procedures.
  • Stored Procedure Parameters: Passing data to and from stored procedures.
    • IN Parameters: Input parameters.
    • OUT Parameters: Output parameters.
    • INOUT Parameters: Parameters that can be both input and output.
  • Stored Functions: Creating functions that return values.
    • Creating Stored Functions: Writing and deploying stored functions.
    • Calling Stored Functions: Executing stored functions.
    • Deleting Stored Functions: Removing stored functions.
  • Triggers: Automated PL/SQL code that executes in response to database events.
    • Trigger Types: Understanding different types of triggers.
    • Trigger Syntax: Writing trigger code.
    • :NEW and :OLD Modifiers: Using :NEW and :OLD to access data before and after an event.
    • Example: Employee Table Update Logging: A practical example of using a trigger to log changes to an employee table.
$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(81)
38m
beginner
5.0(10)
1h 46m
all

中國針灸學:初階【認識經絡與穴位】

by 駿緯視聽醫學器材股份有限公司 MEDITALENT ENTERPRISES LTD.

5.0(1)
5h 2m
all

中國針灸學-21.針刺補瀉

by 駿緯視聽醫學器材股份有限公司 MEDITALENT ENTERPRISES LTD.

5.0(2)
44m
all