Full Oracle SQL tutorials
Oracle 12c Tutorial
Updated on Sep, 2023
Language - English
Course Description
This course offers you an introduction to the Oracle Database technology.
Completing this course will equip you with essential SQL skills. Some of the tasks you can do with these skills include querying single and multiple tables, inserting data in tables, creating tables, and querying metadata.
You will gain an understanding of RDBMS. You are also introduced to Oracle SQL Developer and SQL*Plus as development environments used for executing SQL statements, and for formatting and reporting purposes.
Goals
What will you learn in this course:
- Prepare for Oracle Database SQL Certified Associate
- Understand the basic concepts of relational databases ensure refined code by developers.
- Create reports of sorted and restricted data.
- Run data manipulation statements (DML).
- Control database access to specific objects.
- Retrieve row and column data from tables.
Prerequisites
What are the prerequisites for this course?
- No prerequisites required only your interest in Coding
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
SQL Introduction
01:15
01:15
Environment Setup
3 Lectures
Retrieving Data Using the SQL SELECT Statement
10 Lectures
Restricting and Sorting Data
14 Lectures
Using Single-Row Functions
11 Lectures
Using Conversion Functions and Conditional Expressions
11 Lectures
Aggregated Data Using the Group Functions
7 Lectures
Displaying Data from Multiple Tables Using Joins
9 Lectures
Using Subqueries to Solve Queries
4 Lectures
Using Set Operators
2 Lectures
Managing Tables Using DML Statements
4 Lectures
Introduction to Data Definition Language
4 Lectures
Instructor Details
Benjamin
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now