The Complete Oracle Sql Bootcamp (2023)

[SKIKDA]

Last updated 8/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 19.58 GB | Duration: 38h 22m

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

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!

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
Welcome to the MOST COMPREHENSIVE Oracle SQL Bootcamp Course on the planet!Latest Course UpdatesAug 2023) : Brand New Content (Managing Oracle Privileges and Roles) was added!(Jun 2023) : Brand New Content (Using Oracle FLASHBACK Technologies) was added!(May 2023) : 3-Real SQL(Over 200+ High-Quality Questions) Certification Exam Samples are added! (Feb 2023) : More Quiz Questions were added!Important Notice: This course will be continuously getting updated with more lectures, quizzes, and assessments to enhance your knowledge of Oracle SQL.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 are in the right place!In this course, all the subjects are explained in professional order. If you are new to SQL, no problem! You can easily learn 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!Topics covered in the Complete Oracle SQL Bootcamp 2023 Courseatabase Concepts & TerminologiesWhat is a Database?What is the Oracle Database?What is a pluggable database?What is SQL?What is a database table?What is Relational-Database Management System (RDBMS)?What is the Entity-relationship model in SQL?What is a database schema? Installing Oracle Sample Schemas (HR, SH, OE, IX, etc.)Introduction to Database ObjectsDownloading and Installing the Oracle Database (Version 12c, 18c, 19c, 21c, etc.)Downloading the Oracle Database Installation FileInstalling Oracle Database into Your Local ComputerWorking with a Database via a Virtual MachineDownloading and Installing a Virtualization Software (Virtual Box, VMWare)Downloading Pre-built Virtual Machine ImageImporting Virtual Machine into Virtualization SoftwareConfiguring, Using, and Working with Virtual Machines through Virtualization SoftwareDownloading, Installing, Configuring, and Using the Oracle SQL Developer SoftwareConnecting to the Oracle Database Using SQL Developer and SQL PlusConfiguring SQL Developer for the first useConfiguring Network Connections to work with Oracle Sample SchemasWorking with Oracle Live SQLIntroduction to Oracle Live SQL PlatformHow to use Oracle Live SQLRetrieving Data from the Database Using SELECT StatementsWhat is NULL?SELECT StatementsUsing Column Aliases in SQLDISTINCT and UNIQUE Operators in SQLConcatenation Operators in SQLThe Quote (q) Operator in SQLFiltering & Restricting Data returned by SQL Queries using the WHERE ClauseUsing the WHERE Clause in SQLUsing Oracle Comparison Operators in SQLBETWEEN AND Operator in SQLIN Operator in SQLLIKE Operator in SQLIS NULL Operator in SQL Logical Operators in SQL: AND Logical OperatorOR Logical OperatorNOT Logical OperatorOracle Rules of Precedence in SQLSorting Data using the ORDER BY ClauseUsing the ORDER BY ClauseUsing the ASC and DESC OperatorsUsing the NULLS FIRST and NULLS LAST OperatorsUsing the FETCH Clause Using Oracle Substitution VariablesWhat are Substitution Variables? Double Ampersand (&&) and DEFINE & UNDEFINE CommandsACCEPT and PROMPT CommandsSET VERIFY ON / SET VERIFY OFF CommandsUsing Oracle Single-Row Functions to Customize the Query OutputsIntroduction to Oracle Single-Row FunctionsCharacter FunctionsCase Conversion FunctionsUPPER FunctionLOWER FunctionINITCAP FunctionCharacter Manipulation FunctionsSUBSTR Function in SQL LENGTH Function in SQL CONCAT Function in SQL INSTR Function in SQL TRIM Function in SQL LTRIM and RTRIM Functions in SQL REPLACE Function in SQL LPAD and RPAD Functions in SQL Numeric Functions ROUND Function in SQLTRUNC Function in SQL CEIL Function in SQL FLOOR Function in SQL MOD Function in SQLNested SQL Group Functions Date Data Types and SQL Date FunctionsDate Data Types DATE Data Type in SQLTIMESTAMP Data Type in SQL TIMESTAMP WITH TIME ZONE Data Type in SQL TIMESTAMP WITH LOCAL TIME ZONE Data Type in SQLOracle Date Functions SYSDATE Function in SQLCURRENT_DATE Function in SQLSESSIONTIMEZONE Function in SQLSYSTIMESTAMP Function in SQLCURRENT_TIMESTAMP Function in SQLDate Manipulation FunctionsADD_MONTHS FunctionMONTHS_BETWEEN FunctionROUND FunctionTRUNC FunctionEXTRACT FunctionNEXT_DAY FunctionLAST_DAY FunctionOracle Conversion Functions TO_CHAR Function in SQLTO_NUMBER Function in SQLTO_DATE Function in SQLNull Related Functions in SQLNVL FunctionNVL2 FunctionNULLIF FunctionCOALESCE FunctionConditional Expressions in SQLCASE Expressions in SQLDECODE Function in SQLReporting Aggregated Data Using the Group FunctionsIntroduction to Oracle Group FunctionsAVG Function in SQLCOUNT Function in SQLMAX Function in SQLMIN Function in SQLLISTAGG Function in SQLOverview of Group Functions in SQLDisplaying Data from Multiple Tables Using JoinsWhat is a SQL Join?Join Types in Oracle SQLHow to Create a Join in SQLNatural JoinJoin with the USING ClauseHandling Ambiguous Column Names While Joining Multiple TablesInner Join (Join with the ON Clause)Multiple Join OperationsRestricting JoinsSelf-JoinNon-Equijoins (Joining Unequal Tables)Outer Joins in SQLLEFT OUTER JOIN (LEFT JOIN)RIGHT OUTER JOIN (RIGHT JOIN)FULL OUTER JOIN (FULL JOIN)Cross Join (Cartesian Product or Cross Product)Oracle's Old Style Join Syntax (Comparison of ANSI vs. Non-ANSI SQL Join Syntaxes)Using & Building & Analyzing SubqueriesWhat is a Subquery in SQL?How to Use Subqueries in SQL?Subquery Types in SQL:Single-Row Subqueries in SQLMultiple-Row Subqueries in SQLMultiple-Column Subqueries in SQLSCALAR Subqueries in SQLCorrelated Subqueries in SQLUsing Subqueries as a TableUsing the EXISTS Operator (Semijoins in SQL)Using the NOT EXISTS OperatorWorking with Oracle SET OperatorsWhat are SET Operators and Why are They Used?UNION OperatorUNION ALL OperatorMINUS OperatorINTERSECT OperatorCombining Multiple Queries Using Multiple SET Operators in Complex SQL QueriesUsing Data Manipulation Language (DML) StatementsINSERT Statement UPDATE Statement DELETE StatementMERGE StatementMultiple INSERT StatementsUnconditional INSERT (INSERT ALL) Statements Conditional INSERT ALL StatementsConditional INSERT FIRST StatementsPivot Insert in SQLUsing Transaction Control Language (TCL) StatementsWhat is a transaction in SQL?TCL CommandsCOMMIT and ROLLBACK Statements in SQLRow Locking Mechanism in SQLSAVEPOINT Statement in SQLFOR UPDATE Statement in SQLUsing Data Definition Language (DDL) StatementsWhat are Data Definition Language StatementsNaming Rules & Naming Conventions in OracleCreating Tables using the CREATE TABLE statementsCREATE TABLE AS SELECT (CTAS) Statement in OracleALTER TABLE StatementMarking Columns Unused (Using The SET UNUSED Clause)READ-ONLY Tables in SQLDROP TABLE StatementTRUNCATE TABLE StatementCOMMENT StatementRENAME StatementCreating, Using, Working, and Managing ConstraintsWhat is a Constraint in SQL?Oracle Constraint TypesNOT NULL ConstraintUNIQUE ConstraintPRIMARY KEY ConstraintFOREIGN KEY ConstraintThe ON DELETE CASCADE ClauseThe ON DELETE SET NULL ClauseCHECK ConstraintAdding Constraints via ALTER TABLE StatementsDropping (Removing) ConstraintsCascading Constraints in OracleRenaming ConstraintsEnabling / Disabling ConstraintsStatus of Constraints Deferring (Deferrable) ConstraintsCreating, Using, and Managing Database Views in DetailsWhat is a Database View and What is it Used for?View Types in OracleCreating Simple ViewsCreating Complex ViewsModifying ViewsPerforming DML Operations with ViewsUsing the WITH CHECK OPTION Clause in SQLUsing the WITH READ ONLY Clause on ViewsManaging Objects Using Oracle Data Dictionary ViewsWhat are Data Dictionary views in Oracle?The DICTIONARY View (The Main Dictionary)USER, ALL, DBA, and V$ Prefixes in Data Dictionary ViewsUSER_OBJECTS, ALL_OBJECTS, and DBA_OBJECTS ViewsUSER_TABLES, ALL_TABLES, and DBA_TABLES Data Dictionary ViewsUSER_TAB_COLUMNS Data Dictionary ViewUSER_CONSTRAINTS Data Dictionary ViewUSER_CONS_COLUMNS Data Dictionary ViewUSER_VIEWS Data Dictionary ViewUSER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary ViewsCreating and Using, Working with Sequences in SQLWhat is a Sequence?Creating SequencesModifying SequencesUsing SequencesUsing Sequences as Default ValuesSequence CachingThe USER_SEQUENCES ViewUsing the IDENTITY Column in OracleCreating and Using SynonymsWorking with IndexesManaging Schema ObjectsRetrieving Data By Using SubqueriesManipulating Data By Using SubqueriesControlling User Access in DetailsManaging Data in Different Time ZonesBENEFITS OF TAKING THIS SQL COURSE:Knowing SQL can get you a better job or improve the one you have and it can earn you $100k+ per/year 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 think analytically against the problem in your company.STUDENT REVIEWS PROVE THIS COURSE'S WORTH: Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.Many students had also taken other SQL courses in the past, only to find that this SQL course was their favorite. They enjoyed the structure of the content and the high-quality audio/video.Check out all of the great reviews in the review section ... a lot of happy students :-)IMPORTANT NOTE:Knowing SQL is "mandatory" for any IT Professional and having good SQL knowledge will be a "GREAT PLUS" for you!If you want to Become a Job-Ready SQL Professional who can pass any Oracle SQL Exam confidently, this course will be the next step for you!So let's do this! I'll see you in the first lecture!

