This video shows the steps required to download and install SQL Developer, connect using SQL Developer to and Oracle instance and perform a quick overview of the graphical interface.
- [Instructor] SQL Developer is not included…as part of the Oracle software installation,…and we'll need to go grab it from Oracle.com…for us to use it.…So, in your virtual machine,…please switch to your web browser.…In the Google search box, type download SQL Developer.…The first result will be Oracle SQL Developer downloads.…Click on that link.…Click on accept license agreement.…
And remember, you have to be registered with Oracle…in order to be able to download SQL Developer.…If not, you can always register free account.…I have already registered.…You can select which operating system…you plan to run SQL Developer on.…As you can see, we have multiple options.…Windows 64-bit, Windows 32-bit, Mac OS,…Linux and more.…That's because SQL Developer is the go-to tool…for many Oracle users when they either want to…open a connection from their desktop or laptop computers…to an Oracle database and work with that database…or when running SQL Developer locally…on the same server as the Oracle database.…
We'll use option number two in our example,…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 58s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.