The Complete Oracle SQL Bootcamp 2023

The Complete Oracle SQL Bootcamp 2023

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 Updates:(Feb 2023) : Brand New Content (Managing Oracle Privileges and Roles) was added!(Jan 2023): Brand New Content (Using Oracle FLASHBACK Technologies) was added!(Nov 2022) : 3-Real SQL(Over 200+ High-Quality Questions) Certification Exam Samples are added! (Jun 2022) : 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 Course:Database 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

Lecture 18 Option 1: Configuring the VMware Virtualization Software

Lecture 19 Option 1: Configuring the Oracle VirtualBox Virtualization Software

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

Lecture 21 Important Note

Lecture 22 Option 2: Downloading And Installing Oracle Database

Lecture 23 Option 2: Unlocking the HR Schema

Lecture 24 Option 2: Configuring and Using the SQL Developer

Lecture 25 Option 2: Installing Sample Schemas in Oracle Database

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

Lecture 27 Option 3 : Using Oracle Live SQL

Lecture 28 Option 3: Oracle Live SQL Limitations

Lecture 29 SQL Statements Used in This Course

Lecture 30 Don’t Forget to Leave a Rating!

Section 3: Retrieving Data

Lecture 31 Oracle Data Types

Lecture 32 What is a NULL Value?

Lecture 33 DESCRIBE Command

Lecture 34 INFORMATION Command

Lecture 35 INFORMATION Command (Code Samples)

Lecture 36 SQL Statement Basics

Lecture 37 SQL Statement Basics (Code Samples)

Lecture 38 Oracle Error Messages

Lecture 39 Oracle Error Messages (Code Samples)

Lecture 40 Using SELECT Statements

Lecture 41 Using SELECT Statements (Code Samples)

Lecture 42 Using Column Aliases

Lecture 43 CODE: Using Column Aliases

Lecture 44 Quote (Q) Operator

Lecture 45 Quote (Q) Operator (Code Samples)

Lecture 46 DISTINCT and UNIQUE Operator

Lecture 47 DISTINCT and UNIQUE Operators (Code Samples)

Lecture 48 Coding Exercise 1 Solution

Lecture 49 Concatenation Operators

Lecture 50 Concatenation Operators (Code Samples)

Lecture 51 Arithmetic Expressions and NULL Values

Lecture 52 Arithmetic Expressions and NULL Values (Code Samples)

Lecture 53 Coding Exercise 2 Solution

Section 4: Restricting Data

Lecture 54 Using WHERE Clause

Lecture 55 Using WHERE Clause (Code Samples)

Lecture 56 Comparison Operators

Lecture 57 Comparison Operators (Code Samples)

Lecture 58 BETWEEN … AND Operator

Lecture 59 BETWEEN…AND Operator (Code Samples)

Lecture 60 IN Operator

Lecture 61 IN Operator (Code Samples)

Lecture 62 LIKE Operator

Lecture 63 LIKE Operator (Code Samples)

Lecture 64 IS NULL Operator

Lecture 65 IS NULL Operator (Code Samples)

Lecture 66 Logical Operators (AND, OR, NOT)

Lecture 67 Logical Operators (Code Samples)

Lecture 68 Rules of Precedence

Lecture 69 Rules of Precedence (Code Samples)

Lecture 70 Quiz

Section 5: Sorting Data

Lecture 71 ORDER BY Clause

Lecture 72 ORDER BY Clause (Code Samples)

Lecture 73 ASC and DESC Operators

Lecture 74 ASC and DESC Operators (Code Samples)

Lecture 75 NULLS FIRST and NULLS LAST Operators

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

Lecture 77 ROWNUM & ROWID in SQL

Lecture 78 ROWNUM & ROWID in SQL (Code Samples)

Lecture 79 Oracle FETCH Clause

Lecture 80 Oracle FETCH Clause (Code Samples)

Section 6: Using Substitution Variables

