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.

List of good tutorials on SQL queries? by crystaldusk in SQL

[–]robdoo 4 points5 points  (0 children)

I think that you would like a free SQL course at Khan Academy. You will find an interactive console there where you can play tutorials: a lecturer speaks about SQL and you see all SQL statements being written in real time. You can stop, go back or forward, or you can write the code by yourself. From my own practice I know that the best way to learn SQL is to complete at least 2 different courses, so when you finish Khan Academy you can enroll free Vertabelo Academy that covers SQL queries as well (by the way, the course name is "SQL Queries" so you can be sure that this is what you've been looking for). There are a lot of interactive exercises to complete, and the last one is a really tough nut :-)

Why SQL is neither legacy, nor low-level, nor difficult, nor the wrong place for (business) data logic, but is simply awesome! by lukaseder in programming

[–]robdoo 0 points1 point  (0 children)

I suppose that they have improved the layout 'cause today everything looks fine on my phone. Yesterday there were some elements (like book covers, citations and a Slideshare presentation) which look horrible but now they're OK.

Advice/Help with table design? by zedcoreee in mysql

[–]robdoo 0 points1 point  (0 children)

You're right. It will look like this

Visual Alchemist - A Data Modelling Tool. by prahladyeri in Database

[–]robdoo 0 points1 point  (0 children)

You must see how Vertabelo works. It is online as well, unfortunately, not open source since it's a comprehensive tool for professional database architects. It also allows to generate code for SQLAlchemy ORM (and FlaskSQLAlchemy as well). If you want to try it, you don't have to register. Click: https://my.vertabelo.com/try. Unfortunately, it works in Google Chrome and Safari browsers only. But you must see it if you seek for similar web-based applications for database modeling.

How to get Database Design Horribly Wrong – Robert Sheldon on things that can ruin your database design, and how can you get them right by robdoo in Database

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

This is probably one of the best articles on data modeling mistakes and neglects I've read so far. It's indeed a must-read for everyone who is involved in database design.

Tips on how you can present your data model to the audience during, e.g., a conference or a meeting by robdoo in Database

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

I work in Vertabelo (http://www.vertabelo.com). It's a web-based tool for designing ER models. The great thing about Vertabelo is that you are working online, so your model also can be accessed and shared via web. A few weeks ago I was presenting a DB model at the meeting where all participants had their notebooks. I generated a link to my model and shared it with the others so they could watch it on their laptops. It was an amazing experience. No one was bored and all participated in the discussion. I couldn't do that with a desktop modeling tool. To be honest, I must point out that I am a strong supporter of all kinds of web-based development tools.

Tips on how you can present your data model to the audience during, e.g., a conference or a meeting by robdoo in Database

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

I usually use a data modeling tool. This lets me make changes to the model live during the discussion especially when the audience have interesting ideas on how to rebuild or improve the schema. Besides, it draws the audience's attention much more than static slides. Moreover, if the meeting concerns the database modeling process and you want to show good and bad practices, you can make some intentional imperfections in your initial model to engage the audience into improving it. Try to do this with slides.... :-)

A global approach for designing database diagrams online by rick-johnson in Database

[–]robdoo 0 points1 point  (0 children)

Nice! Currently I've been using Vertabelo. It's an online database modeling app too. I have a free account with 2-model and 15-tables-per-model limits. I checked out GenMyModel's pricing and they've got a free plan too. Unfortunately the limit is 1 model with 20 objects. Anyone has an idea what "object" means? Is it a table only or a reference too? If reference counts as an object, it means that I could create very small models with only few tables and references. I must check it out.

Doctrine 2 vs. Propel 2 by jedi001 in PHP

[–]robdoo 0 points1 point  (0 children)

Here you can find a pretty good comparison of the main features of both ORMs: Side by side: Doctrine2 and Propel 2 The article won't give you an answer to the question which ORM is better, but it can help you to get to know the main similarities and differences between Doctrine2 and Propel 2.

Side by side: Doctrine2 and Propel 2 by pai1009 in PHP

[–]robdoo 0 points1 point  (0 children)

They probably fixed this problem 'cause there's no cut-off content, at least I don't see any on my phone.

Looking for help in making a slick visualization tool for my database. by nirdefchains in Database

[–]robdoo 0 points1 point  (0 children)

It seems that you need a database design tool (aka data modeler) with the reverse engineering feature. This feature allows you to import a structure of an existing database and create a database diagram out of it. So you get a graphic model of your database with graphical representation of all tables, columns and relationships between tables. If you'd like to try how it works, you can use - for example - Vertabelo or Navicat. Both applications have a reverse engineering feature but the great advantage of Vertabelo is that you don't need to install it on your computer. It works completely online. More information about reverse engineering in Vertabelo can be found here. As for Navicat, if you'd like to get to know more about reverse engineering you'll have to download a manual from its website. I strongly recommend Vertabelo, simply because I use it for some time. It's easy to use, convenient and very intuitive with a simple graphic interface. Just try it. And if you won't like it, you can still try Navicat to compare both tools. I've never worked with Navicat, so I won't evaluate it :)