Overview
Section 1: Database Concepts

Lecture 1 What is a Database?

Lecture 2 Why Oracle Database?

Lecture 3 What is a Table?

Lecture 4 UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)

Lecture 5 The Working Document (Course Slide for Course Participants)

Lecture 6 Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples)

Lecture 7 What is a Relational Database (RDBMS)?

Lecture 8 Entity Relationship Logic in Databases

Lecture 9 What is Pluggable Database?

Lecture 10 Introduction to Database Objects

Lecture 11 The Sample (HR) Schema Used in This Course

Lecture 12 What is SQL?

Section 2: Software Download & Installation

Lecture 13 About the Database Installation

Lecture 14 The Ways to Get a Database

Lecture 15 Option 1: Installing VMware and VirtualBox on Windows

Lecture 16 Option 1: How to Install the Virtual Box on Mac OS X?

Lecture 17 Option 1: Downloading Virtual Machine Image (19c)

Lecture 18 Option 1: Downloading Virtual Machine Image

Lecture 19 Option 1: Configuring the VMware Virtualization Software

Lecture 20 Option 1: Configuring the Oracle VirtualBox Virtualization Software

Lecture 21 Option 1: Configuring SQL Developer inside of the Virtual Machine

Lecture 22 Important Note

Lecture 23 Option 2: Downloading And Installing Oracle Database

