Learn RDBMS and SQL – Easy and Effective explanation
What you will 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
Description
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.
English
language
Content
Introduction : SQL & Relational Databases
Introduction
Information and Data Models
Types of Relationships
Mapping Entities to tables
Relational Model Concepts
Check your Understanding
Relational Model Constraints & Data Objects
Relational Constraints Introduction
Relational Model Constraints – Advanced
Additional Details – Relational Model Constraints
Getting Started with Database – Set up Microsoft SQL Server database
Resources
Check your Understanding
Data Definition Language(DDL) & Data Manipulation Language (DML)
Types of SQL statements
CREATE table Statement
CREATE table statement – Hands On
CREATE table with Foreign Key – Hands On
INSERT statement
INSERT statement – Hands on
SELECT statement
SELECT statement – hands on
UPDATE & DELETE Statemnt
UPDATE & DELETE Statement – Hands on
Check your understanding
Advanced Data Definition Language(DDL) & Data Manipulation Language (DML)
String patterns, Ranges & Sets
String patterns, Ranges & Sets – Hands on
Sorting Results sets
Sorting Results sets – Hands on
Grouping Results Sets
Grouping Results Sets – Hands on
Check your understanding
Working with Multiple Tables
Introduction
Joins
Joins – Hands on
Check your understanding
Conclusion
Congratulations