Tags
Language
Tags
<<
November 2025
Su Mo Tu We Th Fr Sa
26 27 28 29 30 31 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 1 2 3 4 5 6
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz
    1. Home
    2. eBooks & eLearning
    3. Pluralsight - SQL Data Wrangling in Oracle: Table Data [repost]

    Pluralsight - SQL Data Wrangling in Oracle: Table Data [repost]

    Posted By: house23
    Date: 25 Mar 2015 14:46:26
    Pluralsight - SQL Data Wrangling in Oracle: Table Data [repost]

    Pluralsight - SQL Data Wrangling in Oracle: Table Data
    MP4 | AVC 211kbps | English | 1024x768 | 15fps | 5h 18mins | AAC stereo 102kbps | 624 MB
    Genre: Video Training

    This course describes Oracle functionality useful to the SQL-savvy data analyst, and features topics such as ordering your data with NULLs appearing first or last, using FETCH to subset your data, using SAMPLE to randomly sample from a table, using CROSS APPLY and OUTER APPLY, how to use the MODEL feature to access the rows and columns of a database table like a spreadsheet, generating random numbers, computing occurrences, using nested tables, and much, more.

    Course Introduction
    16:48
    Ordering, Sampling, and Random Numbers: Part I
    18:26
    Ordering, Sampling, and Random Numbers: Part II
    21:05
    Extraction and Insertion: Part I
    21:48
    Extraction and Insertion: Part II
    24:31
    Extraction and Insertion: Part III
    24:46
    Extraction and Insertion: Part IV
    32:35
    Nested Tables
    36:11
    Computing Intersections and Occurrences: Part I
    20:07
    Computing Intersections and Occurrences: Part II
    22:08
    The MODEL Feature - Part I
    21:34
    The MODEL Feature - Part II
    18:30
    The MODEL Feature - Part III
    20:12
    Course Summary
    19:23


    Format : MPEG-4
    Format profile : Base Media / Version 2
    Codec ID : mp42
    File size : 11.8 MiB
    Duration : 5mn 13s
    Overall bit rate mode : Variable
    Overall bit rate : 316 Kbps
    Movie name : sql-data-wrangling-oracle-tables-m14-cs
    Encoded date : UTC 2014-11-14 15:43:51
    Tagged date : UTC 2014-11-14 15:44:10
    Writing application : HandBrake 0.9.8 2012071700
    Video #1
    ID : 1
    Format : AVC
    Format/Info : Advanced Video Codec
    Format profile : Baseline@L3.1
    Format settings, CABAC : No
    Format settings, ReFrames : 2 frames
    Format settings, GOP : M=1, N=50
    Codec ID : avc1
    Codec ID/Info : Advanced Video Coding
    Duration : 5mn 13s
    Duration_FirstFrame : 67ms
    Bit rate : 211 Kbps
    Width : 1 024 pixels
    Height : 768 pixels
    Display aspect ratio : 4:3
    Frame rate mode : Constant
    Frame rate : 15.000 fps
    Color space : YUV
    Chroma subsampling : 4:2:0
    Bit depth : 8 bits
    Scan type : Progressive
    Bits/(Pixel*Frame) : 0.018
    Stream size : 7.89 MiB (67%)
    Writing library : x264 core 120
    Encoding settings : cabac=0 / ref=2 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=0 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=0 / weightp=0 / keyint=50 / keyint_min=15 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=20.0 / qcomp=0.60 / qpmin=3 / qpmax=69 / qpstep=4 / ip_ratio=1.40 / aq=1:1.00
    Encoded date : UTC 2014-11-14 15:43:51
    Tagged date : UTC 2014-11-14 15:44:10
    Color primaries : BT.709
    Transfer characteristics : BT.709
    Matrix coefficients : BT.709
    Audio #2
    ID : 2
    Format : AAC
    Format/Info : Advanced Audio Codec
    Format profile : LC
    Codec ID : 40
    Duration : 5mn 13s
    Bit rate mode : Variable
    Bit rate : 102 Kbps
    Maximum bit rate : 136 Kbps
    Channel(s) : 2 channels
    Channel positions : Front: L R
    Sampling rate : 44.1 KHz
    Compression mode : Lossy
    Stream size : 3.83 MiB (32%)
    Language : English
    Encoded date : UTC 2014-11-14 15:43:51
    Tagged date : UTC 2014-11-14 15:44:10


    Pluralsight - SQL Data Wrangling in Oracle: Table Data [repost]

    Pluralsight - SQL Data Wrangling in Oracle: Table Data [repost]

    Pluralsight - SQL Data Wrangling in Oracle: Table Data [repost]


    No mirrors please

    Visit my blog, click here
    UPWARDS