*signup for a free trial session. Contact us for fee details.
To gain the knowledge and skills to build database queries and create database objects using SQL Server Management studio tool. As part of the course, student will also have excellent understanding and hands-on experience on Relational database design with SQL language structure and T-SQL programming language.
Student will learn:
- About Databases and SQL Database platform
- About Relational Database Design
- Structured Query Language (SQL); In depth knowledge of T-SQL programming language
- Writing SQL Queries and manipulating data
- Writing Stored Procedures, Views and database transaction management
Pre-requisite: Basic knowledge of computer systems
Potential Job Roles after successful completion: Data Analyst, SQL/Database Developer, SQA Analyst, Business Analyst, Reports developer, Business Intelligence developer
Understanding of SQL is a must for anyone venturing into the IT world.
- Lectures 37
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 75
- Certificate Yes
- Assessments Yes
Introduction to Database & SQL Server 2hrs
Setup SQL Server database 2 hrs (with lab)
Relational Database Management System 6 hrs (with lab)
Implementing Data Integrity 4 hrs (with lab)
Writing Queries to fetch data 6 hrs (with lab)
Create and Manage Views 4 hrs (with lab)
Create and Manage Stored Procedure 4 hrs (with lab)
Create and Manage User Defined Functions 4 hrs (with lab)
Create and Manage Triggers 4 hrs (with lab)
Data load to tables & Advanced features 4 hrs (with lab)
and 70 students enrolled.