SQL Server Administration and Development (Online Training)
07 December 2020 — 08 January 2021
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 | 99 Euro |
| Application deadline | December 6, 2020 |
| (This course has ended) | |
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)5 weeks
Monday - Wednesday - Friday from 17:30 - 20:30
This course will start on December 7, 2020
☆ Certification
Certificate of Attendance / Completion
Minimum criteria:
1. Course attendance – 80%.
2. Final Project/Exam - 20%
☆ Supporters
This training course is supported by “The Innovation & Training Park (ITP)”.
Mentor Pajaziti
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.