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
• Working knowledge of relational databases.
• Basic knowledge of operating system and its core functionality
• Database Administrator
• Hardware and Software Engineer
• Analyst and Database Designer
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
• 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