Skip to main content

Training on Microsoft SQL Server for Beginner - Intermediate

Microsoft SQL server trainingKUISCELL database SQL

This training will be organised by KUISCELL Sdn Bhd and targeted to corporate clients. Kindly contact me at for request of quotation.

This is the course outline for 4 days.

KUISCELL Short Course


Microsoft SQL for Beginner - Intermediate


4 days (5 hours x 4 days)


Microsoft produced their own Database Server which famously known as Microsoft SQL Server. This database system calibrates all the Microsoft functionalities whether it is on desktop, client server or web based environment. As a result new integrated system such as Microsoft Dynamic CMS (Microsoft version of SAP), Share Point being developed rapidly using this database infrastructure. Its ability is ranging from small till enterprise solutions. Users will be exposed to the new version of Microsoft SQL Server 2012.

The SQL standard has sublanguages such as:

  • Data Manipulation Language (DML): SELECT statements and action queries (DELETE, UPDATE, INSERT INTO, ...)
  • Data Definition Language (DDL): Statements that alter the schema (changing the tables, fields, indexes, relations, queries, etc.)

Skills Gained

At the end of the course, participant should be able to;

· Install Microsoft SQL Server 2012 and the related components

· Understand the Database Concept

    • ERD Diagram
    • FLOW Chart
    • Primary Keys , Foreign Keys, etc

· Able to write SQL statement from the basic to the intermediate commands

· Able to perform automate backup and restore of created database

Who Can Benefit

· New and experienced application and database developers who wish to expand their toolset and specialize in creating and dealing Microsoft SQL Server capabilities.

· Developers seeking a career as an database developer and administrator

· Those new to database design and development.

· Anyone who started building a database application and needs help putting all the pieces together.


· Have working experienced in related fields.

· Knowledge in Web application using any languages and databases format is highly recommended.

· A computer running Windows with approximately 10GB of free disk space and 4GB of RAM.

Day 1

     Module 1.

Introduction to Database

Primary Keys , Foreign Keys , etc

Entity Relationship Diagram

Data Flow Diagram

     Module 2.

Overview of MSSQL Server 2012

Installation of MSSQL Server

     Module 3.
Understanding the Query Flow
Syntactical Flow of the Query Statement
Logical Flow of the Query Statement
From Clause Data Sources
Possible Data Sources
Named Ranges
[Table Name]
Four-Part Table Names



     Module 4:
Where Conditions
Using the Between Search Condition
Using the In Search Condition
Using the Like Search Condition
Multiple Where Conditions
Ordering the Result Set
Specifying the Order by Using Column Names
Specifying the Order by Using Expressions
Order by and Collation
Select Distinct
     Module 5:
Scalar Functions
User Information Functions
Data-Time Functions
String Functions



     Module 6:
Inner Joins
Creating Inner Joins within SQL Code
Number of Rows Returned
Multiple Table Joins
Outer Joins
Outer Joins and Optional Full Outer Joins
Placing the Conditions within Outer Joins
Multiple-Condition Joins
     Module 7:
Using Unions
Intersection Union
     Module 8:
Simple Subqueries
Using Scalar Subqueries
Using Subqueries as Lists
Using Subqueries as Tables
Simple Aggregations
Basic Aggregations
Grouping within a Result Set
Simple Groupings
Aggravating Queries



     Module 9:
Why Use Views?
Working with Views
Creating Views with DDL Code
Order By and Views
View Restrictions
Executing Views
     Module 10:
Inserting Data
Inserting One Row of Values
Inserting the Result Set from a Stored Procedure
Updating Data
Updating a Single Table
Deleting Data
Creating Tables
Creating Primary Keys
Primary Keys
Creating Foreign Keys
     Module 11:
DDL Triggers
Creating and Altering DDL Triggers
Enabling and Disabling DDL Triggers
Implementing Triggers



Ahmad Kamal Ramli

Master in Computer Network (Computer Science), UiTM.

Bachelor in I. T. (Hons), UTP

Aisyah Mat Jasin

Master in Real Time Software Engineering, UTM

Bachelor in IT (Artificial Intelligent), UUM


Keywords: MsSql training in Malaysia, corporate Microsoft SQL training, SQL Workshop, Learn MsSQL, ICT course, SQL course in Malaysia.


Popular posts from this blog

Several English proverbs and the Malay pair

Or you could download here for the Malay proverbs app – English proverbs and the Malay pair Corpus Reference: Amir Muslim, 2009. Peribahasa dan ungkapan Inggeris-Melayu. DBP, Kuala Lumpur CTRL+F to search Proverbs in English Definition in English Similar Malay Proverbs Definition in Malay 1 Where there is a country, there are people. A country must have people. Ada air adalah ikan. Ada negeri adalah rakyatnya. 2 Dry bread at home is better than roast meat home's the best hujan emas di negeri orang,hujan batu di negeri sendiri Betapa baik pun tempat orang, baik lagi tempat sendiri. 3 There's no accounting for tastes We can't assume that every people have a same feel Kepala sama hitam hati lain-lain. Dalam kehidupan ini, setiap insan berbeza cara, kesukaan, perangai, tabia

WebDev PHP DEVELOPMENT TOOLS Download the XAMPP latest version from . This installation file contains the Apache web server, PHP 5 and 4 interpreter, and the MySQL 5 Community edition. - download latest version MozillaFireFox (OpenSource web browser firefox) – download latest version Google Chrome – fastest web browser on earcth – fast download chrome here TEACHING PLAN Download the teaching plan here for Web/Internet Programming ( download ) NOTES HTML references HTML Editor - Lab 1: HTML Basics - Lab 2: Responsive Design: Lab 3: HTML Forms Lab 4: HTML 5 Lab 5: Bootstrap for responsive Web -

Contact Us at

Powered by EMF HTML Contact Form

Bootstrap Template for PHP database system - MyCompanyHR

HTML without framework is dull. Doing hard-coded CSS and JS are quite difficult with no promising result on cross platform compatibility. So I decided to explore BootStrap as they said it is the most popular web framework. What is BootStrap? - Bootstrap is the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first web sites. (   ) Available here - Why you need Flat-UI? Seems like a beautiful theme to make my site look professional. Anyway you could get variety of BootStrap theme out there, feel free to select here Flat-UI is from DesignModo - Web Programming MyCompanyHR – PHP & MySQL mini project (with Boostrap HTML framework) Template 1: Template for the Lab Exercise. This is a project sample of a staff record management system. It has the PHP structured co

Login JSON Android using Login Activity

I’ve been trying to release this tutorial quite a while. At last after a long hard effort. Since HttpClient is not supported any more in Android SDK 23, I have to resort to org.json.JSONObject and library to do online database with JSON. The objective of this tutorial is to log-in from a mobile client with the username and password stored in an online database facility. STEP 1: Create a new Android project, this time choose the LoginActivity .