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 khirulnizam@gmail.com for request of quotation.

This is the course outline for 4 days.

KUISCELL Short Course

Module

Microsoft SQL for Beginner - Intermediate

Duration

4 days (5 hours x 4 days)

Synopsis

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.

Prerequisites

· 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

 

DAY 2

     Module 4:
Where Conditions
Using the Between Search Condition
Using the In Search Condition
Using the Like Search Condition
Multiple Where Conditions
Select...Where
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:
Operators
Scalar Functions
User Information Functions
Data-Time Functions
String Functions

 

DAY 3

     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
Self-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

 

DAY 4

     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
EventData()
Enabling and Disabling DDL Triggers
Implementing Triggers

 

Instructors

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.

Comments

Popular posts from this blog

Several English proverbs and the Malay pair

Or you could download here for the Malay proverbs app – https://play.google.com/store/apps/details?id=net.kerul.peribahasa English proverbs and the Malay pair Corpus Reference: Amir Muslim, 2009. Peribahasa dan ungkapan Inggeris-Melayu. DBP, Kuala Lumpur http://books.google.com.my/books/about/Peribahasa_dan_ungkapan_Inggeris_Melayu.html?id=bgwwQwAACAAJ 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 blogger.com 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.

ViewFlipper Example–a simple FlashCard

UPDATE: Improved with Fling gesture (Sept 2012) UPDATE: ViewFlipper with Flip-In and Flip-Out Animation (August 2012) This tutorial is to demonstrate the ViewFlipper layout that is almost similar to CardLayout (in Java). The app will produce a simple Flash card that provide several screens with different picture for each card. Flip-in and Flip-out animation provided. Added in Sept 2012 – an improvement to support Fling gesture – enjoy… The amendment is only on the coding part. Some how the layout design (main.xml) is quite long. Later I’ll produce separated screen by including several XML layout from outside files. Screenshots;

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. (  http://www.w3schools.com/bootstrap/   ) Available here -  http://getbootstrap.com/ 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  http://bootstraphero.com/the-big-badass-list-of-twitter-bootstrap-resources/ Flat-UI is from DesignModo -   http://designmodo.com/flat/ 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