Lecture 81 What is a Substitution Variable?

Lecture 82 What is a Substitution Variable (Code Samples)

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

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

Lecture 85 ACCEPT and PROMPT Commands

Lecture 86 ACCEPT and PROMPT Commands (Code Samples)

Lecture 87 SET VERIFY ON / SET VERIFY OFF Commands

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

Section 7: Single-Row Functions

Lecture 89 Single Row Functions

Lecture 90 Character Functions – Case Conversion (LOWER, UPPER, INITCAP) Functions

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

Lecture 92 Character Functions – Character Manipulation Functions (Part 1)

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

Lecture 94 Character Functions – Character Manipulation Functions Part 2 (INSTR Function)

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

Lecture 96 Character Functions – Part 3 (TRIM, LTRIM, RTRIM Functions)

Lecture 97 Character Functions – Part 3 (TRIM, LTRIM, RTRIM Functions) (Code Samples)

Lecture 98 Character Functions – Part 4 (REPLACE, LPAD, RPAD Functions)

Lecture 99 Character Functions – Part 4 (REPLACE, LPAD, RPAD Functions) (Code Samples)

Lecture 100 Numeric Functions

Lecture 101 Numeric Functions (Code Samples)

Lecture 102 Nested Functions

Lecture 103 Nested Functions (Code Samples)

Lecture 104 Date Values & Date Formats in Oracle

Lecture 105 Date Functions & Arithmetic Operations on Dates

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

Lecture 107 Date Manipulation Functions in SQL

Lecture 108 Date Manipulation Functions in SQL (Code Samples)

Section 8: Conversion Functions

Lecture 109 Conversion Functions

Lecture 110 Conversion Functions (Code Samples)

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

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

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

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

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

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

Section 9: Conditional Expressions

Lecture 117 Oracle Conditional Expressions: CASE Expressions

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

Lecture 119 Oracle Conditional Expressions: DECODE Function

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

Section 10: Group Functions

Lecture 121 Group Functions

Lecture 122 AVG Function

Lecture 123 AVG Function (Code Samples)

Lecture 124 COUNT Function

Lecture 125 COUNT Function (Code Samples)

Lecture 126 MAX Function

Lecture 127 MAX Function (Code Samples)

Lecture 128 MIN Function

Lecture 129 MIN Function (Code Samples)

Lecture 130 SUM Function

Lecture 131 SUM Function (Code Samples)

Lecture 132 LISTAGG Function

Lecture 133 LISTAGG Function (Code Samples)

Lecture 134 Overview Of Group Functions

Lecture 135 Overview Of Group Functions (Code Samples)

Section 11: Grouping Data

Lecture 136 GROUP BY Clause (Part 1)

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

Lecture 138 GROUP BY Clause (Part 2)

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

Lecture 140 HAVING Clause

Lecture 141 HAVING Clause (Code Samples)

Lecture 142 Nested Group Functions

Lecture 143 Nested Group Functions (Code Samples)

Section 12: Joining Multiple Tables

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

Lecture 145 Creating a Join

Lecture 146 Natural Join

Lecture 147 Natural Join (Code Samples)

Lecture 148 Join with the USING Clause

Lecture 149 Join with the USING Clause (Code Samples)

Lecture 150 Handling Ambiguous Column Names

Lecture 151 Handling Ambiguous Column Names (Code Samples)

Lecture 152 Inner Join & Join with the ON Clause

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

Lecture 154 Multiple Join Operations

Lecture 155 Multiple Join Operations (Code Samples)

Lecture 156 Restricting Joins

Lecture 157 Restricting Joins (Code Samples)

Lecture 158 Self Join

Lecture 159 Self Join (Code Samples)

Lecture 160 Non-Equijoins (Joining Unequal Tables)

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

Lecture 162 OUTER JOINS

Lecture 163 OUTER JOINS (Code Samples)

