Courses
Sections
Projects
Wiki
News
Forums
Surveys
Mailing Lists| Author | Message |
|---|---|
|
nextmatrixman
Posts: 57
|
Posted 00:45 Nov 18, 2014 |
Dr. Sun After receiving the material in the last lecture for SQL review (I watched the video online), it seems that the topic is quite open ended. What should we be focusing on in preparation for Lab 6 - SQL besides the examples presented in class along with string functions and date/time functions? And what will be the level of complexity to be expected? Thank you! |
|
cysun
Posts: 2935
|
Posted 08:12 Nov 18, 2014 |
Just review your CS122 course materials about SQL (create/insert/select), and have MySQL documentation handy in case you need to look up any functions. You should expect one outer join and one aggregation (i.e. group by) query, but for the most part the queries will be pretty straightforward. |
|
Schnitzcel
Posts: 7
|
Posted 22:15 Nov 18, 2014 |
Do we need to install MySQL for the lab? |
|
cysun
Posts: 2935
|
Posted 22:38 Nov 18, 2014 |
You don't have to as each CS3 account comes with a MySQL database, but like I said in class, if you use your own laptop for the labs, I'd recommend you install a local copy of MySQL. |
