| 1 - Getting Ready.mp4 | 2.9 MB | ||
| 10 - SELECT Distinct Column Values.mp4 | 10.7 MB | ||
| 11 - ORDER BY Clause.mp4 | 19.2 MB | ||
| 12 - Query Summary.html | 1.2 KB | ||
| 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 | 716.8 B | ||
| 18 - Aggregates.mp4 | 24.4 MB | ||
| 19 - Group By Clause.mp4 | 18.9 MB | ||
| 2 - Install SQL Server.mp4 | 8.3 MB | ||
| 20 - Query Summary.html | 1 KB | ||
| 21 - DATEDIFF.mp4 | 6.8 MB | ||
| 22 - Other Date Functions.mp4 | 7.5 MB | ||
| 23 - Query Summary.html | 512 B | ||
| 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 | 716.8 B | ||
| 3 - Install SQL Server Management Studio.mp4 | 6.8 MB | ||
| 30 - HAVING Clause.mp4 | 11.6 MB | ||
| 31 - Partition By.mp4 | 18.7 MB | ||
| 32 - Query Summary.html | 307.2 B | ||
| 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 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 | ||
| 4 - Load Sample Database.mp4 | 18.4 MB | ||
| 40 - Query Summary.html | 2.4 KB | ||
| 41 - EXISTS.mp4 | 19.2 MB | ||
| 42 - ALL.mp4 | 21.7 MB | ||
| 43 - Query Summary.html | 512 B | ||
| 44 - CASE SWITCH.mp4 | 19.8 MB | ||
| 45 - Query Summary.html | 512 B | ||
| 46 - Create and Query a SQL View.mp4 | 15.6 MB | ||
| 47 - Query Summary.html | 614.4 B | ||
| 48 - Create and Drop Table.mp4 | 56.7 MB | ||
| 49 - Query Summary.html | 307.2 B | ||
| 5 - Load Flat Files.mp4 | 51.3 MB | ||
| 50 - Insert and Delete Rows.mp4 | 41.3 MB | ||
| 51 - Query Summary.html | 409.6 B | ||
| 52 - Update Statement.mp4 | 11.2 MB | ||
| 53 - Query Summary.html | 102.4 B | ||
| 54 - SQL Queries and Power BI.mp4 | 18.1 MB | ||
| 6 - SQLiteOnline.mp4 | 8.8 MB | ||
| 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 | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| complaint.csv | 72 KB | ||
| customer.csv | 124.5 KB | ||
| district.csv | 3.8 KB | ||
| order.csv | 1.5 MB | ||
| ▲ 64 total files | |||
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 1 day | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 1 day | 1 | 5 |
| 2.5 GB | freecoursewb | 3 days | 56 | 10 | |
| 1.6 GB | freecoursewb | 2 weeks | 9 | 8 | |
| 1.3 GB | freecoursewb | 2 weeks | 32 | 2 |
All Comments