SQL Server Administration and Development Training

SQL Server Administration and Development Training

17 March 2020 — 18 April 2020

Special Focus

This course is designed to provide students with technical skills who want to learn and write SQL queries as well as to develop and administer databases in SQL Server.



Price 220 Euro (20% discount for bachelor students)
Application deadline March 16
Apply

Course Details


☆  Introduction

This course is designed to provide students with technical skills who want to learn and write SQL queries as well as to develop and administer databases in SQL Server. The purpose of the course is to train students with concepts of creation, administration and development of databases by implementing with SQL Server.

☆  Course objectives

After completing this course, students will be able to:
describe the relational databases; describe basic architecture and concepts of Microsoft SQL Server; write SQL queries using the SELECT statement; query multiple tables; manipulate data using Transact-SQL; as well as students will be able to implement and administer databases.

☆  Course content

1.Introduction to Relational Databases

• What is Relational Database
• Advantages and disadvantages of RDBMS
• What is SQL and Concepts of Databases
• Tables and columns
• SQL data types
• Relationships in database

2. Microsoft SQL Server

• What is SQL Server
• Versions and editions of SQL Server
• SQL Server data files
• System Databases

3. SQL language commands (DDL, DML, DCL)

• Create tables
• Modify tables
• Delete tables
• Add/rename columns

4.Adding/inserting data to tables

• Introduction to Insert statement
• Insert statements
• Insert statements in multiple rows

5.Select, Update, and Delete the data

• Basic statements
• SQL Aliases
• SQL Statements: WHERE, AND, OR, BETWEEN, IN
• SQL Statements: DISTINCT, TOP, OFFSET-FETCH, LIKE, GROUP BY, HAVING, ORDER BY, SELECT INTO, ANY, ALL

6.Querying multiple tables

• INNER JOIN, LEFT JOIN, RIGHT JOIN
• FULL JOIN, CROSS JOIN
• UNION, Sub-query

7.Data validations using Constraints

• Introduction to validations and constraints
• Types of SQL constraints
• Creation and use of SQL constraints


8.SQL functions and indexes

• Introduction to SQL functions
• Aggregate functions
• Scalar functions
• Introduction to SQL indexes
• SQL Index types

9.Introduction to SQL Server programming

• Basic of SQL programming
• Stored procedures
• SQL User functions
• SQL Views
• SQL Triggers

10. Normalization

• What is Normalization
• Understanding of database normalization
• Normalization types in SQL


11.Security and administration

• Authentications
• Users and logins in SQL Server
• Recovery models
• Backup and Restore

12.Access from applications

• Introduction to applications
• Connection strings in SQL
• Access and basic reading from applications

☆  Schedule

45 hours (3 days per week, 3 hours per day)

Tuesday - Thursday from 09:30 - 12:30
Saturday from 13:00 - 16:00




SQL Server Administration and Development Training

Mentor Pajziti

Instructor

Mentor Pajaziti is a database administrator and developer as well as lecturer. Mentor holds a Master’s Degree in Computers and Telecommunications from University of Prishtina. He also has many certifications and titles, such as: MCP, MCDBA, MCITP, MCTS. Mentor has more than 10 years of work experience working on variety projects related to IT infrastructure and solutions in Microsoft systems, VMware virtualization, and other systems for small, medium, or large companies. Currently he works at Ipko Telecommunications as well as at Probit Academy.






BOLD

© ICK — Innovation Centre Kosovo