SQL Fundamentals LiveLessons

seeders: 13

leechers: 3

Download torrent

Added on March 6, 2014 by Antignorin Other > Tutorials
Torrent verified.

Main
Comments

add to bookmarks

SQL Fundamentals LiveLessons (Size: 2.42 GB)

		01. Learning Objectives.mp4	2.54 MB
		02. Introduction to the MySQL Interfaces.mp4	116.18 MB
		07. Using the WHERE clause to filter data.mp4	184.54 MB
		03. Learning Objectives.mp4	9.92 MB
		04. The SELECT statement.mp4	30.46 MB
		05. DISTINCT.mp4	61.06 MB
		06. Ordering the results with ORDER clause.mp4	83.74 MB
		08. Using Subqueries to filter data.mp4	86.4 MB
		09. Learning Objectives.mp4	3.35 MB
		10. UPDATE.mp4	43.91 MB
		11. INSERT.mp4	133.05 MB
		12. DELETE.mp4	43.57 MB
		13. Managing Transactions.mp4	46.58 MB
		14. Learning Objectives.mp4	12.34 MB
		15. COUNT-SUM-MIN-MAX.mp4	49.21 MB
		16. GROUP BY.mp4	138.43 MB
		17. Filtering results using the HAVING clause.mp4	41.4 MB
		18. Learning Objectives.mp4	11.34 MB
		19. Introduction to the concept of joins.mp4	108.47 MB
		20. INNER.mp4	26.85 MB
		21. OUTER.mp4	71.07 MB
		22. UNION.mp4	72.01 MB
		23. INTERSECT.mp4	33.95 MB
		25. Learning Objectives.mp4	5.51 MB
		26. CREATE and DROP.mp4	53.22 MB
		27. ALTER objects in the table objects.mp4	111.88 MB
		28. Placing indexes on tables for improved performance.mp4	52.21 MB
		29. Using keys and constraints to control data entered into tables.mp4	143.43 MB
		30. Working with temporary table objects.mp4	47.39 MB
		31. Learning Objectives.mp4	9.37 MB
		32. Introduction of how security in the database is handled.mp4	87.49 MB
		33. Working with Users.mp4	106.59 MB
		34. Assigning rights.mp4	30.79 MB
		35. Learning Objectives.mp4	11.16 MB
		36. SQL Functions- String and Numbers.mp4	3.49 MB
		37. SQL Functions- Date and Time.mp4	102.03 MB
		38. SQL Functions- Conversions.mp4	37.81 MB
		39. VIEWS.mp4	61.98 MB
		40. STORED PROCEDURES.mp4	38.5 MB
		42. CURSORS.mp4	151.14 MB
		43.SQL Fundamentals Overview.mp4	9.6 MB
		sql.sitx	2.42 KB
		sql.zip	2.95 KB
		Sams Teach Yourself SQL in 24 Hours, 4th Edition.pdf	2.17 MB
		SQL Fundamentals LiveLessons.txt	2.97 KB
		SQLFLL.jpg	53.22 KB

Description

SQL Fundamentals LiveLessons

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
CSS Fundamentals LiveLessons Posted by Antignor in Other > Tutorials	4.46 GB	7	14
C# Async Fundamentals LiveLessons Posted by Antignor in Other > Tutorials	1016.35 MB	11	6
Python Fundamentals LiveLessons Posted by Antignor in Other > Tutorials	3.18 GB	24	15
C# 2012 Fundamentals LiveLessons Parts I, II, III, and IV Posted by PCWalker in Other > Tutorials	6.57 GB	3	13
LiveLessons - C# Asynch Fundamentals Posted by trancedude in Other > Tutorials	1004.71 MB	1	0

Sharing Widget

Download torrent

2.42 GB

seeders:13

leechers:3

SQL Fundamentals LiveLessons

All Comments

ChairmanMeow

Nice up thanks

yumugee

do you have these videos? http://www.informit.com/store/ios-and-mac-network-programming-livelessons-video-training-9780321948854

Antignor

I don't have it, but maybe you could find it here: http://lmgtfy.com/?q=iOS+and+Mac+Network+Programming+LiveLessons