Database Design and Implementation in SQL Server

Database Design and Implementation in SQL Server

  • Course level: Intermediate  
There are no active Semester Schedule for this course   Pre-registar

Description

This is a data engineering course in intermediate level to learn how to design and implement a database in Microsoft SQL Server.

COURSE OBJECTIVES

•To know SQL Server, its components, and configurations
•To learn how to build conceptual and logical data model
•To work with the data types supported by SQL Server
•To design and implement tables and work with schemas
•To design and implement stored procedures, and functions
•To design and implement constraints and triggers

COURSE SYLLABUS

•Introduction to Database Design
•Introduction to Microsoft SQL Server
•Installing and Configuring SQL Database
•Introduction to Tables
•CRUD Stored Procedures
•SQL Comments
•Import and Export data
•Joins
•Functions
•Triggers
•Views
•Cursors
•Data Integrity
•Exception Handling
•Data Manipulation Language (DML)
•SQL Server Security
•SQL Database Backup & Restore
•Database Maintenance
Registration fee :
€ 590

Target audience

  • Data Engineers
  • Database Administrators
  • IT staff
  • Computer Science and IT Students

Requirements

  • Basic knowledge on programming