Oracle Database: SQL Fundamentals
- Beginner
- 18 and older
- $2,995
- 33 Wood Avenue S, Iselin, NJ
- over 5 sessions
Thankfully we have 13 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.
Noble Desktop - Virtually Online
Unlock the power of SQL and relational databases with this comprehensive course. Learn how to write SQL queries, filter results, and combine data from multiple tables, all while gaining a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.
Apr 1st
10am–5pm EDT
May 14th
6–9pm EDT
Meets 2 Times
This class has 3 more dates.
Tap here to see more
Noble Desktop - Virtually Online
Enhance your SQL skills by mastering Outer Joins, NULL data, grouping, aggregate functions, filtering, and working with dates/times. Extract and analyze specific data from databases, turning raw information into valuable insights. Prerequisite: SQL proficiency equivalent to Noble Desktop's SQL Level 1 course.
Apr 2nd
10am–5pm EDT
May 21st
6–9pm EDT
Meets 2 Times
This class has 3 more dates.
Tap here to see more
Noble Desktop - Virtually Online
Take your SQL skills to the next level with this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Gain in-depth techniques that will prepare you for a job in data analysis or data science.
Noble Desktop - Virtually Online
In this course, students will master Excel, SQL, and Tableau, some of the top data analytics tools. Here, students will gain the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.
Apr 1st
10am–5pm EDT
Meets 8 Times
May 13th
10am–5pm EDT
Meets 8 Times
May 14th
6–9pm EDT
Meets 16 Times
Noble Desktop - Virtually Online
Master the art of turning raw data into actionable insights with SQL queries. This hands-on course will teach you how to filter, group, and join data, as well as use advanced techniques like subqueries and aggregate functions. Gain the skills to excel in any data-driven industry and make more informed decisions.
Apr 30th
10am–5pm EDT
Meets 3 Times
This class has 3 more dates.
Tap here to see more
Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This course introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). One will become acquainted with the differences in the working environment between a traditional on-premise database installation and the Oracle database service cloud-computing platform. This course also considers intermediate-level SQL topics such as writing database queries using the SQL-99 syntax and exploiting the power of built-in functions that extend the capabilities of SQL.
Since SQL is an industry standard language, many of the topics presented and many of the skills you will acquire will be applicable to other database platforms, such as Microsoft SQL Server, IBM DB2, the open-source databases MySQL and PostgreSQL, and others.
This course takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.
You will learn how to complete of an application schema definition by creating database objects such as relational views, sequences, synonyms, indexes and others to compliment the table definitions. The crucial topic of data integrity and how this is protected using declarative constraints is covered.
With this course we will also leave the idyllic realm of the learning environment and begin to explore such practical real-world considerations as database object security and database performance.
Note: This course content is applicable to versions 12c, 18c, and 19c.
Target Audience
The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are:
This course and the subsequent ones within this series consider subjects applicable to certification as an Oracle Database Certified SQL Expert. The topics considered are included within "Exam 1Z0-047: Oracle Database: SQL Certified Expert".
Objectives
The first portion of this course considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data.
This course also demonstrates how one can build intermediate-level and even advanced queries using the SQL-99 join syntax, along with other advanced query topics. It also considers both ANSI/ISO and native Oracle SQL built-in functions and the tremendous power that functions offer to SQL operations. It is difficult for one to use SQL within a production environment without liberal use of the built-in functions. Among many other tasks, the built-in functions allow one to move beyond the use of primitive date data types and values to include timestamps, time zones and to address other realistic date and time challenges. Finally attention is given to how one completes an application schema by creating database objects to compliment table definitions. One cannot implement a production database application simply with table and column definitions but needs to create and manage views, indexes, constraints and other object types.
OUTLINE
RELATIONAL DATABASES & DATA MODELS
SQL FUNCTIONS: CHARACTER HANDLING
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
Cancellation / Reschedule by Student
Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.
Please note the following policies:
Substitutions
Make-up Policy
Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.
Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.
In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.
People who viewed this class also viewed the following classes
Get quick answers from CourseHorse and past students.
ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.
Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...
Read more about ONLC Training Centers
This school has been carefully vetted by CourseHorse and is a verified Online educator.
Booking this class for a group? Find great private group events
Or see all Professional Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.
More in Database
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.