Udemy - Oracle SQL 12c - Become an SQL Developer [with Eng Subtitle]_Sin

seeders: 1
leechers: 0
Added on July 1, 2016 by Sinin Other > Tutorials
Torrent verified.



Udemy - Oracle SQL 12c - Become an SQL Developer [with Eng Subtitle]_Sin (Size: 2.36 GB)
 001 Downloading and Installing Oracle Database.mp440.75 MB
 002 Downloading and Configuring Oracle SQL Developer.mp426.25 MB
 003 Describing Relational Database Management Systems RDBMS.mp46.03 MB
 004 Describe the Schema used in this course HR.mp47.92 MB
 005 Entity Relationship Logic in Oracle Database.mp49.28 MB
 006 SQL Statement used in this course.mp44.14 MB
 007 Oracle SQL Developer Basics.mp419.2 MB
 001 Oracle Data Types.mp410.88 MB
 001 Quiz.pdf631.71 KB
 002 DESCRIBE Command.mp49.24 MB
 003 SQL Statement Basics.mp439.12 MB
 004 Using SELECT Statement.mp415.13 MB
 005 Using Column Aliases.mp423.81 MB
 006 Quote Q Operator.mp417.96 MB
 007 DISTINCT Operator.mp416.46 MB
 008 Concatenation Operators.mp424.22 MB
 009 Arithmetic Expressions and NULL Values.mp432.21 MB
 001 Using WHERE Clause.mp410.38 MB
 002 Comparison Operators.mp424.9 MB
 003 BETWEEN AND Operator.mp420.79 MB
 004 IN Operator.mp422.14 MB
 005 LIKE Operator.mp429.96 MB
 006 IS NULL Operator.mp49.24 MB
 007 Logical Operators AND, OR, NOT.mp442.75 MB
 008 Rules of Precedence.mp416.94 MB
 001 ORDER BY Clause.mp416.84 MB
 002 ASC and DESC Operators.mp431.12 MB
 003 NULLS FIRST and NULLS LAST Operators.mp420.6 MB
 001 Single Row Functions.mp423.43 MB
 002 Character Functions Part 1.mp445.06 MB
 003 Character Functions Part 2.mp451.88 MB
 004 Number Functions.mp425.52 MB
 005 Nesting Functions.mp421.55 MB
 006 Date Operations.mp467.85 MB
 007 Date Functions.mp424.72 MB
 001 Conversion Functions.mp422.46 MB
 002 TO_CHAR, TO_DATE, TO_NUMBER Functions Part 1.mp436.71 MB
 003 TO_CHAR, TO_DATE, TO_NUMBER Functions Part 2.mp438.17 MB
 004 NVL, NVL2, NULLIF, COALESCE Functions.mp443.03 MB
 001 Conditional Expressions CASE-DECODE.mp467.17 MB
 001 Group Functions.mp411.95 MB
 002 AVG Function.mp414.09 MB
 003 COUNT Function.mp413.9 MB
 004 MAX Function.mp412.45 MB
 005 MIN Function.mp417.67 MB
 006 SUM Function.mp49.62 MB
 007 Overview Of Group Functions.mp48.16 MB
 001 GROUP BY Clause.mp457.03 MB
 002 HAVING Clause.mp427.68 MB
 003 Nesting Group Functions.mp412.58 MB
 001 Joining Multiple Tables Types of Joins.mp413.19 MB
 002 Natural Joins.mp437.58 MB
 003 Join with USING Clause.mp425.38 MB
 004 Handling Ambiguous Column Names.mp425.71 MB
 005 Join with ON Clause.mp421.5 MB
 006 Multiple Join Operations.mp422.78 MB
 007 Restricting Joins.mp49.35 MB
 008 Joining Unequal Tables.mp413.27 MB
 009 SELF JOIN.mp419.82 MB
 010 OUTER JOINS.mp418.84 MB
 001 Using Subqueries.mp422.82 MB
 002 Single Row Subqueries.mp435.13 MB
 003 Multiple Row Subqueries.mp436.37 MB
 004 Multiple Column Subqueries.mp426.68 MB
 001 SET Operators.mp441.88 MB
 002 UNION and UNION AlLL Operators.mp441.7 MB
 003 INTERSECT Operator.mp47.14 MB
 004 MINUS Operator.mp48.23 MB
 005 Matching Unmatched Queries in SET Operations.mp410.43 MB
 006 Order By with SET Operators.mp421.15 MB
 001 Data Manipulation Language DML.mp49.07 MB
 002 INSERT Statement Part 1.mp438.23 MB
 003 INSERT Statement Part 2.mp443.85 MB
 004 UPDATE Statement.mp439.69 MB
 005 DELETE Statement.mp423.15 MB
 006 Transaction Control Statements.mp416.77 MB
 007 COMMIT and ROLLBACK Statements.mp433.49 MB
 008 SAVEPOINT Statement.mp445.59 MB
 009 FOR UPDATE Statement.mp430.08 MB
 001 Data Definition Language DDL.mp44.55 MB
 002 Naming Rules.mp48.44 MB
 003 CREATE TABLE Statement.mp457.09 MB
 004 ALTER TABLE Statements.mp472.41 MB
 005 DROP TABLE Statement.mp413.34 MB
 006 TRUNCATE TABLE Statement.mp416.06 MB
 007 COMMENT Statement.mp424.21 MB
 008 RENAME Statement.mp418.95 MB
 001 Creating Constraints.mp415.63 MB
 002 NOT NULL Constraint.mp419.81 MB
 003 UNIQUE Constraint.mp436.69 MB
 004 PRIMARY KEY Constraint.mp423.03 MB
 005 FOREIGN KEY Constraint.mp461.37 MB
 006 CHECK Constraint.mp413.64 MB
 001 Conclusion.mp4897.06 KB

Description

Course description

An easy course does not mean to understand easily, it means just think to understand. This course is not just easily explained, but also explained in detail, and many examples. If you get this course, please try to write and run all the examples with me. If you follow what I said in this course, "You will be an SQL Developer just in 7 weeks."

What will I learn?

Write SQL codes easily
Can create solutions on any sql problems in their jobs..
Very well organised into 16 sections
Understand database terminology
Reading data using a SELECT statement
Grouping, filtering and restricting data
Inserting, updating and deleting data
Oracle SQL Functions
Oracle Data Types
Joins, set operators, subqueries
Creating, Modifying and Dropping tables
Support from the author

Who is this for?

University or college students
Graduates or workers
Beginners on SQL
Intermediates on SQL
Anyone who wants to improve SQL
Software developers (java/.net/python) interacting with the Oracle Database

What are the requirements?

Oracle Database Software
Oracle SQL Developer

Sharing Widget


Download torrent
2.36 GB
seeders:1
leechers:0
Udemy - Oracle SQL 12c - Become an SQL Developer [with Eng Subtitle]_Sin