Companies Home Search Profile
TrainingHub TrainingHub

Job-Ready SQL in an Afternoon

Focused View

6:01:54

10 View
  • 01-intro.mp4
    00:40
  • 02-relational databases intro.mp4
    15:19
  • 03-data types and schemas.mp4
    17:35
  • 04-mac setting up a local pg server.mp4
    03:25
  • 05-windows local postgres server.mp4
    04:52
  • 06-mac postico setup.mp4
    04:34
  • 07-datagrip setup.mp4
    05:32
  • 08-cli connection.mp4
    01:20
  • 09-creating and dropping databases.mp4
    06:01
  • 10-creating schemas.mp4
    03:48
  • 11-creating tables.mp4
    08:36
  • 12-altering tables.mp4
    03:06
  • 13-enumerated types.mp4
    04:51
  • 14-inserting values.mp4
    06:57
  • 15-running an sql script.mp4
    06:20
  • 16-reading data.mp4
    07:00
  • 17-creating tables from query result.mp4
    06:28
  • 18-16aliasingandorderinghb.mp4
    13:41
  • 19-conditional filtering direct comparison.mp4
    05:08
  • 20-18conditionalfilteringgroupcomparisonhb.mp4
    10:20
  • 21-19joiningconditionalshb.mp4
    07:50
  • 22-20negatingconditionalshb.mp4
    04:40
  • 23-21filteringnullvalueshb.mp4
    01:31
  • 24-22creatingnewcolumnsandarithmeticshb.mp4
    07:36
  • 25-23datatypeconverstionshb.mp4
    06:33
  • 26-24logicstatementshb.mp4
    07:22
  • 27-25manipulatingstringshb.mp4
    09:59
  • 28-26stringpositionalinformationhb.mp4
    08:10
  • 29-27stringsubsetsandconcatinationshb.mp4
    22:56
  • 30-28stringreplacementshb.mp4
    09:35
  • 31-29dateandtimehb.mp4
    06:32
  • 32-30datetimeintervalshb.mp4
    07:37
  • 33-31commentshb.mp4
    06:50
  • 34-32aggregationfunctionshb.mp4
    06:54
  • 35-33groupingandfilteringaggregationshb.mp4
    12:20
  • 36-34joinshb.mp4
    18:49
  • 37-35leftrightfulljoinshb.mp4
    16:48
  • 38-36selfjoinshb.mp4
    09:05
  • 39-37unionshb.mp4
    05:29
  • 40-subqueries.mp4
    09:02
  • 41-39windowfunctionsandaliaseshb.mp4
    15:26
  • 42-40rownumbersandrankshb.mp4
    06:14
  • 43-41usingotherrowswithwindowfunctionshb.mp4
    11:07
  • 44-42ntileshb.mp4
    04:09
  • 45-43understandingqueryperformancehb.mp4
    03:47

    • More details

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category

    SQL

    SkillShare
    SkillShare
    View courses SkillShare
    Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.
    • language english
    • Training sessions 45
    • duration 6:01:54
    • Release Date 2024/03/07

    Courses related to SQL

    RDBMS - SQL Course - Step by Step Guide to learn SQL
    UdemyRDBMS - SQL Course - Step by Step Guide to learn SQL
    12:56:32
    03/27/2023
    SQL Mastery: Learn Enough SQL To Be A Professional [2023]
    Udemy SDE Arts | Octavo
    SDE Arts | Octavo
    SQL Mastery: Learn Enough SQL To Be A Professional [2023]
    4:34:45
    06/20/2023
    SQL Essentials with MariaDB: A Beginner's Guide
    Udemy 247 Learning
    247 Learning
    SQL Essentials with MariaDB: A Beginner's Guide
    3:05:28
    05/19/2024