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 2012 Fundamentals LiveLessons

Course Summary

SQL Server 2012 Fundamentals for the Accidental DBA: A Guide to SQL Server for Developers and Systems Administrators


  • +

    Course Syllabus

    • Introduction
      • Introduction to SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons
    • Lesson 1 SQL Server Overview
      • Learning objectives
      • 1.1 Understanding SQL Server
      • 1.2 SQL Server Uses
    • Lesson 2 The Tools
      • Learning objectives
      • 2.1 SQL Server Management Studio
      • 2.2 Configuration Manager
      • 2.3 Profiler
      • 2.4 SQL Server Data Tools
    • Lesson 3 Relational Database Basics
      • Learning objectives
      • 3.1 Tables
      • 3.2 Relationships
    • Lesson 4 Understanding SQL Server Databases
      • Learning objectives
      • 4.1 Database Files
      • 4.2 Transaction Log
      • 4.3 Understanding System Databases
    • Lesson 5 Server Configuration
      • Learning objectives
      • 5.1 Basic SQL Server Configuration
    • Lesson 6 Backing Up SQL Server Database
      • Learning objectives
      • 6.1 Backup Types
      • 6.2 Scheduling Backups
    • Lesson 7 Restoring SQL Server Databases
      • Learning objectives
      • 7.1 Restore Type
      • 7.2 Restoring System Databases
    • Lesson 8 Server Security
      • Learning objectives
      • 8.1 Server Security
    • Lesson 9 Database Security
      • Learning objectives
      • 9.1 Users
      • 9.2 Database Roles
      • 9.3 Ownership Changing
    • Lesson 10 T-SQL
      • Learning objectives
      • 10.1 Basic Data Manipulation Language
      • 10.2 Basic Data Definition Language
    • Lesson 11 Advanced Programmability
      • Learning objectives
      • 11.1 Stored Procedures
      • 11.2 Functions
      • 11.3 Views
      • 11.4 Triggers
      • 11.5 CLR Integration
    • Lesson 12 Indexing
      • Learning objectives
      • 12.1 Index Overview
      • 12.2 Working with Indexes
      • 12.3 Included Columns
    • Lesson 13 Application Security
      • Learning objectives
      • 13.1 How to Set Up Security
      • 13.2 Understanding Abstraction Layers
    • Summary
      • Summary of SQL Server 2012 Fundamentals for the Accidental DBA LiveLessons


Course Fee:
USD 149

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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