Udemy - Complete guide to understanding Oracle SQL - Hands on course

seeders: 5
leechers: 1
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - Complete guide to understanding Oracle SQL - Hands on course
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 01 - Introduction
    • 001 Introduction.mp4 (31.2 MB)
    • 002 Definitions.mp4 (44.5 MB)
    • 003 What is structured query language.mp4 (27.4 MB)
    • 004 SQL development environment.mp4 (4.1 MB)
    • 005 hr-schema.mp4 (44.9 MB)
    02 - Projection
    • 001 1_basic_select, describe, projection.mp4 (20.3 MB)
    • 002 2_arithmetics, null, column alias, concatenation and distinct.mp4 (53.0 MB)
    03 - Selection
    • 001 Where Clause.mp4 (48.1 MB)
    • 002 IN and LIKE operators.mp4 (37.3 MB)
    • 003 NULL and LOGICAL operators.mp4 (55.3 MB)
    • 004 Recap.mp4 (87.1 MB)
    04 - SQL Single row Functions
    • 001 Introduction to sql functions.mp4 (20.4 MB)
    • 002 character single row functions.mp4 (20.5 MB)
    • 003 CONCAT and SUBSTR.mp4 (35.6 MB)
    • 004 TRIM single row functions.mp4 (21.4 MB)
    • 005 REPLACE single row functions.mp4 (13.0 MB)
    • 006 INSTR single row function.mp4 (21.3 MB)
    • 007 LPAD, RPAD AND LENGTH single row functions.mp4 (17.6 MB)
    • 008 Dual table.mp4 (10.1 MB)
    05 - number single row functions
    • 001 Trunc and Round functions.mp4 (18.1 MB)
    • 002 mod, abs, ceil, floor, cos, power, sqrt.mp4 (10.5 MB)
    06 - Date single row functions
    • 001 intro current_date and sysdate.mp4 (21.2 MB)
    • 002 arithmetic with dates.mp4 (23.4 MB)
    • 003 months_between, add_months, next_day, last_day functions.mp4 (41.9 MB)
    • 004 round and trunc with dates.mp4 (22.3 MB)
    07 - Conversion single row functions
    • 001 introduction.mp4 (35.7 MB)
    • 002 to_char, to_date, to_number functions.mp4 (88.1 MB)
    08 - General single row functions
    • 001 nvl, nvl2, nullif, coalesce functions.mp4 (59.6 MB)
    • 002 decode and case functions.mp4 (41.4 MB)
    09 - Multiple Row functions
    • 001 max, min, avg, sum group functions.mp4 (39.4 MB)
    • 002 count function.mp4 (13.8 MB)
    • 003 group by and having clause.mp4 (76.8 MB)
    10 - Working with Joins
    • 001 natural join clause.mp4 (46.2 MB)
    • 002 using clause.mp4 (58.5 MB)
    • 003 on clause.mp4 (29.1 MB)
    • 004 n-way join clause.mp4 (23.3 MB)
    • 005 self and non-equijoins clause.mp4 (53.5 MB)
    • 006 outer joins.mp4 (35.9 MB)
    • 007 cross join.mp4 (19.3 MB)
    11 - Subqueries
    • 001 introduction to subqueries.mp4 (50.8 MB)
    • 002 single row subqueries labs.mp4 (28.6 MB)
    • 003 having clause.mp4 (35.7 MB)
    12 - Multiple Row subquery
    • 001 Multiple Row subqueries.mp4 (30.5 MB)
    • 002 Multiple column subqueries.mp4 (28.1 MB)
    13 - Set Operators
    • 001 introduction.mp4 (20.3 MB)
    • 002 UNION operator.mp4 (38.1 MB)
    • 003 UNION ALL operator.mp4 (31.1 MB)
    • 004 INTERSECT-MINUS operator.mp4 (51.1 MB)
    • Bonus Resources.txt (0.4 KB)

Description

Complete guide to understanding Oracle SQL: Hands on course



https://DevCourseWeb.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.64 GB | Duration: 5h 8m

The ultimate, complete with examples and hands on Labs SQL training plus guide to Oracle exam 1z0-071.

What you'll learn
What is SQL and its importance in databases
Access Oracle database and its development environment
Write efficient SQL queries to produce accurate reports
Understand the different types of SQL statements and how to use them.
Use of SQL Functions
Working with Subqueries
Working with Joins
Using set operators

Requirements
No prior SQL experience required, this is a comprehensive hands on training with easy to follow examples.
Description
These days, almost everyone has to work with data in some form or another. Usually it's through spreadsheets or databases, but if you can learn a little SQL, you can become so much more powerful in your job.



Download torrent
1.6 GB
seeders:5
leechers:1
Udemy - Complete guide to understanding Oracle SQL - Hands on course

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
1.6 GB
seeders:5
leechers:1
Udemy - Complete guide to understanding Oracle SQL - Hands on course

Torrent hash: 06151017856C7084110E5C5E3C2717EA61761FA5