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 MTA: Database Administration Fundamentals

Course Summary

This is a practical course for someone new to relational databases that moves you through basic concepts right into real-world usage, demonstrating core tasks in Microsoft SQL Server itself.


  • +

    Course Syllabus

    Getting Started with Database Administration Fundamentals
    - 2m 56s

    —Introduction 2m 56s
    Different Types of Databases
    - 15m 5s

    —Introduction 0m 32s
    —What's a Database? 6m 10s
    —Flat-File Databases 0m 54s
    —Hierarchical Databases 1m 13s
    —Relational Databases 6m 16s
    Relational Database Concepts
    - 15m 30s
    Database Data Types
    - 14m 42s
    The SQL Language
    - 12m 29s
    Introducing the SQL Server Management Studio
    - 14m 29s
    Creating and Using Tables
    - 13m 28s
    Creating and Using Views
    - 13m 14s
    Creating Stored Procedures
    - 10m 8s
    Basic Queries
    - 20m 42s
    Complex Conditions
    - 17m 16s
    Multi-Table Queries
    - 15m 8s
    Modifying Data
    - 19m 27s
    Database Normalization
    - 14m 39s
    Keys and Constraints
    - 11m 28s
    Indexes
    - 12m 30s
    Security
    - 17m 4s
    Backup and Recovery
    - 15m 1s
    Continual Maintenance
    - 13m 35s
    Preparing for Your DBA Fundamentals (98-364) Exam
    - 4m 26s
    Next Steps
    - 1m 51s


Course Fee:
USD 29

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