2o17 PGA CREW
__________.
______\\ |
.\ |
|| pROPAGANDA! |
|| ----------- |
._______ .______. ____ ____| ____ ____
| _ /__|_ _ |_______\__ ).________\__ )____. .__\ \ ._\__ )_.
| __/ ___/ / | _ / _ | _ | _ | |___| \ \| _ |
| | | |______| __/ \ | \ | \ | _ | |\ \ \ |mK^dS!
_|___| |________| |_|______|____ |______| | | |/ /_______|___
\ |___| |___| | |___| |___/___/ /
\____________________________________|______________|__________________/
|| |
| || 2o17.o6.15 | |
| - HOT.OFF.THE.PRESS !! || | WE.WARP.YOUR.MIND.WITH |
| -------------------- `----------------' ---------------------- |
| ....[PROPAGANDA].................................................. |
| || : |
| || INFINITE.SKILLS.ORACLE.DATABASE.12C.CERTIFIED.PROFESSIONAL. : |
| || TUTORiAL-PROPAGANDA : |
| ||...............................................................: |
| |
| ....[iSO.MD5]..................................................... |
| || : |
| || c8422c2ba7b762b1a632b2f3f16c870a : |
| ||...............................................................: |
| |
| ....[URL]......................................................... |
| || www.safaribooksonline.com : |
| ||...............................................................: |
| |
| ....[ISBN/COURSE.NUMBER].......................................... |
| || 9781771373159 : |
| ||...............................................................: |
| |
| ....[COURSE.iNFO]................................................. |
| || By: Steve Ries : |
| || Publisher: Infinite Skills : |
| || Release Date: November 2014 : |
| || ISBN: 9781771373159 : |
| || Running Time: 05:35:37 : |
| || Topics: Oracle RDBMS 12C : |
| || ------------------------------------------------------------- : |
| || Description: : |
| || ------------ : |
| || In this Oracle Database 12c Certified Professional - SQL : |
| || Foundations training course, expert author Steve Ries will : |
| || teach you the fundamentals of the SQL programming language, as: |
| || well as prepare you for the first test the Oracle certifica- : |
| || tion track. This course is designed for the absolute beginner,: |
| || meaning no experience with Oracle 12c is required. : |
| || : |
| || You will start by learning about the Oracle relational data- : |
| || base, then jump into learning about the SQL SELECT statement. : |
| || From there, Steve will teach you about conditionals in SQL, : |
| || conversion functions, and implicit and explicit joins. This : |
| || video tutorial also covers subqueries, data manipulation, and : |
| || data definition language. Finally, you will learn about the : |
| || exam, and Steve will provide you with hints and strategies to : |
| || help you prepare. : |
| || : |
| || Once you have completed this computer based training course, : |
| || you will be fully capable of using the SQL programming : |
| || language. You will also have gained the knowledge necessary to: |
| || prepare for the Oracle Database 12c SQL Fundamentals exam. : |
| || Working files are included, allowing you to follow along with : |
| || the author throughout the lessons. : |
| || : |
| ||...............................................................: |
| |
| ....[TABLE.OF.CONTENTS]........................................... |
| || : |
| || Introduction : |
| || - What You Should Expect From This Course 00:03:46 : |
| || - About The Author 00:02:31 : |
| || - How To Access Your Working Files 00:03:22 : |
| || : |
| || The Oracle Relational Database : |
| || - The Relational Database 00:05:51 : |
| || - The Oracle 12C RDBMS 00:06:23 : |
| || - Structured Query Language 00:05:02 : |
| || - Setting Up SQL Developer 00:05:11 : |
| || - Setting Up Oracle APEX 00:05:06 : |
| || : |
| || The SQL SELECT Statement : |
| || - The Syntax Of SQL 00:04:03 : |
| || - Projecting Columns In A SQL Statement 00:04:17 : |
| || - Using DESCRIBE 00:05:33 : |
| || - Using Aliases In SQL 00:03:38 : |
| || - Arithmetic Operators 00:04:38 : |
| || - Displaying Unique Values With DISTINCT 00:04:22 : |
| || - Concatenating Values 00:04:17 : |
| || - Conditionals In SQL Statements : |
| || - Selectivity And WHERE Clause Syntax 00:03:07 : |
| || - Conditions Of Equality 00:04:23 : |
| || - Conditions Of Non-Equality 00:05:17 : |
| || - Range Conditions With BETWEEN 00:03:34 : |
| || - Set Conditions With IN 00:02:51 : |
| || - Pattern Matching With LIKE 00:05:06 : |
| || - Boolean Conditions 00:05:03 : |
| || - Sorting Data With ORDER BY 00:04:43 : |
| || - Sort Ordering And Secondary Sorts 00:05:03 : |
| || - Ampersand Substitution 00:05:11 : |
| || : |
| || Row Level Data Transformation : |
| || - Understanding Single-Row Functions 00:03:50 : |
| || - Case Conversion Functions 00:03:37 : |
| || - Basic String Manipulation Functions 00:06:23 : |
| || - Advanced String Manipulation Functions 00:07:04 : |
| || - Date Functions 00:04:41 : |
| || - Arithmetic Functions 00:05:04 : |
| || - Conversion Functions And Conditional Expressions : |
| || - Date To Character Conversion 00:05:06 : |
| || - Character To Date Conversion 00:04:20 : |
| || - Numeric Conversion 00:04:43 : |
| || - Conditional Expression Functions 00:04:50 : |
| || - Aggregate Data Transformation : |
| || - Group Functions 00:03:45 : |
| || - Grouping Data With GROUP BY 00:04:03 : |
| || - Row Exclusion With HAVING 00:03:22 : |
| || - Using SQL Clauses Together 00:02:55 : |
| || : |
| || Combining Data : |
| || - Explicit Versus Implicit Join Notation 00:04:28 : |
| || - Implicit Cartesian Joins 00:03:13 : |
| || - Implicit Equijoins 00:04:48 : |
| || - Implicit Outer Joins 00:04:46 : |
| || - Explicit Cross Joins 00:03:17 : |
| || - Ambiguous Explicit Joins With NATURAL JOIN 00:04:30 : |
| || - Explicit Column Joins With JOIN USING 00:03:07 : |
| || - Fully Specified Explicit Joins With JOIN ON 00:02:52 : |
| || - Self Joins And Non-Equijoins 00:04:04 : |
| || - Multi-Table Joins 00:05:17 : |
| || : |
| || Subqueries And Set Operators : |
| || - Solving Problems With Subqueries 00:03:10 : |
| || - Basic Scalar Subqueries 00:03:13 : |
| || - Advanced Scalar Subqueries 00:03:59 : |
| || - Multi-Row Subqueries 00:06:16 : |
| || - Correlated Subqueries 00:03:40 : |
| || - Multi-Column Subqueries 00:04:30 : |
| || - Nested Subqueries 00:02:27 : |
| || - Using Set Operators 00:04:41 : |
| || : |
| || Data Manipulation And DML : |
| || - Create Data With INSERT 00:05:02 : |
| || - Modify Data With UPDATE 00:03:58 : |
| || - Remove Data With DELETE And TRUNCATE 00:03:56 : |
| || - Transaction Control 00:05:30 : |
| || : |
| || Data Definition Language : |
| || - The Purpose Of DDL 00:04:16 : |
| || - Oracles Schema Based Approach 00:04:38 : |
| || - Database Objects 00:05:57 : |
| || - Column Datatypes 00:04:36 : |
| || - The CREATE TABLE Statement 00:04:55 : |
| || - Avoiding Datatype Errors 00:06:30 : |
| || - Modifying Tables With ALTER TABLE 00:07:36 : |
| || - The NOT NULL Constraint 00:02:39 : |
| || - PRIMARY KEY Constraint 00:05:08 : |
| || - FOREIGN KEY Constraint 00:04:59 : |
| || - UNIQUE Constraint 00:03:29 : |
| || - CHECK Constraint 00:03 : |
| || : |
| || Certification Exam Preparation : |
| || - About The Exam 00:03:51 : |
| || - Hints And Strategies For Preparation 00:04:17 : |
| || : |
| || Conclusion : |
| || - Wrap Up 00:02:12 : |
| || : |
| || Working_Files.zip included ( in section directory ) : |
| ||...............................................................: |
| |
| ....[SiZE.NUMBER.OF.DiSCS]........................................ |
| || 50 Files @ 20,000,000 Bytes = 934 MB : |
| ||...............................................................: |
| |
| ....[GREETINGS/Hi-5's]............................................ |
| || kEiSO - QUASAR - PRODEV - ELOHIM - JGTiSO - OXBRiDGE : |
| ||...............................................................: |
| |
| ....[FUCK-YOU's].................................................. |
| || SoSISO - XQZT - AND ALL OTHER P2P BITCHES : |
| || DO NOT TRUST THESE PEOPLES PROPAGANDA! +DUPECHECK + ISBN PLS! : |
| || INCLUDE SUPPORT_FILES! & LABEL YOUR DIRS PROPERLY!!!!!! : |
| || --------------------------------------------------------------: |
| || PEOPLE HAD THE AUDACITY TO ASK US WHAT THIS EVEN MEANS!!!! : |
| || WHILE THERE ARE RELAXED RULES IN BOOKWARE THIS DOES NOT MEAN : |
| || EVERY VIDEO ON A SITE IS PUBLISHED BY THAT WEB SITE, THERE HAS: |
| || BEEN COUNTLESS DUPES OVER THE PAST YEARS THAT WERE NOT NUKED : |
| || INCLUDE AN ISBN NUMBER - INFACT HONESTLY THE DIRS SHOULD BE : |
| || ISBNXXXXXXXXXXXX.BOOKWARE/TUTORiAL-GROUP SINCE PPL HAVE SO : |
| || TROUBLE READING. ISBN NUMBER SHOULD NEED BE REQUIRED IN NFO. : |
| || THERE IS NO OTHER WAY TO KNOW 100% IF THE GROUP GOT THE TITLE : |
| || OR ANYTHING ELSE CORRECT!!!! WE WILL HAPPILY LEAVE WHEN THIS : |
| || IS FIXED! : |
| || ------------------------------------------------------------- : |
| || /dev/random: : |
| || ------------ : |
| || They paint the world full of shadows, and then tell their : |
| || children to stay close to the light, their light, their : |
| || reasons, *their* judgements. Because in the darkness there be : |
| || dragons, but it is not true. We can prove that it is not true.: |
| || In the dark there is discovery, there is possibility, there is: |
| || freedom in the dark when someone has illuminated it. And who : |
| || who has been so close as we are right now? : |
| || : |
| || PGA is dedicated to the purity of real piracy, not for making : |
| || money off of it, or exploiting the scene in *ANY* way. We are : |
| || the true pirates, illuminating the darkness, giving birth to : |
| || possibilities in a time where so little seems achievable. Join: |
| || us and usher in this new age. : |
| ||...............................................................: |
|....................................................................|
- LAYOUT & DESiGN BY #MONk!# oF DiViNE STYLERS! -