DTSA 5734 The Structured Query Language (SQL)

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

  • Specialization: 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.