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 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 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:
-
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 SQLÂ statements in Microsoft SQLÂ server studio
-
learn to work with any database tool.