SQL Database MasterClass: Go from Pupil to Master

SQL Database MasterClass: Go from Pupil to Master

585 Enrolled
6 Hours
Deal Price$19.00
Suggested Price
$50.00
You save 62%
🔥 500+ Sold! Selling Fast
SQL Database MasterClass: Go from Pupil to Master
$19.00$50.0062% OFF
SQL Database MasterClass: Go from Pupil to Master

50 Lessons (6h)

  • Introduction to SQL
    Intro to SQL a 101 Guide to Designing and Building Your First Database5:28
  • Lets Recreate a Video Course Database
    Lets Talk About Tables And How They Are Used In SQL (1728:02)
    What Would This Database Need If We Were Recreating A Video Course Site?7:33
    Lets Make The Person Table15:04
  • Primary and Foreign Keys
    How to Create Keys In SQL And Why10:18
    Look What Keys Buy You1:50
  • Lets Fill In Our Datapoints
    Adding Data To Your Database11:35
  • The Select
    Select Statement In SQL10:13
    The Anatomy of the Select Statement in SQL3:45
    Select Exercises to Help You Learn SQL Faster3:50
    What Else Can You Do WIth The Select17:05
    Lets Talk About The Order By Clause In SQL6:54
    Lets Talk About The Order By Clause In SQL7:15
    Lets Discuss The Like and the In Statements8:02
    Basic Database Analytics - Introducing Aggregate Functions11:25
    More Complex Analytics: Group By Clause7:48
  • Sub-Queries
    What Is A Subquery
  • Joins In SQL
    The Beauty That Is Inner Joins15:33
    Left Outer Joins The Tool That Saves7:27
  • User Defined Functions
    Introduction to User Defined Functions2:06
    Scalar Function10:22
    Table Functions4:52
  • The View
    Lets Talk About Views5:24
  • Stored Procedures The V8 of the SQL World
    Our First Stored Procedure6:39
  • Insert Update Delete Statements in SQL
    Insert Statements in SQL (2329:23)
    Update Statements in SQL5:47
    SQL Delete Statement6:54
  • Getting Real Deep in SQL
    Adding Random Data To Play With7:56
  • Introducing the Pivot
    Intro to Pivot and Unpivot2:21
    Our First Example Of A Pivot6:34
  • Trouble Shooting and Optimizing Your Database
    A Intro To SQL Profiler7:25
    A How To On Optimizing Our Datbase4:21
    Adding Our First Indexes To Our Database9:40
    Create a Script to Index All Foreign Keys25:41
  • SQL Server Reporting Services SSRS
    Installing SQL Report Builder 3.01:52
    A Very Basic SSRS Report2:44
  • Random Tips That Make Life Easier
    How To Use Templates For Quick Access To SQL2:33
SQL Database MasterClass: Go from Pupil to Master
$19.00$50.0062% OFF
View similar items
DescriptionInstructorImportant DetailsRelated Products

Get Immediate Hands-On Experience Working with Databases

BS
Bill Sims

Instructor

Bill Sims has spent his life teaching others how to be better developers and master the art of software engineering. He has designed many enterprise-level applications as well as iOS and Android applications. The skills he teaches in his courses are the same skills that he uses every day to do everything from running his teams to consulting on projects. In his career, he has found classes like this to be helpful in advancing his career, and he hopes to drive you to the next level in your own career. For more details on this course and instructor, click here. This course is hosted by StackSkills, the premier eLearning destination for discovering top-shelf courses on everything from coding—to business—to fitness, and beyond!

Description

Do you want to master SQL, and start making more money with each paycheck? Even the lowest payed SQL developers make upwards of $60,000 per year, and this course will teach you the skills necessary to rock out SQL Statements, Views, Stored Procedures, and more.

  • Study database design w/ 50 lectures & 6 hours of content
  • Design a database from scratch & understand the thought process behind it
  • Building on basic SQL skills w/ more technique
  • Learn techniques that even you average DBA doesn't fully understand
  • Study SQL Statements, Views, Stored Procedures, Triggers, User Defined Functions & more
  • Add essential SQL skills to your resume
  • Build the database back-end for an application

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...