Lecture 24 Option 2: Unlocking the HR Schema

Lecture 25 Option 2: Configuring and Using the SQL Developer

Lecture 26 Option 2: Installing Sample Schemas in Oracle Database

Lecture 27 Option 2: HR Schema Create Code (if you could not get the HR user in other ways)

Lecture 28 Option 3 : Using Oracle Live SQL

Lecture 29 Option 3: Oracle Live SQL Limitations

Lecture 30 SQL Statements Used in This Course

Lecture 31 Don't Forget to Leave a Rating!

Section 3: Retrieving Data

Lecture 32 Oracle Data Types

Lecture 33 What is a NULL Value?

Lecture 34 DESCRIBE Command

Lecture 35 INFORMATION Command

Lecture 36 INFORMATION Command (Code Samples)

Lecture 37 SQL Statement Basics

Lecture 38 SQL Statement Basics (Code Samples)

Lecture 39 Oracle Error Messages

Lecture 40 Oracle Error Messages (Code Samples)

Lecture 41 Using SELECT Statements

Lecture 42 Using SELECT Statements (Code Samples)

Lecture 43 Using Column Aliases

Lecture 44 CODE: Using Column Aliases

Lecture 45 Quote (Q) Operator

Lecture 46 Quote (Q) Operator (Code Samples)

