Corso The Complete Oracle SQL Bootcamp (2021)

Abstract

Course delivered in English
Lessons: 19
Level: Advanced
Access: Paid Online Course (price may vary)

Become an In-demand SQL Professional & Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!

Knowing SQL can get you a better job or improve the one you have and it can earn you $80-100k+ in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, this is why it's so popular and backed by Oracle. This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts of how to write SQL codes easily and thinking analytically against the problem in your company.

This course includes:

19 sections • 161 lectures • 25h 26m total length
25 hours on-demand video
11 articles
16 downloadable resources
Full lifetime access
Access on mobile and TV
Assignments
Certificate of completion

Requirements

Nothing more than a working computer; all PC, Mac or Linux, etc. users are all welcome.
No previous programming experience is required!
No paid tools are required!

Description

Are you a student ready to learn SQL for your lessons?
Do you want to get a better job?
Are you bored with watching a lot of stuff, but could not learn anything?
Do you think you know SQL, but you cannot write SQL codes?
Are you looking for a really professional course?

In this course, all the subjects are explained in a professional order.

If you are new to SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects. After completing this course, you will learn all that you need to know. If you don't see something in this course, it means you really don't need to know it for now. Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.

★ Last Course Updates: ✔ (Jul, 2021): 3-Real SQL(200+ High-Quality Questions) Certification Exam Samples are added!

Important Notice: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL.

Obiettivi didattici

Course content

Section 1 - Database Concept - 11 lectures, 1,05 Hours

What is a Database - 07,44 min
In this lecture, our students going to learn what a database is and why we need to use the databases.
Why Oracle Database - 07:00
What is a Table - 3,40 min
In this lecture, our students going to learn what a table is and why we need to use the tables.
UDEMY 101: How to Use Udemy? + Some Useful Tips (Do not Skip) - 05,01 min
This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.
Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples) - 00:34 min
What is a Relational Database (RDBMS)? - 07:52 min
Entity Relationship Logic in Databases - 03:46 min
What is Pluggable Database? - 03:13 min
In this lecture, you're going to learn what the pluggable database (multitenant architecture) is in Oracle Database.
Introduction to Database Objects - 13:26 min
The Sample (HR) Schema Used in This Course - 07:23 min
What is SQL - 05:02
Section 1 : Quiz - Section: Database Fundamentals Quiz
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "SQL Database Concepts quiz".

Section 2 -Software Download & Installation - 14 lectures, 1,34 Hours

About the Database Installation - 03:02 minWhich Option to Choose to Have a Database? - 09:18 min
Option 1: Having the Database with the Oracle Virtual Box - 16:29 min
Option 1: How to Install the Virtual Box on Mac OS X? - 01:41 min
Option 2: Downloading And Installing Oracle Database - 18:18 min
Option 2: Unlocking the HR Schema - 07:34 min
Option 2: Configuring and Using the SQL Developer - 22:14 min
Option 3 : Using Oracle Live SQL - 07:40 min
Option 3: Warning About Oracle Live SQL Limitations - 00:33 min
SQL Statements Used in This Course - 05:29 min
The Working Document - 00:16 min
Don't Forget to Leave a Rating! - 00:13 min

Section 3 - Retrieving Data - 14 lectures, 1,34 Hours

Oracle Data Types - 06:54 min
What is a NULL Value? - 05:10 min
DESCRIBE Command- 04:25 min
INFORMATION Command - 08:13 min
SQL Statement Basics - 13:56 min
Oracle Error Messages - 06:51 min
Using SELECT Statements - 06:00 min
CODE: Using SELECT Statements - 00:05 min
Using Column Aliases - 07:26 min
CODE: Using Column Aliases - 00:10 min
Quote (Q) Operator - 08:53 min
DISTINCT & UNIQUE Operator - 07:42 min
Concatenation Operators - 07:46 min
Arithmetic Expressions and NULL Values - 10:05 min
Section 2 : Quiz - 5 questions
You can test your sql skills with our quizzes. Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 4 - Restricting Data - 9 Lectures - 1,10 hours

Using WHERE Clause - 04:41
Comparison Operators - 06:33
BETWEEN … AND Operator - 05:48
IN Operator - 11:10 min
LIKE Operator - 11:21 min
IS NULL Operator - 05:21 min
Logical Operators (AND, OR, NOT) - 14:23 min
Rules of Precedence - 10:41 min
Quiz - Oracle SQL Quiz about Section 2 : Retrieving Data with using SQL.
10 questions You can evaluate your SQL knowledge and skills with our quizzes.

Section 5 - Sorting Data - 5 Lectures, 55 min

ORDER BY Clause - 15:12 min
ASC and DESC Operators - 09:55 min
NULLS FIRST and NULLS LAST Operators - 04:24 min
ROWNUM & ROWID in SQL - 12:48 min
Oracle FETCH Clause - 13:02 min
Section: Quiz 5 questions
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "Sorting data quiz".

