Amigoscode - Advanced Databases

[TUTProfessor]

TUTProfessor submitted a new resource:

Amigoscode - Advanced Databases - Master Advanced Concepts

Master Advanced Concepts

Advanced Database

In this course you will learn advanced database concepts that you must know to write production ready applications. As a software engineer knowing these concepts will make sure you write solid backend application and fully understand what goes on behind the scenes. You will learn the following:

• Joins
• Indexes
• Transactions
• Database Administration
• Functions...

Read more about this resource...

 

[peter856]

Thank you!

 

[vineet]

@TUTProfessor is there other course i.e

Please, Log in or Register to view URLs content!

because the part 1 i.e
Relational Database and SQL Essentials is free

 

[TUTProfessor]

Link fixed

 

[naenroo]

link is dead

 

[naenroo]

Link is down

 

[Lightning Storm]

Link fixed

thanks

 

[dankie]

Link is dead

 

[shehangamage]

Link is dead

 

[maHooo_089]

Link fixed

Its Down Professor

 

[m1k3y]

The link is not working TutProfessor

 

[briangates007]

Please fix the dead link and also update the course. Tysm in advance.

 

[girajjasamajja]

up

 

[abjos7]

please, update

 

[KhajaMohiddin]

Thanks a lot

 

[sourav123]

mega link is not working!!!!!!!!!!!!!!!!!!!!!

 

[yimfan]

hi , guys, the link doesn't working now, I want to download this course, could u help update?

 

[CrispDentist]

hi , guys, the link doesn't working now, I want to download this course, could u help update?

No problem. You can down it from

Please, Log in or Register to view URLs content!

.

 

[abjos7]

No problem. You can down it from

Please, Log in or Register to view URLs content!

.

excuse me, sir. is it the same of this post or a new updated version?

 

[CrispDentist]

excuse me, sir. is it the same of this post or a new updated version?

They might or might not be the same version. I have no clue, as I do not have a copy of the one in the original post.

It contains 39 lessons and covers the topics below.

1. Installing Postgres
2. Datagrip
3. Installing Datagrip
4. Configure Datagrip
5. Presentation assistant and Keymaps
6. Connecting to Databases Using Terminal
7. Create Database Using Datagrip
8. Joins
9. Inner Joins
10. Left Joins
11. Right Join
12. Full Join
13. Inner & Outer Joins
14. Why Transactions
15. Begin, Commit and Rollback
16. Nested Transactions
17. Primary Keys and Indexes
18. View Indexes Trough Terminal
19. Create and Drop Indexes
20. Indexes in action
21. Multi Column Indexes
22. Unique Indexes
23. Partial Indexes
24. Function skeleton
25. Create functions
26. View and Drop Functions
27. Roles
28. View Roles
29. Creating roles
30. Privileges
31. Revoking Permissions
32. Member Roles
33. What are Schemas
34. Create Schemas
35. Schema Search Path
36. Grant Schema Usage
37. Backing up Databases
38. Restore Database
39. Backup All databases