Download SQL - Beyond The Basics Training Video [2015, ENG] Torrent

SQL - Beyond The Basics Training Video [2015, ENG]

01. The Warm Up

0101 About This SQL Advanced Title.MP4	MP4	4.98 MB
0102 About The Author.MP4	MP4	5.41 MB
0103 Relational Databases And Key Terms Explained.MP4	MP4	11.23 MB
0104 Recap Of SQL SELECT Command.MP4	MP4	19.76 MB
0105 Overview Of The Other DML Statements.MP4	MP4	10.83 MB
0106 How To Access Your Working Files.MP4	MP4	7.33 MB
0107 Installing The Sample Data And Using The Working Files.MP4	MP4	7.71 MB

02. Useful Skills

0201 Converting Datatypes.MP4	MP4	21.66 MB
0202 Creating A Temporary Table.MP4	MP4	16.41 MB
0203 The DISTINCT And TOP Keywords In Action.MP4	MP4	14.62 MB
0204 Indexing To Speed Up Your Life.MP4	MP4	20.96 MB
0205 Declaring And Using Variables.MP4	MP4	18.22 MB

03. The Subquery

0301 What Is A Subquery.MP4	MP4	16.38 MB
0302 Subquery Vs Joins.MP4	MP4	14.61 MB
0303 Using Correlated Subqueries.MP4	MP4	21.35 MB
0304 Using The EXISTS Keyword.MP4	MP4	14.67 MB
0305 Finding Duplicate Records.MP4	MP4	18 MB

04. The CASE Statement

0401 Getting Started With The CASE Statement.MP4	MP4	17.49 MB
0402 Using The CASE Statement With Criteria On Multiple Columns.MP4	MP4	16.52 MB
0403 Multiple Criteria Within The CASE Statement.MP4	MP4	18.53 MB
0404 CASE In WHERE, ORDER BY, And GROUP BY Clauses.MP4	MP4	13.16 MB
0405 CASE In UPDATE And INSERT Statements.MP4	MP4	18.16 MB
0406 CASE Within Subqueries.MP4	MP4	16.52 MB

05. Numbering And Ranking

0501 Numbering Or Ranking Records In A SELECT Statement.MP4	MP4	19.72 MB
0502 Filtering Results Based On Numbering Ranking.MP4	MP4	17.94 MB
0503 Using Numbering Within Groups.MP4	MP4	13.68 MB
0504 Filtering A Ranked Group To Determine Top N.MP4	MP4	14.81 MB

06. Functions

	0601 Using Built In Functions.MP4	MP4	22.26 MB
	0602 Creating And Using Your Own Functions (UDF).MP4	MP4	14.52 MB

07. Views

0701 Creating A View.MP4	MP4	14.79 MB
0702 Example Views And Views In Views.MP4	MP4	14.42 MB
0703 Using The UNION Clause.MP4	MP4	17.62 MB

08. Stored Procedures

0801 What Is A Stored Procedure.MP4	MP4	25.23 MB
0802 Creating A Stored Procedure.MP4	MP4	17.67 MB
0803 Running A Stored Procedure.MP4	MP4	14.16 MB
0804 Stored Procedures Within Stored Procedures.MP4	MP4	15.04 MB
0805 The Global Variables @@Identity And @@Rowcount.MP4	MP4	23.33 MB
0806 Looping With WHILE And IF.MP4	MP4	19.79 MB
0807 Dynamically Build SQL Statements.MP4	MP4	21.63 MB
0808 TRY And CATCH For Error Trapping.MP4	MP4	13.98 MB
0809 Cursors In Use.MP4	MP4	16.11 MB
0810 Use Of Transactions.MP4	MP4	19.49 MB

09. Conclusions

0901 Wrap Up.MP4

MP4

7.21 MB

Project Files

ZIP

661.02 KB

SQL - Beyond The Basics Training Video [2015, ENG]

Tracker name
http://bt2.t-ru.org/ann?magnet
http://bt1.t-ru.org/ann
http://bt2.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337