Relational Databases and SQL
Data Abstractions, Data Models, Normalization, Normal Forms, Aggregate Functions, Group By, Joins, Unions, Order by
Development ,Database and Design Development,SQL
Lectures -35
Resources -14
Duration -7.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
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.

Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
10 Lectures
-
Excerpts 03:25 03:25
-
Summary 04:34 04:34
-
Databases 13:00 13:00
-
Data Abstractions 06:00 06:00
-
Data Models 19:50 19:50
-
Relational Databases 10:22 10:22
-
Data Types 14:07 14:07
-
Constraints 29:38 29:38
-
Exercises I 01:26 01:26
-
Solutions to Ex. I 22:23 22:23
Basic SQL Commands
6 Lectures

Normalization and Normal Forms
8 Lectures

Advanced SQL Commands
11 Lectures

Instructor Details
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.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now