Lecture 164 LEFT OUTER JOIN (LEFT JOIN)

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

Lecture 166 RIGHT OUTER JOIN (RIGHT JOIN)

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

Lecture 168 FULL OUTER JOIN (FULL JOIN)

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

Lecture 170 Cross Join (Cartesian Product / Cross Product)

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

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

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

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

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

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

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

Lecture 178 Which Join Type Should You Use?

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

Section 13: Using Subqueries

Lecture 180 Using Subqueries

Lecture 181 Using Subqueries (Code Samples)

Lecture 182 Single Row Subqueries

Lecture 183 Single Row Subqueries (Code Samples)

Lecture 184 Multiple Row Subqueries

Lecture 185 Multiple Row Subqueries (Code Samples)

Lecture 186 Multiple Column Subqueries

Lecture 187 Multiple Column Subqueries (Code Samples)

Lecture 188 Using Subqueries as a Table

Lecture 189 Using Subqueries as a Table (Code Samples)

Lecture 190 SCALAR Subqueries

Lecture 191 SCALAR Subqueries (Code Samples)

Lecture 192 Correlated Subqueries

Lecture 193 Correlated Subqueries (Code Samples)

Lecture 194 EXISTS Operator & Semijoins

Lecture 195 EXISTS Operator & Semijoins (Code Samples)

Lecture 196 NOT EXISTS Operator

Lecture 197 NOT EXISTS Operator (Sample Codes)

Section 14: Working with the Oracle SET Operators

Lecture 198 Introduction to SET Operators in Oracle SQL

Lecture 199 UNION and UNION ALL Operators

Lecture 200 UNION and UNION ALL Operators (Code Samples)

Lecture 201 INTERSECT Operator

Lecture 202 INTERSECT Operator (Code Samples)

Lecture 203 MINUS Operator

Lecture 204 MINUS Operator (Code Samples)

Lecture 205 Matching Unmatched Queries in SET Operations

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

Lecture 207 Using the ORDER BY Clause with SET Operators

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

Lecture 209 Combining Multiple Queries Using the SET Operators

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

Section 15: Data Definition Language (DDL) Statements

Lecture 211 Data Definition Language (DDL)

Lecture 212 Naming Rules & Naming Conventions in Oracle

Lecture 213 CREATE TABLE Statement

Lecture 214 CREATE TABLE Statement (Code Samples)

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

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

Lecture 217 ALTER TABLE Statement

Lecture 218 ALTER TABLE Statement (Code Samples)

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

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

Lecture 221 READ-ONLY Tables in SQL

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

Lecture 223 DROP TABLE Statement

Lecture 224 DROP TABLE Statement (Code Samples)

Lecture 225 TRUNCATE TABLE Statement

Lecture 226 TRUNCATE TABLE Statement (Code Samples)

Lecture 227 COMMENT Statement

Lecture 228 COMMENT Statement (Code Samples)

Lecture 229 RENAME Statement

Lecture 230 RENAME Statement (Code Samples)

Section 16: Data Manipulation Language (DML) Statements

Lecture 231 Data Manipulation Language (DML)

Lecture 232 INSERT Statement (Part 1)

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

Lecture 234 INSERT Statement (Part 2)

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

Lecture 236 Multitable Insert Statements

Lecture 237 Unconditional Insert Statements (INSERT ALL Statements)

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

Lecture 239 Conditional INSERT ALL Statements

Lecture 240 Conditional INSERT ALL Statements (Code Samples)

Lecture 241 Conditional INSERT FIRST Statements

Lecture 242 Conditional INSERT FIRST Statements (Code Samples)

Lecture 243 Pivoting Insert

Lecture 244 Pivoting Insert (Code Samples)

Lecture 245 UPDATE Statement

Lecture 246 UPDATE Statement (Code Samples)

Lecture 247 DELETE Statement

Lecture 248 DELETE Statement (Code Samples)

