Yea I was thrown off by it too but apparently it's not a one sided story. Bill Gates calls it sequel in an interview but the codeveloper of SQL says its ess que ell.
Depends on who you ask I guess.
http://www.vertabelo.com/blog/notes-from-the-lab/sql-or-sequel
I say "sequel". It just flows better. It's faster to say "Sequel Server" than "S Q L Server".
There's no right or wrong; say it how you want.
If you want to go down the rabbit hole, there's a lot of history behind how you're "supposed" to say it: http://www.vertabelo.com/blog/notes-from-the-lab/sql-or-sequel
Honestly, I had no idea that people actually pronounced it S-Q-L in a professional environment. This blog post seems to indicate that it is probably a cultural divide like I suggested above. I guess this is one thing that I can't really hate Felicity for... I still hate her though.
this article might give you some ideas on how to structure it if you want to have models in a relational database. http://www.vertabelo.com/blog/technical-articles/what-do-poker-blackjack-belot-and-preference-have-to-do-with-databases
Which RDBMS?
PIVOT/UNPIVOT is what you’re looking for.
ORACLE: https://www.techonthenet.com/oracle/pivot.php
SQL Server: https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot
Too basic for my taste, there are no details. Compare with these. It has description of joins: http://www.vertabelo.com/blog/technical-articles/understanding-execution-plans-in-postgresql These are also more informative (btw, you give a link to this website): * https://www.depesz.com/2013/04/16/explaining-the-unexplainable/ * https://www.depesz.com/2013/04/27/explaining-the-unexplainable-part-2/#index-scan
Some trivia: Stonebraker is the 4th person who was given the Turing Award for significant contribution to database systems. And it seems that the Award in this "category" is granted approximately every 16 years. Source: http://www.vertabelo.com/blog/who-will-get-turing-award-in-2030
Here is a good DB design guide and where you should start after you are done with the game design and mechanics documentation:
http://www.vertabelo.com/blog/technical-articles/mmo-games-and-database-design
I remember trying to read up on it and finding it's not a trivial thing to implement, especially if you want to be able to detect clashes.
Possible places to start: - https://martinfowler.com/apsupp/recurring.pdf - http://www.vertabelo.com/blog/technical-articles/again-and-again-managing-recurring-events-in-a-data-model
This would be considered "Denormalizing" your data. There's nothing inherently wrong with it, but has its advantages and disadvantages that you should always be aware of when designing your database. Here's a great, concise article on the topic.
I have nothing to do with these folks, but they have some good stuff to get you started.
https://my.vertabelo.com/community/database-models/most-popular/?allDbms=true
Thanks for responses guys. Ill.be starting FCC soon. If.anyone was interested Ive went through http://openbookproject.net/thinkcs/python/english3e/ For most of my Python. stuff and used these two.things to start Flask http://www.vertabelo.com/blog/technical-articles/web-app-development-with-flask-sqlalchemy-bootstrap-introduction http://blog.miguelgrinberg.com/post/the-flask-mega-tutorial-part-i-hello-world
Im also wondering if anyone has any good material for JS on mobile, work 12hours, but have decent amounts of downtime to use my phone and did alot.of my.Python studies on it.
Some trivia: Stonebraker is the 4th person who was given the Turing Award for significant contribution to database systems. And it seems that the Award in this "category" is granted approximately every 16 years. Source: http://www.vertabelo.com/blog/who-will-get-turing-award-in-2030
There are many online tools that give you the basic knowledge about database concepts. In this article you can find the group of most popular resources: http://www.vertabelo.com/blog/notes-from-the-lab/18-best-online-resources-for-learning-sql-and-database - may be helpful.
Many of those tools are interactive and provides some examples of the differences between sql flavors and allow to try different queries by yourself . Keep in mind that it makes the most sense when you're working with your own real life data.
I think I'm just having a hard time understanding PKs and FKs in general and in Laravel.
If I upload an event, and that event is recurring, do I have to set the event_id
in the recurring_pattern
table myself, or since it's tied as a foreign key to the calendar_event
table, does that field automatically get populated?
I followed this tutorial for the calendar event database, but this is one part of a larger application I'm working on. Because I followed the tutorial, I think I missed some key steps in understanding primary and foreign keys and how they work, and how Laravel handles all of it.
If you are looking for some example app that laverages the flask-sqlalchemy extension take a look at:
https://github.com/pdybka-ep/flask-todoapp
https://github.com/Vertabelo/flask-oauth-demo-app
Both demo apps are wrote for the purpose of tutorials. You can equally take a look at some development details. Links to articles are attached in the README.
And here you've got a pretty cool tutorial how to develop a Python web application with Flask (where Flask-SQLAlchemy is used as well): http://www.vertabelo.com/blog/technical-articles/web-app-development-with-flask-sqlalchemy-bootstrap-introduction
Here you can find some good web-based courses: 18+ Best Online Resources for Learning SQL and Database Concepts
That's right! You should start with the nouns. It's pretty good described here: Database design tutorial. How to create a database model
Here, you've got some useful articles on db normalization:
* A unified view on database normal forms: from the Boyce-Codd Normal Form to the Second Normal Form (2NF, 3NF, BCNF)
* What is the actual definition of First Normal Form (1NF)?
* Database Normalization Primer: How (and how not) to decompose relations
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.
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.
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.
Vertabelo has an in-house license that allows you to install Vertabelo on your own server while providing the same features as a company account in the SaaS model: http://www.vertabelo.com/pricing/enterprise
I agree, the experience with your own real life data is essential. However some theoretical guide is sufficient. I recommend the set of the most known places, where you can learn the basics: