Studying dbms, so boring. Any advice or tip ?
By mor
@stringer321 (5643)
Kiryat Ata, Israel
August 22, 2016 2:12am CST
I went back to study for my Bs.c in computer sciences and the course I'm taking is database management systems. I have to learn SQL, use postgreSQL, I study about formal query languages such as relational algebra and more.
Some more topics include ER model that is a way to depict the types of entities in the company, and the connections between them, so, then, it is easier to understand how to make the tables and manage the data about them.
So, far, the material is not easy, and it's not easy for me to sit and study. I want to mylot all day. So, I sometimes take notes as questions and answers and review them, I check my memory and see that I can remember stuff.
I will study normalization of tables, make an assignment and at the 22 of September. I will have a test.
I study from the book `Database System Concept (sixth edition) (Abraham Silberschatz, Henry F. Korth, S. Sudarshan).
If you know some stuff, please give me tips.
6 people like this
7 responses
@skysnap (20154)
•
22 Aug 16
It is boring but if you try to teach the concept to others then it'd not be boring. Also if you write some opensource program and script and host it on github then you'd have some refernece to look up to for future. I usually made lot of sample programs to learn and that helped.
3 people like this
@stringer321 (5643)
• Kiryat Ata, Israel
22 Aug 16
I will do that on my computer first of all. Maybe later I will use Github.
SQL is not properly for programming, just to manage the data and the database.
PostgreSQL has the procedural language pl/pgsql that can do complicated tasks and sharing scripts on github can help me to study that. Thanks.
1 person likes this
@skysnap (20154)
•
22 Aug 16
@stringer321 yes what i meant by above response is use postgres or mysql to create small projects and that will make use of the concepts learned in DBMS course.
2 people like this
@silvermist (19702)
• India
22 Aug 16
No I do not have any tips to offer But if you want to study you will have to allot specefic times for studies and online activities.
2 people like this
@stringer321 (5643)
• Kiryat Ata, Israel
22 Aug 16
You are right, I will need to allocate time for studying and time for online activity.
Mylotting I think can help as long as it's not about other subjects.
1 person likes this
@silvermist (19702)
• India
28 Aug 16
@stringer321 So hope you prepare a sort of timetable.
1 person likes this
@ptrikha_2 (45472)
• India
20 Nov 19
Practice is the best way to learn. Try to make a simple application with the database as the backend and some other tool as the Frontend.
Post your queries on Stackoverflow.
There is a site Dzine which covers many Tech topics in a nice way. There could be some good Ppts on LinkedIn.
If you need guidance in Oracle, you can message me as well.
@BelleStarr (61047)
• United States
24 Aug 16
Sorry, been out of school a very very long time, but good luck!!
@stringer321 (5643)
• Kiryat Ata, Israel
24 Aug 16
Many people don't fit to regular schools, I know school is not for everybody.
Don't you learn anything alone as a hobby ? Maybe an art? Painting ?
You can pick up anything and read about it on the internet, watch video guides.
Many things that we learn, we learn in real life and not at school.
@stringer321 (5643)
• Kiryat Ata, Israel
26 Aug 16
@BelleStarr The genealogy is interesting, how do you study genealogy ?
Do you interview people ?
What is the exercise class all about ? what exactly do you do there ?
What blogs do you have ?
Maybe writing a blog is a modern way of studying so you actually help me very much :-)
@BelleStarr (61047)
• United States
25 Aug 16
@stringer321 I am learning new things every day, I do genealogy, I crochet, I go to exercise class, I am very busy. I also have 5 blogs.
1 person likes this
@stringer321 (5643)
• Kiryat Ata, Israel
22 Aug 16
Maybe you know something about studying in general ?
@xstitcher (30291)
• Petaluma, California
6 Sep 16
Oh, my goodness. You must be very smart ! 
I'm afraid I know nothing about those sorts of things ! 
I'm afraid I know nothing about those sorts of things ! 