Courses
Web Development
Business
Design
Marketing
IT & Software
Photography
Music
View All Courses
Log in Sign Up
Call us
800 388 80 90
329 Queensberry Street,
North Melbourne VIC 3051, Australia.
hi@educrat.com
Popular Categories
Web Development Data Science Design Business Marketing Programming
image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659
Log in Sign up
Home
All courses
Oracle Database 12c Certified Professional - SQL Foundations
Oracle Database
IT & Software
IT Certifications

Oracle Database 12c Certified Professional - SQL Foundations

A step-by-step guide to introduce you to Oracle's unique SQL requirements and prepare you for the first official exam.

4.3
(135)
927 enrolled on this course
Last updated 11/2021
Infinite Skills
image
₹ 799.0
₹ 2299.0
Buy Now
30-Day Money-Back Guarantee
Lessons
20
Quizzes
3
Duration
13 Hours
Skill level
Beginner
Language
English
Certificate
Yes
Full lifetime access
Yes

Description

In this multi-part video course, you'll learn the fundamentals of the SQL programming language in Oracle, and get specific guidance for the first test in the Oracle certification track. This course is designed for the beginner, meaning no experience with Oracle 12c is required.

You will start by learning about the Oracle relational database, then jump into learning about the SQL SELECT statement. From there, author Steve Ries will teach you about conditionals in SQL, conversion functions, and implicit and explicit joins. This video tutorial also covers subqueries, data manipulation, and data definition language. Finally, you will learn about the exam, and Steve will provide you with hints and strategies to help you prepare.

Once you have completed the course, you will be fully capable of working with the SQL programming language, and in doing so, you will be much better prepared for the Oracle Database 12c SQL Fundamentals exam. Project files are included, allowing you to follow along with the author throughout the lessons.
Who this course is for:
IT professionals and developers interested in approaching Oracle from a professional perspective

What you'll learn

work proficiently with SQL within an Oracle environment

approach Oracle certification with a confident understanding of SQL fundamentals

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
3
1.1-Important - Download These First - Working Files
1.2-What You Should Expect From This Course
1.3-How To Access Your Working Files
2-The Oracle Relational Database
5
2.1-The Relational Database
2.2-The Oracle 12C RDBMS
2.3-Structured Query Language
2.4-Setting Up SQL Developer
2.5-Setting Up Oracle APEX
3-The SQL SELECT Statement
7
3.1-The Syntax Of SQL
3.2-Projecting Columns In A SQL Statement
3.3-Using DESCRIBE
3.4-Using Aliases In SQL
3.5-Arithmetic Operators
3.6-Displaying Unique Values With DISTINCT
3.7-Concatenating Values
4-Conditionals In SQL Statements
10
4.1-Selectivity And WHERE Clause Syntax
4.2-Conditions Of Equality
4.3-Conditions Of Non-Equality
4.4-Range Conditions With BETWEEN
4.5-Set Conditions With IN
4.6-Pattern Matching With LIKE
4.7-Boolean Conditions
4.8-Sorting Data With ORDER BY
4.9-Sort Ordering And Secondary Sorts
4.10-Ampersand Substitution
5-Row Level Data Transformation
6
5.1-Understanding Single-Row Functions
5.2-Case Conversion Functions
5.3-Basic String Manipulation Functions
5.4-Advanced String Manipulation Functions
5.5-Date Functions
5.6-Arithmetic Functions
6-Conversion Functions And Conditional Expressions
4
6.1-Date To Character Conversion
6.2-Character To Date Conversion
6.3-Numeric Conversion
6.4-Conditional Expression Functions
7-Aggregate Data Transformation
4
7.1-Group Functions
7.2-Grouping Data With GROUP BY
7.3-Row Exclusion With HAVING
7.4-Using SQL Clauses Together
8-Combining Data
10
8.1-Explicit Versus Implicit Join Notation
8.2-Implicit Cartesian Joins
8.3-Implicit Equijoins
8.4-Implicit Outer Joins
8.5-Explicit Cross Joins
8.6-Ambiguous Explicit Joins With NATURAL JOIN
8.7-Explicit Column Joins With JOIN USING
8.8-Fully Specified Explicit Joins With JOIN ON
8.9-Self Joins And Non-Equijoins
8.10-0810 Multi-Table Joins
9-Subqueries And Set Operators
8
9.1-Solving Problems With Subqueries
9.2-Basic Scalar Subqueries
9.3-Advanced Scalar Subqueries
9.4-Multi-Row Subqueries
9.5-Correlated Subqueries
9.6-Multi-Column Subqueries
9.7-Nested Subqueries
9.8-Using Set Operators
10-Data Manipulation And DML
4
10.1-Create Data With INSERT
10.2-Modify Data With UPDATE
10.3-Remove Data With DELETE And TRUNCATE
10.4-Transaction Control
11-Data Definition Language
12
11.1-The Purpose Of DDL
11.2-Oracles Schema Based Approach
11.3-Database Objects
11.4-Column Datatypes
11.5-The CREATE TABLE Statement
11.6-Avoiding Datatype Errors
11.7-Modifying Tables With ALTER TABLE
11.8-The NOT NULL Constraint
11.9-PRIMARY KEY Constraint
11.10-FOREIGN KEY Constraint
11.11-UNIQUE Constraint
11.12-CHECK Constraint
12-Certification Exam Preparation
2
12.1-About The Exam
12.2-Hints And Strategies For Preparation
13-Conclusion
1
13.1-Wrap Up

You May Like

10,000+ unique online course list designs

Oracle Cloud: Oracle cloud database administration
3.8
(101)
Oracle Cloud: Oracle cloud database administration
icon
14 lessons
icon
N/A
icon
Beginner
U
Unknown
$999.0
$999.0