Section 6 - Using Substitution Variables - 4 Lectures, 55 min

What is a Substitution Variable? - 15:50 min
Double Ampersand (&&) and DEFINE & UNDEFINE Commands - 18:52 min
ACCEPT and PROMPT Commands - 08:17 min
SET VERIFY ON / SET VERIFY OFF Commands - 08:07 min

Section 7 - Single Row Functions - 11 Lectures, 2,56 min

Single Row Functions - 12:33 min
Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios - 15:12 min
Character Functions - Character Manipulation Functios (Part 1) - 14:27 min
Character Functions - Character Manipulation Functions Part 2 (INSTR Function) - 11:06 min
Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions) - 20:15 min
Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions) - 11:37 min
Numeric Functions - 16:32 min
Nested Functions - 15:24 min
Date Values & Date Formats in Oracle - 22:33 min
Date Functions & Arithmetic Operations on Dates - 16:43 min
Date Manipulation Functions in SQL - 19:20 min
Section: Quiz - Single-Row Functions Quiz
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "Single-row functions quiz".

Section 8 - Conversion Functions - 4 Lectures, 1,04 min

Conversion Functions - 10:23 min
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1) - 17:28 min
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2) - 16:17 min
Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions - 19:46 min
Section: Quiz 6 questions - Section: SQL Conversion Functions Quiz
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "Conversion functions quiz".

Section 9 - Conditional Expressions - 2 Lectures, 32 min

Oracle Conditional Expressions: CASE Expressions - 22:23 min
Oracle Conditional Expressions: DECODE Function - 09:21 min
Section Quiz 5 questions
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "Conditional Expressions quiz".

Section 10 - Group Functions - 8 Lectures, 50 min

Group Functions - 07:41 min
AVG Function - 09:31 min
COUNT Function - 06:06 min
MAX Function - 04:35 min
MIN Function - 04:16 min
SUM Function - 03:40 min
LISTAGG Function - 09:56 min
Overview Of Group Functions - 03:48 min
Section Group Functions Quiz
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "Group functions quiz".

Section 11 - Grouping Data - 4 Lectures, 41 min

GROUP BY Clause (Part 1) - 15:30 min
GROUP BY Clause (Part 2) - 11:55 min
HAVING Clause - 09:06 min
Nested Group Functions - 04:29 min
Grouping Data Quiz - 7 questions
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "Grouping data quiz".

Section 12 - Joining Multiple Tables - 21 Lectures, 3,28 hours

What is a Join? & Oracle SQL Join Types - 07:23 min
Creating a Join - 03:01 min
Natural Join - 10:19 min
Join with the USING Clause - 05:42 min
Handling Ambiguous Column Names - 10:27 min
Inner Join & Join with the ON Clause - 07:20 min
Multiple Join Operations - 12:19 min
Restricting Joins - 03:31 min
Self Join - 06:00 min
Non-Equijoins (Joining Unequal Tables) - 13:15 min
OUTER JOINS - 08:32 min
LEFT OUTER JOIN (LEFT JOIN) - 13:20 min
RIGHT OUTER JOIN (RIGHT JOIN) - 09:42 min
FULL OUTER JOIN (FULL JOIN) - 04:04 min
Cross Join (Cartesian Product / Cross Product) - 17:15 min
Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1) - 14:22 min
Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2) - 16:33 min
Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3) - 09:54 min
The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins - 14:24 min
Which Join Type Should You Use? - 03:41 min
Entity-Relationship Models in DBMS - How to Use Them with Joins? - 17:17 min
Joining Multiple Tables Quiz - 10 domande
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "SQL joins", "SQL joining tables quiz".

Section 13 - Using Subqueries - 9 Lectures, 2 Hours

Using Subqueries - 08:07 min
Single Row Subqueries - 15:23 min
Multiple Row Subqueries - 18:23 min
Multiple Column Subqueries - 17:50 min
Using Subqueries as a Table - 08:26 min
SCALAR Subqueries - 16:01 min
Correlated Subqueries - 16:34 min
EXISTS Operator & Semijoins - 11:17 min
NOT EXISTS Operator - 06:34 min
Section Using Subqueries: Quiz - 5 domande
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "SQL subqueries test".

Section 14 - Working with the Oracle SET Operators - 7 Lectures, 58 min

Introduction to SET Operators in Oracle SQL - 14:58 min
UNION and UNION ALL Operators - 14:46 min
INTERSECT Operator - 02:53 min
MINUS Operator - 04:26 min
Matching Unmatched Queries in SET Operations - 06:20 min
Using the ORDER BY Clause with SET Operators - 08:11 min
Combining Multiple Queries Using the SET Operators - 06:27 min
Section SQL SET Operators: Quiz - 5 domande
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "SQL SET Operators quiz".

