Learn SQL From The Best And Maximize Your Career

Microsoft SQL is one of the most used enterprise databases. In this course
Course Created by BIll Sims
I have been a Software Architect, Senior Software Developer and SQL Database Architect and Developer for the passed 20 years. I am King of the mountain when it comes to c# and SQL. I have spent my life teaching others how to be developers how to slow down to speed up, and how to be better at their craft. I would love to help you do the same..

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.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

Course Objectives

  • To Teach You From Beginning To End How To Use A Database

Who Is This For?

Course Outline

Chapter 1: Intro

  • Lesson 1
    This Course
    00:36
  • Lesson 2
    What Is A Database
    01:19

Chapter 2: Creating Our First DB

  • Lesson 3
    Lets Create Our First Database
    07:12
  • Lesson 4
    Inserting Data Into Tables …
    08:42

Chapter 3: Basic Queries

  • Lesson 5
    The Select Statement
    06:26
  • Lesson 6
    Anatomy Of The Select State…
    03:09

Chapter 4: Sub Queries

  • Lesson 7
    Lets Turn Up The Heat: Sub…
    02:38
  • Lesson 8
    Inserting Mass Data Into Ta…
    06:41

Chapter 5: More Complex SQL

  • Lesson 9
    How To Update Data in a Dat…
    06:18
  • Lesson 10
    How To Delete Data In A Dat…
    03:38
  • Lesson 11
    The Where Clause is How We …
    06:54

Chapter 6: Your Almost A Pro

  • Lesson 12
    Joining 2 Tables Together
    07:58
  • Lesson 13
    Left Outer Join
    05:51
  • Lesson 14
    Grouping Your Data For Anal…
    08:16
  • Lesson 15
    Aggregate Functions Help Yo…
    08:43

Chapter 7: You Are On Fire: Lets Start Tying It All Together

  • Lesson 16
    Create Alter Drop
    03:36
  • Lesson 17
    Scalar Functions How To Mak…
    07:49
  • Lesson 18
    Joining To A Sub-Query
    05:04
  • Lesson 19
    Functions That Return Tables
    03:55
  • Lesson 20
    Creating a View Helps Re-Us…
    03:53
  • Lesson 21
    Stored Procedures Allow You…
    10:50
  • Lesson 22
    Triggers
    08:16

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)