What you'll learnPass 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!
RequirementsNothing 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!
DescriptionWelcome to the MOST COMPREHENSIVE Oracle SQL Bootcamp Course on the planet!Latest Course Updates:(Aug 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 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!
OverviewSection 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.