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

Submit your blog address here

Create your own blog and send the address by submitting the comment of this article. Make sure to provide your full name, matrix and URL address of your blog. Refer to the picture below. Manual on developing a blog using and AdSense, download here … Download Windows Live Writer (a superb offline blog post editor)

Applications of Web 2.0

Web 2.0 describes the changing trends in the use of World Wide Web technology and web design that aim to enhance creativity , secure information sharing, collaboration and functionality of the web. Web 2.0 concepts have led to the development and evolution of web-based communities and hosted services , such as social-networking sites , video sharing sites , wikis , blogs . Find a website or web application that conform to the criteria of Web 2.0. Put the name of the application and the URL in the comment below. Please provide your full name and matrix number. Make sure the application you choose is not already chosen by your friend in the previous comment.

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

List of Malay stop words

Malay Stop Word List ada inikah sampai adakah inilah sana adakan itu sangat adalah itukah sangatlah adanya itulah saya adapun jadi se agak jangan seandainya agar janganlah sebab akan jika sebagai aku jikalau sebagaimana akulah jua sebanyak akupun juapun sebelum al juga sebelummu alangkah kalau sebelumnya allah kami sebenarnya amat kamikah secara antara kamipun sedang antaramu kamu sedangkan antaranya kamukah sedikit apa kamupun sedikitpun apa-apa katakan segala apabila ke sehingga apakah kecuali sejak apapun kelak sekalian atas kembali