Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Relational Databases and SQL

person icon Ivan Iliev

4.3

Relational Databases and SQL

Data Abstractions, Data Models, Normalization, Normal Forms, Aggregate Functions, Group By, Joins, Unions, Order by

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Ivan Iliev

category icon Development ,Database and Design Development,SQL

Lectures -35

Resources -14

Duration -7.5 hours

Lifetime Access

4.3

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

In this course the students will learn about the different levels of data abstractions, how the humanity developed various data models to store information and why the relational model is still widely used. In order to become a better database architect, the pupil must know what normalization is and how to achieve it. This course will have a plenty of exercises where a data model should be created based on the normal forms. The intricacies of their interconnection will be explained and showed. Disciples will hopefully see through that with the fundamental base of knowledge, abstract and logical thinking the planning process of a database will be easily manageable.

Students will also learn the language SQL so that they can not only plan but implement a database for an application. Starting with simple and basic commands (initialization of databases and tables; create, read, update and delete  (CRUD) of data) and moving to more complex queries (joining, grouping, sorting and filtering of the data) will be covered in the course. Making complex queries from multiple tables will be required for students to finish their exercises. If you would like to test (and further develop) your SQL skills, then this course is also for you.

Before we start making multi-tier applications a strong foundation of knowledge, skills and experience with solving simple tasks are necessary. This course is the fifth stepping stone towards achieving that goal.

I hope that my students will be benevolent toward each other in the Q&A section of the courses and be successful in their future career as a software developer (and engineer).

Goals

  • The different data models and how the concept of databases evolved.
  • The advantages and disadvantages of the relational databases.
  • Knowing about the process of Normalization and Normal Forms.
  • How to use the language SQL to write basic queries - creation of database and CRUD.
  • When and why to use the different ways of Joining data.
  • How to group, filter and sort data.
  • Solving practical and complex tasks.

Prerequisites

None.

Relational Databases and SQL

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

10 Lectures
  • play icon Excerpts 03:25 03:25
  • play icon Summary 04:34 04:34
  • play icon Databases 13:00 13:00
  • play icon Data Abstractions 06:00 06:00
  • play icon Data Models 19:50 19:50
  • play icon Relational Databases 10:22 10:22
  • play icon Data Types 14:07 14:07
  • play icon Constraints 29:38 29:38
  • play icon Exercises I 01:26 01:26
  • play icon Solutions to Ex. I 22:23 22:23

Basic SQL Commands

6 Lectures
Tutorialspoint

Normalization and Normal Forms

8 Lectures
Tutorialspoint

Advanced SQL Commands

11 Lectures
Tutorialspoint

Instructor Details

Ivan Iliev

Ivan Iliev

Greetings, stranger! :) I am not surprised to see your kind here. If you want to break free from the Singleton pattern and the exceptional thought about learning from more than one teacher pops up in your mind stack, then you better try that idea now, before the memory reallocation takes place. Some say that in order to become a great software developer you shall learn from the start. The mighty and fearsome kung-fu legends of the past talked and taught about the importance of a strong foundation. In their case that was the core and the legs, in our case, that’s the fundamental theory that will allow us to build complex and meaningful applications.

But don’t be fooled by the seemingly simple task – the casting of that theory into practice will have its price – the asynchronous 0s and 1s that will create the never-ending illusion of everything. The battles ahead will contain different data types, complicated concepts, composite layers of business logic, a variety of databases, and on top of that a selection of presentation layers for the different tastes of the end users. If you are intrepid and passionate enough, merciful and generous towards my lack of ‘x’ years in renowned universities and companies – you have the basic requirements and I am thankful. I will do my best so you can become what I am not – a better version in that repository! :)

P.S.: If you enjoy playing computer games like Witcher 3, WarCraft 3 TFT, Heroes 3 Might and Magic, AOE 2/3, and Diablo 2 – congratulations, you met the recommended requirements for my courses. :)

P.S.S: I have been teaching professional classes in Software Development for 5 years and have a Bachelor's degree in Business Information Technology.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515