No cover art

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

Other
Size
933 MB
Seeders
2
Leechers
3
Files
63
Category
Other
Added
11/16/23 at 10:41am GMT+1
Infohash
5eec51e3de046d1589705add6afa68a08e0d804b

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.

File list
  • Udemy - Sql Queries 101 - A Beginner'S Guide To Data Retrieval
  • ~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 2.4 KB
  • ~Get Your Files Here !/Bonus Resources.txt 386 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
15 MB07/19/2648713243
15 MB08/10/2646603103
9 MB08/05/2646173074
15 MB07/16/2643952928
9 MB07/15/2643402888
14 MB07/19/2643292885
14 MB07/15/2642642837
60 MB05/14/2331052067
60 MB05/14/2329861983
31 MB06/07/2329661982
36 MB05/14/2329341951
21 MB05/14/2329091927
10 MB07/12/2328601907
132 MB08/11/2322621508
100 MB12/10/2221231375