42 lines
1.6 KiB
Markdown
42 lines
1.6 KiB
Markdown
Week 3 Day 1
|
|
============
|
|
|
|
Welcome back!
|
|
|
|
Today we're going to be diving into databses. We'll explore the basics of database creation and design using real world examples.
|
|
|
|
#### Resources
|
|
|
|
[SQL Schema Designer](http://ondras.zarovi.cz/sql/demo/)
|
|
|
|
[SQLite tutorial](http://zetcode.com/db/sqlite/)
|
|
|
|
[Best practices for database design. There are more good things on this site](http://www.sqlwatchmen.com/blogs/jim/2011/03/28/best-practices-for-database-schema-design/)
|
|
|
|
[10 common database design mistakes](https://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/)
|
|
|
|
[An article about null values. The important part of this is that emptiness and null are not the same. You don't have to agree with what he says.](http://www.bennadel.com/blog/85-why-null-values-should-not-be-used-in-a-database-unless-required.htm)
|
|
|
|
[High Scalability - A blog on scaling databases](http://highscalability.com/)
|
|
|
|
[SQL Course](http://www.sqlcourse.com/)
|
|
|
|
[SQL Course 2](http://www.sqlcourse2.com/)
|
|
|
|
|
|
|
|
|
|
Week 3 Day 2
|
|
============
|
|
|
|
|
|
Ready for some serious OOD, SQL, and algorithm challenges today? Grab a coffee and do some stretches.
|
|
|
|
Thankfully, we'll use the [Model-View-Controller](https://en.wikipedia.org/wiki/Model%E2%80%93view%E2%80%93controller) structure to keep our code abstracted and organized - leaving more room in your brain for computation.
|
|
|
|
#### Resources
|
|
|
|
[Object Oriented Design](http://en.wikipedia.org/wiki/Object-oriented_design)
|
|
[SQL Quick Reference](http://www.w3schools.com/sql/sql_quickref.asp)
|
|
[Model-View-Controller](http://c2.com/cgi/wiki?ModelViewController)
|