SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
Microsoft SQL Server is one the most popular Relational Database Management System
(RDBMS) used in Microsoft universe. It can be used for data storage as well as for data
retrieval for applications which can be either on desktop or Web/Browser.
Course Objectives: Learn about SQL – Structured Query Language
- Build database using Data Definition Language Statements Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures and Functions stored in database.
- Write and manage database triggers, cursors and Index.
Curriculum
- 21 Sections
- 21 Lessons
- 20 Hours
- Introduction to Basic Database Concepts1
- ER-Modeling and Diagram1
- Normalization1
- Introduction to SQL Server1
- Introduction to SQL1
- DDL and DML Statements1
- Working with Queries (DQL)1
- Aggregate Functions1
- Joins and Set Operations1
- Implementation of Data Integrity1
- Working with Constraints1
- Implementing Views1
- Data Control Language (DCL)1
- Working with Indexes1
- Writing Transact-SQL (T-SQL)1
- Working with Stored Procedures and Functions1
- Implementing Triggers1
- Working with Cursors1
- Transaction Control Language (TCL)1
- Backup and Restore1
- Advance Features1