In BTM 382 Database Management, we use Oracle, the world’s most popular enterprise DBMS. I strongly recommend that for this course you install Oracle on your own computer, for the following reaons:
To start SQL Developer, go to the sqldeveloper directory under the sqldeveloperinstall directory, and do one of the following, as appropriate for your operating system: On Linux and Mac OS X systems, run sh sqldeveloper.sh. On Windows systems, double-click sqldeveloper.exe. The SQL Developer client looks for JDK 1.8 and above to launch it. If you don’t have the correct JDK version, it will download and install it. Install Option#2: Standalone SQL Developer Install. To overcome this fat installation of SQL developer, go for the stand-alone SQL Developer version.
- The project and one of the homework assignments will involve extensive use of Oracle. Without installing it on your own computer, it will be very difficult to succeed in these exercises and contribute effectively to your team project.
- For the sake of your learning, if you really want to know Oracle, the installation procedure is an important part of the learning experience.
- At the end of this class, you should all be able to add your knowledge of Oracle on your CVs. Beyond just knowing how to write Oracle SQL queries, it would be good to be able to specify that you also know how to install Oracle and set up databases.
That said, after explaining how to install Oracle, I provide a couple ways to run Oracle without actually installing it, each of which has some disadvantages.
Contents
- 1 How to install Oracle
- 2 How to run Oracle without installing it
How to install Oracle
![Installing Sql Developer On Parallels For Mac Installing Sql Developer On Parallels For Mac](/uploads/1/1/7/8/117850197/322247852.png)
There are two components to Oracle: the DBMS itself (called “Oracle Database”) and a graphical user interface called “SQL Developer”. (Note that the textbook uses a command-line interface that comes with the Oracle Database; I don’t recommend this.) Once you’ve installed Oracle Database and Oracle SQL Developer, you need to establish connections in SQL Developer to give yourself a suitable workspace. Here I present this installation and configuration in three steps.
1. Install Oracle Database (Windows and Linux only)
![Installing Installing](https://o7planning.org/en/10255/cache/images/i/20973.png)
You can install Oracle Database 11g XE Express Edition (the free version of Oracle). You can download it either from the course website (64-bit Windows, 384 MB, BTM 382 password required) or directly from Oracle for other versions (registration required). Here are some important notes:
- During installation, you will be asked to enter a password. REMEMBER THIS PASSWORD! If you forget it, then you will have no choice but to completely uninstall and then reinstall Oracle. A low security password is perfectly fine if you are only using Oracle locally on your own computer.
- Current versions of Oracle Database do not run on Apple OS X (welcome to the business computing world). To run it on an Apple computer, you must run Windows on your computer either using Boot Camp (recommended) or a virtual machine like Virtualbox or Parallels. You can see complete instructions in one of the tutorials linked below.
- Most BTM 382 students should have access to a free version of Windows in MyConcordia | Software and Applications | DreamSpark Premium | Popular.
2. Install Oracle SQL Developer (Windows and Linux only)
After installing Oracle Database, you can then install Oracle SQL Developer (also free). You can download it either from the course website (64-bit Windows, 373 MB, BTM 382 password required) or directly from Oracle for other versions (registration required). Here are some important notes:
- If you download SQL Developer yourself from Oracle, I recommend that you choose the version that includes the JDK. That avoids a lot of of potential problems with Java.
- Oracle SQL Developer is a Java application. It does not require installation; it only requires you to unzip the file and then find and run sqldeveloper64.exe. That’s it.
- Oracle SQL Developer does not work unless you have installed Oracle Database (see previous step), and it is running.
- Although there is an Apple OS X version of Oracle SQL Developer, it assumes that you are connecting to an Oracle Database on another computer (since Oracle Database doesn’t run on OS X). So, don’t choose the OS X version of SQL Developer; rather, choose the same operating system version for which you installed Oracle Database in the previous step.
3. Configure a dedicated user account for Oracle SQL Developer
Finally, after installing Oracle SQL Developer, you will probably want to create a dedicated user account with a dedicated connection as explained in the following video.
Other tutorials for installing Oracle Database and SQL Developer (including Mac)
In addition to the instructions above, here are some tutorials for installing Oracle:
- Official Oracle installation instructions for Windows and for Linux
- Video tutorial for installing Oracle XE and SQL Developer on Windows: Not a great tutorial, but the best I’ve found
- Tutorial for installing Oracle on Apple OS X
How to run Oracle without installing it
There are at least two free “online” versions of Oracle that let you run Oracle without actually installing it. (Oracle also has a cloud version, but it ain’t cheap–I won’t cover it here.) Althouth easy to get started, neither of these options lets you save your work in a persistent database; they only let you play around with SQL scripts.
SQL Fiddle
SQL Fiddle is without a doubt the easiest way to run SQL queries. It works not only for Oracle, but for many other major DBMSs, and so it’s a great way to dabble with and compare different SQL versions without the hassle of having to install them or dealing with virtual machines and incompatible operating systems. so, be sure to select Oracle (specifically, “Oracle 11g R2”) as the database in the top left drop-down box as shown here:
However, SQL Fiddle only supports very small databases, and so would not work for the project for this class. However, it is great for learning and quick tests. A good video tutorial is available on YouTube (though the tutorial isn’t specific to Oracle).
Oracle Live SQL
In 2016, Oracle launched Oracle Live SQL, a free, online version of Oracle. To use it, you need to sign up for a (free) Oracle account. Jeff Smith (Oracle SQL Developer guru) has an introductory article to the service.
At Parallels, we love sharing our customers’ success stories! Recently, Tim Goldstein, a leading business intelligence analyst, database architect, and senior developer specializing in the Microsoft SQL server tool set, implemented a more agile development process with Parallels Desktop for Mac. Goldstein’s new process has been a great success and proven Parallels Desktop to be a developer’s “Swiss Army Knife” of productivity! Below are a few quotes from Goldstein himself regarding how Parallels Desktop has helped him stay ahead of the competitive landscape in his personal business:
“Parallels allows me to run a full development environment on Windows, including SQL Server, Analysis Services Server, Visual Studio, and SQL Management console simultaneously with El Capitan. I am running this on an 11-inch MacBook Air with 8 GB of RAM and a two-core i7 processor.”
Not only is the Microsoft SQL Server Management Studio a crucial weapon in a developer’s tool kit but Goldstein leverages success by additionally using Microsoft Visual Studio, CorelDRAW, and Notepad++.
Install Sql Server On Mac
Above: “Windows 10 running Microsoft SQL Server, SQL Management Studio (SSMS), SQL Data Tools (a.k.a. Visual Studio) with an SSIS package, and working on an infographic for my speaking/training topic of “Engaging Technical Workers, Getting Business and Technical Staff Communicating” in CorelDRAW.”
Goldstein has additionally leveraged Parallels Desktop to save money for his business. He’s achieved this by not having to own multiple computers to complete his work as a senior developer. Thanks to his love of technology and the people who have helped him have such a great IT career, Goldstein, a Certified High Performance Coach, is simultaneously speaking, training, and mentoring executives on how to understand the mind of the technical worker. He can help you reach your next level just like Parallels Desktop has helped him reach his! In his own words:
“For my personal business in training executives to understand their technical workforce and training geeks to better handle the soft side of interviews, I work entirely on a Mac. Parallels has been a wonderful solution and a much easier company culture to deal with than competitors.”
Connect with Tim Goldstein via LinkedIn here, or check out his personal website here.
Installing Sql Developer On Parallels For Mac Windows 7
Need Microsoft Windows operating system? Buy Below:
Installing Sql Developer On Parallels For Mac Computer
Want to make your life easier with Parallels Desktop? Try it for free for 14 days: Try Now