Udemy - SQL Bootcamp - Complete SQL Course

seeders: 31
leechers: 13
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 237
  • Language: English

Files

[ FreeCourseWeb.com ] Udemy - SQL Bootcamp - Complete SQL Course
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 01 Introduction
    • 001 Course Intro.en.srt (5.2 KB)
    • 001 Course Intro.mp4 (52.1 MB)
    02 Beginner_ PostgreSQL Downloading & Installing + Preparing Airlines Database
    • 001 SQL PostgreSQL Down and install.en.srt (3.2 KB)
    • 001 SQL PostgreSQL Down and install.mp4 (21.4 MB)
    • 002 PostgreSQL Database creation.en.srt (1.4 KB)
    • 002 PostgreSQL Database creation.mp4 (6.7 MB)
    • 003 SQL Restore.en.srt (1.4 KB)
    • 003 SQL Restore.mp4 (10.5 MB)
    03 Beginner_ Database Airlines Overview
    • 001 SQL Database Overview Part 1.en.srt (2.7 KB)
    • 001 SQL Database Overview Part 1.mp4 (8.7 MB)
    • 002 SQL Database Overview Part 2.en.srt (4.7 KB)
    • 002 SQL Database Overview Part 2.mp4 (6.2 MB)
    • 003 SQL Data Types.en.srt (1.3 KB)
    • 003 SQL Data Types.mp4 (11.0 MB)
    04 Beginner_ SQL Basics Part 1
    • 001 Select Statement.en.srt (6.2 KB)
    • 001 Select Statement.mp4 (36.8 MB)
    • 002 Select Challenge Solution.en.srt (2.8 KB)
    • 002 Select Challenge Solution.mp4 (18.4 MB)
    • 003 Select Statement For all Airlines Database Tables.en.srt (1.8 KB)
    • 003 Select Statement For all Airlines Database Tables.mp4 (29.9 MB)
    • 004 Distinct.en.srt (2.1 KB)
    • 004 Distinct.mp4 (11.7 MB)
    05 Beginner_ SQL Basics Part 2
    • 001 Where Clause.en.srt (7.3 KB)
    • 001 Where Clause.mp4 (49.6 MB)
    • 002 Operators used with Where Clause.en.srt (4.6 KB)
    • 002 Operators used with Where Clause.mp4 (31.9 MB)
    • 003 Where Clause + AND & Where Clause + OR.en.srt (3.5 KB)
    • 003 Where Clause + AND & Where Clause + OR.mp4 (17.2 MB)
    • 004 Where Clause + LIKE.en.srt (5.5 KB)
    • 004 Where Clause + LIKE.mp4 (24.9 MB)
    • 005 (Where Clause + BETWEEN & IN) & AS.en.srt (5.5 KB)
    • 005 (Where Clause + BETWEEN & IN) & AS.mp4 (41.6 MB)
    06 Beginner_ SQL Basics Part 3
    • 001 LIMIT & ORDER BY.en.srt (8.0 KB)
    • 001 LIMIT & ORDER BY.mp4 (51.6 MB)
    • 002 FETCH vs LIMIT.en.srt (2.8 KB)
    • 002 FETCH vs LIMIT.mp4 (22.5 MB)
    • 003 NOT IN.en.srt (4.1 KB)
    • 003 NOT IN.mp4 (28.5 MB)
    • 004 ISNULL & IS NOT NULL.en.srt (2.8 KB)
    • 004 ISNULL & IS NOT NULL.mp4 (22.0 MB)
    • 005 CAST.en.srt (4.4 KB)
    • 005 CAST.mp4 (30.7 MB)
    07 Intermediate_ SQL Aggregations
    • 001 COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE.en.srt (4.9 KB)
    • 001 COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE.mp4 (25.9 MB)
    • 002 SUM( ) Function.en.srt (1.0 KB)
    • 002 SUM( ) Function.mp4 (6.2 MB)
    • 003 MIN( ) , MAX( ) & AVG( ) Functions.en.srt (2.3 KB)
    • 003 MIN( ) , MAX( ) & AVG( ) Functions.mp4 (10.9 MB)
    • 004 GROUP BY & HAVING.en.srt (2.3 KB)
    • 004 GROUP BY & HAVING.mp4 (14.5 MB)
    08 Intermediate_ SQL Conditional
    • 001 CASE Clause in SQL.en.srt (4.5 KB)
    • 001 CASE Clause in SQL.mp4 (9.1 MB)
    • 002 NULLIF() Function in SQL.en.srt (4.0 KB)
    • 002 NULLIF() Function in SQL.mp4 (24.4 MB)
    • 003 COALESCE() Function in SQL.en.srt (2.7 KB)
    • 003 COALESCE() Function in SQL.mp4 (24.3 MB)
    09 Intermediate_ SQL Time Data management
    • 001 Overview of Time Functions in PostgreSQL.en.srt (2.2 KB)
    • 001 Overview of Time Functions in PostgreSQL.mp4 (30.5 MB)
    • 002 TIMESTAMP EXTRACT().en.srt (3.0 KB)
    • 002 TIMESTAMP EXTRACT().mp4 (25.4 MB)
    • 003 DATE_TRUNC() & DATE_PART().en.srt (7.7 KB)
    • 003 DATE_TRUNC() & DATE_PART().mp4 (38.7 MB)
    • 004 Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( ).en.srt (3.5 KB)
    • 004 Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( ).mp4 (19.6 MB)
    10 Intermediate_ SQL Joins
    • 001 INNER JOIN.en.srt (6.8 KB)
    • 001 INNER JOIN.mp4 (53.0 MB)
    • 002 Joins Types Overview.en.srt (10.7 KB)
    • 002 Joins Types Overview.mp4 (41.6 MB)
    • 003 LEFT OUTER JOIN.en.srt (4.1 KB)
    • 003 LEFT OUTER JOIN.mp4 (27.7 MB)
    • 004 Deep understanding of LEFT JOIN.en.srt (3.4 KB)
    • 004 Deep understanding of LEFT JOIN.mp4 (22.7 MB)
    • 005 RIGHT OUTER JOIN.en.srt (3.2 KB)
    • 005 RIGHT OUTER JOIN.mp4 (20.6 MB)
    • 006 FULL OUTER JOIN.en.srt (5.5 KB)
    • 006 FULL OUTER JOIN.mp4 (38.0 MB)
    • 007 CROSS JOIN.en.srt (2.3 KB)
    • 007 CROSS JOIN.mp4 (18.5 MB)
    • 008 UNION, UNION ALL, INTERSECT & EXCEPT.en.srt (6.1 KB)
    • 008 UNION, UNION ALL, INTERSECT & EXCEPT.mp4 (36.4 MB)
    • 009 SELF JOIN.en.srt (2.7 KB)
    • 009 SELF JOIN.mp4 (18.2 MB)
    • 010 USING.en.srt (2.3 KB)
    • 010 USING.mp4 (21.9 MB)
    • 011 NATURAL JOIN.en.srt (1.9 KB)
    • 011 NATURAL JOIN.mp4 (14.9 MB)
    11 Intermediate_ Sub-queries & Common Table Expression in SQL
    • 001 Sub-queries.en.srt (6.0 KB)
    • 001 Sub-queries.mp4 (38.8 MB)
    • 002 SQL Sub-query + EXISTS, ANY OR ALL.en.srt (9.2 KB)
    • 002 SQL Sub-query + EXISTS, ANY OR ALL.mp4 (90.3 MB)
    • 003 Common Table Expression.en.srt (8.5 KB)
    • 003 Common Table Expression.mp4 (61.0 MB)
    12 Advanced_ PostgreSQL Math & Window functions
    • 001 Math Functions.en.srt (4.2 KB)
    • 001 Math Functions.mp4 (39.9 MB)
    • 002 Window Functions OVER().en.srt (3.0 KB)
    • 002 Window Functions OVER().mp4 (25.8 MB)
    • 003 Window Functions RANK() + OVER() & NTILE() + OVER().en.srt (5.1 KB)
    • 003 Window Functions RANK() + OVER() & NTILE() + OVER().mp4 (68.8 MB)
    • 004 Window Functions OVER() + LEAD().en.srt (5.6 KB)

    • Description

      SQL Bootcamp: Complete SQL Course



      MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
      Genre: eLearning | Language: English + srt | Duration: 97 lectures (4h 11m) | Size: 1.52 GB
      Using PostgreSQL & applicable to Oracle SQL, Microsoft SQL Server, and MySQL for Data Science, Apps and Web development
      What you'll learn:
      Using Real World PostgreSQL Database Airlines Database.
      Use Python Pandas to Analyze and visualize Postgres Data Output.
      SQL Test Your Self, SQL Challenges, SQL Final Exam and more
      Use Python to visualize Postgres Data Output and get your Conclusion about Data.
      Use SQL to create databases.
      Use SQL to insert data into a table.
      Use SQL to Query & retrieve data from databases.
      Use SQL to Sort records after retrieving from databases.
      Use SQL to Group data by specific conditions.
      Use SQL to Filter data by using where clause.
      How & when to use Joins types in SQL.
      How to create and deal with Sub-queries in SQL.
      How to create and deal with common table expression in SQL.
      Use SQL to perform data analysis of real world databases
      Use SQL to perform advanced techniques to retrieve data from databases.

      Requirements
      Computer and internet.
      No prior knowledge required for this course.

      Description
      You will learn many tips and tricks in PostgreSQL to query data through the following Topics covered in this course:

      Using Real World PostgreSQL Database Airlines Database.



Download torrent
1.7 GB
seeders:31
leechers:13
Udemy - SQL Bootcamp - Complete SQL 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.7 GB
seeders:31
leechers:13
Udemy - SQL Bootcamp - Complete SQL Course

Torrent hash: B103C83937CF88B0D4507C4486B509B5E68941E7