Complete SQL & Relational Database Management System
Learn RDBMS and SQL - Easy and Effective explanation
Ratings 4.18 / 5.00
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.
Who Should Attend!
- Beginner who want to understand Relational database and wanted to become expert in SQL
- Anyone who want to excel the skills in SQL
- Anyone who want to do the career in Database technologies
