Download [TutorialPace] Lynda - SQL Essential Training - [TP] torrent

[TutorialPace] Lynda - SQL Essential Training - [TP]

Torrent:	[TutorialPace] Lynda - SQL Essential Training - [TP]
Description:	Whatever database application you create—whether it's for bookkeeping, sales, inventory, or even the lowly to-do list—it's all about the data. Completely updated for 2018, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. 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 and complete database application using SQL. SQL Essential Training https://tutorialpace.com/SQL-Essential-Training
Downloads:	156
Category:	Other /Tutorials
Size:	412.9 MB
Show Files »	[TutorialPace.com] Lynda - SQL Essential Training - [TP] 7.6. Numbers 40.Rounding numbers.en.srt (1.5 KB) 39.Integer division.en.srt (2.8 KB) 38.What type is that value.en.srt (3.4 KB) 37.Numeric types.en.srt (6.4 KB) 40.Rounding numbers.mp4 (1.6 MB) 39.Integer division.mp4 (2.9 MB) 38.What type is that value.mp4 (3.3 MB) 37.Numeric types.mp4 (6.5 MB) 13.12. Defined Functions 56.Overview.en.srt (1.7 KB) 56.Overview.mp4 (2.5 MB) 57.Defining functions in PHP.mp4 (13.0 MB) 15.Conclusion 61.Goodbye.en.srt (1.8 KB) 61.Goodbye.mp4 (3.1 MB) 1.Introduction 01.Welcome.en.srt (1.9 KB) 03.Course overview.en.srt (2.6 KB) 03.Course overview.mp4 (3.4 MB) 01.Welcome.mp4 (6.0 MB) 02.Exercise files.mp4 (6.0 MB) 6.5. Strings 32.About SQL strings.en.srt (2.6 KB) 36.Folding case.en.srt (2.7 KB) 34.Selecting part of a string.en.srt (3.3 KB) 32.About SQL strings.mp4 (3.2 MB) 34.Selecting part of a string.mp4 (3.2 MB) 36.Folding case.mp4 (3.8 MB) 33.Finding the length of a string.mp4 (4.3 MB) 35.Removing spaces.mp4 (6.2 MB) 9.8. Aggregates 44.Using aggregate functions.en.srt (2.6 KB) 45.Aggregating DISTINCT values.en.srt (3.0 KB) 43.What are aggregates.en.srt (6.5 KB) 45.Aggregating DISTINCT values.mp4 (3.9 MB) 44.Using aggregate functions.mp4 (3.9 MB) 43.What are aggregates.mp4 (8.3 MB) 3.2. SQL Overview 16.Deleting data.en.srt (2.6 KB) 11.Selecting rows.en.srt (2.8 KB) 13.Counting rows.en.srt (3.7 KB) 09.Database organization.en.srt (4.6 KB) 08.About the overview.en.srt (6.1 KB) 10.The SELECT statement.en.srt (9.7 KB) 16.Deleting data.mp4 (2.8 MB) 12.Selecting columns.mp4 (2.9 MB) 11.Selecting rows.mp4 (4.1 MB) 15.Updating data.mp4 (4.5 MB) 13.Counting rows.mp4 (4.6 MB) 14.Inserting data.mp4 (5.7 MB) 09.Database organization.mp4 (5.9 MB) 08.About the overview.mp4 (6.6 MB) 10.The SELECT statement.mp4 (12.4 MB) 4.3. Fundamental Concepts 20.Deleting rows.en.srt (2.7 KB) 23.Changing a schema.en.srt (3.0 KB) 26.Removing duplicates.en.srt (3.6 KB) 18.Deleting a table.en.srt (4.0 KB) 24.ID columns.en.srt (4.0 KB) 28.Conditional expressions.en.srt (4.5 KB) 19.Inserting rows.en.srt (4.9 KB) 22.Constraining columns.en.srt (5.3 KB) 17.Creating a table.en.srt (6.7 KB) 20.Deleting rows.mp4 (3.2 MB) 23.Changing a schema.mp4 (3.2 MB) 18.Deleting a table.mp4 (3.6 MB) 24.ID columns.mp4 (3.7 MB) 28.Conditional expressions.mp4 (4.3 MB) 26.Removing duplicates.mp4 (4.9 MB) 22.Constraining columns.mp4 (5.4 MB) 19.Inserting rows.mp4 (5.5 MB) 17.Creating a table.mp4 (5.8 MB) 27.Ordering output.mp4 (6.2 MB) 21.The NULL value.mp4 (8.5 MB) 25.Filtering data.mp4 (11.4 MB) 8.7. Dates and Times 41.Dates and times.en.srt (3.2 KB) 42.Date- and time-related functions.en.srt (3.4 KB) 41.Dates and times.mp4 (3.8 MB) 42.Date- and time-related functions.mp4 (3.9 MB) 10.9. Transactions 46.What are transactions.en.srt (3.5 KB) 47.Data integrity.en.srt (5.3 KB) 48.Performance.en.srt (5.8 KB) 46.What are transactions.mp4 (4.3 MB) 47.Data integrity.mp4 (5.7 MB) 48.Performance.mp4 (5.9 MB) 12.11. Views and Subselects 55.Creating a joined view.en.srt (3.5 KB) 53.Searching within a result set.en.srt (4.5 KB) 52.Creating a subselect.en.srt (5.9 KB) 55.Creating a joined view.mp4 (5.8 MB) 53.Searching within a result set.mp4 (5.9 MB) 52.Creating a subselect.mp4 (6.3 MB) 54.Creating a view.mp4 (7.7 MB) 11.10. Triggers 51.Example - Timestamps.en.srt (3.7 KB) 50.Preventing updates.en.srt (4.1 KB) 49.Automating data with triggers.en.srt (5.0 KB) 50.Preventing updates.mp4 (4.9 MB) 51.Example - Timestamps.mp4 (5.3 MB) 49.Automating data with triggers.mp4 (6.4 MB) 14.13. A Simple CRUD Application 59.The SELECT functions.en.srt (5.0 KB) 58.Embedding SQL.en.srt (7.1 KB) 59.The SELECT functions.mp4 (10.1 MB) 58.Embedding SQL.mp4 (11.2 MB) 60.The INSERT, UPDATE, and DELETE functions.mp4 (11.3 MB) 5.4. Relationships 31.Relating multiple tables.en.srt (5.5 KB) 29.Understanding JOIN.mp4 (4.6 MB) 31.Relating multiple tables.mp4 (8.0 MB) 30.Accessing related tables.mp4 (8.1 MB) 2.1. Installation 06.Installing on a Mac - Part I.en.srt (12.6 KB) 04.Installing on Windows - Part I.en.srt (13.9 KB) 05.Installing on Windows - Part II.en.srt (16.9 KB) 07.Installing on a Mac - Part II.en.srt (20.5 KB) 06.Installing on a Mac - Part I.mp4 (16.1 MB) 04.Installing on Windows - Part I.mp4 (19.8 MB) 05.Installing on Windows - Part II.mp4 (26.4 MB) 07.Installing on a Mac - Part II.mp4 (30.1 MB) Exercise Files Ex_Fi files
Added:	2019-06-01 11:07:26
Language:	English
Peers:	Seeders : 24 , Leechers : 5
Tags:	TutorialPace Tutorial
Release name:	[TutorialPace] Lynda - SQL Essential Training - [TP]
Trackers:	http://open.trackerlist.xyz:80/announce http://t.nyaatracker.com:80/announce http://tracker.corpscorp.online:80/announce https://opentracker.xyz:443/announce https://t.quic.ws:443/announce https://tracker.fastdownload.xyz:443/announce udp://chihaya.toss.li:9696/announce udp://denis.stalker.upeer.me:6969/announce udp://exodus.desync.com:6969/announce udp://ipv4.tracker.harry.lu:80/announce udp://open.demonii.si:1337/announce udp://open.stealth.si:80/announce udp://tracker.iamhansen.xyz:2000/announce udp://tracker.internetwarriors.net:1337/announce udp://tracker.opentrackr.org:1337/announce udp://tracker.torrent.eu.org:451/announce udp://9.rarbg.me:2710/announce udp://tracker.leechers-paradise.org:6969/announce