Blank

Microsoft SQL Server®

Location Erbil

Fee 400

Start

Monday, 29 January 2024

End

Thursday, 8 February 2024

Course overview

This SQL Server® training course is for participants who want to gain the necessary skills to extract and analyse data from any database and create reports.

The course focuses on teaching professionals the best practices and skills required to successfully design, build and operate a business intelligence solution using SQL Server. During the training, delegates will get an understanding of basics of SQL, queries, sub queries, transactions, database administration, business intelligence, installation of SQL Server and much more.

 
What is Microsoft SQL Server?

SQL Server is Microsoft’s relational database management software built using the SQL language, and it uses a common set of tools to deploy and manage databases both on-premises and in the cloud.

 
Audience

Microsoft SQL Server® Training course is ideal for anyone who wants to write SQL or Transact-SQL queries. However, this will be more beneficial for:

  • Data Analysts

  • Data Engineers

  • Data Scientists

  • Database Administrators

  • Database Developers

Course Outcomes
  • Learn Installing and managing Microsoft SQL Server and Microsoft SQL Studio Management

  • Learn SQL basics with SSMS (SQL Server Management Studio)

  • Database Fundamentals and Design

  • Introduction to SQL Commands

  • Learn how to create, alter and drop tables

  • Use SQL commands to filter, sort, and manipulate strings, and dates numerical data from different sources

  • Retrieving data from the database with different scenarios

  • How to create your own function

  • MSSQL Backup and Restore

  • MSSQL User Management

  • MSSQL Server Agent Management

Course Agenda

Day 1

  • Introduction to the Database.

  • Different Editions of SQL Server.

  • Install MS SQL Server.

  • Download AdventureWorks Database.

  • What is Data.

  • What is Database.

  • How Data is stored.

  • What is SQL.

  • What is the Table, Columns and Rows.

  • What is the Key, Primary Key, Foreign Key and Unique Key.

  • What is RDBMS.

  • What is the transaction and ACID properties.

  • What is Data Normalization.

  • Data Types:

  • Numeric Data Types.

  • Date and Time Data Types.

  • Other Data Types.

  • Create your first database.

  • Start with Basic SQL Command.

  • Quick Quiz

Day 2

  • SQL Statements and Types of SQL Statements.

  • DDL (Data Definition Language) Statements with Examples:

  • Create an Object.

  • Modify an Object.

  • Truncate an Object.

  • Drop an Object.

  • DML (Data Manipulation Language) Statements with Examples:

  • Retrieve the Data.

  • Scalar Functions.

  • Sorting.

  • Distinct Data.

  • Joins.

  • Aggregate Functions.

  • Subqueries.

  • Set Operations.

  • Quick Quiz.

Day 3

  • DCL Statements with Examples:

  • Grant

  • Revoke

  • TCL Statements with Examples:

  • Commit.

  • Rollback.

  • SavePoint.

  • Set Transaction.

  • Quick Quiz

Day 4

  • SELECT Statement in Details.

  • SELECT TOP

  • Operators.

  • Where Close.

  • Having Clause.

  • Group By Clause.

  • SQL Alias Names.

  • Joins.

  • Different Type of Joins.

  • Quick Quiz.

Day 5

  • Wildcards Operations (%,_,[],^,-).

  • Working with Aggregation Functions.

  • Working with Basic Mathematical Functions.

  • Working with Date and Time Functions.

  • Working with String Functions.

  • Quick Quiz.

Day 6

  • SELECT INTO.

  • SQL IN.

  • SQL Between.

  • SQL Comments.

  • SQL Case.

  • Variables

  • SQL IF.

  • SQL While.

  • Quick Quiz.

Day 7

  • INSERT INTO SELECT.

  • INSERT INTO Statement.

  • Update Statement.

  • Delete Statement.

  • SQL Views.

  • SQL Stored Procedures.

  • SQL Triggers.

  • Difference Between Delete and Truncate.

  • Quick Quiz.

Day 8

  • Management SQL System Tools.

  • SQL Server Configuration.

  • Comprehensive Example.

  • Final Quiz.

Format of the Course
  • Interactive lecture and discussion

  • Lots of exercises and practice

 

Prerequisites

There are no formal prerequisites to attend this training course. However, it is recommended to download the required files from the provided link (SQL Server and MS SQL Management Studio).

Course Details
  • Duration: 8 days (From Monday - Thursday)

  • Time: 14:00 - 18:15 pm

  • Refreshments: included

  • Location, Erbil Iraq

About the Trainer

Ezzeddin Qubaitari, certified by Microsoft as Data Analyst Associate, working on MS SQL Server and other programming language like C# and Python as a data analyst and business intelligence developer for more than 12 years in accounting software.

Payment

Must be made 7 working days before the start of the course. Payment can be made in cash, by bank transfer or through exchange offices.

How do I register?

You can register by emailing training@mselect.com with the following details:

  • Full Name:

  • City/Town:

  • Email Address:

  • Phone number:

  • Name of the course