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
This is a three days course syllabus and is a classroom-based instructor-led one.
Course Outline / Content :
The following Modules are included in this course :
- Understanding Core Database Concepts
- Creating Database Objects
- Manipulating Data
- Understanding Data Storage
- Administering a Database
- Managing Roles
- Recovery Models Database Backups
- Knowledge, Competency & Proficiency Assessment