Overview
Designed for those new to writing SQL queries, this course is perfect for those who love to learn and like working with data. You will cover essential topics such as relational database basics, table creation, and data manipulation language. The curriculum focuses on helping you learn and apply key concepts, including SQL functions, joins, subqueries, and PL/SQL programming techniques like subprograms and triggers. By the end of this Oracle training program, you will apply your knowledge in a final SQL-focused project.
Your training concludes with you learning advanced concepts such as AI-assisted coding, which enables developers to enhance productivity and efficiency using tools like ChatGPT and other AI resources. Prepare to enter the job market as an entry-level Oracle SQL developer or take on more responsibility within your current career!
- Course ID: GES336
- Total Hours: 150
- Format: Asynchronous/Self-Paced
- Location: Online
- Schedule: 6 Months
- Credit(s) Earned: 15 CEU
- Instructor: Ed2go
- Cost: $1,900.00
- Category: Programming/Web Development
Hardware Requirements:
This course must be taken on a PC.
Dual monitors are helpful but are not required.
Software Requirements:
PC: Windows 10 or later (not the Home Edition).
Browser: The latest version of Chrome (preferred), Microsoft Edge, or Firefox browsers.
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).
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.
What You Will Learn
Build applications or generate business reports using Structured Query Language (SQL)
Master SQL using an Oracle database
Use PL/SQL extension language to write sophisticated queries against an Oracle database
Program Outcomes
Turn your passion for working with data into a profession by learning to write SQL queries
Prepare to enter the job market as an entry-level Oracle SQL Developer or to take on more responsibility in your current role
Set yourself apart from competitors by taking a challenging course in PL/SQL development


