老程序员带您学SQL第3篇:Oracle数据库
Learn Oracle database management & SQL. Master Oracle-specific SQL, MySQL functions, stored procedures & functions. Ideal for programmers, data analysts, & DBAs.
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
:NEWand:OLDto 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.
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.