Udemy Oracle SQL 12c Become an SQL Developer with Eng Subtitle | 290DF0F0C6700B41B165E08A815C4018FC77C0D7

Udemy Oracle SQL 12c Become an SQL Developer with Eng Subtitle

Name	Udemy - Oracle SQL 12c - Become an SQL Developer [with Eng Subtitle]	DOWNLOAD Copy Link
Total Size	2.5 GB
Total Files	98
Hash	290DF0F0C6700B41B165E08A815C4018FC77C0D7

/01 Introduction and Software Preparation/
001 Downloading and Installing Oracle Database.mp4	42.7 MB
002 Downloading and Configuring Oracle SQL Developer.mp4	27.5 MB
003 Describing Relational Database Management Systems RDBMS.mp4	6.3 MB
004 Describe the Schema used in this course HR.mp4	8.3 MB
005 Entity Relationship Logic in Oracle Database.mp4	9.7 MB
006 SQL Statement used in this course.mp4	4.3 MB
007 Oracle SQL Developer Basics.mp4	20.1 MB
/02 Retrieving Data/
001 Oracle Data Types.mp4	11.4 MB
001 Quiz.pdf	646.9 KB
002 DESCRIBE Command.mp4	9.7 MB
003 SQL Statement Basics.mp4	41.0 MB
004 Using SELECT Statement.mp4	15.9 MB
005 Using Column Aliases.mp4	25.0 MB
006 Quote Q Operator.mp4	18.8 MB
007 DISTINCT Operator.mp4	17.3 MB
008 Concatenation Operators.mp4	25.4 MB
009 Arithmetic Expressions and NULL Values.mp4	33.8 MB
/03 Restricting Data/
001 Using WHERE Clause.mp4	10.9 MB
002 Comparison Operators.mp4	26.1 MB
003 BETWEEN AND Operator.mp4	21.8 MB
004 IN Operator.mp4	23.2 MB
005 LIKE Operator.mp4	31.4 MB
006 IS NULL Operator.mp4	9.7 MB
007 Logical Operators AND, OR, NOT.mp4	44.8 MB
008 Rules of Precedence.mp4	17.8 MB
/04 Sorting Data/
001 ORDER BY Clause.mp4	17.7 MB
002 ASC and DESC Operators.mp4	32.6 MB
003 NULLS FIRST and NULLS LAST Operators.mp4	21.6 MB
/05 Single-Row Functions/
001 Single Row Functions.mp4	24.6 MB
002 Character Functions Part 1.mp4	47.2 MB
003 Character Functions Part 2.mp4	54.4 MB
004 Number Functions.mp4	26.8 MB
005 Nesting Functions.mp4	22.6 MB
006 Date Operations.mp4	71.1 MB
007 Date Functions.mp4	25.9 MB
/06 Conversion Functions/
001 Conversion Functions.mp4	23.6 MB
002 TO_CHAR, TO_DATE, TO_NUMBER Functions Part 1.mp4	38.5 MB
003 TO_CHAR, TO_DATE, TO_NUMBER Functions Part 2.mp4	40.0 MB
004 NVL, NVL2, NULLIF, COALESCE Functions.mp4	45.1 MB
/07 Conditional Expressions/
001 Conditional Expressions CASE-DECODE.mp4	70.4 MB
/08 Group Functions/
001 Group Functions.mp4	12.5 MB
002 AVG Function.mp4	14.8 MB
003 COUNT Function.mp4	14.6 MB
004 MAX Function.mp4	13.1 MB
005 MIN Function.mp4	18.5 MB
006 SUM Function.mp4	10.1 MB
007 Overview Of Group Functions.mp4	8.6 MB
/09 Grouping Data/
001 GROUP BY Clause.mp4	59.8 MB
002 HAVING Clause.mp4	29.0 MB
003 Nesting Group Functions.mp4	13.2 MB
/10 Joining Multiple Tables/
001 Joining Multiple Tables Types of Joins.mp4	13.8 MB
002 Natural Joins.mp4	39.4 MB
003 Join with USING Clause.mp4	26.6 MB
004 Handling Ambiguous Column Names.mp4	27.0 MB
005 Join with ON Clause.mp4	22.5 MB
006 Multiple Join Operations.mp4	23.9 MB
007 Restricting Joins.mp4	9.8 MB
008 Joining Unequal Tables.mp4	13.9 MB
009 SELF JOIN.mp4	20.8 MB
010 OUTER JOINS.mp4	19.8 MB
011 LEFT OUTER JOIN.mp4	20.4 MB
012 RIGHT OUTER JOIN.mp4	37.6 MB
013 FULL OUTER JOIN.mp4	11.5 MB
014 CROSS JOIN Cartesian Product.mp4	26.8 MB
/11 Using Subqueries/
001 Using Subqueries.mp4	23.9 MB
002 Single Row Subqueries.mp4	36.8 MB
003 Multiple Row Subqueries.mp4	38.1 MB
004 Multiple Column Subqueries.mp4	28.0 MB
/12 Using SET Operators/
001 SET Operators.mp4	43.9 MB
002 UNION and UNION AlLL Operators.mp4	43.7 MB
003 INTERSECT Operator.mp4	7.5 MB
004 MINUS Operator.mp4	8.6 MB
005 Matching Unmatched Queries in SET Operations.mp4	10.9 MB
006 Order By with SET Operators.mp4	22.2 MB
/13 Data Manipulation Language DML Statements/
001 Data Manipulation Language DML.mp4	9.5 MB
002 INSERT Statement Part 1.mp4	40.1 MB
003 INSERT Statement Part 2.mp4	46.0 MB
004 UPDATE Statement.mp4	41.6 MB
005 DELETE Statement.mp4	24.3 MB
006 Transaction Control Statements.mp4	17.6 MB
007 COMMIT and ROLLBACK Statements.mp4	35.1 MB
008 SAVEPOINT Statement.mp4	47.8 MB
009 FOR UPDATE Statement.mp4	31.5 MB
/14 Data Definition Language DDL Statements/
001 Data Definition Language DDL.mp4	4.8 MB
002 Naming Rules.mp4	8.9 MB
003 CREATE TABLE Statement.mp4	59.9 MB
004 ALTER TABLE Statements.mp4	75.9 MB
005 DROP TABLE Statement.mp4	14.0 MB
006 TRUNCATE TABLE Statement.mp4	16.8 MB
007 COMMENT Statement.mp4	25.4 MB
008 RENAME Statement.mp4	19.9 MB
/15 Creating Constraints/
001 Creating Constraints.mp4	16.4 MB
002 NOT NULL Constraint.mp4	20.8 MB
003 UNIQUE Constraint.mp4	38.5 MB
004 PRIMARY KEY Constraint.mp4	24.2 MB
005 FOREIGN KEY Constraint.mp4	64.3 MB
006 CHECK Constraint.mp4	14.3 MB
/16 Conclusion/
001 Conclusion.mp4	918.6 KB
Total files 98