SQL Server Administration and Development (Online 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. The purpose of the course is to train students with concepts of creation, administration and development of databases by implementing with SQL Server.

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.

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

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

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

This course will start on May 5, 2020

Minimum criteria:

1. Course attendance – 80%.
2. Final Project/Exam - 20%