Database Design with Microsoft SQL Server

MS SQL Server

Key Features Live Online

  • 3 days Instructor-Led Live Online Classroom
  • Webex Virtual Class for interactive near-classroom experience
  • Access to Remote Lab PC for Hands-On activities
  • Unlimited Practice exams
  • Integrated Courseware in the Learning Management System
  • Step by Step guide for challenging hands-on lab activities
  • Flexible Schedules – Both Weekdays and Weekends Classes 
  • Get Trained by Database Design with Microsoft SQL Server Expert Trainer with Over 15 Years of Industry Experience
  • No. 1 Training Center for Database Design with Microsoft SQL Server Courses
  • E-learning Access for Pre-course and Post-Training Support 
  • Best Price Guaranteed for Database Design with Microsoft SQL Server Courses

Key Features

  • 3 days Instructor-Led Face to Face Classroom training
  • We are a TESDA Registered Training Center
  • Offering Flexible Schedules – Both Weekdays and Weekends Classes
  • Get Trained by Database Design with Microsoft SQL Server Expert Instructor with Over 15 Years of Industry Experience
  • No. 1 Training Center for Database Design with Microsoft SQL Server Courses
  • We Guarantee the Best Price for Database Design with Microsoft SQL Server Courses

Key Features

  • Gain the technical skills needed in the workplace. 1 on 1 training is the best way to learn
  • The quickest way to master any of our course offerings.
  • Experience superb hands-on laboratory activities and unobstructed attention from your trainer.
  • Guaranteed to start the Training

TRAINEE FEEDBACKS

ABOUT THE COURSE:

This course will provide you with vital skills in designing and implementing a database using Microsoft SQL Server. It is designed for beginners who wish to manage a database running in Microsoft SQL. It covers the fundamentals of relational databases, database design, Structured Query Language (SQL), and database management and administration.

CERTIFICATION:

Training Certificate will be provided after completing the training

ENTRY REQUIREMENTS:

No Required prerequisite, but you should have basic computing and computer database skills

COURSE OUTCOME:

After completing this course, you will learn how to:

  • Learn Database Concepts
  • Familiarize MS SQL Server
  • Plan and Create Databases
  • Learn Constraints and Data Integrity
  • Learn Structured Query Language (SQL) and T-SQL
  • Retrieve Data with SQL and T-SQL
  • Creating Views, Stored Procedures and UDF
  • Learn T-SQL Programming
  • Understanding Indexes and Database Normalisation
  • Migrating, Importing, and Exporting Database
  • Implement Database security
  • Back-Up and Restorethe database

EMPLOYMENT OBJECTIVES

Upon completion of the course, trainees will be qualified to be a database administrator, database developer or database architect

Database Design with Microsoft SQL Server Syllabus

CHAPTER 1 - Database Concepts and Introduction of MS SQL Server

  • Database and DBMS
  • Database Types
  • Flat-type databases
  • Hierarchical databases
  • Relational databases
  • Editions of MS SQL Server 2008, 2012, 2014 and 2016
  • Installing and Configuring Microsoft SQL Server
  • Introduction to SQL Server Management Studio

CHAPTER 2 - Planning and Creating Databases

  • Planning Your Database
  • Creating a SQL Server database
  • Creating tables
  • Data types in SQL Server
  • Defining Primary keys and Identity Specification
  • Inserting, Updating and Deleting records
  • Creating default values

CHAPTER 3 - Constraints and Data Integrity

  • Introduction of Database Constraints
  • Unique Key Constraint
  • Primary and Foreign Key Constraint
  • Relationships in a Database
  • Composite Primary Keys
  • Creating Database Diagram
  • Referential Integrity
  • Setting Cascade Update and Delete

CHAPTER 4 - Structured Query Language (SQL) and T-SQL

  • Introduction of SQL and Transact-SQL (T-SQL)
  • Introduction of Data Definition Language (DDL)
  • USE Command
  • Create Databases using T-SQL
  • Drop Databases using T-SQL
  • Creating, Altering and Removing Tables using T-SQL
  • TRUNCATE TABLE Command to delete data
  • Commenting and Saving T-SQL
  • Introduction of Data Manipulation Language (DML)
  • INSERT statements
  • UPDATE statements
  • DELETE statements
  • Difference between DELETE and TRUNCATE

Assessment Exam

CHAPTER 5 - Retrieving Data with SQL and T-SQL  

  • Using SELECT statements
  • Using WHERE for filtering
  • Using the NOT operator
  • Using the LIKE operator
  • Using IS NULL and IS NOT NULL
  • Using ORDER BY for sorting
  • Using DISTINCT to find unique values
  • Concatenating Columns
  • Creating Calculated Field
  • Limiting Results by using TOP Clause

CHAPTER 6 - Retrieving Data with SQL and T-SQL

  • Using SQL Server Built-in Functions
  • Using Scalar Functions
  • Using Aggregate functions: AVG, MIN, MAX, SUM and COUNT
  • Using GROUP BY clause
  • SQL HAVING Clause
  • SQL UNION and UNION ALL Operators
  • SQL EXCEPT and INTERSECT Operators
  • Using Subqueries
  • Joining multiple tables together

CHAPTER 7 - Creating Views, Stored Procedures and UDF

  • Introduction of Views
  • Creating Views using T-SQL
  • Using View Designer Tools
  • Creating User Defined Functions
  • Creating Stored Procedures

Assessment Exam

CHAPTER  8 -  T-SQL Programming

  • Variables
  • Control Flow - IF…ELSE
  • CASE Statement/Expression

CHAPTER 9 - Database Normalization

  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Understanding Indexes
  • Introduction of Indexes
  • Clustered Indexes
  • Non-clustered Indexes
  • Creating Indexes

CHAPTER 10 - Migrating, Importing and Exporting

  • Generate SQL Scripts
  • Import and Export Wizard
  • Import Data into SQL Server
  • Exporting DataDatabase security
  • Introduction of Database Security
  • Authentication Methods
  • Creating and Managing Logins
  • Creating and Managing Database Users
  • Using SQL Server Roles
  • Managing Permissions

CHAPTER 11 - Backing Up and Restoring

  • Introduction of Database Backups
  • Types of Database Backup
  • Creating backups
  • Restoring databases

Assessment Exam

COURSE FEE

COURSE SCHEDULES

3 days / 8am - 6pm (30hrs)

Administering an SQL 2016 Database Infrastructure

Call Us for more information

Tel: (+632) 8285-2936 / (+632) 8736-2032

SMART: 09204282022 / 09603525900

GLOBE: 09773282627 / 09563346864

Request Course Quotation

Read our Privacy Policy for details on how your information may be used.

Take advantage of CNCTC 's latest interactive Instructor-Led Live Online Training. Online Courses are delivered using WebEx to bring the classroom to your home or workplace and can be accessed directly on your own computer with an internet connection. By using Cisco’s WebEx and integrating our Computer lab facilities, we can provide a near-classroom experience remotely to your location of choice. Register Now!

Executive Gourmet
Copyright © 2000-2025. CNCTC, Inc.
All rights reserved.
Tel Viber Messenger
Live Chat