Lecture 47 DISTINCT and UNIQUE Operator

Lecture 48 DISTINCT and UNIQUE Operators (Code Samples)

Lecture 49 Coding Exercise 1 Solution

Lecture 50 Concatenation Operators

Lecture 51 Concatenation Operators (Code Samples)

Lecture 52 Arithmetic Expressions and NULL Values

Lecture 53 Arithmetic Expressions and NULL Values (Code Samples)

Lecture 54 Coding Exercise 2 Solution

Section 4: Restricting Data

Lecture 55 Using WHERE Clause

Lecture 56 Using WHERE Clause (Code Samples)

Lecture 57 Comparison Operators

Lecture 58 Comparison Operators (Code Samples)

Lecture 59 BETWEEN . AND Operator

Lecture 60 BETWEEN...AND Operator (Code Samples)

Lecture 61 IN Operator

Lecture 62 IN Operator (Code Samples)

Lecture 63 LIKE Operator

Lecture 64 LIKE Operator (Code Samples)

Lecture 65 IS NULL Operator

Lecture 66 IS NULL Operator (Code Samples)

Lecture 67 Logical Operators (AND, OR, NOT)

Lecture 68 Logical Operators (Code Samples)

Lecture 69 Rules of Precedence

Lecture 70 Rules of Precedence (Code Samples)

Lecture 71 Quiz

Section 5: Sorting Data

Lecture 72 ORDER BY Clause

Lecture 73 ORDER BY Clause (Code Samples)

Lecture 74 ASC and DESC Operators

Lecture 75 ASC and DESC Operators (Code Samples)

Lecture 76 NULLS FIRST and NULLS LAST Operators

Lecture 77 NULLS FIRST and NULLS LAST Operators (Code Samples)

Lecture 78 ROWNUM & ROWID in SQL

Lecture 79 ROWNUM & ROWID in SQL (Code Samples)

Lecture 80 Oracle FETCH Clause

Lecture 81 Oracle FETCH Clause (Code Samples)

Section 6: Using Substitution Variables

Lecture 82 What is a Substitution Variable?

Lecture 83 What is a Substitution Variable (Code Samples)

Lecture 84 Double Ampersand (&&) and DEFINE & UNDEFINE Commands

Lecture 85 Double Ampersand (&&) and DEFINE & UNDEFINE Commands (Code Samples)

Lecture 86 ACCEPT and PROMPT Commands

Lecture 87 ACCEPT and PROMPT Commands (Code Samples)

Lecture 88 SET VERIFY ON / SET VERIFY OFF Commands

Lecture 89 SET VERIFY ON-OFF Commands(Code Samples)

Section 7: Single-Row Functions

Lecture 90 Single Row Functions

Lecture 91 Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functions

Lecture 92 Case Conversion (LOWER, UPPER, INITCAP) Functions (Code Samples)

Lecture 93 Character Functions - Character Manipulation Functions (Part 1)

Lecture 94 Character Manipulation Functions (Part 1) (Code Samples)

Lecture 95 Character Functions - Character Manipulation Functions Part 2 (INSTR Function)

Lecture 96 Character Manipulation Functions Part 2 (INSTR Function) (Code Samples)

Lecture 97 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)

Lecture 98 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions) (Code Samples)

Lecture 99 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)

Lecture 100 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions) (Code Samples)

Lecture 101 Numeric Functions

Lecture 102 Numeric Functions (Code Samples)

Lecture 103 Nested Functions

Lecture 104 Nested Functions (Code Samples)

Lecture 105 Date Values & Date Formats in Oracle

Lecture 106 Date Functions & Arithmetic Operations on Dates

Lecture 107 Date Functions & Arithmetic Operations on Dates (Code Samples)

Lecture 108 Date Manipulation Functions in SQL

Lecture 109 Date Manipulation Functions in SQL (Code Samples)

Section 8: Conversion Functions

Lecture 110 Conversion Functions

Lecture 111 Conversion Functions (Code Samples)

Lecture 112 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)

Lecture 113 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1) (Code Samples)

Lecture 114 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)

Lecture 115 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2) (Code Samples)

Lecture 116 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions

Lecture 117 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions (Code Samples)

Section 9: Conditional Expressions

Lecture 118 Oracle Conditional Expressions: CASE Expressions

Lecture 119 Oracle Conditional Expressions: CASE Expressions (Code Samples)

