A one-month course, which covers the basics of Database, DQL, DCL etc. this course helps you to become an expert in database administration.

COURSE DURATION

1 MONTH/36 HOURS

COURSE OUTLINE

•  Introduction to basic database concepts
•  E-R modelling and diagram
•  Normalization
•  Introduction to SQL server
•  Introduction to SQL
•  DDL and DML statements
•  Working with queries (DQL)
•  Aggregate functions
•  Joins and set operations
•  Implementation of data integrity
•  Working with constraints
•  Implementing views
•  Data control language (dcl)
•  Working with indexes
•  Writing transact-SQL (t-SQL)
•  Working with stored procedures and functions
•  Implementing triggers
•  Working with cursors
•  Transaction control language (TCL)
•  Backup and restore
•  Advance features

Career Path

Database administrator

Interactive Programmer with database as SQL Server