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

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

DescriptionInstructorImportant DetailsRelated Products

Get Immediate Hands-On Experience Working with Databases

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...