SQL Server from Basics to Advanced
DESCRIPTION
SQL Server is a relational database management system (RDBMS) developed by Microsoft. In this two days course, candidates will learn how to execute the four main operations (CRUD) using SQL Server,create database objects such as views, indexes, stored procedures, triggers… and transactions in SQL.
This course in quite practical with so many examples and activities and candidates will learn all the principles in a practical project means candidates will leave the class by a project in their hands on the first day of training.
- For the first day no knowledge about programming languages or databases is required.
- For the second day basic knowledge of SQL Server is assumed.
- RDBMS
- Primary key, Surrogate key, Natural key, Composite key and Foreign key
- What is SQL Server?
- Install and connect to SQL Server
- Install SQL Server Management Studio
- CREATE DATABASE
- DELETE DATABASE
- DATA TYPES
- CREATE TABLE
- UPDATE TABLE
- DELETE TABLE
- INSERT
- UPDATE
- DELETE
- SELECT
- ORDER BY
- GROUP BY
- WHERE CLAUSE
- OFFSET
- LIKE
- DISTINCT
- AND, OR, BETWEEN, IN
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN
- CROSS JOIN
- SELF JOIN
- UNION
- INTERSECT
- EXCEPT
- PIVOT
- TEMPORARY TABLES
- NORMALIZATION
- VIEWS
- INDEXES
- STORED PROCEDURES
- USER DEFINED FUNCTIONS
- TRIGGERS
- T-SQL
Course Fee: (per PAX)
RM 1,800
Buying for yourself?
Write to us in the form below, we will contact you to discuss how best to fit your schedule.
Buying for a Team?
Write to us in the form below, we would be happy to talk to you about a group DISCOUNT.
Course Features
- Lectures 0
- Quizzes 0
- Duration 2 Days
- Skill level Beginner
- Language English
- Students 0
- Certificate Yes
- Assessments Self