Summary
Highlights
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.
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.
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.
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.
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.
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.