Gtec
Gtec education course thumbnail

Certificate Course In SQL Server

Course category: Certificate Course

Course Duration: 1 Month

OBJECTIVE: - 

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 OUTLINE

Module 1

  •  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

G-TEC Courses