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.
Instructor(s):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.
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.
Hide Syllabus
Lesson 1
- Oracle SQL and PL/SQL Developer
- Oracle SQL
- Relational Database Basics
- Creating Tables
- Basic Selects
- Oracle SQL Functions
- Aggregate Functions
- Joins
- Subqueries
- Set Operators
- Conditional Processing with CASE
- Data Manipulation Language
- Creating Views
- Oracle PL/SQL
- PL/SQL Basics
- Subprograms
- Conditional Processing
- Exceptions
- Cursors
- Packages
- Triggers
- 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
- Data
- Mathematics in Java
- Creating and Using Methods
- Java Objects
- 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
- Arrays
- Arrays
- Enhanced for Loops - the For-Each Loop
- Multi-Dimensional Arrays
- Typecasting with Arrays of Primitives
- Inheritance
- Inheritance
- Polymorphism
- Creating a Derived Class
- Example - Factoring Person Out of Employee and Dependent
- Typecasting with Object References
- Other Inheritance-Related Keywords
- Methods Inherited from Object
- Interfaces
- Interfaces
- Creating an Interface Definition
- Implementing Interfaces
- Reference Variables and Interfaces
- Interfaces and Inheritance
- Some Uses for Interfaces
- Exceptions
- Exceptions
- 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
- Iterators
- Creating Collectible Classes
- Generics
- Inner Classes
- Inner Classes, aka Nested Classes
- Final Exam
- Project: Hotel Reservations Case Study
Hide Syllabus