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. You'll not only gain new knowledge, but cement that knowledge by


  • +

    Course Syllabus

    ● Getting Started with Database Administration Fundamentals
        ◦ Introduction
    ● Different Types of Databases
        ◦ Introduction
        ◦ What's a Database?
        ◦ Flat-File Databases
        ◦ Hierarchical Databases
        ◦ Relational Databases
    ● Relational Database Concepts
        ◦ Introduction
        ◦ Tables, Rows, and Columns
        ◦ Normalization Overview
        ◦ Indexes
        ◦ Storage: Pages and Physical Files
    ● Database Data Types
        ◦ Introduction
        ◦ Data Type Storage
        ◦ Data Conversions
    ● The SQL Language
        ◦ Introduction
        ◦ Data Manipulation Language (DML)
        ◦ Data Definition Language (DDL)
        ◦ Control Language
    ● Introducing the SQL Server Management Studio
        ◦ Introduction
        ◦ Where to Get It
        ◦ Exploring the Interface and Identifying Key Objects
        ◦ Executing Queries
        ◦ Other Tools
    ● Creating and Using Tables
        ◦ Introduction
        ◦ Creating Tables in the GUI
        ◦ Creating Tables by Using DDL
        ◦ Reviewing Existing Table Designs
        ◦ System Tables
    ● Creating and Using Views
        ◦ Introduction
        ◦ Creating Views in the GUI
        ◦ Creating Views by Using DDL
        ◦ Views vs. Tables
    ● Creating Stored Procedures
        ◦ Introduction
        ◦ The Purpose of Stored Procedures
        ◦ Creating Stored Procedures in the GUI
        ◦ Creating Stored Procedures by Using DDL
        ◦ Executing Stored Procedures
        ◦ Understanding SQL Injection
    ● Basic Queries
        ◦ Introduction
        ◦ SELECT...FROM
        ◦ WHERE
        ◦ ORDER BY
        ◦ Column Aliases
    ● Complex Conditions
        ◦ Introduction
        ◦ Operators
        ◦ Combining Conditions
        ◦ IN
        ◦ LIKE
        ◦ BETWEEN
        ◦ UNION
        ◦ EXCEPT and INTERSECT
    ● Multi-Table Queries
        ◦ Introduction
        ◦ The JOIN Clause
        ◦ Performance and Multi-Table Queries
        ◦ INNER JOIN
        ◦ OUTER JOIN
    ● Modifying Data
        ◦ Introduction
        ◦ INSERT INTO
        ◦ UPDATE
        ◦ DELETE
        ◦ TRUNCATE TABLE
        ◦ DROP TABLE
        ◦ Overview: Referential Integrity
    ● Database Normalization
        ◦ Introduction
        ◦ 1NF: Eliminate Repeating Groups
        ◦ 2NF: Eliminate Redundant Data
        ◦ 3NF: Eliminate Non-Dependent Columns
        ◦ 4NF: No Independent Multiple Relationships
        ◦ 5NF: Isolate Semantically Related Relationships
        ◦ Denormalization
    ● Keys and Constraints
        ◦ Introduction
        ◦ Primary Keys
        ◦ Foreign Keys and Composite Keys
        ◦ Understanding Constraints
    ● Indexes
        ◦ Introduction
        ◦ Clustered Indexes
        ◦ Non-Clustered Indexes
        ◦ Page Index Splits
        ◦ Index Maintenance Concepts
    ● Security
        ◦ Introduction
        ◦ Windows vs. SQL Security
        ◦ Object Permissions
        ◦ Ownership Chains
    ● Backup and Recovery
        ◦ Introduction
        ◦ Recovery Models


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