Lecture 249 MERGE Statement

Lecture 250 MERGE Statement (Code Samples)

Lecture 251 (TCL) Transaction Control Language & TCL Commands

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

Lecture 253 COMMIT and ROLLBACK Statements

Lecture 254 COMMIT and ROLLBACK Statements (Code Samples)

Lecture 255 Row Lock in Oracle

Lecture 256 Row Lock in Oracle (Code Samples)

Lecture 257 SAVEPOINT Statement

Lecture 258 SAVEPOINT Statement (Code Samples)

Lecture 259 FOR UPDATE Statement

Lecture 260 FOR UPDATE Statement (Code Samples)

Section 17: Using Oracle FLASHBACK Technologies

Lecture 261 FLASHBACK Operations (Part 1)

Lecture 262 FLASHBACK Operations (Part 2)

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

Lecture 264 PURGE Operations

Lecture 265 PURGE Operations (Code Samples)

Lecture 266 Tracking Changes In Data In a Particular Time

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

Section 18: Oracle Constraints in SQL

Lecture 268 What is a Constraint? Oracle Constraint Types

Lecture 269 NOT NULL Constraint

Lecture 270 NOT NULL Constraint (Code Samples)

Lecture 271 UNIQUE Constraint

Lecture 272 UNIQUE Constraint (Code Samples)

Lecture 273 PRIMARY KEY Constraint

Lecture 274 PRIMARY KEY Constraint (Code Samples)

Lecture 275 FOREIGN KEY Constraint (Part 1)

Lecture 276 FOREIGN KEY Constraint (Part 2)

Lecture 277 FOREIGN KEY Constraint (Code Samples)

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

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

Lecture 280 CHECK Constraint

Lecture 281 CHECK Constraint (Code Samples)

Lecture 282 Adding Constraints via ALTER TABLE Statements

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

Lecture 284 Dropping (Removing) Constraints

Lecture 285 Dropping (Removing) Constraints (Code Samples)

Lecture 286 Cascading Constraints in Oracle

Lecture 287 Cascading Constraints in Oracle (Code Samples)

Lecture 288 Renaming Constraints

Lecture 289 Renaming Constraints (Code Samples)

Lecture 290 Disabling Constraints

Lecture 291 Disabling Constraints (Code Samples)

Lecture 292 Enabling Constraints

Lecture 293 Enabling Constraints (Code Samples)

Lecture 294 Status of Constraints

Lecture 295 Status of Constraints (Code Samples)

Lecture 296 Deferring Constraints (Part 1)

Lecture 297 Deferring Constraints (Part 2)

Lecture 298 Deferring Constraints (Code Samples)

Section 19: Database Views

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

Lecture 300 View Types in Oracle

Lecture 301 Creating Simple Views

Lecture 302 Creating Simple Views (Code Samples)

Lecture 303 Creating Complex Views

Lecture 304 Creating Complex Views (Code Samples)

Lecture 305 Modifying Views

Lecture 306 Modifying Views (Code Samples)

Lecture 307 Performing DML Operations with Views

Lecture 308 Performing DML Operations with Views (Code Samples)

Lecture 309 Using the WITH CHECK OPTION Clause in SQL

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

Lecture 311 Using the WITH READ ONLY Clause on Views

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

Lecture 313 Dropping Views

Lecture 314 Dropping Views (Code Samples)

Section 20: Data Dictionary Views

Lecture 315 What are Data Dictionary Views in Oracle?

Lecture 316 The Dictionary View

Lecture 317 The Dictionary View (Code Samples)

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

Lecture 319 USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views

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

Lecture 321 USER_TABLES Data Dictionary View

Lecture 322 USER_TABLES Data Dictionary View (Code Samples)

Lecture 323 USER_TAB_COLUMNS Data Dictionary View

Lecture 324 USER_TAB_COLUMNS Data Dictionary View (Code Samples)