Lecture 120 Oracle Conditional Expressions: DECODE Function

Lecture 121 Oracle Conditional Expressions: DECODE Function (Code Samples)

Section 10: Group Functions

Lecture 122 Group Functions

Lecture 123 AVG Function

Lecture 124 AVG Function (Code Samples)

Lecture 125 COUNT Function

Lecture 126 COUNT Function (Code Samples)

Lecture 127 MAX Function

Lecture 128 MAX Function (Code Samples)

Lecture 129 MIN Function

Lecture 130 MIN Function (Code Samples)

Lecture 131 SUM Function

Lecture 132 SUM Function (Code Samples)

Lecture 133 LISTAGG Function

Lecture 134 LISTAGG Function (Code Samples)

Lecture 135 Overview Of Group Functions

Lecture 136 Overview Of Group Functions (Code Samples)

Section 11: Grouping Data

Lecture 137 GROUP BY Clause (Part 1)

Lecture 138 GROUP BY Clause (Part 1) (Code Samples)

Lecture 139 GROUP BY Clause (Part 2)

Lecture 140 GROUP BY Clause (Part 2) (Code Samples)

Lecture 141 HAVING Clause

Lecture 142 HAVING Clause (Code Samples)

Lecture 143 Nested Group Functions

Lecture 144 Nested Group Functions (Code Samples)

Section 12: Joining Multiple Tables

Lecture 145 What is a Join? & Oracle SQL Join Types

Lecture 146 Creating a Join

Lecture 147 Natural Join

Lecture 148 Natural Join (Code Samples)

Lecture 149 Join with the USING Clause

Lecture 150 Join with the USING Clause (Code Samples)

Lecture 151 Handling Ambiguous Column Names

Lecture 152 Handling Ambiguous Column Names (Code Samples)

Lecture 153 Inner Join & Join with the ON Clause

Lecture 154 Inner Join & Join with the ON Clause (Code Samples)

Lecture 155 Multiple Join Operations

Lecture 156 Multiple Join Operations (Code Samples)

Lecture 157 Restricting Joins

Lecture 158 Restricting Joins (Code Samples)

Lecture 159 Self Join

Lecture 160 Self Join (Code Samples)

Lecture 161 Non-Equijoins (Joining Unequal Tables)

Lecture 162 Non-Equijoins (Joining Unequal Tables) (Code Samples)

Lecture 163 OUTER JOINS

Lecture 164 OUTER JOINS (Code Samples)

Lecture 165 LEFT OUTER JOIN (LEFT JOIN)

Lecture 166 LEFT OUTER JOIN (LEFT JOIN) (Code Samples)

Lecture 167 RIGHT OUTER JOIN (RIGHT JOIN)

Lecture 168 RIGHT OUTER JOIN (RIGHT JOIN) (Code Samples)

Lecture 169 FULL OUTER JOIN (FULL JOIN)

Lecture 170 FULL OUTER JOIN (FULL JOIN) (Code Samples)

Lecture 171 Cross Join (Cartesian Product / Cross Product)

Lecture 172 Cross Join (Cartesian Product / Cross Product) (Code Samples)

Lecture 173 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)

Lecture 174 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)

Lecture 175 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)

Lecture 176 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Code Samples)

Lecture 177 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins

Lecture 178 Differences Between Inner Joins-Outer Joins, Equijoins-Non-Equijoins (Code)

Lecture 179 Which Join Type Should You Use?

Lecture 180 Entity-Relationship Models in DBMS - How to Use Them with Joins?

Section 13: Using Subqueries

Lecture 181 Using Subqueries

Lecture 182 Using Subqueries (Code Samples)

Lecture 183 Single Row Subqueries

Lecture 184 Single Row Subqueries (Code Samples)

Lecture 185 Multiple Row Subqueries

Lecture 186 Multiple Row Subqueries (Code Samples)

Lecture 187 Multiple Column Subqueries

Lecture 188 Multiple Column Subqueries (Code Samples)

Lecture 189 Using Subqueries as a Table

Lecture 190 Using Subqueries as a Table (Code Samples)

Lecture 191 SCALAR Subqueries

Lecture 192 SCALAR Subqueries (Code Samples)

Lecture 193 Correlated Subqueries

Lecture 194 Correlated Subqueries (Code Samples)

Lecture 195 EXISTS Operator & Semijoins

