Requirements
-
You need to know how to use a computer, and hopefully, know how to use a spreadsheet.
-
No prior knowledge of Oracle SQL Database or any other database is required – although the more knowledge you do have, the better.
-
To install Oracle SQL Database on your computer, you will need a 64-bit machine.
-
Oracle SQL Database cannot easily be installed on the macOS because Oracle doesn’t support running an Oracle database directly on a Mac computer. You can’t install Oracle Express, for example, in the same way, that you can on a Windows computer. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
-
You don’t even need Oracle SQL Database installed – I’ll show you have to install it on your computer for free!
-
Why not have a look at the curriculum below and see what you can learn?
Description
This course is the foundation for the Oracle Database SQL 1Z0-071 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access. It is divided into 6 sessions, each of which should take a morning or afternoon to complete.
Lesson 1: Writing Basic SQL Statements
After completing this lesson, you should be able to do the following:
- List the capabilities of SQL SELECT statements
- Execute a basic SELECT statement
- Differentiate between SQL statements and SQL*Plus commands
Lesson 2: Restricting and Sorting Data
After completing this lesson, you should be able to do the following:
- Limit the rows retrieved by a query
- Sort the rows retrieved by a query
Lesson 3: Single-Row Functions
After completing this lesson, you should be able to do the following:
- Describe various types of functions available in SQL
- Use character, number, and date functions in SELECT statements
- Describe the use of conversion functions
Lesson 4: Displaying Data from Multiple Tables
After completing this lesson, you should be able to do the following:
- Write SELECT statements to access data from more than one table using equality and nonequality joins
- View data that generally does not meet a join condition by using outer joins
- Join a table to itself
Lesson 5: Aggregating Data Using Group Functions
After completing this lesson, you should be able to do the following:
- Identify the available group functions
- Describe the use of group functions
- Group data using the GROUP BY clause
- Include or exclude grouped rows by using the HAVING clause
Lesson 6: Subqueries
After completing this lesson, you should be able to do the following:
- Describe the types of problems that subqueries can solve
- Define subqueries
- List the types of subqueries
- Write single-row and multiple-row subqueries
Lesson 7: Multiple-Column Subqueries
After completing this lesson, you should be able to do the following:
- Write a multiple-column subquery
- Describe and explain the behavior of subqueries when null values are retrieved
- Write a subquery in a FROM clause
Who this course is for:
- This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL.
- This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required
