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


4 года 3 месяца

Репутация: 101

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

SQL - Beyond The Basics Training Video
Год выпуска: 2015
Производитель: Infinite Skills
Сайт производителя: infiniteskills.com
Автор: Guy Vaccaro
Продолжительность: 4:15
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: In this SQL - Beyond the Basics training course, expert author Guy Vaccaro will dive deeper into SQL and covers advanced techniques. This course is designed for users that already have experience with SQL.
You will start by learning a variety of useful skills, including how to convert datatypes, create a temporary table, and declare and use variables. From there, Guy will teach you about sub queries, the CASE statement, and numbering and ranking. This video tutorial also covers using built in functions, creating and using your own functions, and creating views. Finally, you will learn about stored procedures, such as how to create and run a stored procedure, loop with WHILE and IF, and dynamically build SQL statements.
Once you have completed this computer based training course, you will have expanded your skills and be able to make more efficient use of SQL. Working files are included, allowing you to follow along with the author throughout the lessons.
Продвинутые техники SQL.


01. The Warm Up
0101 About This SQL Advanced Title
0102 About The Author
0103 Relational Databases And Key Terms Explained
0104 Recap Of SQL SELECT Command
0105 Overview Of The Other DML Statements
0106 How To Access Your Working Files
0107 Installing The Sample Data And Using The Working Files
02. Useful Skills
0201 Converting Datatypes
0202 Creating A Temporary Table
0203 The DISTINCT And TOP Keywords In Action
0204 Indexing To Speed Up Your Life
0205 Declaring And Using Variables
03. The Subquery
0301 What Is A Subquery?
0302 Subquery Vs Joins
0303 Using Correlated Subqueries
0304 Using The EXISTS Keyword
0305 Finding Duplicate Records
04. The CASE Statement
0401 Getting Started With The CASE Statement
0402 Using The CASE Statement With Criteria On Multiple Columns
0403 Multiple Criteria Within The CASE Statement
0405 CASE In UPDATE And INSERT Statements
0406 CASE Within Subqueries
05. Numbering And Ranking
0501 Numbering Or Ranking Records In A SELECT Statement
0502 Filtering Results Based On Numbering Ranking
0503 Using Numbering Within Groups
0504 Filtering A Ranked Group To Determine Top N
06. Functions
0601 Using Built In Functions
0602 Creating And Using Your Own Functions (UDF)
0701 Creating A View
0702 Example Views And Views In Views
0703 Using The UNION Clause
08. Stored Procedures
0801 What Is A Stored Procedure?
0802 Creating A Stored Procedure
0803 Running A Stored Procedure
0804 Stored Procedures Within Stored Procedures
0805 The Global Variables @@Identity And @@Rowcount
0806 Looping With WHILE And IF
0807 Dynamically Build SQL Statements
0808 TRY And CATCH For Error Trapping
0809 Cursors In Use - Part 1
0810 Cursors In Use - Part 2
0811 Use Of Transactions
09. Conclusions
0901 Wrap Up
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG-4, 1280x720, 16:9, 15fps, 351kbps
Аудио: AAC, 48kHz, 64kbps, mono


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

Текущее время: Сегодня 01:48

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

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