Relational Databases and SQL

Focused View

Ivan Iliev

7:30:45

36 View

1. Introduction

1. Introduction.mp4

04:34

2. Excerpts.mp4

03:25

3. Databases.mp4

13:00

4.1 levels of abstraction.zip

4. Data Abstractions.mp4

06:00

5. Data Models.mp4

19:50

6.1 Installation.txt

6. Relational Databases.mp4

10:22

7.1 Data Types.xlsx

7.2 sql server data types.zip

7. Data Types.mp4

14:07

8.1 SQL Constraints.xlsx

8. Constraints.mp4

29:38

9.1 #1.pdf

9. Exercises I.mp4

01:26

10. Solutions to Ex. I.mp4

22:23

2. Basic SQL Commands

1. SQL Commands - Part I (Initialize DB).mp4

36:26

2.1 #2.pdf

2. Exercises II.html

3.1 #2 shopdb.zip

3. Solutions to Ex. II.mp4

07:27

4. SQL Commands - Part II (CRUD).mp4

15:10

5.1 #3.pdf

5. Exercises III.html

6.1 #3 shopdb.zip

6. Solutions to Ex. III.mp4

21:21

3. Normalization and Normal Forms

1.1 Normal Forms.pdf

1.2 normal forms.zip

1. Normalization and Normal Forms.mp4

04:29

2.1 Normal Forms - Solution.pdf

2. NF 1-3.mp4

34:03

3.1 #4.pdf

3. Exercises IV.mp4

01:33

4.1 #4 - Solution.pdf

4. Solutions to Ex. IV.mp4

23:24

5. NF 4-5.mp4

28:17

6. DKNF and NF6.mp4

08:34

7.1 #5.pdf

7. Exercises V.html

8.1 #5 - Solution.pdf

8. Solutions to Ex. V.mp4

19:55

4. Advanced SQL Commands

1. Union.mp4

09:14

2.1 sql joins.zip

2. Joins - Part I.mp4

15:00

3.1 Subqueries and Joins.txt

3. Joins - Part II.mp4

12:57

4. Aggregate Functions.mp4

10:31

5. Group By.mp4

22:04

6. Order By and Having.mp4

05:54

7.1 #6.pdf

7. Exercises VI.html

8.1 #6 populace - initialization.zip

8.2 #6 populace - queries.zip

8. Solutions to Ex. VI.mp4

15:13

9.1 #7.pdf

9. Exercises VII.html

10.1 #7 complicated db scenario (mysql).zip

10.2 #7 complicated db scenario (sql server).zip

10.3 #7 inner joins and subqueries task (marti last).zip

10. Solutions to Ex. VII.mp4

25:58

11. End.mp4

08:30

Description

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

What You'll Learn?

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.

Who is this for?

Anyone who has an interest in software development and particularly relational databases.

Students that would like to learn or deepen their understanding in SQL.

What You Need to Know?

None.

More details

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).
Who this course is for:
Anyone who has an interest in software development and particularly relational databases.
Students that would like to learn or deepen their understanding in SQL.

User Reviews

Rating

average 0

Total votes0

Focused display

Greetings, stranger! :) I am not surprised to see your kind here. Many hungry students have travelled through the dense forest of Udemy – the “unbeknownst” factory of knowledge and wisdom. If you want to break free from the Singleton pattern and the exceptional thought about learning from more than one teacher pop up to 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 the strong foundation. In their case that were 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, the variety of databases and on top of that a selection of presentation layers for the different taste 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, War Craft 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 degree of Business Information Technology.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.