Oracle SQL from Zero to Hero
- Description
- Curriculum
- FAQ
- Reviews
Unlock the power of Oracle SQL with this engaging course designed specifically for beginners preparing for the Oracle Database SQL Certified Associate (1Z0-071) Exam. Whether you are new to SQL or looking to build foundational skills in Oracle databases, this course provides everything you need to succeed in your journey.
Starting from scratch, you will learn how to retrieve, sort, filter, and restrict data effectively. The course covers essential SQL topics such as group functions, joins, subqueries, and set operators, ensuring you have a comprehensive understanding of how to manage and query data efficiently. Additionally, you will explore key database object management skills, including creating and managing tables, views, indexes, sequences, and constraints.
What sets this course apart is its hands-on approach. You will work through real-world examples, interactive demos, quizzes, and practice sessions to build practical and applicable skills. The curriculum is designed to not only help you pass the 1Z0-071 certification exam but also prepare you to tackle everyday database challenges with confidence.
By the end of this course, you will have the knowledge and expertise to write effective SQL queries and work with Oracle databases, setting you on a path to success in your career and certification goals.
-
11Introduction to Oracle SQLVideo lesson
-
12Retrieving Data ( Part 1 )Video lesson
-
13Retrieving Data ( Part 2 )Video lesson
-
14Retrieving Data ( Part 3 )Video lesson
-
15Restricting DataVideo lesson
-
16Practice - Retrieving and Restricting DataText lesson
-
17Quiz - Retrieving and Restricting DataQuiz
-
23Using Single-Row FunctionsVideo lesson
-
24Practice - Using Single-Row FunctionsText lesson
-
25Quiz - Using Single-row FunctionsQuiz
-
26Working with DATE Data TypeVideo lesson
-
27Practice - Working with DATE Data TypeText lesson
-
28Using Conversion Functions ( Part 1 )Video lesson
-
29Using Conversion Functions ( Part 2 )Video lesson
-
30Practice - Using Conversion FunctionsText lesson
-
31Converting Character to DATE Data TypeVideo lesson
-
32Practice - Converting Character to DATE Data TypeText lesson
-
33Quiz - Using Conversion FunctionsQuiz
-
34Functions to Handle Null ValuesVideo lesson
-
35Practice - Functions to Handle Null ValuesText lesson
-
48Using Scalar SubqueriesVideo lesson
-
49Practice - Using Scalar SubqueriesText lesson
-
50Using Multiple-Row SubqueriesVideo lesson
-
51Using Multiple-Column SubqueriesVideo lesson
-
52Using Subqueries - More OptionsVideo lesson
-
53Practice - Using SubqueriesText lesson
-
54Quiz - SubqueriesQuiz
-
60Using DML Statements - INSERT ( Part 1 )Video lesson
-
61Using DML Statements - INSERT ( Part 2 )Video lesson
-
62Using DML Statements - UPDATEVideo lesson
-
63Using DML Statements - DELETEVideo lesson
-
64Using DML Statements - MERGEVideo lesson
-
65Practice - Using DML StatementsText lesson
-
66Quiz - DMLQuiz
-
67Using Transaction Control Commands ( Part 1 )Video lesson
-
68Using Transaction Control Commands ( Part 2 )Video lesson
-
69Demo - Using Transaction Control CommandsVideo lesson
-
70Practice - Using Transaction Control CommandsText lesson
-
71Read Consistency and Locking Data ( Part 1 )Video lesson
-
72Read Consistency and Locking Data ( Part 2 )Video lesson
-
73Demo - Read Consistency and Locking DataVideo lesson
-
74Practice - Using Transaction Control CommandsText lesson
External Links May Contain Affiliate Links read more