Summary
Highlights
Downloading Oracle Express Edition00:00:16
The video begins by demonstrating how to find and download the Oracle Express Edition for Windows 64-bit from the official Oracle website. The download is a large zip file (around 1.88 GB) and takes some time to complete.
Extracting and Running the Installer00:01:02
Once downloaded, the zip file needs to be extracted. The user then navigates to the extracted folder and launches the 'setup' application to begin the installation wizard for Oracle 21c Express Edition.
Installation Configuration00:01:46
The installation process involves accepting the license agreement, choosing the destination folder (default is recommended), and setting a password for the 'SYS' and 'SYSTEM' users. A simple password like 'system' is used for demonstration.
Completing the Installation00:02:53
After configuring the settings, the installation proceeds, which includes configuring the Oracle XE database components. Upon successful installation, a confirmation message is displayed along with important connection information that should be saved.
Verifying SQL Plus Functionality00:03:40
To verify the installation, SQL Plus is launched. The user logs in using 'system' as the username and the previously set password. The video then demonstrates creating a table, describing its structure, inserting a record, and querying the data to confirm SQL Plus is working correctly.
Conclusion and Call to Action00:05:06
The video concludes by summarizing the installation process and encourages viewers to like, comment, subscribe, and follow the creator's social media for more content and resources.