Skip to content
Database testing is mainly composed of constructing SQL queries to assert and validate different database operations, structures, and attributes required by the application the database is for.
Topics for this course
Module 1:- Introduction to Basic Database Concepts
What is Data, Field, Record and database?
Limitations of File Management System
Basic Concepts of Advantages of DBMS
Exploring Relational DBMS
Understanding Client and Server
Module 2: Introduction to SQL Server
What is SQL Server Version history and different editions?
Basic Features Components and Tools
Starting and Stopping SQL Server Instances / Services
Types of System Databases in SQL
Module 3: Introduction to SQL
Basics of SQL Types of SQL Statements
DDL, DML, DQL, DCL and TCL
Create Database using Management Studio
Datatypes in SQL Server
Exploring DDL Statements on Table using Management Studio
Module 4: DDL and DML Statements
Why write statements in Frontends?
Create, Alter and Drop Table Insert
Update and Delete Statement Truncate Statement
Module 5: Working with Queries (DQL)
Understanding Select Statement
Usage of Top, Distinct, Null etc… keywords
Using String and Arithmetic Expressions
Exploring Where Clause with Operators
Using Advanced Operators
Sorting data using Order By clause
Working with basic of Sub Queries
Module 6: Aggregate Functions
Using functions in Queries
Count, Sum, Min, Max, Avg Group By and Having Clause
Using Group By with Rollup and Cube
Module 7: Joins and Set Operations
Introduction to Joins Cross Joins
Co-related Sub Queries
Set Operations using Unions, Intersect and Except
Module 8: Implementation of Data integrity
Types of constraints
Module 9: Working with Constraints
Default Check Foreign Key
Enter the destination URL
Open link in a new tab
Or link to existing content
No search term specified. Showing recent items.
Search or use up and down arrow keys to select an item.