Microsoft SQL Server®
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.
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:
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.
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.
Numeric Data Types.
Date and Time Data Types.
Other Data Types.
Create your first database.
Start with Basic SQL Command.
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.
DCL Statements with Examples:
TCL Statements with Examples:
SELECT Statement in Details.
Group By Clause.
SQL Alias Names.
Different Type of Joins.
Wildcards Operations (%,_,,^,-).
Working with Aggregation Functions.
Working with Basic Mathematical Functions.
Working with Date and Time Functions.
Working with String Functions.
INSERT INTO SELECT.
INSERT INTO Statement.
SQL Stored Procedures.
Difference Between Delete and Truncate.
Management SQL System Tools.
SQL Server Configuration.
Format of the Course
Interactive lecture and discussion
Lots of exercises and practice
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).
Duration: 8 days (From Monday - Thursday)
Time: 14:00 - 18:15 pm
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.
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 email@example.com with the following details:
Name of the course