SQL Database MasterClass: Go From Pupil To Master!
Do you want to SKY ROCKET your Income?
Do you want to master the skill of SQL.
Do you have an Interview coming up where you know SQL would look amazing on your resume?
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.
User Defined Functions
and a lot more!
When you are done with this course, you will be able to walk into a interview with a calm confidence and show them that you know what you are doing and apply these skills to build the database back end for an application that will stand the test of time.
If you want a better career take this course you will not be disappointed.
Enroll with confidence! Your enrollment is backed by Udemy’s 30-day, no-questions-asked, money-back guarantee!
What are the requirements?
We teach you how to download SQL Server Management Studio 2014 Express.
What am I going to get from this course?
Design a Complex Database For Any Line Of Business Application
Understand Primary and Foreign Keys
Understand Simple and Complex SQL Statements
What is the target audience?
If You have never Seen a Database You Should Take this course
If you want to know how to speed up Queries you should take this course.
|Section 1: Intro|
Intro to SQL a 101 Guide to Designing and Building Your First Database
Hit the High Def Button Please
Section 1 quiz
|Section 2: Lets Recreate a Database Like Udemy’s Database|
Lets Talk About Tables And How They Are Used In SQL
What Would This Database Need If We Were Recreating Udemy?
Section 2 quiz
|Section 3: Keys Both Primary and Foreign|
How to Create Keys In SQL And Why
Look What Keys Buy You
Section 3 quiz
|Section 4: Lets Fill In Our Datapoints|
Adding Data To Your Database
|Section 5: THe Select|
Select Statement In SQL
The Anatomy of the Select Statement in SQL
Select Exercises to Help You Learn SQL Faster
What Else Can You Do WIth The Select
Lets Talk About The Order By Clause In SQL
Where Clause Deep Dive
Lets Discuss The Like and the In Statements
Basic Database Analytics – Introducing Aggregate Functions
More Complex Analytics: Group By Clause
Section 5 quiz
|Section 6: Sub-queries|
What Is A Subquery
Section 6 quiz
|Section 7: Course Slides and Material Up To Here|
Course Slides and Material Up To Now
|Section 8: Joins|
Left Outer Join
Section 8 quiz
|Section 9: User Defined Functions|
Introduction to User Defined Functions
Scalar Functions SQL Statments
Table Functions SQL Statements
Section 9 quiz
|Section 10: The View|
Lets Talk About Views
View SQL Statements
|Section 11: Stored Procedures The V8 of the SQL World|
Our First Stored Procedure
Stored Proc SQL Statments
Section 11 quiz
|Section 12: Insert Update Delete The Fabulous 3|
Insert Statements in SQL
Update Statements in SQL
SQL Delete Statement
SQL for this section
Section 12 quiz
|Section 13: Getting Real Deep In SQL|
Adding Random Data To Play With
Statements for the Random Data
Adding More Random Data
|Section 14: Introducing the Pivot|
Intro to Pivot and Unpivot
Our First Example Of A Pivot
Code For Pivot Lecture
Section 14 quiz
|Section 15: Trouble Shooting and Optimizing Your Database|
A Intro To SQL Profiler
A How To On Optimizing Our Datbase
Adding Our First Indexes To Our Database
Create a Script to Index All Foreign Keys
Useful Queries For Building The Script To Index All Foreign Keys
Section 15 quiz
|Section 16: SQL Server Reporting Services (SSRS)|
Installing SQL Report Builder 3.0
A Very Basic SSRS Report
|Section 17: Random Tips That Make Life Easier|
How To Use Templates For Quick Access To SQL
Whole DB as Text File
Rico Rodriguez, SQL Architect, Senior Software Developer, Project Manager
I have spent my life teaching others how to be better developers and master the art that is Software Engineering.
I have designed many Enterprise level applications as well as IOS and Android Applications. The skills I teach in my courses is the same skills that I use every day to do everything from running my teams to consulting on Enterprise level projects.
In my career I have found classes like this to be helpful in advancing my career and I wanted to make courses for people that really showed you end to end classes that weren’t as simple as “Hello World”. My goal as an instructor is to drive you to the next level in your careers, and if you want to do that, it takes 3 things. Knowledge, Leadership, Ingenuity. These are the 3 skills that i have used to take my career to the next level.
I have also been a father for 9 years. Throughout those years I have learned so much about myself and raising children. I have been on both sides of the fence from raising step-children and now raising my own son. It has been the experience of a lifetime and I would love to share any of my experiences with you so that you don’t have to go through all the same learning curves that I did.
- Lectures 0
- Quizzes 0
- Duration 50 hours
- Skill level All level
- Language English
- Students 12378
- Assessments Self