Information Technology, Control, Audit and Security Experience

Lets learn a little on how to interact with a database using a language called SQL . If you are already familiar with SQL, then this post is NOT for you. This blog post is tailored for beginners with interest in the query language. SQL means S tructured Q uery L anguage. Simply put, it is used to communicate with a database in order to define, access, or manipulate it's data.

Have you always desired to test on the fly, a script you just thought up to see if it would work? If you are that someone like me then you are in luck as Oracle Corporation has designed something for us (those guys think of everything). Ladies and Gentlemen, I introduce to you ORACLE LIVE SQL. Disclaimer: Please note that I am in no way affiliated to Oracle nor was I paid to spin this hype.😀

Oracle Database: Acclaimed as the world most flexible and robust database management system is the result of over 3 decades of innovative development. Founded by Larry Ellison, Bob Miner, and Ed Oates in 1977. Oracle’s first relational database (ORACLE version 2) was born in 1979. Please note that there was no version 1, as Larry Ellison, knew consumers will not have faith in buying version 1 😀😀. The most recent database version now is Oracle 12c. In today’s post, I will show you how to install oracle 11g database on a Microsoft Windows PC. This will be done using Oracle Database 11g Release 2 Software. System Requirement Minimum Recommended It is important that while preparing for installation, the following minimum requirement should be met: Random Access Memory(RAM) with minimum of 1GB in size. Note  that Oracle always recommends more RAM be available than specified in the system requirements. This avoids performance problems like paging and swapping du...