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

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size412.9 MB
  • Uploaded ByTutorialPace
  • Downloads156
  • Last checkedJun. 02nd '19
  • Date uploadedJun. 01st '19
  • Seeders 24
  • Leechers5
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : DB7AE169555A9FAC9794B49135298D026796D113

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

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

Code:

  • 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