English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 25h 26m | 13.1 GB
Become an In-demand SQL Professional & Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!
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?
Then this is the course you are looking for.
You have come to the right place!
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.
So come on, what are you waiting for?
Get this course, and go get a better job!
Benefits of Taking This SQL Course:
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.
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!
Table of Contents
Database Concepts
1 What is a Database
2 Why Oracle Database
3 What is a Table
4 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)
5 What is a Relational Database (RDBMS)
6 Entity Relationship Logic in Databases
7 What is Pluggable Database
8 Introduction to Database Objects
9 The Sample (HR) Schema Used in This Course
10 What is SQL
11 Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples)
Software Download & Installation
12 Oracle-Master-Training-Scripts-to-Unlock-the-HR-Schema
13 About the Database Installation
14 Which Option to Choose to Have a Database
15 Option 1 Having the Database with the Oracle Virtual Box
16 Option 2 Downloading And Installing Oracle Database
17 Option 2 Unlocking the HR Schema
18 Option 2 Configuring and Using the SQL Developer
19 Option 3 Using Oracle Live SQL
20 SQL Statements Used in This Course
21 Changing-Virtual-Machine-Keyboard-Settings
22 Don’t Forget to Leave a Rating!
23 Option 1 How to Install the Virtual Box on Mac OS X
24 Option 3 Warning About Oracle Live SQL Limitations
25 The Working Document
Retrieving Data
26 Oracle Data Types
27 What is a NULL Value
28 DESCRIBE Command
29 INFORMATION Command
30 SQL Statement Basics
31 Oracle Error Messages
32 Using SELECT Statements
33 Using Column Aliases
34 Quote (Q) Operator
35 DISTINCT and UNIQUE Operator
36 Concatenation Operators
37 Arithmetic Expressions and NULL Values
38 CODE Using Column Aliases
39 CODE Using SELECT Statements
Restricting Data
40 Using WHERE Clause
41 Comparison Operators
42 BETWEEN … AND Operator
43 IN Operator
44 LIKE Operator
45 IS NULL Operator
46 Logical Operators (AND, OR, NOT)
47 Rules of Precedence
48 SQL-Quiz-by-Oracle-Master-Training
Sorting Data
49 ORDER BY Clause
50 ASC and DESC Operators
51 NULLS FIRST and NULLS LAST Operators
52 ROWNUM & ROWID in SQL
53 Oracle FETCH Clause
Using Substitution Variables
54 What is a Substitution Variable
55 Double Ampersand (&&) and DEFINE & UNDEFINE Commands
56 ACCEPT and PROMPT Commands
57 SET VERIFY ON SET VERIFY OFF Commands
Single-Row Functions
58 Single Row Functions
59 Character Functions – Case Conversion (LOWER, UPPER, INITCAP) Functios
60 Character Functions – Character Manipulation Functios (Part 1)
61 Character Functions – Character Manipulation Functions Part 2 (INSTR Function)
62 Character Functions – Part 3 (TRIM, LTRIM, RTRIM Functions)
63 Character Functions – Part 4 (REPLACE, LPAD, RPAD Functions)
64 Numeric Functions
65 Nested Functions
66 Date Values & Date Formats in Oracle
67 Date Functions & Arithmetic Operations on Dates
68 Date Manipulation Functions in SQL
Conversion Functions
69 Conversion Functions
70 TO CHAR, TO DATE, TO NUMBER Functions (Part 1)
71 TO CHAR, TO DATE, TO NUMBER Functions (Part 2)
72 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions
Conditional Expressions
73 Oracle Conditional Expressions CASE Expressions
74 Oracle Conditional Expressions DECODE Function
Group Functions
75 Group Functions
76 AVG Function
77 COUNT Function
78 MAX Function
79 MIN Function
80 SUM Function
81 LISTAGG Function
82 Overview Of Group Functions
Grouping Data
83 GROUP BY Clause (Part 1)
84 GROUP BY Clause (Part 2)
85 HAVING Clause
86 Nested Group Functions
Joining Multiple Tables
87 What is a Join & Oracle SQL Join Types
88 Creating a Join
89 Natural Join
90 Join with the USING Clause
91 Handling Ambiguous Column Names
92 Inner Join & Join with the ON Clause
93 Multiple Join Operations
94 Restricting Joins
95 Self Join
96 Non-Equijoins (Joining Unequal Tables)
97 OUTER JOINS
98 LEFT OUTER JOIN (LEFT JOIN)
99 RIGHT OUTER JOIN (RIGHT JOIN)
100 FULL OUTER JOIN (FULL JOIN)
101 Cross Join (Cartesian Product Cross Product)
102 Oracle’s Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)
103 Oracle’s Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)
104 Oracle’s Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)
105 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins
106 Which Join Type Should You Use
107 Entity-Relationship Models in DBMS – How to Use Them with Joins
Using Subqueries
108 Using Subqueries
109 Single Row Subqueries
110 Multiple Row Subqueries
111 Multiple Column Subqueries
112 Using Subqueries as a Table
113 SCALAR Subqueries
114 Correlated Subqueries
115 EXISTS Operator & Semijoins
116 NOT EXISTS Operator
Working with the Oracle SET Operators
117 Introduction to SET Operators in Oracle SQL
118 UNION and UNION ALL Operators
119 INTERSECT Operator
120 MINUS Operator
121 Matching Unmatched Queries in SET Operations
122 Using the ORDER BY Clause with SET Operators
123 Combining Multiple Queries Using the SET Operators
Data Definition Language (DDL) Statements
124 Data Definition Language (DDL)
125 Naming Rules & Naming Conventions in Oracle
126 CREATE TABLE Statement
127 CREATE TABLE AS SELECT (CTAS) Statement in Oracle
128 ALTER TABLE Statement
129 Marking Columns Unused (Using The SET UNUSED Clause)
130 READ-ONLY Tables in SQL
131 DROP TABLE Statement
132 TRUNCATE TABLE Statement
133 COMMENT Statement
134 RENAME Statement
Data Manipulation Language (DML) Statements
135 Data Manipulation Language (DML)
136 INSERT Statement (Part 1)
137 INSERT Statement (Part 2)
138 Multitable Insert Statements
139 Unconditional Insert Statements (INSERT ALL Statements)
140 Conditional INSERT ALL Statements
141 Conditional INSERT FIRST Statements
142 Pivoting Insert
143 UPDATE Statement
144 DELETE Statement
145 MERGE Statement
146 (TCL) Transaction Control Statements
147 COMMIT and ROLLBACK Statements
148 SAVEPOINT Statement
149 FOR UPDATE Statement
150 Good News!
Creating Constraints
151 Creating Constraints
152 NOT NULL Constraint
153 UNIQUE Constraint
154 PRIMARY KEY Constraint
155 FOREIGN KEY Constraint
156 CHECK Constraint
Appendix
157 Appendix 1 Oracle Database 12c Installation into Your Computer
158 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c
159 Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c
Conclusion + Reward!
160 Conclusion
161 Bonus Lecture
162 Code-Samples
163 Course Gifts(SQL Cheatsheet & SQL Certification Exam Samples)
Resolve the captcha to access the links!