Overview
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
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
Basic knowledge about computer
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.
Atul Kadlag
Having worked for more than 14 years in the IT industry on various projects in a multinational company for clients across the globe.
With rapidly changing technologies, I have always adopted new technologies.
Having started my professional career with Java technologies, I have worked on many technologies in Business Intelligence technologies.
Over the 14 years I have worked on the below tools:
- Java ( Enterprise development)
BI Technologies
- WebFocus
- SAP Business Objects Reporting (BI)
- SAP Design Studio (BI)
- SAP Lumira Designer (BI)
- SAP Analytics Cloud (BI)
- Microsoft Power BI Desktop/Microsoft Power BI Pro
ETL Technologies
- Microsoft SQL Server Integration Service(SSIS)
- SAP BusinessObjects Data Services(BODS)
- Pentaho
Having been a quick learner of new technologies and passionate about working in these technologies I have always believed in sharing knowledge.
Sharing knowledge is one thing that gives immense satisfaction to me, that is why I started a Youtube channel ('Atul Kadlag') where I have been sharing my technical knowledge for more than 5 years.