Course Description
These are the skills i have used to help redesign a major CRM system.
This course is designed to teach you T-SQL from a Microsoft SQL Management Studio standpoint.
90% of everything I teach you can be used in MySQL as well.
In
this course for Beginners I go over a creating the concept of a
Database for a website that would be similar functionality to Udemy. We
go over the simple and complex parts of designing your first database.
We walk through this whole concept step by step. We talk about
Instructors vs Customers and how to create a database that would support
all the little quirks a Udemy Style application would have to target
from a basic level.
- We spend time on Basic Database Designs
- We slow down to almost half speed so that you can learn what you need to learn from me.
- I show you What questions to ask when creating a Database
In this course we cover all the way from creating a database to complex Select statements, Inner Joins, Where Clauses, Sub queries and so much more. I teach you the pitfalls of each technology so that you can't fall into the same traps everyone else does.
In this course I spend so much time covering the basics setting a great foundation for the things to come later in the course.
I am committed to delivering the best product possible If you love my
course give me a great review. If you are not satisfied with my course
please request a refund and I will happily give it I want to make you a
more powerful developer and if i didn't do that It is my duty to give
you a refund. Along with your refund request please tell me why you are
not happy with my course and what I could have done better to teach you.
Curriculum
Adding Data To Your Database
Basic Database Analytics - Introducing Aggregate Functions
Course Slides and Material Up To Now
How to Create Keys In SQL And Why
Inner Join
Intro to SQL a 101 Guide to Designing and Building Your First Database
Left Outer Join
Lets Discuss The Like and the In Statements
Lets Talk About Tables And How They Are Used In SQL
Lets Talk About The Order By Clause In SQL
Look What Keys Buy You
More Complex Analytics: Group By Clause
Person Table
Section 1: Intro
Section 2: Lets Recreate a Database Like Udemy's Database
Section 3: Keys Both Primary and Foreign
Section 4: Lets Fill In Our Datapoints
Section 5: THe Select
Section 6: Sub-queries
Section 7: Course Slides and Material Up To Here
Section 8: Joins
Select Exercises to Help You Learn SQL Faster
Select Statement In SQL
The Anatomy of the Select Statement in SQL
What Else Can You Do WIth The Select
What Is A Subquery
What Would This Database Need If We Were Recreating Udemy?
Where Clause Deep Dive
LINK FOR THE FREE COURSE
https://www.udemy.com/sql-for-people-who-dont-know-sql-at-all-a-beginners-guide/?couponCode=april2015100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
