30-days Money-Back Guarantee
Learn to execute different SQL statements in Microsoft SQL server studio and work with any database tool
Updated on Sep, 2026
Programming, Database and Design Development, SQL
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
In this course, you will learn about Relational Database Management systems and Structured Query Language (SQL)
Introduction to Relational Databases.
Information and Data Models.
Types of Relationships.
Mapping Entities to tables.
Advanced relational model constraints.
What is the Primary Key?
What is a Foreign key?
What are Entity, Attributes?
´Data Definition Language(DDL) & Data Manipulation Language (DML).
Types of SQL statements.
What is DDL (Data Definition Language)?
What is DML (Data Manipulation Language)?
How to get started with Database - install and set up Microsoft SQL Server Management Studio.
How to create a table in a Microsoft SQL server with CREATE TABLE command.
How to insert data in a table in a Microsoft SQL server with INSERT INTO statement.
How to retrieve data from a table with a SELECT statement.
Advanced DDL & DML statements :
How to use string pattern, range of values and set in the SELECT statement.
how to sort data with ORDER BY statement.
how to group by data with GROUP BY clause.
how to use the GROUP BY HAVING clause.
Working with multiple tables:
How to use different tables.
understand the use of Primary key and foreign key.
Understand Different types of Joins:
All these topics you will learn with theoretical concepts along with hands-on practices.
By the end of the course, you gain :
Understand RDBMS concepts.
learn to execute different SQL statements in Microsoft SQL server studio.
learn to work with any database tool.
Get an understanding of Relational Database Management System (RDBMS).
Understand Different terminology of RDBMS.
Learn about SQL statements and their types(DDL and DML statements).
Learn to CREATE Table in Microsoft SQL Server.
Understand how to INSERT data in a table.
How to use a SELECT statement to retrieve data and make use of it effectively.
Understand how to UPDATE and DELETE data in a table.
Check out the detailed breakdown of what’s inside the course
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.