Oracle SQL: beginner Oracle 12c
- 15 Courses | 11h 35m 20s
- 8 Books | 52h 44m
- Includes Lab
Master Oracle SQL in-depth.
COURSES INCLUDED
Relational Database Concepts
As an administrator or developer, it's important to understand the object-relational aspects of Oracle Database 12c. Learn about data models, the Entity Relationship Model, and the Oracle HR sample schema.
10 videos |
38m
Assessment
Badge
SQL Developer
Oracle offers a free integration development environment, SQL Developer. Learn about SQL Developer, including creating connections, using SQL Worksheet, debugging, modeling data, and linking to external tools.
16 videos |
1h 1m
Assessment
Badge
SQL*Plus Commands
SQL*Plus is an interactive and batch query tool that is installed with every Oracle Server and client installation. Learn about the features and functionality of SQL*Plus, including editing, file, and output commands.
7 videos |
24m
Assessment
Badge
SELECT Statement, Expressions, & Operators
SQL*Plus provides a convenient way to work with Oracle data. Learn to retrieve data using SELECT statements with arithmetic expressions, NULL values, column aliases, and literal strings. In addition, learn how to handle duplicate rows.
12 videos |
42m
Assessment
Badge
Restricting Output
Database tables often hold a large number of rows, which aren't necessarily sorted. Learn how to selectively return only a subset of rows, sorted and customized, using operators, conditions, wildcards, and clauses.
10 videos |
44m
Badge
Working with Substitution
Learn how to build dynamic queries in Oracle Database 12c using substitution variables and the DEFINE and VERIFY commands.
5 videos |
23m
Badge
Customizing Output
In Oracle Database 12c, you have the ability to use functions to return and analyze data in a large variety of ways. Learn about character, case-conversion, numeric, nesting, date, and numeric functions.
13 videos |
57m
Badge
Data Conversion
Frequently when retrieving data stored in an Oracle database it needs to be converted, manipulated, or aggregated. Learn about the Oracle conversion functions and conditional expressions.
13 videos |
52m
Badge
Aggregating Data
Grouping data according to specific conditions allows you to create more effective reports and analyze data in more productive ways. Explore group functions, grouping data, and the clauses used for grouping in Oracle Database 12c.
12 videos |
45m
Badge
Working with Joins
It's important to minimize data redundancy in a relational database. Learn how to view information across multiple tables with joins and use advanced SELECT features to obtain values based on an unknown conditional value.
17 videos |
1h 1m
Badge
Working with Subqueries
It's not uncommon to need more than one query to get to the data results you require. Learn about using subqueries to solve problems in Oracle Database 12c.
11 videos |
38m
Badge
Data Manipulation Language
Oracle Database 12c objects contain data, and that data needs to be managed. Learn about manipulating tables by inserting, updating, deleting, and truncating rows.
14 videos |
1h 3m
Badge
Database Transactions
It's important to ensure that the SQL statements that make up a transaction succeed or fail as a group. Explore the concepts of database transaction control using the COMMIT, ROLLBACK, and SAVEPOINT commands.
10 videos |
45m
Assessment
Badge
Working with SET Operators
SET operators allow you to combine the results of two queries into one. Learn how to use SET operators and match SELECT statements in Oracle Database 12c.
8 videos |
26m
Badge
Working with DDL
There's a lot of flexibility available in how you create tables to store data in an Oracle 12c database. Learn about how to create tables, choose the proper data type for columns, set constraints, and change or delete existing tables.
18 videos |
1h 10m
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Beginning Oracle SQL: For Oracle Database 12c, Third EditionOffering an introduction to the interactive query tools and specific dialect of SQL used with Oracle Database, this easy-going, example-based guide will get you started down the path to successfully writing SQL statements and getting results from Oracle Database.
7h 15m
By Inger Jørgensen, Lex de Haan, Melanie Caffrey, Tim Gorman
Book
Oracle SQL: A Beginner's Tutorial, Second EditionBy providing exercises and examples of real world applications, this informative reference enables developers to master the skills necessary to perform intermediate tasks in SQL right away.
1h 33m
By Djoni Darmawikarta
Book
Oracle SQL: The Best SQL Book in the GalaxyFrom the basics to advanced levels of Oracle SQL, this must-read book educates readers with numerous SQL examples and explanations, and reveals clever tricks and examples to provide an expert level of learning.
1h 29m
By Leona Coffing, Tom Coffing
Book
Introduction to SQL and PL/SQLIncluding a large number of examples, practical questions, objective questions, and FAQs, this book provides a complete guide to the practical implementations of DBMS concepts including SQL and PL/SQL development.
5h 23m
By Ruchin Jain, Sharad Maheshwari
Book
Expert Oracle SQL: Optimization, Deployment, and StatisticsAssuming you have already identified a particular SQL statement and are considering taking steps to improve its performance, this Oracle-specific book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system.
11h 31m
By Tony Hasler
Book
Pro Oracle SQL, Second EditionComprehensive and performance-focused, this book will enable you to work at a truly professional level in the Oracle dialect of SQL and will help you master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL.
11h 9m
By Jared Still, Karen Morton, Kerry Osborne, Riyaj Shamsudeen, Robyn Sands
Book
Oracle SQL: A Beginner's TutorialBy providing exercises and examples of real world applications, this informative reference enables developers to master the skills necessary to perform intermediate tasks in SQL right away.
1h 10m
By Djoni Darmawikarta
Book
Real-World SQL and PL/SQL: Advice from the ExpertsShowing how to fully exploit lesser known but extremely useful SQL and PL/SQL features, this book offers best practices, detailed examples, and insider tips that clearly demonstrate how to write, troubleshoot, and implement code for a wide variety of practical applications.
13h 14m
By Alex Nuijten, Arup Nanda, Brendan Tierney, Heli Helskyaho, Martin Widlake
SHOW MORE
FREE ACCESS
