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
Contents
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
