Mastering Oracle SQL is one today's most marketable programming skills for end-to-end developers. This online, self-paced course covers the basics of Oracle SQL. You will learn the fundamentals, including queries, procedures, and functions through hands-on assignments. By course completion, your SQL skills will be on par with industry standards.
What you will learn
- How tables are structured and how data is stored
- To use Oracle to output reports and to use SQL functions
- To group data to get aggregate values
- To write joins and subqueries to get data from multiple tables and to write INSERT, UPDATE, and DELETE statements
- To use SET operators and to do conditional processing with CASE
How you will benefit
- Gain skills that every developers needs
- Bring your SQL skills to any web development job
Instructor(s):Self-Study
Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
- Oracle SQL Developer - The client interface for connecting to Oracle (software not included).
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Adobe Acrobat Reader.
Other:
- Software must be installed and fully operational before the course begins.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Hide Syllabus
Lesson 1
- Relational Database Basics
- Creating Tables
- Basic Selects
- Oracle SQL Functions
- Aggregate Functions
- Subqueries
- Set Operators
- Conditional Processing with CASE
- Data Manipulation Language
- Creating Views
Hide Syllabus
Login/Create account
checkout
view cart (
0
)
