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

LinkedIn Learning - SQL Essential Training

TORRENT SUMMARY

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

DESCRIPTION

Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.

VISITOR COMMENTS (0

)

FILE LIST

Filename		Size
	01- Understanding SQL.en.srt	1.9 KB
	01- Understanding SQL.mp4	22.7 MB
	02- How to use the exercise files.en.srt	1.8 KB
	02- How to use the exercise files.mp4	2.5 MB
	03- Course overview.en.srt	2.5 KB
	03- Course overview.mp4	2.6 MB
	04- Installing on Windows.en.srt	9.7 KB
	04- Installing on Windows.mp4	16.3 MB
	05- Installing on a Mac.en.srt	12.5 KB
	05- Installing on a Mac.mp4	17.9 MB
	06- About SQL.en.srt	6.1 KB
	06- About SQL.mp4	6.2 MB
	07- Database organization.en.srt	4.5 KB
	07- Database organization.mp4	5.5 MB
	08- The SELECT statement.en.srt	8.6 KB
	08- The SELECT statement.mp4	12.8 MB
	09- Selecting rows.en.srt	3.7 KB
	09- Selecting rows.mp4	7.7 MB
	10- Selecting columns.en.srt	2.2 KB
	10- Selecting columns.mp4	4.7 MB
	11- Counting rows.en.srt	2.9 KB
	11- Counting rows.mp4	4.3 MB
	12- Inserting data.en.srt	2.8 KB
	12- Inserting data.mp4	4.3 MB
	13- Updating data.en.srt	3 KB
	13- Updating data.mp4	5.2 MB
	14- Deleting data.en.srt	1.6 KB
	14- Deleting data.mp4	2.7 MB
	15- Creating a table.en.srt	4.5 KB
	15- Creating a table.mp4	6.3 MB
	16- Deleting a table.en.srt	3.4 KB
	16- Deleting a table.mp4	5 MB
	17- Inserting rows.en.srt	4.6 KB
	17- Inserting rows.mp4	7.9 MB
	18- Deleting rows.en.srt	3 KB
	18- Deleting rows.mp4	4.9 MB
	19- The NULL value.en.srt	7.7 KB
	19- The NULL value.mp4	14.2 MB
	20- Constraining columns.en.srt	7 KB
	20- Constraining columns.mp4	11.1 MB
	21- Changing a schema.en.srt	3.8 KB
	21- Changing a schema.mp4	5.8 MB
	22- ID columns.en.srt	5.4 KB
	22- ID columns.mp4	7.3 MB
	23- Filtering data.en.srt	10.1 KB
	23- Filtering data.mp4	19.5 MB
	24- Removing duplicates.en.srt	4.6 KB
	24- Removing duplicates.mp4	7.8 MB
	25- Ordering output.en.srt	5.2 KB
	25- Ordering output.mp4	8.6 MB
	26- Conditional expressions.en.srt	4.1 KB
	26- Conditional expressions.mp4	6.1 MB
	27- Understanding JOIN.en.srt	3.7 KB
	27- Understanding JOIN.mp4	4.2 MB
	28- Accessing related tables.en.srt	10.2 KB
	28- Accessing related tables.mp4	15.9 MB
	29- Relating multiple tables.en.srt	7.6 KB
	29- Relating multiple tables.mp4	13.8 MB
	30- About SQL strings.en.srt	2.5 KB
	30- About SQL strings.mp4	3 MB
	31- Finding the length of a string.en.srt	2.8 KB
	31- Finding the length of a string.mp4	4.6 MB
	32- Selecting part of a string.en.srt	5.2 KB
	32- Selecting part of a string.mp4	8.3 MB
	33- Removing spaces.en.srt	2.5 KB
	33- Removing spaces.mp4	3.3 MB
	34- Folding case.en.srt	3.6 KB
	34- Folding case.mp4	5.4 MB
	35- Numeric types.en.srt	5 KB
	35- Numeric types.mp4	4.9 MB
	36- What type is that value.en.srt	3.4 KB
	36- What type is that value.mp4	4.9 MB
	37- Integer division.en.srt	2.9 KB
	37- Integer division.mp4	4.3 MB
	38- Rounding numbers.en.srt	1.7 KB
	38- Rounding numbers.mp4	2.6 MB
	39- Dates and times.en.srt	3.5 KB
	39- Dates and times.mp4	3.5 MB
	40- Date- and time-related functions.en.srt	3.2 KB
	40- Date- and time-related functions.mp4	5.2 MB
	41- What are aggregates.en.srt	7.6 KB
	41- What are aggregates.mp4	11.9 MB
	42- Using aggregate functions.en.srt	2 KB
	42- Using aggregate functions.mp4	3.6 MB
	43- Aggregating DISTINCT values.en.srt	2.8 KB
	43- Aggregating DISTINCT values.mp4	4 MB
	44- What are transactions.en.srt	3.5 KB
	44- What are transactions.mp4	3.5 MB
	45- Data integrity.en.srt	6.3 KB
	45- Data integrity.mp4	10.6 MB
	46- Performance.en.srt	4.3 KB
	46- Performance.mp4	7.3 MB
	47- Automating data with triggers.en.srt	6.8 KB
	47- Automating data with triggers.mp4	10.7 MB
	48- Preventing updates.en.srt	6.5 KB
	48- Preventing updates.mp4	9.7 MB
	49- Example - Timestamps.en.srt	5.3 KB
	49- Example - Timestamps.mp4	9.4 MB
	50- Creating a subselect.en.srt	4.4 KB

RELATED DOWNLOADS

Torrent Name

Added

Size

Seeds

Peers

Uploader

Health