Complete SQL & Relational Database Management System
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
Instructor
- 4.2 Instructor Rating
- 1,137 Reviews
- 62,983 Students
- 6 Courses
With over 16 years of enriching experience in the IT industry, I have carved a niche for myself at the forefront of technological innovation, working on a multitude of projects for a global clientele within a leading multinational company. My journey began in the realm of Java technologies, where I honed my skills in enterprise development before diving into the dynamic world of Business Intelligence (BI) and ETL technologies. My expertise spans a wide array of tools and platforms, including:
SAP Business Objects Reporting, SAP Design Studio, SAP Lumira Designer, SAP Analytics Cloud, and Microsoft Power BI Desktop/Pro, Data Fabric, Data Modelling. Python for Data Analysis( Jupyter Notebook, Pandas, Numpy, Matplotlib, Seaborn)
SQL - Microsoft SQL Server, Oracle.
ETL - Microsoft SQL Server Integration Service (SSIS), SAP BusinessObjects Data Services (BODS), and Pentaho,Microsoft Fabric.
In an industry characterized by rapid technological evolution, my ability to swiftly adapt and master new technologies has been a cornerstone of my professional growth. This adaptability, coupled with a deep-seated passion for technology, has propelled me to not only excel in my field but also to share my wealth of knowledge with others.
Driven by the belief that sharing knowledge enriches the community, I founded a YouTube channel, 'Atul Kadlag,' over 5 years ago. Through this platform, I have been dedicated to demystifying complex technological concepts and empowering both peers and enthusiasts alike with practical insights into the latest in technology and BI solutions. This endeavour reflects my commitment to not just excel in the IT industry, but also to contribute to its growth by fostering a culture of learning and innovation.