Lecture 325 USER_CONSTRAINTS Data Dictionary View

Lecture 326 USER_CONSTRAINTS Data Dictionary View (Code Samples)

Lecture 327 USER_CONS_COLUMNS Data Dictionary View

Lecture 328 USER_CONS_COLUMNS Data Dictionary View (Code Samples)

Lecture 329 USER_VIEWS Data Dictionary View

Lecture 330 USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views

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

Section 21: Oracle Sequences

Lecture 332 What is a Sequence?

Lecture 333 Creating Sequences

Lecture 334 Creating Sequences (Code Samples)

Lecture 335 Modifying Sequences

Lecture 336 Modifying Sequences (Code Samples)

Lecture 337 Dropping Sequences

Lecture 338 Using Sequences

Lecture 339 Using Sequences (Code Samples)

Lecture 340 Using Sequences as a Default Value

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

Lecture 342 Sequence Caching

Lecture 343 The User_Sequences View

Lecture 344 Oracle IDENTITY Column (Part 1)

Lecture 345 Oracle IDENTITY Column (Part 2)

Lecture 346 Oracle IDENTITY Column (Code Samples)

Section 22: Oracle Synonyms

Lecture 347 What is a Synonym?

Lecture 348 Creating, Using, and Dropping Synonyms

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

Lecture 350 Analyzing The USER_SYNONYMS View

Lecture 351 Analyzing The USER_SYNONYMS View (Code Samples)

Section 23: Working with Oracle Indexes in SQL

Lecture 352 What is an Index in SQL?

Lecture 353 Index Types in SQL

Lecture 354 How to Create Indexes (Part 1)

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

Lecture 356 How to Create Indexes (Part 2)

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

Lecture 358 How to Create Indexes While Table Creation?

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

Lecture 360 How to Remove (Drop) Indexes?

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

Lecture 362 Function-Based Indexes

Lecture 363 Function-Based Indexes (Code Samples)

Lecture 364 Multiple Indexes on the Same Columns & Invisible Indexes

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

Lecture 366 Analyzing the USER_INDEXES and USER_IND_COLUMNS Views

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

Lecture 368 How to Modify (Alter) Indexes?

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

Section 24: Managing Oracle Privileges and Roles

Lecture 370 What are Privileges in SQL?

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

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

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

Lecture 374 Changing Database Users’ Passwords in Oracle Database

Lecture 375 Changing Users’ Passwords in Oracle Database (Code Samples)

Lecture 376 Granting System Privileges

Lecture 377 Granting System Privileges (Code Samples)

Lecture 378 Roles and PUBLIC (Part 1)

Lecture 379 Roles and PUBLIC (Code Samples)

Lecture 380 Roles and PUBLIC (Part 2)

Lecture 381 Granting Object Privileges

Lecture 382 Granting Object Privileges (Code Samples)

Lecture 383 Definer’s Rights and Invoker’s Rights (Part 1)

Lecture 384 Definer’s Rights and Invoker’s Rights (Part 2)

Lecture 385 Definer’s Rights and Invoker’s Rights (Code Samples)

Lecture 386 Revoking Privileges and Roles (Part 1)

Lecture 387 Revoking Privileges and Roles (Part 2)

Lecture 388 Revoking Privileges and Roles (Code Samples)

Lecture 389 Searching Privileges Using Data Dictionary Views

Lecture 390 Good News!

Section 25: Appendix

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

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

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

Lecture 394 Appendix 4: How to Uninstall Oracle Database?

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

Section 26: Conclusion

Lecture 396 Course Code Samples

Lecture 397 SQL Cheatsheet

Lecture 398 SQL Certification Exam Samples

Lecture 399 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!

Course Information:

Udemy | English | 38h 22m | 19.38 GB
Created by: Oracle Master Training | 200,000+ Students Worldwide

You Can See More Courses in the Developer >> Greetings from CourseDown.com