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

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 java.net.HttpURLConnection 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 .

Contact Us at blog.kerul.net

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. (  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

AutocompleteTextview items from SQLite database

AutoCompleteTextView is yet another basic controls in Android. The main purpose is to provide a suggestion list while you type on the textbox (as in the image below). This time instead of listing a regular ArrayList, I will show how to populate the list from a offline database table  through SQLite. Starts by creating a new project, create a BASIC PROJECT. –> the tutorial is here http://blog.kerul.net/2016/12/creating-new-android-studio-project.html .