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