Description

This course provides students with the knowledge and skills necessary to design and implement a Microsoft SQL Server Database. This course cover from basic database structure as well as introduction to SQL up to how to design a corporate database application using Microsoft SQL Server.

Duration: 3 Days

Prerequisites

• Working knowledge of relational databases.
• Basic knowledge of operating system and its core functionality

Who Should Attend

• Database Administrator
• Hardware and Software Engineer
• Analyst and Database Designer

Course Objectives

After completing this course, students will be able to:
• Understand basic concept of Microsoft SQL Server database
• Understand how to use and build database
• Perform table manipulation and maintain data integrity

Course Outline

• Client-Server Programming
• Introduction to Microsoft SQL Server
• ERD & Database Design
• Building Database
• Microsoft SQL Server Table
• Data Manipulation
• Structure Query Language
• View
• Transact-SQL
• Trigger
• Transactions
• Store Procedure

WhatsApp Us
Chat Us