Lynda - SQL for Non-Programmers

seeders: 0
leechers: 0
Added 5 years ago by tutsnode in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

Lynda - SQL for Non-Programmers (Size: 266.9 MB)
  0 135.5 KB
  01 How can SQL answer your data questions.mp4 6.3 MB
  02 What is SQL Server.mp4 11.9 MB
  03 Understanding servers, databases, and tables.mp4 14.6 MB
  04 Relational database concepts.mp4 12.4 MB
  05 Surrogate, primary, and foreign keys.mp4 6.2 MB
  06 SQL data types and nullability.mp4 6.8 MB
  07 Reading from a single table in SQL.mp4 16.2 MB
  08 Filtering on a single condition in SQL.mp4 31.8 MB
  09 Filtering on multiple conditions in SQL.mp4 21.1 MB
  10 Inner joins.mp4 15.7 MB
  11 Multiple inner joins.mp4 8.6 MB
  12 Outer joins.mp4 13.1 MB
  13 Subqueries.mp4 15.2 MB
  14 Case statements.mp4 27.2 MB
  15 Built-in functions.mp4 33.4 MB
  16 Aggregates.mp4 11.2 MB
  17 Query processing order.mp4 11.2 MB
  18 Next steps.mp4 2.1 MB
  Ex_Files_SQL_Non_Programmers.zip 16.7 KB
  TutsNode.com.txt 102 B
  [TGx]Downloaded from torrentgalaxy.to .txt 614 B
  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 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
  ▲ 38 total files

Description



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

Related Torrents

torrent name size uploader age seed leech
1
0
0
0
0