MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server Essentials: What you should know!

Course Summary

Step-by-Step Beginner's Training Course in SQL Server 2012. No prior database knowledge is needed.


  • +

    Course Syllabus

    • Foundation
      • Welcome
      • Learning Plan
      • Learning Outline
      • Pre Assessment
      • Vocabulary List
      • Installing SQL Server 2012 Express
      • Installing Training Database - SQLTrainingOnlineSimpleDB
      • Installing Training Database - AdventureWorks2012
    • Module #1: Introduction to Databases
      • 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
      • Lesson #5: Introduction Management Studio Part 1
      • Lesson #6: Introduction 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
      • Lesson #14: Creating Stuff with Scripts Part 2
    • Module #3: Writing SQL
      • 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 #23: Group By
      • Lesson #24: Having Clause
      • Lesson #25: Joining Part 1
      • Lesson #26: Joining Part 2
    • Module #4: Advanced Objects
      • 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
      • 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
    • Bonuses
      • Bonus #1: SQL and SQL Server Reporting Services
      • Bonus #2: SQL and Microsoft Excel
      • Bonus #3: SQL and Power Pivot
      • Bonus #4: SQL and Microsoft Access
      • Bonus #5: SQL Import and Export


Course Fee:
USD 129

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Open Source and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top