Lecture 196 EXISTS Operator & Semijoins (Code Samples)

Lecture 197 NOT EXISTS Operator

Lecture 198 NOT EXISTS Operator (Sample Codes)

Section 14: Working with the Oracle SET Operators

Lecture 199 Introduction to SET Operators in Oracle SQL

Lecture 200 UNION and UNION ALL Operators

Lecture 201 UNION and UNION ALL Operators (Code Samples)

Lecture 202 INTERSECT Operator

Lecture 203 INTERSECT Operator (Code Samples)

Lecture 204 MINUS Operator

Lecture 205 MINUS Operator (Code Samples)

Lecture 206 Matching Unmatched Queries in SET Operations

Lecture 207 Matching Unmatched Queries in SET Operations (Code Samples)

Lecture 208 Using the ORDER BY Clause with SET Operators

Lecture 209 Using the ORDER BY Clause with SET Operators (Code Samples)

Lecture 210 Combining Multiple Queries Using the SET Operators

Lecture 211 Combining Multiple Queries Using the SET Operators (Code Samples)

Section 15: Data Definition Language (DDL) Statements

Lecture 212 Data Definition Language (DDL)

Lecture 213 Naming Rules & Naming Conventions in Oracle

Lecture 214 CREATE TABLE Statement

Lecture 215 CREATE TABLE Statement (Code Samples)

Lecture 216 CREATE TABLE AS SELECT (CTAS) Statement in Oracle

Lecture 217 CREATE TABLE AS SELECT (CTAS) Statement in Oracle (Code Samples)

Lecture 218 ALTER TABLE Statement

Lecture 219 ALTER TABLE Statement (Code Samples)

Lecture 220 Marking Columns Unused (Using The SET UNUSED Clause)

Lecture 221 Marking Columns Unused (Using The SET UNUSED Clause) (Code Samples)

Lecture 222 READ-ONLY Tables in SQL

Lecture 223 READ-ONLY Tables in SQL (Code Samples)

Lecture 224 DROP TABLE Statement

Lecture 225 DROP TABLE Statement (Code Samples)

Lecture 226 TRUNCATE TABLE Statement

Lecture 227 TRUNCATE TABLE Statement (Code Samples)

Lecture 228 COMMENT Statement

Lecture 229 COMMENT Statement (Code Samples)

Lecture 230 RENAME Statement

Lecture 231 RENAME Statement (Code Samples)

Section 16: Data Manipulation Language (DML) Statements

Lecture 232 Data Manipulation Language (DML)

Lecture 233 INSERT Statement (Part 1)

Lecture 234 INSERT Statement (Part 1) (Code Samples)

Lecture 235 INSERT Statement (Part 2)

Lecture 236 INSERT Statement (Part 2) (Code Samples)

Lecture 237 Multitable Insert Statements

Lecture 238 Unconditional Insert Statements (INSERT ALL Statements)

Lecture 239 Unconditional Insert Statements (INSERT ALL Statements) (Code Samples)

Lecture 240 Conditional INSERT ALL Statements

Lecture 241 Conditional INSERT ALL Statements (Code Samples)

Lecture 242 Conditional INSERT FIRST Statements

Lecture 243 Conditional INSERT FIRST Statements (Code Samples)

Lecture 244 Pivoting Insert

Lecture 245 Pivoting Insert (Code Samples)

Lecture 246 UPDATE Statement

Lecture 247 UPDATE Statement (Code Samples)

Lecture 248 DELETE Statement

Lecture 249 DELETE Statement (Code Samples)

Lecture 250 MERGE Statement

Lecture 251 MERGE Statement (Code Samples)

Lecture 252 (TCL) Transaction Control Language & TCL Commands

Lecture 253 (TCL) Transaction Control Language & TCL Commands (Code Samples)

Lecture 254 COMMIT and ROLLBACK Statements

Lecture 255 COMMIT and ROLLBACK Statements (Code Samples)

Lecture 256 Row Lock in Oracle

Lecture 257 Row Lock in Oracle (Code Samples)

Lecture 258 SAVEPOINT Statement

Lecture 259 SAVEPOINT Statement (Code Samples)

Lecture 260 FOR UPDATE Statement

Lecture 261 FOR UPDATE Statement (Code Samples)

Section 17: Using Oracle FLASHBACK Technologies

Lecture 262 FLASHBACK Operations (Part 1)

