SQL Server Administration and Development Training

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

Application Deadline

• May 16, 2022
• The course will start on May 16, 2022

Schedule

• Monday – Wednesday – Friday from 17:30 – 20:30 • 9 hours per week* 3 days per week* in a total of 45 hours
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

Facebook
Twitter
LinkedIn