mcAfee-secured website

Course name Databases Courses SQL: From design to Mastery Class: SQL: From design to Mastery Class

SQL: From design to Mastery Class Video Course

SQL: From design to Mastery Class Video Course is developed by Databases Courses Professionals to help you pass the SQL: From design to Mastery Class exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass SQL: From design to Mastery Class exam.

Curriculum For This Course

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