Learn the key concepts of Structured Query Language (SQL) and gain a solid working knowledge of this powerful database programming language.
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.
- This course must be taken on a PC.
- Dual monitors are helpful but not required.
- PC: Windows 8 or newer.
- 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).
- 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).
- 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
- Relational Database Basics
- Creating Tables
- Basic Selects
- Oracle SQL Functions
- Aggregate Functions
- Set Operators
- Conditional Processing with CASE
- Data Manipulation Language
- Creating Views
- Oracle PL/SQL
- PL/SQL Basics
- Conditional Processing
- Oracle SQL Developer Final Project
- Java Programmer
- Java Introduction
- Conventions in These Notes
- The Java Environment - Overview
- Writing a Java Program
- Obtaining The Java Environment
- Setting up your Java Environment
- Creating a Class That Can Run as a Program
- Useful Stuff Necessary to go Further
- Using the Java Documentation
- Java Basics
- Basic Java Syntax
- Mathematics in Java
- Creating and Using Methods
- Java Objects
- String, StringBuffer, and StringBuilder
- Creating Documentation Comments and Using Javadoc
- Mid-term exam
- Comparisons And Flow Control Structures
- Controlling Program Flow
- Additional Loop Control: break and continue
- Classpath, Code Libraries, and Jar files
- Enhanced for Loops - the For-Each Loop
- Multi-Dimensional Arrays
- Typecasting with Arrays of Primitives
- Creating a Derived Class
- Example - Factoring Person Out of Employee and Dependent
- Typecasting with Object References
- Other Inheritance-Related Keywords
- Methods Inherited from Object
- Creating an Interface Definition
- Implementing Interfaces
- Reference Variables and Interfaces
- Interfaces and Inheritance
- Some Uses for Interfaces
- Attempting Risky Code - try and catch
- Guaranteeing Execution of Code - the finally Block
- Letting an Exception be Thrown to the Method Caller
- Throwing an Exception
- Exceptions and Inheritance
- Creating and Using Your Own Exception Classes
- Rethrowing Exceptions
- Initializer Blocks
- Generics and Collections
- Fundamental Collections: Sets, Lists, and Maps
- Creating Collectible Classes
- Inner Classes
- Inner Classes, aka Nested Classes
- Final Exam
- Project: Hotel Reservations Case Study
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.