Designing Databases

Two important concepts:

  • Entity-Relationship Diagrams
  • Relational schemas

Tools: ERDPlus

SQL

Basic commands:

  1. http://www.sqlcommands.net/
  2. https://www.codecademy.com/articles/sql-commands?r=master
  3. https://www.w3schools.com/sql

At the minimum, you would want to create a table and load your data. You can create a table following https://dev.mysql.com/doc/refman/5.5/en/creating-tables.html. Be mindful of variable types.

To load data (be it CSV/pipe-delimited), follow https://dev.mysql.com/doc/refman/5.7/en/load-data.html When altering the table is required, follow https://www.tutorialspoint.com/mysql/mysql-alter-command.htm.

Keywords: https://dev.mysql.com/doc/refman/5.5/en/keywords.html

Functions and operators:

Date and time: http://www.tutorialspoint.com/mysql/mysql-date-time-functions.htm

Syntax that varies across database platforms:

  • LIMIT/TOP/ROWNUM: http://www.tutorialspoint.com/sql/sql-top-clause.htm

References

Advertisements
Categories: Tags:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s