Lecture 263 FLASHBACK Operations (Part 2)

Lecture 264 FLASHBACK Operations (Part 2) (Code Samples)

Lecture 265 PURGE Operations

Lecture 266 PURGE Operations (Code Samples)

Lecture 267 Tracking Changes In Data In a Particular Time

Lecture 268 Tracking Changes In Data In a Particular Time (Code Samples)

Section 18: Oracle Constraints in SQL

Lecture 269 What is a Constraint? Oracle Constraint Types

Lecture 270 NOT NULL Constraint

Lecture 271 NOT NULL Constraint (Code Samples)

Lecture 272 UNIQUE Constraint

Lecture 273 UNIQUE Constraint (Code Samples)

Lecture 274 PRIMARY KEY Constraint

Lecture 275 PRIMARY KEY Constraint (Code Samples)

Lecture 276 FOREIGN KEY Constraint (Part 1)

Lecture 277 FOREIGN KEY Constraint (Part 2)

Lecture 278 FOREIGN KEY Constraint (Code Samples)

Lecture 279 The ON DELETE CASCADE | ON DELETE SET NULL Clause

Lecture 280 The ON DELETE CASCADE | ON DELETE SET NULL Clause (Code Samples)

Lecture 281 CHECK Constraint

Lecture 282 CHECK Constraint (Code Samples)

Lecture 283 Adding Constraints via ALTER TABLE Statements

Lecture 284 Adding Constraints via ALTER TABLE Statements (Code Samples)

Lecture 285 Dropping (Removing) Constraints

Lecture 286 Dropping (Removing) Constraints (Code Samples)

Lecture 287 Cascading Constraints in Oracle

Lecture 288 Cascading Constraints in Oracle (Code Samples)

Lecture 289 Renaming Constraints

Lecture 290 Renaming Constraints (Code Samples)

Lecture 291 Disabling Constraints

Lecture 292 Disabling Constraints (Code Samples)

Lecture 293 Enabling Constraints

Lecture 294 Enabling Constraints (Code Samples)

Lecture 295 Status of Constraints

Lecture 296 Status of Constraints (Code Samples)

Lecture 297 Deferring Constraints (Part 1)

Lecture 298 Deferring Constraints (Part 2)

Lecture 299 Deferring Constraints (Code Samples)

Section 19: Database Views

Lecture 300 What is a View and What is it Used for?

Lecture 301 View Types in Oracle

Lecture 302 Creating Simple Views

Lecture 303 Creating Simple Views (Code Samples)

Lecture 304 Creating Complex Views

Lecture 305 Creating Complex Views (Code Samples)

Lecture 306 Modifying Views

Lecture 307 Modifying Views (Code Samples)

Lecture 308 Performing DML Operations with Views

Lecture 309 Performing DML Operations with Views (Code Samples)

Lecture 310 Using the WITH CHECK OPTION Clause in SQL

Lecture 311 Using the WITH CHECK OPTION Clause in SQL (Code Samples)

Lecture 312 Using the WITH READ ONLY Clause on Views

Lecture 313 Using the WITH READ ONLY Clause on Views (Code Samples)

Lecture 314 Dropping Views

Lecture 315 Dropping Views (Code Samples)

Section 20: Data Dictionary Views

Lecture 316 What are Data Dictionary Views in Oracle?

Lecture 317 The Dictionary View

Lecture 318 The Dictionary View (Code Samples)

Lecture 319 Difference Between USER, ALL, DBA and V$ Prefixes

Lecture 320 USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views

Lecture 321 USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views (Code Samples)

Lecture 322 USER_TABLES Data Dictionary View

Lecture 323 USER_TABLES Data Dictionary View (Code Samples)

Lecture 324 USER_TAB_COLUMNS Data Dictionary View

Lecture 325 USER_TAB_COLUMNS Data Dictionary View (Code Samples)

Lecture 326 USER_CONSTRAINTS Data Dictionary View

Lecture 327 USER_CONSTRAINTS Data Dictionary View (Code Samples)

Lecture 328 USER_CONS_COLUMNS Data Dictionary View

Lecture 329 USER_CONS_COLUMNS Data Dictionary View (Code Samples)

Lecture 330 USER_VIEWS Data Dictionary View

Lecture 331 USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views

Lecture 332 USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views (Code Samples)

Section 21: Oracle Sequences

Lecture 333 What is a Sequence?

Lecture 334 Creating Sequences

