17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - Sql Queries 101 - A Beginner'S Guide To Data Retrieval
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1 - Introduction/1 - Getting Ready.mp4
2.9 MB
~Get Your Files Here !/1 - Introduction/2 - Install SQL Server.mp4
8.3 MB
~Get Your Files Here !/1 - Introduction/3 - Install SQL Server Management Studio.mp4
6.8 MB
~Get Your Files Here !/1 - Introduction/4 - Load Sample Database.mp4
18.4 MB
~Get Your Files Here !/1 - Introduction/5 - Load Flat Files.mp4
51.3 MB
~Get Your Files Here !/1 - Introduction/FlatFiles/complaint.csv
74.8 KB
~Get Your Files Here !/1 - Introduction/FlatFiles/customer.csv
128.5 KB
~Get Your Files Here !/1 - Introduction/FlatFiles/district.csv
3.8 KB
~Get Your Files Here !/1 - Introduction/FlatFiles/order.csv
1.5 MB
~Get Your Files Here !/10 - SubQuery/41 - EXISTS.mp4
19.2 MB
~Get Your Files Here !/10 - SubQuery/42 - ALL.mp4
21.7 MB
~Get Your Files Here !/10 - SubQuery/43 - Query Summary.html
528 B
~Get Your Files Here !/11 - CASE SWITCH/44 - CASE SWITCH.mp4
19.8 MB
~Get Your Files Here !/11 - CASE SWITCH/45 - Query Summary.html
547 B
~Get Your Files Here !/12 - SQL View/46 - Create and Query a SQL View.mp4
15.6 MB
~Get Your Files Here !/12 - SQL View/47 - Query Summary.html
603 B
~Get Your Files Here !/13 - Create and Drop Table/48 - Create and Drop Table.mp4
56.7 MB
~Get Your Files Here !/13 - Create and Drop Table/49 - Query Summary.html
290 B
~Get Your Files Here !/14 - Insert and Delete Rows/50 - Insert and Delete Rows.mp4
41.3 MB
~Get Your Files Here !/14 - Insert and Delete Rows/51 - Query Summary.html
366 B
~Get Your Files Here !/15 - Update Rows/52 - Update Statement.mp4
11.2 MB
~Get Your Files Here !/15 - Update Rows/53 - Query Summary.html
118 B
~Get Your Files Here !/16 - SQL Queries with Power BI/54 - SQL Queries and Power BI.mp4
18.1 MB
~Get Your Files Here !/2 - Setup without SQL Server/6 - SQLiteOnline.mp4
8.8 MB
~Get Your Files Here !/2 - Setup without SQL Server/FlatFiles_SQLLiteOnline/complaint.csv
72 KB
~Get Your Files Here !/2 - Setup without SQL Server/FlatFiles_SQLLiteOnline/customer.csv
124.5 KB
~Get Your Files Here !/2 - Setup without SQL Server/FlatFiles_SQLLiteOnline/district.csv
3.8 KB
~Get Your Files Here !/2 - Setup without SQL Server/FlatFiles_SQLLiteOnline/order.csv
1.5 MB
~Get Your Files Here !/3 - The SELECT Statement/10 - SELECT Distinct Column Values.mp4
10.7 MB
~Get Your Files Here !/3 - The SELECT Statement/11 - ORDER BY Clause.mp4
19.2 MB
~Get Your Files Here !/3 - The SELECT Statement/12 - Query Summary.html
1.2 KB
~Get Your Files Here !/3 - The SELECT Statement/7 - SELECT All Columns.mp4
6.9 MB
~Get Your Files Here !/3 - The SELECT Statement/8 - SELECT Specific Columns.mp4
13.6 MB
~Get Your Files Here !/3 - The SELECT Statement/9 - SELECT Top and Bottom Rows.mp4
7.9 MB
~Get Your Files Here !/4 - Scalar Functions/13 - Concatenate.mp4
14.2 MB
~Get Your Files Here !/4 - Scalar Functions/14 - RIGHT and LEFT.mp4
7.3 MB
~Get Your Files Here !/4 - Scalar Functions/15 - LEN.mp4
6.7 MB
~Get Your Files Here !/4 - Scalar Functions/16 - Format.mp4
19.5 MB
~Get Your Files Here !/4 - Scalar Functions/17 - Query Summary.html
742 B
~Get Your Files Here !/5 - Aggregate Functions and Grouping/18 - Aggregates.mp4
24.4 MB
~Get Your Files Here !/5 - Aggregate Functions and Grouping/19 - Group By Clause.mp4
18.9 MB
~Get Your Files Here !/5 - Aggregate Functions and Grouping/20 - Query Summary.html
1 KB
~Get Your Files Here !/6 - Date and Time Functions/21 - DATEDIFF.mp4
6.8 MB
~Get Your Files Here !/6 - Date and Time Functions/22 - Other Date Functions.mp4
7.5 MB
~Get Your Files Here !/6 - Date and Time Functions/23 - Query Summary.html
537 B
~Get Your Files Here !/7 - Operators/24 - Comparison Operators.mp4
81.9 MB
~Get Your Files Here !/7 - Operators/25 - AND or BETWEEN.mp4
33.5 MB
~Get Your Files Here !/7 - Operators/26 - LIKE.mp4
24.3 MB
~Get Your Files Here !/7 - Operators/27 - IN and OR.mp4
18.8 MB
~Get Your Files Here !/7 - Operators/28 - Logical Operators Wrap Up.mp4
3.4 MB
~Get Your Files Here !/7 - Operators/29 - Query Summary.html
759 B
~Get Your Files Here !/8 - GROUPING/30 - HAVING Clause.mp4
11.6 MB
~Get Your Files Here !/8 - GROUPING/31 - Partition By.mp4
18.7 MB
~Get Your Files Here !/8 - GROUPING/32 - Query Summary.html
302 B
~Get Your Files Here !/9 - Table Relationships/33 - Inner Join Video Chapter.mp4
56.8 MB
~Get Your Files Here !/9 - Table Relationships/34 - More with INNER JOINS.mp4
64.1 MB
~Get Your Files Here !/9 - Table Relationships/35 - LEFT and RIGHT JOIN.mp4
37 MB
~Get Your Files Here !/9 - Table Relationships/36 - JOIN Three Tables.mp4
57.3 MB
~Get Your Files Here !/9 - Table Relationships/37 - JOIN Four Tables.mp4
28.1 MB
~Get Your Files Here !/9 - Table Relationships/38 - FULL OUTER JOIN.mp4
12.8 MB
~Get Your Files Here !/9 - Table Relationships/39 - EXCEPT.mp4
17.5 MB
~Get Your Files Here !/9 - Table Relationships/40 - Query Summary.html
