BitTorrent Трекер RusTrek.ru http://5.45.70.241/
Lynda.com - SQL Essential Training [2009 г.] http://5.45.70.241/viewtopic.php?f=513&t=37222	Страница 1 из 1

---

Автор:	Релизер [ 2012-04-22 17:02 ]
Заголовок сообщения:	Lynda.com - SQL Essential Training [2009 г.]
Lynda.com - SQL Essential Training #777 Производитель: Lynda.com Дата выпуска: 08/04/2009 Автор: William E. Weinman Видео кодек: H.264 Видео: QuickTime (.MOV), File Type: QuickTime (.MOV) Аудио: MPEG-4 AAC LC, 48000Hz 64 kb/s tot , stereo (2/0) Язык: английский Продолжительность: 2.5 ч Файлы примеров: Присутсвуют Описание: 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. 1. Introduction Introduction 1:36 What is SQL? 1:26 Understanding the terminology 3:37 About the examples 2:27 Setting up the test environment on a PC 8:28 Setting up the example data on a PC 3:33 Setting up the test environment on a Mac 10:46 Setting up the example data on a Mac 3:56 2. SQL Quick Start Quick-start introduction 0:40 Using the basic SELECT statement 1:34 Selecting columns 5:54 Selecting rows 2:35 Counting things 3:48 3. SQL Essentials Organization: Databases and tables 1:24 SQL syntax overview 2:08 Formatting SQL 3:18 Creating a database and tables 5:24 Inserting data 2:22 Reading tables with JOIN 5:18 Filtering data with WHERE, LIKE, and IN 5:52 Removing duplicates with DISTINCT 1:34 Sorting with ORDER BY 4:09 Updating data 1:48 Deleting data 2:15 4. IDs and Indexes Creating relationships between tables 1:06 Accessing related tables with JOIN 4:00 About indexes 1:11 5. Strings About the string functions 2:48 Finding the length of a string 1:12 Finding part of a string 1:34 Removing spaces with TRIM 2:22 Making strings UPPERCASE and lowercase 0:51 6. Numbers When to use numeric functions 1:41 Finding the absolute value 1:28 Rounding numbers 1:56 Integer division and remainders 4:08 7. Dates Dates and times 1:52 Date- and time-related functions 2:16 8. Aggregates How aggregates work 3:38 Removing duplicates with DISTINCT 0:59 Using aggregate functions 2:36 9. The CRUD Application About the CRUD application 7:48 The SELECT functions 5:46 The INSERT functions 1:47 The UPDATE functions 2:17 The DELETE functions 3:02 Conclusion Goodbye 0:32

---

Страница 1 из 1	Часовой пояс: UTC + 3 часа
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/