Важное объявление!
У Нас Все раздачи мультитрекерные, при нуле пиров в релизах, можете смело вставать на закачку!
 
Автор Сообщение

HUNTER

Стаж:
4 года 4 месяца
Сообщений:
56808

Репутация: 101

[+] [-]
Вне форума [Профиль] [ЛС]

Learning SQL Training Video
Год выпуска: 2014
Производитель: Infinite Skills
Сайт производителя: infiniteskills.com
Автор: Guy Vaccaro
Продолжительность: 3:30
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: In this SQL training course, expert author Guy Vaccaro teaches you how to use SQL to manage data that is held in relational databases. This training course is designed for beginners who have no previous experience with SQL of any kind.
You will start by learning how to use SQL (Structured Query Language) to select and filter data from a database, including sorting the data, filtering date columns, and working with null or empty values. Guy then teaches you about common SQL functions, such as text manipulation, and how to group and summarize. This video tutorial also covers topics such as joining tables, data modification, and creating new tables and views. Finally, you will learn about the powerful subquery, and the main variances in SQL between database types.
Once you have completed this computer based training course, you will have a fundamental knowledge of what SQL is and how you can apply it to different database types. Working files are included, allowing you to follow along with the author throughout the lessons.
Обзор SQL.

Содержание

01. Getting Started With Databases And SQL
0101 Relational Databases And Key Terms Explained
0102 About The Author
0103 What Are The SQL Commands
0104 Select Syntax And Examples
0105 Where Can I Use SQL?
0106 Installing Sample Databases And Working Files
0107 How To Access Your Working Files
02. Using SQL To Select And Filter Data
0201 Using Select To View Data
0202 Sorting The Data
0203 Adding A Where Clause To Filter Data
0204 Filtering Date Columns
0205 Working With Null Or Empty Values
0206 Using Comments Within SQL
0207 Use Of Wildcards In Filtering
0208 Multiple Criteria Using And Or In
03. Functions, Grouping And Summarizing
0301 Add A Calculating Column To A SQL Statement
0302 Text Manipulation Functions
0303 Differences In Date Functions Within SQL
0304 Calculating Age
0305 Concatenate Data Columns
04. Joining Tables
0401 Which Tables Can I Join And How?
0402 Joining More Than Two Tables
0403 Using Different Join Types
0404 The Special Cross Or Cartesian Join
0405 Group And Summaries Within Joined Table SQL
05. Data Modification
0501 Amend Data In Tables
0502 Adding Data To Tables With Insert
0503 Removing Data From Tables
06. Creating And Altering Database Objects
0601 Create A New Table
0602 Changing A Tables Structure
0603 What Is A View And How To Create One
0604 Alter Or Delete A View
07. SQL Summary
0701 The Main Variances In SQL Between Databases
0702 The Powerful Subquery
08. Conclusions
0801 Wrap Up
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1280x720, 16:9, 15fps, 225kbps
Аудио: AAC, 44.1kHz, 64kbps, mono

Скриншоты


_________________
Показать сообщения:    

Текущее время: Сегодня 09:40

Часовой пояс: GMT



Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете голосовать в опросах
Вы не можете прикреплять файлы к сообщениям
Вы не можете скачивать файлы