This course is designed by Microsoft to benefit those who are looking to build a career in data platform, data administration, database development, business intelligence. The course is taught by the Microsoft Certified Trainer with years of experience in database and SQL. This course is suitable for beginners, people thinking of changing career, students, graduates, professionals, company staff dealing with database/SQL.
Course Covers
- Understanding core database concepts
- Create database objects
- Manipulate data
- Understand data storage
- Administer a database
Syllabus
Relational Database Management System is the basis for SQL, and for all database design and development systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. SQL commands are used to perform select, insert, delete and update operations on database objects.
Module 1: Understanding Core Database Concepts
This module will cover the following lessons:- Understand how data is stored in tables
- Understand relational database concepts
- Understand data manipulation language (DML)
- Understand data definition language (DDL)
Module 2: Create Database Objects
This module will cover the following lessons:- Choose data types
- Understand tables and how to create them
- Create views
- Create stored procedures and functions
Module 3: Manipulate Data
This module will cover the following lessons:- Select data
- Insert data
- Update data
- Delete & Truncate data
Module 4: Understand Data Storage
This module will cover the following lessons:- Understand normalization
- Understand primary, foreign, and composite keys
- Understand indexes
Module 5: Administer a Database
This module will cover the following lessons:- Understand database security concepts
- Understand database backups and restore