Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

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

Size
413 MB
Seeders
0
Leechers
0
Files
99
Category
Added
at 1:10pm GMT+1
Infohash
db7ae169555a9fac9794b49135298d026796d113
Don't like banners? Log in and we will make sure you see no banners. For free.

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

File list
  • [TutorialPace.com] Lynda - SQL Essential Training - [TP]
  • 1.Introduction/01.Welcome.en.srt 1.9 KB
  • 1.Introduction/01.Welcome.mp4 6 MB
  • 1.Introduction/02.Exercise files.mp4 6 MB
  • 1.Introduction/03.Course overview.en.srt 2.6 KB
  • 1.Introduction/03.Course overview.mp4 3.4 MB
  • 10.9. Transactions/46.What are transactions.en.srt 3.5 KB
  • 10.9. Transactions/46.What are transactions.mp4 4.3 MB
  • 10.9. Transactions/47.Data integrity.en.srt 5.3 KB
  • 10.9. Transactions/47.Data integrity.mp4 5.7 MB
  • 10.9. Transactions/48.Performance.en.srt 5.8 KB
  • 10.9. Transactions/48.Performance.mp4 5.9 MB
  • 11.10. Triggers/49.Automating data with triggers.en.srt 5 KB
  • 11.10. Triggers/49.Automating data with triggers.mp4 6.4 MB
  • 11.10. Triggers/50.Preventing updates.en.srt 4.1 KB
  • 11.10. Triggers/50.Preventing updates.mp4 4.9 MB
  • 11.10. Triggers/51.Example - Timestamps.en.srt 3.7 KB
  • 11.10. Triggers/51.Example - Timestamps.mp4 5.3 MB
  • 12.11. Views and Subselects/52.Creating a subselect.en.srt 5.9 KB
  • 12.11. Views and Subselects/52.Creating a subselect.mp4 6.3 MB
  • 12.11. Views and Subselects/53.Searching within a result set.en.srt 4.5 KB
  • 12.11. Views and Subselects/53.Searching within a result set.mp4 5.9 MB
  • 12.11. Views and Subselects/54.Creating a view.mp4 7.7 MB
  • 12.11. Views and Subselects/55.Creating a joined view.en.srt 3.5 KB
  • 12.11. Views and Subselects/55.Creating a joined view.mp4 5.8 MB
  • 13.12. Defined Functions/56.Overview.en.srt 1.7 KB
  • 13.12. Defined Functions/56.Overview.mp4 2.5 MB
  • 14.13. A Simple CRUD Application/58.Embedding SQL.en.srt 7.1 KB
  • 14.13. A Simple CRUD Application/59.The SELECT functions.en.srt 5 KB
  • 15.Conclusion/61.Goodbye.en.srt 1.8 KB
  • 15.Conclusion/61.Goodbye.mp4 3.1 MB
  • 2.1. Installation/04.Installing on Windows - Part I.en.srt 13.9 KB
  • 2.1. Installation/05.Installing on Windows - Part II.en.srt 16.9 KB
  • 2.1. Installation/06.Installing on a Mac - Part I.en.srt 12.6 KB
  • 2.1. Installation/07.Installing on a Mac - Part II.en.srt 20.5 KB
  • 3.2. SQL Overview/08.About the overview.en.srt 6.1 KB
  • 3.2. SQL Overview/08.About the overview.mp4 6.6 MB
  • 3.2. SQL Overview/09.Database organization.en.srt 4.6 KB
  • 3.2. SQL Overview/09.Database organization.mp4 5.9 MB
  • 3.2. SQL Overview/10.The SELECT statement.en.srt 9.7 KB
  • 3.2. SQL Overview/11.Selecting rows.en.srt 2.8 KB
  • 3.2. SQL Overview/11.Selecting rows.mp4 4.1 MB
  • 3.2. SQL Overview/12.Selecting columns.mp4 2.9 MB
  • 3.2. SQL Overview/13.Counting rows.en.srt 3.7 KB
  • 3.2. SQL Overview/13.Counting rows.mp4 4.6 MB
  • 3.2. SQL Overview/14.Inserting data.mp4 5.7 MB
  • 3.2. SQL Overview/15.Updating data.mp4 4.5 MB
  • 3.2. SQL Overview/16.Deleting data.en.srt 2.6 KB
  • 3.2. SQL Overview/16.Deleting data.mp4 2.8 MB
  • 4.3. Fundamental Concepts/17.Creating a table.en.srt 6.7 KB
  • 4.3. Fundamental Concepts/17.Creating a table.mp4 5.8 MB
  • 4.3. Fundamental Concepts/18.Deleting a table.en.srt 4 KB
  • 4.3. Fundamental Concepts/18.Deleting a table.mp4 3.6 MB
  • 4.3. Fundamental Concepts/19.Inserting rows.en.srt 4.9 KB
  • 4.3. Fundamental Concepts/19.Inserting rows.mp4 5.5 MB
  • 4.3. Fundamental Concepts/20.Deleting rows.en.srt 2.7 KB
  • 4.3. Fundamental Concepts/20.Deleting rows.mp4 3.2 MB
  • 4.3. Fundamental Concepts/21.The NULL value.mp4 8.5 MB
  • 4.3. Fundamental Concepts/22.Constraining columns.en.srt 5.3 KB
  • 4.3. Fundamental Concepts/22.Constraining columns.mp4 5.4 MB
  • 4.3. Fundamental Concepts/23.Changing a schema.en.srt 3 KB
  • 4.3. Fundamental Concepts/23.Changing a schema.mp4 3.2 MB
  • 4.3. Fundamental Concepts/24.ID columns.en.srt 4 KB
  • 4.3. Fundamental Concepts/24.ID columns.mp4 3.7 MB
  • 4.3. Fundamental Concepts/26.Removing duplicates.en.srt 3.6 KB
  • 4.3. Fundamental Concepts/26.Removing duplicates.mp4 4.9 MB
  • 4.3. Fundamental Concepts/27.Ordering output.mp4 6.2 MB
  • 4.3. Fundamental Concepts/28.Conditional expressions.en.srt 4.5 KB
  • 4.3. Fundamental Concepts/28.Conditional expressions.mp4 4.3 MB
  • 5.4. Relationships/29.Understanding JOIN.mp4 4.6 MB
  • 5.4. Relationships/30.Accessing related tables.mp4 8.1 MB
  • 5.4. Relationships/31.Relating multiple tables.en.srt 5.5 KB
  • 5.4. Relationships/31.Relating multiple tables.mp4 8 MB
  • 6.5. Strings/32.About SQL strings.en.srt 2.6 KB
  • 6.5. Strings/32.About SQL strings.mp4 3.2 MB
  • 6.5. Strings/33.Finding the length of a string.mp4 4.3 MB
  • 6.5. Strings/34.Selecting part of a string.en.srt 3.3 KB
  • 6.5. Strings/34.Selecting part of a string.mp4 3.2 MB
  • 6.5. Strings/35.Removing spaces.mp4 6.2 MB
  • 6.5. Strings/36.Folding case.en.srt 2.7 KB
  • 6.5. Strings/36.Folding case.mp4 3.8 MB
  • 7.6. Numbers/37.Numeric types.en.srt 6.4 KB
  • 7.6. Numbers/37.Numeric types.mp4 6.5 MB
  • 7.6. Numbers/38.What type is that value.en.srt 3.4 KB
  • 7.6. Numbers/38.What type is that value.mp4 3.3 MB
  • 7.6. Numbers/39.Integer division.en.srt 2.8 KB
  • 7.6. Numbers/39.Integer division.mp4 2.9 MB
  • 7.6. Numbers/40.Rounding numbers.en.srt 1.5 KB
  • 7.6. Numbers/40.Rounding numbers.mp4 1.6 MB
  • 8.7. Dates and Times/41.Dates and times.en.srt 3.2 KB
  • 8.7. Dates and Times/41.Dates and times.mp4 3.8 MB
  • 8.7. Dates and Times/42.Date- and time-related functions.en.srt 3.4 KB
  • 8.7. Dates and Times/42.Date- and time-related functions.mp4 3.9 MB
  • 9.8. Aggregates/43.What are aggregates.en.srt 6.5 KB
  • 9.8. Aggregates/43.What are aggregates.mp4 8.3 MB
  • 9.8. Aggregates/44.Using aggregate functions.en.srt 2.6 KB
  • 9.8. Aggregates/44.Using aggregate functions.mp4 3.9 MB
  • 9.8. Aggregates/45.Aggregating DISTINCT values.en.srt 3 KB
  • 9.8. Aggregates/45.Aggregating DISTINCT values.mp4 3.9 MB
  • Exercise Files/Ex_Files_SQL_EssT.zip 250.6 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.