2016
Udemy
04:54:45
English

Low pay SQL developers make $60,000 per year. In this course you will learn the skills necessary to rock out SQL Statements, Views, Stored Procedures and more.
In this course you will Design a database from scratch so that you understand the thought process that goes into such a design. We will then bring in the basic skills of SQL and give you example upon example of how to use this skill while building on those basic skills adding in more technique and more difficulty until they become more advanced. You will learn skills that even you average DBA doesn't do properly.

├── 01 - Intro
│ └── 1 Intro to SQL a 101 Guide to Designing and Building Your First Database.mp4
├── 02 - Lets Recreate a Database Like Udemy's Database
│ ├── 1 Lets Talk About Tables And How They Are Used In SQL.mp4
│ ├── 2 What Would This Database Need If We Were Recreating Udemy.mp4
│ └── 3 Person Table.mp4
├── 03 - Keys Both Primary and Foreign
│ ├── 1How to Create Keys In SQL And Why.mp4
│ └── 2 What Keys Buy You.mp4
├── 04 - Lets Fill In Our Datapoints
│ └── 1 Adding Data To Your Database.mp4
├── 05 - THe Select
│ ├── 1 Select Statement In SQL.mp4
│ ├── 2 The Anatomy of the Select Statement in SQL.mp4
│ ├── 3 Select Exercises to Help You Learn SQL Faster.mp4
│ ├── 4 What Else Can You Do WIth The Select.mp4
│ ├── 5 Lets Talk About The Order By Clause In SQL.mp4
│ ├── 6 Where Clause Deep Dive.mp4
│ ├── 7 Lets Discuss The Like and the In Statements.mp4
│ ├── 8 Basic Database Analytics - Introducing Aggregate Functions.mp4
│ └── 9 More Complex Analytics - Group By Clause.mp4
├── 06 - Sub-queries
│ └── 1 What Is A Subquery.mp4
├── 08 - Joins
│ ├── 1 Inner Join.mp4
│ └── 2 Left Outer Join.mp4
├── 09 - User Defined Functions
│ ├── 1 Introduction to User Defined Functions.mp4
│ ├── 2 Scalar Functions.mp4
│ ├── 3.txt
│ ├── 4 Table Functions.mp4
│ └── 5.txt
├── 10 - The View
│ ├── 1 Lets Talk About Views.mp4
│ └── 2.txt
├── 11 - Stored Procedures The V8 of the SQL World
│ ├── 1 Our First Stored Procedure.mp4
│ └── 2.txt
├── 12 - Insert Update Delete The Fabulous 3
│ ├── 1 Insert Statements in SQL.mp4
│ ├── 2 Update Statements in SQL.mp4
│ ├── 3 SQL Delete Statement.mp4
│ └── 4.txt
├── 13 - Getting Real Deep In SQL
│ ├── 1 Adding Random Data To Play With.mp4
│ ├── 2.txt
│ └── 3 Adding More Random Data.mp4
├── 14 - Introducing the Pivot
│ ├── 1 Intro to Pivot and Unpivot.mp4
│ ├── 2 Our First Example Of A Pivot.mp4
│ └── 3.txt
├── 15 - Trouble Shooting and Optimizing Your Database
│ ├── 1 A Intro To SQL Profiler.mp4
│ ├── 2 A How To On Optimizing Our Datbase.mp4
│ ├── 3 Adding Our First Indexes To Our Database.mp4
│ ├── 4 Create a Script to Index All Foreign Keys.mp4
│ └── 5.txt
├── 16 - SQL Server Reporting Services (SSRS)
│ ├── 1 A Very Basic SSRS Report.mp4
│ └── 2 Installing SQL Report Builder 3.0.mp4
└── 17 - Random Tips That Make Life Easier
├── 1 How To Use Templates For Quick Access To SQL.mp4
└── 2.txt

Download File Size:655.09 MB

---