<!-- ********************************** --> #### &nbsp; ##**Syllabus, schedule, notes** ###Below, you'll find links to the lecture and discussion notes. ###The notes are in the form of browser-based slides [not PDF or ppt], but you can create PDFs out of them by 'printing to PDF' using Chrome [you might need to install a PDF driver], in 'landscape' [not 'portrait'] orientation. ###Speaking of discussions - we'll have lecture from 5-7:30, and discussions from 7:40-8:20. During discussion time, YOU [collectively speaking] need to be speaking more than me :) I'll bring up questions, topics etc. for us to talk about. We'll try to cover new ground during this time, and not use it as a chance to go over all the existing slides; the best use of the discussion slot is when we can talk about 'peripheral', and additional items, compared to lecture notes. <div style="height:1px;border:1px solid #BBBBBB;"/> <div style="height:1px;border:1px solid #BBBBBB;"/> <div style="height:1px;border:1px solid #BBBBBB;"/> <table cellspacing="2" cellpadding="5" border="2" style="margin-left: 10px; text-color:#FFFFFF;padding:10px"> <thead> <tr> <td><b>Week# (start)</b></td> <td><b>Topic(s)</b></td> </tr> </thead> <tbody> <tr> <td>1 (1/9)</td> <td> <ul> <li><a target="_blank" href="Intro/slides.html">Introduction</a><br> <li><a target="_blank" href="DataModeling/slides.html">Data modeling</a> <li><a target="_blank" href="discussions/w1.html">Discussions</a> </ul> </td> </tr> <tr> <td>2 (1/16)</td> <td> <ul> <li><a target="_blank" href="DataModeling/slides.html">Data modeling</a> [cont'd] <li><a target="_blank" href="ER/slides.html">E-R diagrams</a>, <a target="_blank" href="EER/slides.html">E-E-R diagrams</a> </ul> </td> </tr> <tr> <td>3 (1/23)</td> <td> <ul> <li><a target="_blank" href="RelationalModel/slides.html">Relational model</a> <li><a target="_blank" href="discussions/w3.html">Discussions</a> </ul> </td> </tr> <tr> <td>4 (1/30)</td> <td> <ul> <li><a target="_blank" href="Normalization/slides.html">Normalization</a> <li><a target="_blank" href="SQL/slides.html">SQL</a><br> </ul> </td> </tr> <tr> <td>5 (2/6)</td> <td> <ul> <li><a target="_blank" href="SQL/slides.html">SQL</a> [cont'd] <li><a target="_blank" href="MoreSQL/slides.html">More SQL</a> </ul> </td> </tr> <tr> <td>6 (2/13)</td> <td> <ul> <li><a target="_blank" href="MoreSQL/slides.html">More SQL</a> [cont'd] </ul> </td> </tr> <tr> <td>7 (2/20)</td> <td> <ul> <li><a target="_blank" href="TransacMgmt/slides.html">Transaction management</a> <li><a target="_blank" href="DistributedDBs/slides.html">Distributed DBs</a> </ul> </td> </tr> <tr> <td>8 (2/27)</td> <td> <ul> <li><a target="_blank" href="DistributedDBs/slides.html">Distributed DBs</a> [cont'd] <li><a target="_blank" href="DBConn/slides.html">DB connectivity</a> </td> </tr> <tr> <td>9 (3/6)</td> <td> <ul> <li><a target="_blank" href="PerfTuning/slides.html">Performance tuning</a> <li><b> Midterm exam</b> [3/10 (Fri), 3-4:30 pm] </ul> </td> </tr> <tr> <td>(3/13)</td> <td> <ul> <li><b>SPRING BREAK!!</b> </ul> </td> </tr> <tr> <td>10 (3/20)</td> <td> <ul> <li><a target="_blank" href="BI/slides.html">Business Intelligence</a> <li><a target="_blank" href="Spatial/slides.html">Spatial DBs</a> </ul> </td> </tr> <tr> <td>11 (3/27)</td> <td> <ul> <li><a target="_blank" href="Spatial/slides.html">Spatial DBs</a> [cont'd] </ul> </td> </tr> <tr> <td>12 (4/3)</td> <td> <ul> <li><a target="_blank" href="NoSQL/slides.html">NoSQL</a> </ul> </td> </tr> <tr> <td>13 (4/10)</td> <td> <ul> <li><a target="_blank" href="MapReduce/slides.html">MapReduce</a> </ul> </td> </tr> <tr> <td>14 (4/17)</td> <td> <ul> <li><a target="_blank" href="DM/slides.html">Data mining (DM)</a> <li><a target="_blank" href="ML/slides.html">Machine learning (ML)</a> <li><a target="_blank" href="DM_ML_tools/slides.html">DM/ML tools</a> </ul> </td> </tr> <tr> <td>15 (4/24)</td> <td> <ul> <li><a target="_blank" href="Viz/slides.html">Data viz</a> <li><a target="_blank" href="GPSETC/slides.html">Data governance, etc.</a> <li><a target="_blank" href="Review/slides.html">Review</a> </ul> </td> </tr> <tr> <td><b></b></td> <td> <ul> <li><a target="_blank" href="https://classes.usc.edu/term-20231/finals/"><b>Final exam: 5/3 (Wed), 8-9:30 am</b></a> </ul> </td> </tr> </tbody> </table> <div style="height:1px;border:1px solid #BBBBBB;"/> ##Tools ###Whiteboards: ####https://webwhiteboard.com/ ####https://www.tutorialspoint.com/whiteboard.htm ####https://canvas.apps.chrome/ ####https://bytes.usc.edu/~saty/tools/lc/ ###Viewers: ####https://www.jsonformatter.io/ ####https://jsoncrack.com/editor ####https://bytes.usc.edu/~saty/tools/jsoned ###VDI: ####https://cloudapps.usc.edu/portal/webclient/#/desktop <div style="height:1px;border:1px solid #BBBBBB;"/> <div style="height:1px;border:1px solid #BBBBBB;"/> <div style="height:1px;border:1px solid #BBBBBB;"/> <!-- **************************** --> <!-- ********************************** -->