Udemy - Sql Queries 101 - A Beginner'S Guide To Data Retrieval

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

Files

[ DevCourseWeb.com ] Udemy - Sql Queries 101 - A Beginner'S Guide To Data Retrieval
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1 - Introduction
    • 1 - Getting Ready.mp4 (2.9 MB)
    • 2 - Install SQL Server.mp4 (8.3 MB)
    • 3 - Install SQL Server Management Studio.mp4 (6.8 MB)
    • 4 - Load Sample Database.mp4 (18.4 MB)
    • 5 - Load Flat Files.mp4 (51.3 MB)
      • FlatFiles
      • complaint.csv (74.8 KB)
      • customer.csv (128.5 KB)
      • district.csv (3.8 KB)
      • order.csv (1.5 MB)
      10 - SubQuery
      • 41 - EXISTS.mp4 (19.2 MB)
      • 42 - ALL.mp4 (21.7 MB)
      • 43 - Query Summary.html (0.5 KB)
      11 - CASE SWITCH
      • 44 - CASE SWITCH.mp4 (19.8 MB)
      • 45 - Query Summary.html (0.5 KB)
      12 - SQL View
      • 46 - Create and Query a SQL View.mp4 (15.6 MB)
      • 47 - Query Summary.html (0.6 KB)
      13 - Create and Drop Table
      • 48 - Create and Drop Table.mp4 (56.7 MB)
      • 49 - Query Summary.html (0.3 KB)
      14 - Insert and Delete Rows
      • 50 - Insert and Delete Rows.mp4 (41.3 MB)
      • 51 - Query Summary.html (0.4 KB)
      15 - Update Rows
      • 52 - Update Statement.mp4 (11.2 MB)
      • 53 - Query Summary.html (0.1 KB)
      16 - SQL Queries with Power BI
      • 54 - SQL Queries and Power BI.mp4 (18.1 MB)
      2 - Setup without SQL Server
      • 6 - SQLiteOnline.mp4 (8.8 MB)
        • FlatFiles_SQLLiteOnline
        • complaint.csv (72.0 KB)
        • customer.csv (124.5 KB)
        • district.csv (3.8 KB)
        • order.csv (1.5 MB)
        3 - The SELECT Statement
        • 10 - SELECT Distinct Column Values.mp4 (10.7 MB)
        • 11 - ORDER BY Clause.mp4 (19.2 MB)
        • 12 - Query Summary.html (1.2 KB)
        • 7 - SELECT All Columns.mp4 (6.9 MB)
        • 8 - SELECT Specific Columns.mp4 (13.6 MB)
        • 9 - SELECT Top and Bottom Rows.mp4 (7.9 MB)
        4 - Scalar Functions
        • 13 - Concatenate.mp4 (14.2 MB)
        • 14 - RIGHT and LEFT.mp4 (7.3 MB)
        • 15 - LEN.mp4 (6.7 MB)
        • 16 - Format.mp4 (19.5 MB)
        • 17 - Query Summary.html (0.7 KB)
        5 - Aggregate Functions and Grouping
        • 18 - Aggregates.mp4 (24.4 MB)
        • 19 - Group By Clause.mp4 (18.9 MB)
        • 20 - Query Summary.html (1.0 KB)
        6 - Date and Time Functions
        • 21 - DATEDIFF.mp4 (6.8 MB)
        • 22 - Other Date Functions.mp4 (7.5 MB)
        • 23 - Query Summary.html (0.5 KB)
        7 - Operators
        • 24 - Comparison Operators.mp4 (81.9 MB)
        • 25 - AND or BETWEEN.mp4 (33.5 MB)
        • 26 - LIKE.mp4 (24.3 MB)
        • 27 - IN and OR.mp4 (18.8 MB)
        • 28 - Logical Operators Wrap Up.mp4 (3.4 MB)
        • 29 - Query Summary.html (0.7 KB)
        8 - GROUPING
        • 30 - HAVING Clause.mp4 (11.6 MB)
        • 31 - Partition By.mp4 (18.7 MB)
        • 32 - Query Summary.html (0.3 KB)
        9 - Table Relationships
        • 33 - Inner Join Video Chapter.mp4 (56.8 MB)
        • 34 - More with INNER JOINS.mp4 (64.1 MB)
        • 35 - LEFT and RIGHT JOIN.mp4 (37.0 MB)
        • 36 - JOIN Three Tables.mp4 (57.3 MB)
        • 37 - JOIN Four Tables.mp4 (28.1 MB)
        • 38 - FULL OUTER JOIN.mp4 (12.8 MB)
        • 39 - EXCEPT.mp4 (17.5 MB)
        • 40 - Query Summary.html (2.4 KB)
        • Bonus Resources.txt (0.4 KB)

Description

Sql Queries 101: A Beginner'S Guide To Data Retrieval

https://DevCourseWeb.com

Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 930.40 MB | Duration: 2h 27m

Building a Strong Foundation in SQL Query Writing

What you'll learn
Use of Scalar functions to manipulate or compute values for individual rows of a result set
Use of Aggregation Functions allowing you to summarize and compute statistics on data, providing valuable insights into trends and patterns.
Joins to combine data from multiple tables, enabling to perform more complex queries and gain insights from related datasets.
Subqueries as a means of filtering data based on the results of another query or performing calculations

Requirements
A basic understanding of mathematical concepts like arithmetic, comparisons, and logical operations can be beneficial when constructing SQL queries involving calculations or conditional statements.



Download torrent
932.9 MB
seeders:5
leechers:13
Udemy - Sql Queries 101 - A Beginner'S Guide To Data Retrieval

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
932.9 MB
seeders:5
leechers:13
Udemy - Sql Queries 101 - A Beginner'S Guide To Data Retrieval

Torrent hash: 5EEC51E3DE046D1589705ADD6AFA68A08E0D804B