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

Lynda - Learning SQL Programming [AhLaN]

TORRENT SUMMARY

	Status:	All the torrents in this section have been verified by our verification system
Category:	Other
Infohash	08d3a9f387be481af6f17fe4d4c9351b7e421c7c
Size:	184.5 MB in 29 files
Release Date(s):	Torrent Release: 17-07-2020 by user
Swarm:	0 Seeds & 1 Peers
Vote:	No votes yet.

DESCRIPTION

---------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

Proudly Presents

-----------------------------------------------------------------------------------

Lynda - Learning SQL Programming [AhLaN]

SUPPLiER.......: WWW RELEASE DATE......: 17/07/20

Uploader.......: abidmail Collector.........: ThomasKhan

... RELEASE iNFORMATiON ...

GENERAL INFO

Instructor : Scott Simpson

Duration : 1h 27m

Released : 8/15/2017

... About This Course ...

SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. Instructor Scott Simpson also shows how to perform simple math operations and transform data into different formats.

Topics include:

Name the predicate of the following statement: SELECT EyeColor, Age FROM Student WHERE FirstName = 'Tim' ORDER BY LastName ASC;

Explain what to use to enforce the order in which an expression must be evaluated if the WHERE clause contains multiple expressions to evaluate.

Identify the best option to join two tables in a database to be able to display data from both.

List a data type that is not numeric.

Determine the result of running the following statement on a table containing columns col_1 and col_2:

INSERT INTO Box (col_1, col_2) VALUES ('A', 'B'), ('A', 'B'), ('A', 'B'), ('A', 'B');

Determine the best approach of deleting Jon Ramirez (ID 3452) from a Student table.

VISITOR COMMENTS (0

)

FILE LIST

Filename		Size
	1 - Introduction/01 - Welcome.mp4	5.3 MB
	1 - Introduction/02 - Use the exercise files.mp4	5.2 MB
	1 - Introduction/03 - Explore DB Browser.mp4	8.7 MB
	1 - Introduction/04 - What is a database.mp4	4 MB
	1 - Introduction/05 - What is SQL.mp4	9 MB
	2 - 1. Ask for Data from a Database/06 - Ask for data with SELECT.mp4	6.9 MB
	2 - 1. Ask for Data from a Database/07 - Narrow down a query with WHERE.mp4	6.9 MB
	2 - 1. Ask for Data from a Database/08 - Add more criteria to a statement.mp4	12.5 MB
	2 - 1. Ask for Data from a Database/09 - Limit responses.mp4	11.5 MB
	2 - 1. Ask for Data from a Database/10 - Organize responses with ORDER BY.mp4	5.4 MB
	2 - 1. Ask for Data from a Database/11 - Find information about the data.mp4	8.3 MB
	3 - 2. Ask for Data from Two or More Tables/12 - Ask for data across two or more tables.mp4	10.7 MB
	3 - 2. Ask for Data from Two or More Tables/13 - Understand JOIN types.mp4	11.7 MB
	3 - 2. Ask for Data from Two or More Tables/14 - Combine results.mp4	6.7 MB
	4 - 3. Data Types, Math, and Helpful Functions/15 - Data types in SQL.mp4	4.6 MB
	4 - 3. Data Types, Math, and Helpful Functions/16 - Math in SQL.mp4	10.6 MB
	4 - 3. Data Types, Math, and Helpful Functions/17 - Compound Select.mp4	7.7 MB
	4 - 3. Data Types, Math, and Helpful Functions/18 - Transform data.mp4	13.8 MB
	4 - 3. Data Types, Math, and Helpful Functions/19 - Use aliases to shorten field names.mp4	3.7 MB
	5 - 4. Add or Modify Data/20 - Add data to a table.mp4	8.8 MB
	5 - 4. Add or Modify Data/21 - Modify data in a table.mp4	6.7 MB
	5 - 4. Add or Modify Data/22 - Remove data from a table.mp4	4 MB
	6 - Conclusion/23 - Overcome common SQL mistakes.mp4	8.9 MB
	6 - Conclusion/24 - Next steps.mp4	2.4 MB
	Ex_Files_Learning_SQL_Programming/Exercise Files/quizresults.sql	212.3 KB
	Ex_Files_Learning_SQL_Programming/Exercise Files/results.db	83 KB
	Ex_Files_Learning_SQL_Programming/Exercise Files/statements.sql	7.1 KB
	Glossary_Learning_Sql_Programming/Glossary_Learning_Sql_Programming.pdf	111.4 KB
	Seed Me!!.png	42 KB

RELATED DOWNLOADS

Torrent Name

Added

Size

Seeds

Peers

Uploader

Health