Lynda - SQL for Non-Programmers
- Category Other
- Type Tutorials
- Language English
- Total size 266.9 MB
- Uploaded By tutsnode
- Downloads 353
- Last checked 1 day ago
- Date uploaded 4 years ago
- Seeders 10
- Leechers 0
Infohash : 90BC6DC48F092DCADED9433E8E923AC8FB5391B1
Description
Do you want to learn about SQL but aren’t sure where to start? In this beginner-level course, instructor Julianne Thouin covers basic concepts of relational database design and explains how to write simple SELECT statements using joins and proper filtering. Julianne explains what SQL Server is and what it is used for. Next, she shows how tables in a relational database relate to one another through surrogate, primary, and foreign keys. Julianne teaches you how to tackle the most basic query possible. She explains how AND and OR logic applies to filtering queries on more than one data point, then discusses INNER joins and OUTER joins. Julianne covers how to use subqueries for filtering your results. She walks you through some commonly used examples of built-in functions. In conclusion, Julianne shows you how aggregate functions work using the GROUP BY and HAVING clauses.
Released 1/12/2021
Files:
SQL for Non-Programmers [TutsNode.com] - SQL for Non-Programmers- 15 Built-in functions.mp4 (33.4 MB)
- Ex_Files_SQL_Non_Programmers.zip (16.7 KB)
- 08 Filtering on a single condition in SQL.mp4 (31.8 MB)
- 14 Case statements.mp4 (27.2 MB)
- 09 Filtering on multiple conditions in SQL.mp4 (21.1 MB)
- 07 Reading from a single table in SQL.mp4 (16.2 MB)
- 10 Inner joins.mp4 (15.7 MB)
- 13 Subqueries.mp4 (15.2 MB)
- 03 Understanding servers, databases, and tables.mp4 (14.6 MB)
- 12 Outer joins.mp4 (13.1 MB)
- 04 Relational database concepts.mp4 (12.4 MB)
- 02 What is SQL Server.mp4 (11.9 MB)
- 17 Query processing order.mp4 (11.2 MB)
- 16 Aggregates.mp4 (11.2 MB)
- 11 Multiple inner joins.mp4 (8.6 MB)
- 06 SQL data types and nullability.mp4 (6.8 MB)
- 01 How can SQL answer your data questions.mp4 (6.3 MB)
- 05 Surrogate, primary, and foreign keys.mp4 (6.2 MB)
- 18 Next steps.mp4 (2.1 MB)
- TutsNode.com.txt (0.1 KB)
- [TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB) .pad
- 0 (135.5 KB)
- 1 (246.8 KB)
- 2 (86.4 KB)
- 3 (197.3 KB)
- 4 (32.8 KB)
- 5 (13.3 KB)
- 6 (35.7 KB)
- 7 (162.0 KB)
- 8 (118.1 KB)
- 9 (58.3 KB)
- 10 (118.3 KB)
- 11 (52.8 KB)
- 12 (58.8 KB)
- 13 (108.3 KB)
- 14 (212.8 KB)
- 15 (186.8 KB)
- 16 (83.7 KB)
There are currently no comments. Feel free to leave one :)
Code:
- udp://inferno.demonoid.pw:3391/announce
- udp://tracker.openbittorrent.com:80/announce
- udp://tracker.opentrackr.org:1337/announce
- udp://torrent.gresille.org:80/announce
- udp://glotorrents.pw:6969/announce
- udp://tracker.leechers-paradise.org:6969/announce
- udp://tracker.pirateparty.gr:6969/announce
- udp://tracker.coppersurfer.tk:6969/announce
- udp://ipv4.tracker.harry.lu:80/announce
- udp://9.rarbg.to:2710/announce
- udp://shadowshq.yi.org:6969/announce
- udp://tracker.zer0day.to:1337/announce