Learn the key concepts of Structured Query Language (SQL) and gain a solid working knowledge of this powerful database programming language.
Requirements:
Hardware Requirements:
- This course must be taken on a PC.
- Dual monitors are helpful but not required.
Software Requirements:
- PC: Windows 10 or later (not the Home Edition).
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS (download and installation instructions are provided in course). Please view the required specs ahead of time to make sure that your system is compatible.
- Oracle SQL Developer - The client interface for connecting to Oracle (download and installation instructions are provided in course).
- Anaconda (download and installation instructions are provided in course).
- Java (download and installation instructions are provided in course).
- Visual Studio Code (download and installation instructions are provided in course).
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
In today's data-driven world, businesses of all sizes desire expert database use and management—and you can be one of the people to fulfill this growing need. As a database developer, software programmer, or data analyst, you'll need a robust knowledge of Structured Query Language (SQL). In this course, you'll learn both SQL and the Java programming language.
Oracle SQL is a powerful database programming language that is the standard in the industry. This SQL course provides even more value because it combines Oracle training with sections on PL/SQL Developer and Java Programming, so you learn multiple technologies in one. This course is the best way to learn SQL and is ideal for those looking to get started in each of these coding languages. By the end of the course, you'll be prepared to join the job market as an entry-level Oracle SQL and/or Java Developer, or take on more responsibility within your current role.
- Oracle SQL and PL/SQL Developer
- Oracle SQL
- Oracle PL/SQL
- Oracle SQL Developer Final Project
- Java Programmer
- Java Introduction
- Java Basics
- Java Objects
- Mid-term exam
- Comparisons And Flow Control Structures
- Arrays
- Inheritance
- Interfaces
- Exceptions
- Collections
- Inner Classes
- Final Exam
- Project: Hotel Reservations Case Study
What you will learn
- How to use Oracle SQL to communicate with relational databases, including updating and retrieving data.
- The various uses of the PL/SQL procedural language extension and the basics of using blocks, subprograms, and triggers.
- All about the Java environment and syntax, from arrays, inheritance, and interfaces to exceptions and collections.
How you will benefit
- Gain skills and knowledge that are highly in demand in the programming, software development, and database management industries.
- Prepare yourself to enter an exciting new field-or excel even more in your current position.
- Earn a certificate of completion and add your new expertise to your resume.
Nat Dunn
Nat Dunn founded Webucator in 2003 to combine his passion for technical training with his business expertise and to help companies benefit from both. His previous experience was in sales, business and technical training, and management. Nat has an MBA from Harvard Business School and a BA in International Relations from Pomona College.