.jpg){kind=logo}
ATC-CIST1210.AE1
Oracle Database 12c: SQL Fundamentals (CIST1210)
Beginner Self-paced · 1 year access
68 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
8 Interactive Lessons · 57 topics01 Introducing Oracle Database 12c RDBMS Oracle Database 12c 5 topics · 3 LiveLab +
- Relational Database Management Systems
- The Oracle Database 12c
- Becoming Familiar with SQL*Plus
- Summary
- Exam Essentials
3 LiveLab in this lesson — see the labs panel →
02 Introducing SQL 5 topics · 25 LiveLab +
- SQL Fundamentals
- Writing Simple Queries
- Accepting Values at Runtime
- Summary
- Exam Essentials
25 LiveLab in this lesson — see the labs panel →
03 Using Single-Row Functions 8 topics · 7 LiveLab +
- Single-Row Function Fundamentals
- Using Single-Row Character Functions
- Using Single-Row Numeric Functions
- Using Single-Row Date Functions
- Using Single-Row Conversion Functions
- Using Other Single-Row Functions
- Summary
- Exam Essentials
7 LiveLab in this lesson — see the labs panel →
04 Using Group Functions 4 topics · 5 LiveLab +
- Group Function Fundamentals
- Utilizing Aggregate Functions
- Summary
- Exam Essentials
5 LiveLab in this lesson — see the labs panel →
05 Using Joins and Subqueries 5 topics · 11 LiveLab +
- Writing Multiple-Table Queries
- Using Set Operators
- Using Subqueries
- Summary
- Exam Essentials
11 LiveLab in this lesson — see the labs panel →
06 Manipulating Data 4 topics · 5 LiveLab +
- Using DML Statements
- Understanding Transaction Control
- Summary
- Exam Essentials
5 LiveLab in this lesson — see the labs panel →
07 Creating Tables and Constraints 7 topics · 12 LiveLab +
- Database Objects Overview
- Built-in Datatypes
- Creating Tables
- Modifying Tables
- Managing Constraints
- Summary
- Exam Essentials
12 LiveLab in this lesson — see the labs panel →
08 Video Tutorials 19 topics +
- Introduction
- Oracle 12c- SQL Fundamentals
- Basic Select Statements
- Using the Where Clause
- The Order By Clause
- Left And Right Outer Joins
- Multi-Table Selection Demo
- SQL Functions
- Using Group By clause
- Conversion Functions
- Subqueries
- Data Modification
- Implementing Security
- Creating Objects In The Database
- Using Sequences
- Indexes
- Views
- Combining Queries
- Oracle 12c SQL Fundamentals Review
Hands-On Labs Our edge
68 LiveLabs- Connecting to a Database
- Saving the SQL Buffer
- Clearing the SQL Buffer
- Creating a Table
- Inserting Records in the Existing Table
- Converting the String to the DATE Data Type
- Retrieving Data Using the SQL SELECT Statement
- Using the WHERE Clause
- Using the IN Operator
- Using the NULL Values in the SELECT Statement
- Using the Column Aliases
- Using the Concatenation Operator
- Using the DESCRIBE Command
- Using the DISTINCT Keyword
- Using the INEQUALITY Operator
- Using the Less Than Operator
- Using the Greater Than Operator
- Using the ANY Operator
- Using the ALL Operator
- Using the NOT Operator
- Using the AND Operator
- Using the BETWEEN Operator
- Using the EXISTS Operator
- Using the FETCH Clause
- Using the WITH TIES Clause
- Using the OFFSET-FETCH Clause
- Using the CASE Statement
- Using the Runtime Query
- Using the UPPER Function
- Using the SUBSTR Function
- Using the ROUND Function
- Using the TRUNC Function
- Using the Single-Row Date Function
- Using the ASCII Function
- Using the DECODE Function
- Retrieving Unique Columns
- Using the average Function
- Using the MIN Function
- Using the MEDIAN Function
- Using the LISTAGG Function
- Using the INNER JOIN Operation
- Using the Self Join
- Using the FULL OUTER JOIN
- Using the MINUS Operator
- Using the INTERSECT operator
- Using a Subquery
- Using the UNION Operator
- Creating a View
- Using the WITH Clause
- Using the GROUP BY Clause
- Using the HAVING Clause
- Updating a Table
- Deleting Rows from a Table
- Deleting Data from a Table
- Using the MERGE Statement
- Locking a Table
- Creating a Sequence
- Inserting Data Into a Table Using Sequence
- Retrieving the Next Value of Sequence
- Creating an Index
- Using the CREATE SYNONYM Statement
- Creating a Table with the INTERVAL Datatype
- Creating a Table from Another Table
- Creating a Table with Default Values
- Creating a Table with an Invisible Column
- Dropping a Table
- Renaming a Table
- Adding a Column
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
![1Z0-071.AO1: [ORACLE PRESS] Oracle Database SQL_Image](http://d3hu3i8dxloald.cloudfront.net/images/new/MHE-1Z0-071_pro.png?202608009V)
Prepare for Oracle Database 12c: SQL Fundamentals (CIST1210)
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 68 LiveLab included
- Certificate of completion
No credit card required