access
lifetime
content
6 Hours
enrolled
578
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
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!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.
Course Outline
- Introduction to SQL
- Intro to SQL a 101 Guide to Designing and Building Your First Database (5: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 Table (15:04)
- Primary and Foreign Keys
- How to Create Keys In SQL And Why (10:18)
- Look What Keys Buy You (1:50)
- Lets Fill In Our Datapoints
- Adding Data To Your Database (11:35)
- The Select
- Select Statement In SQL (10:13)
- The Anatomy of the Select Statement in SQL (3:45)
- Select Exercises to Help You Learn SQL Faster (3:50)
- What Else Can You Do WIth The Select (17:05)
- Lets Talk About The Order By Clause In SQL (6:54)
- Lets Talk About The Order By Clause In SQL (7:15)
- Lets Discuss The Like and the In Statements (8:02)
- Basic Database Analytics - Introducing Aggregate Functions (11:25)
- More Complex Analytics: Group By Clause (7:48)
- Sub-Queries
- What Is A Subquery
- Joins In SQL
- The Beauty That Is Inner Joins (15:33)
- Left Outer Joins The Tool That Saves (7:27)
- User Defined Functions
- Introduction to User Defined Functions (2:06)
- Scalar Function (10:22)
- Table Functions (4:52)
- The View
- Lets Talk About Views (5:24)
- Stored Procedures The V8 of the SQL World
- Our First Stored Procedure (6:39)
- Insert Update Delete Statements in SQL
- Insert Statements in SQL (2329:23)
- Update Statements in SQL (5:47)
- SQL Delete Statement (6:54)
- Getting Real Deep in SQL
- Adding Random Data To Play With (7:56)
- Introducing the Pivot
- Intro to Pivot and Unpivot (2:21)
- Our First Example Of A Pivot (6:34)
- Trouble Shooting and Optimizing Your Database
- A Intro To SQL Profiler (7:25)
- A How To On Optimizing Our Datbase (4:21)
- Adding Our First Indexes To Our Database (9:40)
- Create a Script to Index All Foreign Keys (25:41)
- SQL Server Reporting Services SSRS
- Installing SQL Report Builder 3.0 (1:52)
- A Very Basic SSRS Report (2:44)
- Random Tips That Make Life Easier
- How To Use Templates For Quick Access To SQL (2:33)
access
lifetime
content
6 Hours
enrolled
578