What you'll learn:
- Get an understanding of Relational Database Management System (RDBMS)
- Understand Different terminology of RDBMS
- Learn about SQL statements and its types(DDL and DML statements)
- Learn to CREATE Table in Microsoft SQL Server
- Understand how to INSERT data in a table
- How to use SELECT statement to retrieve data and making use of its effectively
- Understand how to UPDATE and DELETE data in a table
In this course, you will learn about Relational Database Management systems and Structured Query Language (SQL)
You will learn about the Relational Database Management system:
Introduction to Relational Databases
Information and Data Models
Types of Relationships
Mapping Entities to tables
Advanced relational model constraints
What is Primary Key
What is Foreign key
What is 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 SQLServer Management studio
How to create a table ina Microsoft SQLserver with CREATETABLEcommand
How to insert data in a table in a Microsoft SQLserver with INSERTINTO statement
How to retrieve data from a table with a SELECTstatement
Advanced DDL&DMLstatements :
How to use string pattern, range of values and set in the SELECTstatement
how to sort data with ORDERBY statement
how to group by data with GROUPBYclause
how to use GROUPBYHAVINGclause
Working with multiple tables
How to use different tables
understand the use of Primary key and foreign key
understand Different types of Joins:
Inner Joins
Left Outer Join
Right Outer join
Full outer join
All these topics you will learn with theoretical concepts along with hands-on practices.
By end of the course, you gain :
Understand RDBMS concepts
learn to execute different SQLstatements in Microsoft SQLserver studio
learn to work with any database tool.
