Oracle SQL Course
Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle Database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user's reques
Oracle strives to comply with industry-accepted standards and participates actively in SQL standards committees.
Skilled Instructors
Flexible Learning
Interactive Content
Hands-on Experience
Personalized Learning Paths
Career Support
Course Modules
-
What is a Database?
-
Oracle Database
-
What is a Database?
-
Oracle Database
-
Data Model
-
Normalization
-
ALTER, DROP, TRUNCATE, & CREATE
-
UPDATE, INSERT, SELECT, & DELETE
-
GRANT, REVOKE
-
COMMIT, SAVEPOINT, & ROLLBACK
-
MySQL - Create,Drop,Select,Show,Copy Database
-
Listing Capabilities of the SQL Select Statements
-
Select Specific Columns
-
Select All Columns
-
Use the Column Heading Defaults
-
DESC Command
-
BETWEEN, IN, NOT IN, AND, OR, LIKE, IS, IS NULL, EXISTS, NOT NULL
-
Data Types-character,number,row and long
-
Data Types-Time & Date,Large Objects & Pseudo Columns
-
Constraints-unique,primary key,foreign key
-
Constraints-check,not null,null,default
-
Add/Delete,Rename,show Columns
-
Outer join, inner join & types of join
-
Union,intersect
-
Numeric Functions: CIEL, FLOOR, ABS, MOD, REMAINDER, POWER, SIGN, TRUNC, ROUND
-
Character Functions: CONCAT, CHR, INITCAP, LOWER, REPLACE, LTRIM, RTRIM, SUBSTR, INSTR, LENGTH
-
Time/Date Functions
-
UPPER, LOWER, AND INITCAP
-
COUNT, MAX, MIN, SUM, AVG
-
Sub Queries
-
Set Operators: UNION ALL, INTERSECT, MINUS, and UNION
-
ORACLE PL/SQL
-
PL/SQL Loops
-
Functions, Procedures
-
PL/SQL Cursor
-
Live Projects
-
Deployments