SQL Essential Training - ISBN:0000000000

SQL Essential Training

Date: 21 April 2011, 13:45

Free register and download UseNet downloader, then you can FREE Download from UseNet.

Download without Limit " SQL Essential Training " from UseNet for FREE!

Whatever a database is being used for—web sites, bookkeeping, sales and inventory, or even the lowly to-do list—it's all about the data. SQL Essential Training is designed to help users understand the most common language for database wrangling—SQL. Beginning with a brief introduction, instructor Bill Weinman teaches the major features of SQL; he offers a solid working knowledge of the language, and how to retrieve and manage data efficiently. He also works through a real-world example of building a CRUD (Create, Read, Update, and Delete) application using SQL. Exercise files accompany the course.
Table of contents
1. Introduction
Introduction 1:36 20.5 MB
What is SQL? 1:26 1.4 MB
Understanding the terminology 3:37 3.6 MB
About the examples 2:27 2.7 MB
Setting up the test environment on a PC 8:28 15.8 MB
Setting up the example data on a PC 3:33 5.5 MB
Setting up the test environment on a Mac 10:46 16.3 MB
Setting up the example data on a Mac 3:56 4.1 MB
2. SQL Quick Start
Quick-start introduction 0:40 0.5 MB
Using the basic SELECT statement 1:34 1.6 MB
Selecting columns 5:54 4.9 MB
Selecting rows 2:35 2.4 MB
Counting things 3:48 2.9 MB
3. SQL Essentials
Organization: Databases and tables 1:24 1.7 MB
SQL syntax overview 2:08 1.7 MB
Formatting SQL 3:18 3.0 MB
Creating a database and tables 5:24 3.8 MB
Inserting data 2:22 1.9 MB
Reading tables with JOIN 5:18 4.4 MB
Filtering data with WHERE, LIKE, and IN 5:52 5.8 MB
Removing duplicates with DISTINCT 1:34 1.6 MB
Sorting with ORDER BY 4:09 3.7 MB
Updating data 1:48 1.5 MB
Deleting data 2:15 1.7 MB
4. IDs and Indexes
Creating relationships between tables 1:06 0.9 MB
Accessing related tables with JOIN 4:00 3.0 MB
About indexes 1:11 1.1 MB
5. Strings
About the string functions 2:48 2.3 MB
Finding the length of a string 1:12 1.1 MB
Finding part of a string 1:34 1.3 MB
Removing spaces with TRIM 2:22 1.7 MB
Making strings UPPERCASE and lowercase 0:51 0.8 MB
6. Numbers
When to use numeric functions 1:41 1.3 MB
Finding the absolute value 1:28 1.3 MB
Rounding numbers 1:56 1.7 MB
Integer division and remainders 4:08 3.8 MB
7. Dates
Dates and times 1:52 1.2 MB
Date- and time-related functions 2:16 1.8 MB
8. Aggregates
How aggregates work 3:38 3.1 MB
Removing duplicates with DISTINCT 0:59 0.8 MB
Using aggregate functions 2:36 2.3 MB
9. The CRUD Application
About the CRUD application 7:48 7.6 MB
The SELECT functions 5:46 6.8 MB
The INSERT functions 1:47 3.5 MB
The UPDATE functions 2:17 3.6 MB
The DELETE functions 3:02 3.8 MB
Conclusion
Goodbye 0:32 0.5 MB

DISCLAIMER:

This site does not store SQL Essential Training on its server. We only index and link to SQL Essential Training provided by other sites. Please contact the content providers to delete SQL Essential Training if any and email us, we'll remove relevant links or contents immediately.