Lecture 335 Creating Sequences (Code Samples)

Lecture 336 Modifying Sequences

Lecture 337 Modifying Sequences (Code Samples)

Lecture 338 Dropping Sequences

Lecture 339 Using Sequences

Lecture 340 Using Sequences (Code Samples)

Lecture 341 Using Sequences as a Default Value

Lecture 342 Using Sequences as a Default Value (Code Samples)

Lecture 343 Sequence Caching

Lecture 344 The User_Sequences View

Lecture 345 Oracle IDENTITY Column (Part 1)

Lecture 346 Oracle IDENTITY Column (Part 2)

Lecture 347 Oracle IDENTITY Column (Code Samples)

Section 22: Oracle Synonyms

Lecture 348 What is a Synonym?

Lecture 349 Creating, Using, and Dropping Synonyms

Lecture 350 Creating, Using, and Dropping Synonyms (Code Samples)

Lecture 351 Analyzing The USER_SYNONYMS View

Lecture 352 Analyzing The USER_SYNONYMS View (Code Samples)

Section 23: Working with Oracle Indexes in SQL

Lecture 353 What is an Index in SQL?

Lecture 354 Index Types in SQL

Lecture 355 How to Create Indexes (Part 1)

Lecture 356 How to Create Indexes (Part 1) (Code Samples)

Lecture 357 How to Create Indexes (Part 2)

Lecture 358 How to Create Indexes (Part 2) (Code Samples)

Lecture 359 How to Create Indexes While Table Creation?

Lecture 360 How to Create Indexes While Table Creation (Code Samples)

Lecture 361 How to Remove (Drop) Indexes?

Lecture 362 How to Remove (Drop) Indexes (Code Samples)

Lecture 363 Function-Based Indexes

Lecture 364 Function-Based Indexes (Code Samples)

Lecture 365 Multiple Indexes on the Same Columns & Invisible Indexes

Lecture 366 Multiple Indexes on the Same Columns & Invisible Indexes (Code Samples)

Lecture 367 Analyzing the USER_INDEXES and USER_IND_COLUMNS Views

Lecture 368 Analyzing the USER_INDEXES and USER_IND_COLUMNS Views (Code Samples)

Lecture 369 How to Modify (Alter) Indexes?

Lecture 370 How to Modify (Alter) Indexes (Code Samples)

Section 24: Managing Oracle Privileges and Roles

Lecture 371 What are Privileges in SQL?

Lecture 372 How to Create a User in Oracle Database? (Part 1)

Lecture 373 How to Create a User in Oracle Database? (Part 2)

Lecture 374 How to Create a User in Oracle Database (Code Samples)

Lecture 375 Changing Database Users' Passwords in Oracle Database

Lecture 376 Changing Users' Passwords in Oracle Database (Code Samples)

Lecture 377 Granting System Privileges

Lecture 378 Granting System Privileges (Code Samples)

Lecture 379 Roles and PUBLIC (Part 1)

Lecture 380 Roles and PUBLIC (Code Samples)

Lecture 381 Roles and PUBLIC (Part 2)

Lecture 382 Granting Object Privileges

Lecture 383 Granting Object Privileges (Code Samples)

Lecture 384 Definer's Rights and Invoker's Rights (Part 1)

Lecture 385 Definer's Rights and Invoker's Rights (Part 2)

Lecture 386 Definer's Rights and Invoker's Rights (Code Samples)

Lecture 387 Revoking Privileges and Roles (Part 1)

Lecture 388 Revoking Privileges and Roles (Part 2)

Lecture 389 Revoking Privileges and Roles (Code Samples)

Lecture 390 Searching Privileges Using Data Dictionary Views

Lecture 391 Good News!

Section 25: Appendix

Lecture 392 Appendix 1: Oracle Database 12c Installation into Your Computer

Lecture 393 Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?

Lecture 394 Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c

Lecture 395 Appendix 4: How to Uninstall Oracle Database?

Lecture 396 How to Enroll in Oracle 1Z0-071 SQL Associate Certification Exam?

Section 26: Conclusion

Lecture 397 Course Code Samples

Lecture 398 SQL Cheatsheet

Lecture 399 SQL Certification Exam Samples

Lecture 400 Bonus Lecture

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!

Buy Premium Account From My Download Links & Get Fastest Speed.

[To see links please register or login]

[To see links please register or login]

[To see links please register or login]