SQL Fundamentals LiveLessons

seeders: 13
leechers: 3
Added on March 6, 2014 by Antignorin Other > Tutorials
Torrent verified.



SQL Fundamentals LiveLessons (Size: 2.42 GB)
 01. Learning Objectives.mp42.54 MB
 02. Introduction to the MySQL Interfaces.mp4116.18 MB
 07. Using the WHERE clause to filter data.mp4184.54 MB
 03. Learning Objectives.mp49.92 MB
 04. The SELECT statement.mp430.46 MB
 05. DISTINCT.mp461.06 MB
 06. Ordering the results with ORDER clause.mp483.74 MB
 08. Using Subqueries to filter data.mp486.4 MB
 09. Learning Objectives.mp43.35 MB
 10. UPDATE.mp443.91 MB
 11. INSERT.mp4133.05 MB
 12. DELETE.mp443.57 MB
 13. Managing Transactions.mp446.58 MB
 14. Learning Objectives.mp412.34 MB
 15. COUNT-SUM-MIN-MAX.mp449.21 MB
 16. GROUP BY.mp4138.43 MB
 17. Filtering results using the HAVING clause.mp441.4 MB
 18. Learning Objectives.mp411.34 MB
 19. Introduction to the concept of joins.mp4108.47 MB
 20. INNER.mp426.85 MB
 21. OUTER.mp471.07 MB
 22. UNION.mp472.01 MB
 23. INTERSECT.mp433.95 MB
 25. Learning Objectives.mp45.51 MB
 26. CREATE and DROP.mp453.22 MB
 27. ALTER objects in the table objects.mp4111.88 MB
 28. Placing indexes on tables for improved performance.mp452.21 MB
 29. Using keys and constraints to control data entered into tables.mp4143.43 MB
 30. Working with temporary table objects.mp447.39 MB
 31. Learning Objectives.mp49.37 MB
 32. Introduction of how security in the database is handled.mp487.49 MB
 33. Working with Users.mp4106.59 MB
 34. Assigning rights.mp430.79 MB
 35. Learning Objectives.mp411.16 MB
 36. SQL Functions- String and Numbers.mp43.49 MB
 37. SQL Functions- Date and Time.mp4102.03 MB
 38. SQL Functions- Conversions.mp437.81 MB
 39. VIEWS.mp461.98 MB
 40. STORED PROCEDURES.mp438.5 MB
 42. CURSORS.mp4151.14 MB
 43.SQL Fundamentals Overview.mp49.6 MB
 sql.sitx2.42 KB
 sql.zip2.95 KB
 Sams Teach Yourself SQL in 24 Hours, 4th Edition.pdf2.17 MB
 SQL Fundamentals LiveLessons.txt2.97 KB
 SQLFLL.jpg53.22 KB


Description

SQL Fundamentals LiveLessons

image

Copyright 2010
Edition: 1st
ISBN-10: 0-672-33099-7
ISBN-13: 978-0-672-33099-5


Description

Database expert Arie Jones teaches you SQL the right way...hands-on, and step-by-step! These video lessons focus on exactly what you need to know to master new skills fast and put them to work immediately. Simply place the DVD video in your computer’s DVD drive, and begin mastering SQL the easy way!

Watch and learn how to write queries using the world’s #1 open source database, MySQL--and build skills you can use with any database, from Oracle to SQL Server! Learn to navigate MySQL’s command line and Query Browser…get data out of databases with SELECT…sequence results with ORDER…filter data with WHERE…manage, aggregate, and group data…work with tables…manage security and access…even use advanced functions, views, and stored procedures!

For even more practical guidance, turn to Sams Teach Yourself SQL in 24 Hours, Fourth Edition, by Ryan Stephens, Ron Plew, and Arie Jones. With 24 easy, practical, hands-on lessons, it’s the only SQL book you’ll ever need!


Contents

Lesson 1: Introduction to the MySQL Interfaces

This segment covers the basics of getting around in the MySQL interfaces, especially the command line and also MySQL Query Browser. Other aspects of the interfaces will be discussed throughout the content.


Lesson 2: Getting Data out of the Database

This segment covers use of the SELECT and DISTINCT statements, how to order database results using the ORDER clause, and how to use the WHERE clause and subqueries to filter data.


Lesson 3: Managing Data in the Database

This segment shows viewers how to use the UPDATE, INSERT, and DELETE statements as well as how to manage transactions.


Lesson 4: Aggregation and Grouping

This segments shows viewers how to use the COUNT/SUM/MIN/MAX functions and the GROUP BY clause, and how to filter results using the HAVING clause.


Lesson 5: Working with Multiple Tables

This segment introduces viewers to the concept of joins, and then discusses in detail the INNER, OUTER, UNION, INTERSECT, and MINUS joins.


Lesson 6: Working with Tables in the Database

This segment discusses CREATE, DROP, and ALTER TABLE statements, and shows the viewer how to place Indexes on tables for improved performance. It also shows viewers how to use keys and constraints to control data entered into tables and how to work with temporary table objects.


Lesson 7: Working with Security

This segment introduces viewers to handling database security, working with users, and assigning rights.


Lesson 8: Advanced SQL Programming

This advanced lesson focuses on the use of a variety of SQL functions, including String and Numbers, Date and Time, and Conversion functions. It also discusses VIEWS, STORED PROCEDURES, TRIGGERS, and CURSORS


http://www.informit.com/store/sql-fundamentals-livelessons-video-training-9780672330995

Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
2.42 GB
seeders:13
leechers:3
SQL Fundamentals LiveLessons

All Comments

Nice up thanks
do you have these videos? http://www.informit.com/store/ios-and-mac-network-programming-livelessons-video-training-9780321948854
I don't have it, but maybe you could find it here: http://lmgtfy.com/?q=iOS+and+Mac+Network+Programming+LiveLessons