Excellent Teaching
Oracle SQL Online Training
Master Oracle SQL and become a certified Oracle SQL professional with this comprehensive video course.
Oracle SQL,Development,Databases
Lectures -43
Duration -5 hours
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Oracle SQL is a powerful database language that is used to manage and query data in Oracle databases. If you are looking to advance your career in database administration or software development, Oracle SQL certification is a valuable credential to have.
Oracle SQL Online Training Overview
This course will teach you everything you need to know to pass the Oracle SQL certification exam. You will start by learning the basics of Oracle SQL, including the different types of SQL statements, the different data types, and the different operators.
Then, you will learn how to use Oracle SQL to perform a variety of database tasks, such as:
Creating and managing tables
Inserting, updating, and deleting data from tables
Retrieving data from tables
Creating and using views
Creating and using stored procedures
Analyzing data
By the end of this course, you will be a certified Oracle SQL professional. You will be able to use Oracle SQL to manage and query data in Oracle databases, and you will be a valuable asset to any organization.
Key benefits of this course
Comprehensive coverage of Oracle SQL
Practice exams to prepare for the certification exam
Expert instructors with years of experience
Lifetime access to the course materials
Who is this course for?
This course is for anyone who wants to learn Oracle SQL and become a certified Oracle SQL professional. Whether you are a beginner or an experienced database administrator, you will find this course to be informative and helpful.
Goals
What will you learn in this course:
Learn fundamentals of Oracle SQL
Learn about the different types of SQL statements
Learn about different data types and the different operators.
Understand how you can use Oracle SQL to manage and query data
Learn how to create and manage tables
Learn inserting, updating, and deleting data from tables, and retrieving data from tables.
Learn how to create and use views
Learn how to create and use stored procedures, and analyze data.
Preparing for the Oracle SQL certification exam
Learn how to develop expertise in Oracle SQL
Prerequisites
What are the prerequisites for this course?
Basic programming knowledge
Knowledge of databases is a plus
Curriculum
Check out the detailed breakdown of what’s inside the course
Oracle - SQL
42 Lectures
- Oracle - SQL - Introduction 13:32 13:32
- Oracle - SQL - Environment Setup 03:35 03:35
- Oracle - SQL - Getting Started 02:05 02:05
- Oracle - SQL - DDL Statements 04:19 04:19
- Oracle - SQL - Create Table 08:51 08:51
- Oracle - SQL - Alter Table 09:01 09:01
- Oracle - SQL - Drop Table 01:08 01:08
- Oracle - SQL - Truncate Table 02:25 02:25
- Oracle - SQL - Constraints 07:10 07:10
- Oracle - SQL - Not Null Constraint 05:13 05:13
- Oracle - SQL - Unique Constraint 07:49 07:49
- Oracle - SQL - Primary Key Constraint 04:09 04:09
- Oracle - SQL - Check Constraint 04:14 04:14
- Oracle - SQL - Foreign Key Constraint 06:14 06:14
- Oracle - SQL - Managing Constraints 05:59 05:59
- Oracle - SQL - Data Manipulation Language 02:16 02:16
- Oracle - SQL - Insert Statement 09:29 09:29
- Oracle - SQL - Update Statement 03:44 03:44
- Oracle - SQL - Delete Statement 01:46 01:46
- Oracle - SQL - Merge Statement 07:25 07:25
- Oracle - SQL - Managing Transactions 14:46 14:46
- Oracle - SQL - Select Statement 11:46 11:46
- Oracle - SQL - Sorting Data 07:04 07:04
- Oracle - SQL - Filtering Data 20:53 20:53
- Oracle - SQL - Functions 03:44 03:44
- Oracle - SQL - Character Functions 08:45 08:45
- Oracle - SQL - Number Functions 03:58 03:58
- Oracle - SQL - Date Functions 07:55 07:55
- Oracle - SQL - Conversion Functions 09:02 09:02
- Oracle - SQL - General Functions 07:05 07:05
- Oracle - SQL - Joins 27:39 27:39
- Oracle - SQL - Group Functions 03:12 03:12
- Oracle - SQL - Group By Clause 07:49 07:49
- Oracle - SQL - Advanced Grouping 07:02 07:02
- Oracle - SQL - Subqueries 13:26 13:26
- Oracle - SQL - Advanced Subqueries 11:28 11:28
- Oracle - SQL - Creating Sequences 07:29 07:29
- Oracle - SQL - Creating Index 05:30 05:30
- Oracle - SQL - Creating Synonyms 02:22 02:22
- Oracle - SQL - Creating Users 01:39 01:39
- Oracle - SQL - Managing User Access 07:42 07:42
- Oracle - SQL - Managing Roles 02:24 02:24
Instructor Details
Tutorialspoint
Simply Easy LearningTutorials Point originated from the idea that there exists a class of readers who respond better to online content and prefer to learn new skills at their own pace from the comforts of their drawing rooms.
The journey commenced with a single tutorial on HTML in 2006 and elated by the response it generated, we worked our way to adding fresh tutorials to our repository which now proudly flaunts a wealth of tutorials and allied articles on topics ranging from programming languages to web designing to academics and much more.
40 million readers read 100 million pages every month
Our Text Library Content and resources are freely available and we prefer to keep it that way to encourage our readers acquire as many skills as they would like to. We don't force our readers to sign up with us or submit their details either to use our Free Text Tutorials Library. No preconditions and no impediments, Just Simply Easy Learning!
We have established a Digital Content Marketplace to sell Video Courses and eBooks at a very nominal cost. You will have to register with us to avail these premium services.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
Very good teaching
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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now