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

Microsoft SQL Server 101

Course Summary

Everything you need to know about Microsoft SQL Server 2012 if you are a new, junior, or involuntary DBA.

  • +

    Course Syllabus

    • Introduction
      • Welcome!
    • What Is A Database Management System?
      • What Is A Database Management System
    • Microsoft SQL Server
      • MS SQL Server Editions And Services
      • Microsoft SQL Server Licensing
    • SQL Server Management Studio
      • Using SQL Server Management Studio
    • SQL Server System Databases
      • SQL Server System Databases
    • Database Files And Options
      • Data And Log Files
      • Data And Log File Growth Settings
      • Filegroups and Full Text Indexes
      • Database Settings
    • Backups And Recovery
      • Recovery Models and Backup Types
      • Backup And Restore Demo
    • SQL Server Agent
      • An Introduction To SQL Server Agent
    • SQL Server Management Features
      • Management Features In SSMS
      • The Dedicated Administrator Connection
    • Database Objects
      • Tables And Views
      • Indexes
      • Stored Procedures And Other Objects
    • SQL Server Security
      • Built In Security Roles And Schemas
      • Schema Demo
    • Data Compression
      • Reducing Database Size With Data Compression
    • High Availablity Solutions
      • Clustering
      • Replication
      • Log Shipping
      • Mirroring
      • AlwaysOn
    • Suggested Mainenance Jobs
      • Backups
      • Advanced Backup Methods
      • Backup History Maintenance
      • Index And Statistics Maintenance
      • Cycle Error Logs
      • Database Mail Maintenance
      • DBCC Check
      • Data Compression Maintenance
    • Basic Troubleshooting Tools
      • Finding The SQL Server Verison Number
      • Why Can't I Log In?
      • Why Is My Query Taking So Long?
      • What Is SQL Waiting On?
      • Creating a Performance Baseline
    • Conclusion
      • Wrap Up

Course Fee:
USD 99

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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