Section 15 - Data Definition Language (DDL) Statements - 11 Lectures, 1,49 hours

Data Definition Language (DDL) - 04:23 min
Naming Rules & Naming Conventions in Oracle - 11:16 min
CREATE TABLE Statement - 09:34 min
CREATE TABLE AS SELECT (CTAS) Statement in Oracle - 13:49 min
ALTER TABLE Statement - 19:26 min
Marking Columns Unused (Using The SET UNUSED Clause) - 09:21 min
READ-ONLY Tables in SQL - 07:08 min
DROP TABLE Statement - 08:18 min
TRUNCATE TABLE Statement - 10:22 min
COMMENT Statement - 09:37 min
RENAME Statement - 05:37 min
Section Data Definition Language (DDL) Assessment: Quiz - 5 domande
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "DDL quiz", "SQL DDL test".

Section 16 - Data Manipulation Language (DML) Statements - 16 Lectures, 2,32 hours

Data Manipulation Language (DML) - 05:17 min
INSERT Statement (Part 1) - 14:44 min
INSERT Statement (Part 2) - 19:50 min
Multitable Insert Statements (DML) - 02:57 min
Unconditional Insert Statements (INSERT ALL Statements) - 11:15 min
Conditional INSERT ALL Statements - 14:08 min
Conditional INSERT FIRST Statements - 06:58 min
Pivoting Insert - 10:04 min
UPDATE Statement - 12:16 min
DELETE Statement - 05:21 min
MERGE Statement - 20:55 min
Good News! - 00:32 min
(TCL) Transaction Control Statements - 03:28 min
COMMIT and ROLLBACK Statements - 07:07 min
SAVEPOINT Statement - 08:37 min
FOR UPDATE Statement - 08:21 min
Section Data Manipulation Language (DML): Quiz - 5 domande

Section 17 - Creating Constraints - 6 Lectures, 47 min

Creating Constraints - 04:46 min
NOT NULL Constraint - 05:52 min
UNIQUE Constraint - 10:28 min
PRIMARY KEY Constraint - 07:03 min
FOREIGN KEY Constraint - 13:59 min
CHECK Constraint - 04:44 min
Section 15 : Quiz - 5 domande
You can evaluate your SQL knowledge and skills with our quizzes.
Related Keywords: "SQL", "SQL programming", "SQL quiz", "SQL Constraints quiz", "SQL Constraints test".

Section 18 - Appendix - 3 Lectures, 20 min

Appendix 1: Oracle Database 12c Installation into Your Computer - 08:58 min
Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c? - 01:37 min
Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c - 09:53 min

Section 19 - Conclusion + Rewards - 4 Lectures, 2 min

Conclusion - 00:31 min
Course Code Samples - 10 pagine
Course Gifts(SQL Cheatsheet & SQL Certification Exam Samples) - 00:35 min
Bonus Lecture - 00:33 min

Struttura del corso

Benefits of Taking This SQL Course:

What you'll learn

Pass Oracle 1Z0-071 SQL Database SQL Certification Exam easily on your first try!
Be Able to Answer any SQL Interview Questions Confidently!
Become a Job-Ready SQL Developer by Learning All the Skills You will Need!
Learn Oracle SQL by Professionally Designed Content Step by Step!
Write, Read and Analyze Any SQL Queries Easily and Learn How to Play with Data!
Solve any SQL-related Problems by Yourself Creating Analytical Solutions!
Test Your SQL Skills with Hundreds of Hands-on Examples, Quizzes, Challenges!
Lifetime Support from the Instructors. Get a Well-Organized Recap Document!

This course is added onto our catalogue to help you to preparing for Amazon Oracle SQL 1Z0-071 (OCA) Certification Exam. Learning this topic opens up opportunities to become an In-demand SQL Professional.

Who this course is for:

Anyone willing to step into the software development career!
Anyone dreaming to get a well-paid SQL Development Job!
Anyone planning to Pass the Oracle 1Z0-071 (OCA) exam!
Anyone who wants to Become an in-demand SQL Professional!

We are confident that this learning material will allow you to improve considerably your comprehension and allow you to access many other amazing technical courses in our catalogue. This class is the foundation of a computer science curriculum and fundamental for anyone approaching to Coding and looking to become a tech digital professional. This is why Guilds42 has introduced this Course, even if it is not a free course.

This course is managed by the external partner Udemy. In order to take this course you will need to register on their Academy platform where you can take advantage of this and many other courses on offer. This course however is not a free course but it is considered an excellent valuable asset to make you better yourself.

Once you have obtained your certification, save it on your device in Jpg or Pdf format and go back to the course page, in Guilds42, to upload it to the appropriate box and validate your skills.

Provider

Tutti i corsi

Coding

Corso aperto dal 13/09/2021

Durata 25

Corso The Complete Oracle SQL Bootcamp (2021)

Questo corso include: