All Courses

Database Design with SQL Server Training

Upgrade your Skills. Leave everything to Us

Database Design with Microsoft SQL Server

/ / Databases SQL
MS SQL Server
blank

Key Features

  • 5 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

  • 5 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 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
  • 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

Add Feedbacks

ABOUT THE COURSE:

This course will provide you the vital skills in designing and implementing a database using Microsoft SQL Server. This course is designed for beginners who wish to venture in managing database running in Microsoft SQL It covers fundamentals of relational database, 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 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 Restore database

EMPLOYMENT OBJECTIVES

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

COURSE CURRICULUM

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

(₱18500) Now ₱ 14800
(USD385]) USD308

COURSE SCHEDULES

sat10feb(feb 10)9:00 amsat09mar(mar 9)3:00 pmDatabase Design with Microsoft SQL ServerDatabase Design

sun11feb(feb 11)9:00 amthu15(feb 15)3:00 pmDatabase Design with Microsoft SQL ServerDatabase Design

sun18feb(feb 18)9:00 amsun17mar(mar 17)3:00 pmDatabase Design with Microsoft SQL ServerDatabase Design

sat24feb(feb 24)9:00 amsat23mar(mar 23)3:00 pmDatabase Design with Microsoft SQL ServerDatabase Design

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.

Virtual/Webex Learning

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 at your 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 own location of choice. Register Now!

TOP