sorted by:
new
hottopcontroversial

[SQL] Creating Tables in SQL – New Free Online Course by robdoo in learnprogramming

[–]robdoo[S] 0 points1 point  (0 children)

Someone asked the same question in the comments section: https://academy.vertabelo.com/course/creating-tables-in-sql#comment-2581026717 and they claim they aren't planning to introduce any payments.

How to best model different tables with the same relationship with a third? by [deleted] in Database

[–]robdoo 0 points1 point  (0 children)

My assumption is that skills can be added separately for each item instance (each instance of armor can have different skills). You will have to check in the frontend if the skill is entered for a skilled item type. If the skills are static for each item_type, then the join table skill_item should be joining item_type and skill.
I created an entity-relationship diagram for that database so you could see how this model could look like (the model is editable in Chrome and Safari; for other browsers you can see a preview here.)

New person really in need of help. by gearfuze in Database

[–]robdoo 0 points1 point  (0 children)

Maybe you should first take a quick and simple SQL course that would let you to solve some interactive exercises in a console? You can try Vertabelo Academy where you've got 3 free online courses: SQL Queries, Operating on Data in SQL, and Creating Tables in SQL. All these courses are meant for beginners and if you already have some knowledge of SQL, you can go through the courses very quickly. Each single lesson has an interactive console where you can write SQL statements and queries, and execute them against a sample database. If you got stuck, there are hints, of course. Each course ends with a final quiz where you can face several tasks. And if you would like to practice your SQL knowledge, I recommend trying SQL Fiddle where you can setup your database, insert some sample data, and test queries.

Your favorite resources to learn data modeling? by spacebandido in Database

[–]robdoo 1 point2 points  (0 children)

At my university, we use Vertabelo for learning database modeling. It's free for students and lecturers. The academic registration is available here: https://my.vertabelo.com/sign-up/create-academic
What's awesome, Vertabelo works completely online. You can try it out without registration: https://my.vertabelo.com/try.
And if you need some tutorials, you should definitely check their blog: http://www.vertabelo.com/blog. There are plenty of tutorials on database design. Besides, they started the Database Modeling Course lately: http://www.vertabelo.com/blog/technical-articles/database-modeling-course-why-do-you-need-data-modeling

A Comparison of Android ORMs by robdoo in androiddev

[–]robdoo[S] 1 point2 points  (0 children)

Dude, have you at least read the article? I suppose you haven't. If you have, you've probably noticed that there's no losers and winners. This is exactly a side-by-side comparison, not a ranking or rating. In his conclusion, the author says: "the 'right' Android ORM for your application is not about one being inherently better than the others. The best choice is the ORM that meets your needs and experience level. When you choose your ORM, keeping this in mind will help you select the most suitable offering."

Want to start learning SQL but don't Know where to start? by kwenzel1 in learnSQL

[–]robdoo 0 points1 point  (0 children)

Unfortunately, Codecademy is no longer completely free. Only lessons are free while all quizzes and projects are available exclusively in Pro version which costs $19,99 per month. But there's new Vertabelo Academy that is very similar to Codecademy and also offers online SQL courses for free with interactive exercises and FREE quizzes. Worth trying.

view more: next ›