Last updated 1/2023
Duration: 3h 18m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 1.23 GB
Genre: eLearning | Language: English
Learn RDBMS and SQL - Easy and Effective explanation
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
Requirements
Basic knowledge about computer
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 this course is for
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
Homepage
Screenshots