Developer's T-SQL Playbook [2015, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Developer's T-SQL Playbook

Год выпуска: 2015
Производитель: Pluralsight
Сайт производителя: pluralsight.com/courses/tsql-playbook
Автор: Rob Conery
Продолжительность: 2:06
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: You've been working with data, but don't know SQL. You have a plane ride to catch up and learn what you need to know - that's the focus of this course.

Вы работали с данными, но не знаете SQL. У вас есть на самолете догнать и узнать, что вам нужно знать - это в центре внимания этого курса.
[spoiler="Содержание"]
Introduction
Introduction

Working with Tables
Creating a Table
Primary Keys: Integer
Primary Keys: GUID
Primary Keys: Auto-incrementing
Tangent: Choosing a Primary Key
Composite Keys
Defining Columns
Basic Column Constraints
Column Defaults
Naming Conventions

Working with Data
Inserting Data
Bulk Inserts
Updates
Updates with Criteria
Bulk Updates
Delete
Bulk Deletes

Querying Data
Installing Chinook
Simple Select
Select Columns
Aliasing Columns
Column Expressions
Tangent: Naming Things

Joining Tables
Inner Joins
Subqueries
Left and Right Joins
Full Joins

Filtering, Sifting, and Sorting Data
Ordering Results
Limiting Results
Sequential Ordering
Filtering by Sets
Offsetting Results

Aggregates and Analysis
Basic Aggregates
Grouping Results
A Simple Sales Query
Tangent: Checking Your Numbers
Constraining Aggregate Results

Many to Many and Self-referencing Relationships
Adding Data to a Many to Many
Querying a Many to Many
Many to Many Table Constraints
Querying a Self-referencing Table Using a Join
Querying a Self-referencing Table with a Subquery

Essential String and Date Functions
Querying Strings with a Partial Match
Partial String Results with Substring
Editing String Results with Replace
Fixing Bad Data with Trim
Fixing Bad Data with Rtrim Len and Datalength
Slicing Dates with Datepart
Doing Date Math with Datediff
Summary and Goodbye
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: MP4
Видео: AVC, 1024x576, 16:9, 15fps, 266kbps
Аудио: AAC, 44.1kHz, 192kbps, stereo
[spoiler="Скриншоты"]

[/spoiler]