This program curriculum helps, teach and validate fundamental technology knowledge. Database Administration Fundamentals covers introductory knowledge and skills including: relational databases; core database concepts; relational database concepts; security requirements for databases and the data stored in them; database objects — such as tables and views; graphical tools and T-SQL scripts; database queries; and stored procedures.
This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience. This course is designed for Solution developers, Database developers, Database Administrator, Architects, IT Professionals and anyone who wants to understand new features and capabilities in Database.
- Understand Core Database Concepts, Create Database Objects, Manipulate Data, Understand Data Storage, Administer a Database
- Learn and Understand what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records
- Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established
- Understand what DML is and its role in databases, Understand data definition language (DDL) and Understand how T-SQL can be used to create database objects, such as tables and views