SqlEssentials-Learning Plan

SQL Server Essentials – Learning Plan
This learning plan should help you progress forward through the lessons. Print this off and start
working down the list. As you complete a step, you can check the checkbox and do some kind of
celebration! It can be an inner dialog Attaboy, or a Starbucks, or some kind of reward.
Whatever it is, it is very important to keep yourself excited to move forward.
The lessons are designed to build on each other, so as you progress, you will naturally reuse the
knowledge from the previous lessons. When you make it all the way through, you will have
increased your personal market value in whatever career path you choose!
Good Luck! And, know that you are already in the top 10% by simply getting this far in your quest
for more knowledge
Foundation – Start Here! – Week 1
□ Download and Print this Learning Plan (This is an easy one!)

□ Download and Install SQL Server Express 2012
□ Install AdventureWorks 2012 Practice Database
□ Install SqlTrainingOnlineSimpleDB Practice Database
□ Download and Fill out the Pre-Training Assessment
□ Download, Print, and Review the Vocabulary List
Module 1 – Introduction to Databases – Week 1
□ Lesson #1 – Overview of Databases

□ Watch Video
□ Review PowerPoint Presentation
□ Review Vocabulary and Exercises
□ Lesson #2 – SQL, How to Talk to Databases

□ Watch Video
□ Lesson #3 – Client Server Relationships Part 1

□ Watch Video
□ Lesson #4 – Client Server Relationships Part 2

□ Watch Video
Page |1
Copyright Embark Blue Inc. © 2020
Joey Blue
http://www.SqlTrainingOnline.com
□ Review your vocabulary list to see if you know any more words. Check them off!
Module 2 – Management Studio – Week 2
□ Lesson #5 – Introduction to Management Studio Part 1

□ Watch Video
□ Lesson #6 – Introduction to Management Studio Part 2

□ Watch Video
□ Lesson #7 – Database Objects Part 1

□ Watch Video
□ Lesson #8 – Database Objects Part 2

□ Watch Video
□ Lesson #9 – Tables Part 1

□ Watch Video
□ Lesson #10 – Tables Part 2

□ Watch Video
□ Lesson #11 – Creating Stuff Part 1

□ Watch Video
□ Lesson #12 – Creating Stuff Part 2

□ Watch Video
□ Lesson #13 – Creating Stuff with Scripts Part 1

□ Watch Video
Page |2
Joey Blue
□ Lesson #14 – Creating Stuff with Scripts Part 2
□ Watch Video
Module 3 – Writing SQL – Week 3
□ Lesson #15 – CRUD Part 1

□ Watch Video
□ Lesson #16 – CRUD Part 2

□ Watch Video
□ Lesson #17 – Beginning Select Statements

□ Watch Video
□ Lesson #18 – Where Clause Part 1

□ Watch Video
□ Lesson #19 – Where Clause Part 2

□ Watch Video
□ Lesson #20 – Sorting

□ Watch Video
□ Lesson #21 – Column List Part 1

□ Watch Video
□ Lesson #22 – Column List Part 2

□ Watch Video
Page |3
Joey Blue
□ Lesson #23 – Group By
□ Watch Video
□ Lesson #24 – Having Clause

□ Watch Video
□ Lesson #25 – Joining Part 1

□ Watch Video
□ Lesson #26 – Joining Part 2

□ Watch Video
Module 4 – Advanced Objects – Week 4
□ Lesson #27 – Views Part 1

□ Watch Video
□ Lesson #28 – Views Part 2

□ Watch Video
□ Lesson #29 – Scripting with Variables Part 1

□ Watch Video
□ Lesson #30 – Scripting with Variables Part 2

□ Watch Video
□ Lesson #31 – Stored Procedures Part 1

□ Watch Video
□ Lesson #32 – Stored Procedures Part 2

□ Watch Video
Page |4
Joey Blue
□ Lesson #33 – Functions Part 1

□ Watch Video
□ Lesson #34 – Functions Part 2

□ Watch Video
Module 5 – Advanced Database Concepts – Week 5
□ Lesson #35 – Security Part 1

□ Watch Video

□ Watch Video

□ Watch Video
□ Lesson #38 – Backups Part 1

□ Watch Video
□ Lesson #39 – Backups Part 2

□ Watch Video
□ Lesson #40 – Indexes Part 1

□ Watch Video

□ Watch Video

□ Watch Video
Page |5
Joey Blue
Next Steps
□ Review your vocabulary list. What words are left?
□ Review your Pre-Training Assessment.
o Have those answers changed?
o What did you learn?
□ Watch Next Steps Video
□ You reached your goal.
□ Celebrate!!!
□ Set a new Goal. (If you think you are ready.)
Page |6
Joey Blue

SqlEssentials-Learning Plan

Uploaded by

Copyright:

Available Formats

SqlEssentials-Learning Plan

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

SqlEssentials-Learning Plan

Uploaded by

Copyright:

Available Formats

SQL Server Essentials – Learning Plan

Foundation – Start Here! – Week 1

□ Download and Print this Learning Plan (This is an easy one!)

Module 1 – Introduction to Databases – Week 1

□ Lesson #1 – Overview of Databases

□ Lesson #2 – SQL, How to Talk to Databases

□ Lesson #3 – Client Server Relationships Part 1

□ Lesson #4 – Client Server Relationships Part 2

Module 2 – Management Studio – Week 2

□ Lesson #5 – Introduction to Management Studio Part 1

□ Lesson #6 – Introduction to Management Studio Part 2

□ Lesson #7 – Database Objects Part 1

□ Lesson #8 – Database Objects Part 2

□ Lesson #9 – Tables Part 1

□ Lesson #10 – Tables Part 2

□ Lesson #11 – Creating Stuff Part 1

□ Lesson #12 – Creating Stuff Part 2

□ Lesson #13 – Creating Stuff with Scripts Part 1

Module 3 – Writing SQL – Week 3

□ Lesson #15 – CRUD Part 1

□ Lesson #16 – CRUD Part 2

□ Lesson #17 – Beginning Select Statements

□ Lesson #18 – Where Clause Part 1

□ Lesson #19 – Where Clause Part 2

□ Lesson #20 – Sorting

□ Lesson #21 – Column List Part 1

□ Lesson #22 – Column List Part 2

□ Lesson #24 – Having Clause

□ Lesson #25 – Joining Part 1

□ Lesson #26 – Joining Part 2

Module 4 – Advanced Objects – Week 4

□ Lesson #27 – Views Part 1

□ Lesson #28 – Views Part 2

□ Lesson #29 – Scripting with Variables Part 1

□ Lesson #30 – Scripting with Variables Part 2

□ Lesson #31 – Stored Procedures Part 1

□ Lesson #32 – Stored Procedures Part 2

□ Lesson #33 – Functions Part 1

□ Lesson #34 – Functions Part 2

Module 5 – Advanced Database Concepts – Week 5

□ Lesson #35 – Security Part 1

□ Lesson #36 – Security Part 2

□ Lesson #37 – Security Part 3

□ Lesson #38 – Backups Part 1

□ Lesson #39 – Backups Part 2

□ Lesson #40 – Indexes Part 1

□ Lesson #41 – Indexes Part 2

□ Lesson #42 – Indexes Part 3

You might also like