SQL Database MasterClass: Go From Pupil To Master!

S$30.00
Take This Course
SQL Database MasterClass: Go From Pupil To Master!

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

SQL Statements
Views
Stored Procedures
Triggers
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.

Curriculum

Section 1: Intro
Intro to SQL a 101 Guide to Designing and Building Your First Database
05:28
Hit the High Def Button Please
Article
Section 1 quiz
3 questions
Section 2: Lets Recreate a Database Like Udemy’s Database
Lets Talk About Tables And How They Are Used In SQL
05:57
What Would This Database Need If We Were Recreating Udemy?
07:33
Person Table
15:04
Section 2 quiz
5 questions
Section 3: Keys Both Primary and Foreign
How to Create Keys In SQL And Why
10:18
Look What Keys Buy You
01:50
Section 3 quiz
3 questions
Section 4: Lets Fill In Our Datapoints
Adding Data To Your Database
11:35
Section 5: THe Select
Select Statement In SQL
10:13
The Anatomy of the Select Statement in SQL

Preview

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
Section 5 quiz
7 questions
Section 6: Sub-queries
What Is A Subquery
09:27
Section 6 quiz
1 question
Section 7: Course Slides and Material Up To Here
Course Slides and Material Up To Now
39 pages
Section 8: Joins
Inner Join
15:33
Left Outer Join

Preview

07:27
Section 8 quiz
1 question
Section 9: User Defined Functions
Introduction to User Defined Functions
02:06
Scalar Functions
10:22
Scalar Functions SQL Statments
Article
Table Functions
04:52
Table Functions SQL Statements
Article
Section 9 quiz
2 questions
Section 10: The View
Lets Talk About Views
05:24
View SQL Statements
Article
Section 11: Stored Procedures The V8 of the SQL World
Our First Stored Procedure
06:26
Stored Proc SQL Statments
Article
Section 11 quiz
1 question
Section 12: Insert Update Delete The Fabulous 3
Insert Statements in SQL
07:59
Update Statements in SQL
05:47
SQL Delete Statement
06:54
SQL for this section
Article
Section 12 quiz
2 questions
Section 13: Getting Real Deep In SQL
Adding Random Data To Play With
07:56
Statements for the Random Data
Article
Adding More Random Data
05:26
Section 14: Introducing the Pivot
Intro to Pivot and Unpivot
02:21
Our First Example Of A Pivot
08:09
Code For Pivot Lecture
Article
Section 14 quiz
3 questions
Section 15: Trouble Shooting and Optimizing Your Database
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
Useful Queries For Building The Script To Index All Foreign Keys
Article
Section 15 quiz
1 question
Section 16: SQL Server Reporting Services (SSRS)
Installing SQL Report Builder 3.0
01:52
A Very Basic SSRS Report
02:44
Section 17: Random Tips That Make Life Easier
How To Use Templates For Quick Access To SQL
02:33
Whole DB as Text File
Article

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

Course Features

  • Lectures
    Fatal error: Uncaught Error: Call to undefined method LP_Course::get_lessons() in /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/inc/learnpress-v2-functions.php:624 Stack trace: #0 /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/learnpress-v2/single-course/content-landing.php(64): thim_course_info() #1 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(2492): include('/home2/waf6oo0a...') #2 /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/learnpress-v2/content-single-course.php(65): learn_press_get_template('single-course/c...', Array) #3 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(2492): include('/home2/waf6oo0a...') #4 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(1563): learn_press_get_template('content-single-...') #5 /home2/waf6oo0adwwo/public_html/wp-includes/class-wp-hook.php(286): learn_press_content_single_course('') #6 /home2/waf6oo0adwwo/public_html/wp-i in /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/inc/learnpress-v2-functions.php on line 624