*Please note: This class is听not being offered Summer 2 2023*

  • 厂辫别肠颈补濒颈锄补迟颈辞苍:听Databases
  • Instructor:听Alan Paradise, Assistant Teaching Professor听
  • Prior knowledge needed:听

Learning Outcomes听

  • Analyze database contents using听 basic, intermediate and advanced SQL statement syntax and usage.
  • Demonstrate capability to query data from multiple tables using SQL JOINS.
  • Create and modify database table and index structures.
  • Maintain table data integrity through constraints.
  • Understand how to compose queries for optimum database performance and efficiency.

Course Content

Duration: 2h

The origins of SQL, what it is and how it works.

Duration: 7h

The SELECT statement - retrieving data from your database.

Duration: 4h

The five GROUP functions.

Duration: 4h

听Using the JOIN.

Duration: 1h

You will complete a peer reviewed final project worth 50% of your grade. You must attempt the final in order to earn a grade in the course.听If you've upgraded to the for-credit version of this course, please make sure you review the additional for-credit materials in the Introductory module and anywhere else they may be found.

Note: This page is periodically updated. Course information on the Coursera platform supersedes the information on this page. Click听View on Coursera听button听above for the most up-to-date information.