Learn RDBMS and SQL – Easy and Effective explanation
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.
Course Details
- Language: #English
- Students: 13433
- Rating: 3.97 / 5.0
- Reviews: 119
- Category: #IT_and_Software
- Published: 2022-12-29 20:53:22 UTC
- Price: €19.99
- Instructor: | | Atul Kadlag | |
- Content: 3.5 total hours
- Articles: 3
- Downloadable Resources: 1
Coupon Details
- Coupon Code: LIMITED111
- Expire Time: 2024-03-11 02:17:00 UTC