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.

Popular Posts

WorldConferences.net