Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera Project Network

Advanced SQL Retrieval Queries in SQLiteStudio

Coursera Project Network via Coursera

Overview

In this course you will learn to write advanced SQL (Structured Query Language) retrieval queries using SQLiteStudio. Retrieving data from a relational database is one of the primary methods used by application and web developers to display data and populate web pages. Since a database can be made up of a complex combination of relational tables, retrieving that data can be challenging. You can meet those challenges by gaining experience with some of the more advanced SQL coding techniques. Through hands-on practice you will write SQL code to use functions and grouping, sub queries, calculated fields, and conditional expressions. In addition, you will experiment with alternative methods of joining tables for data retrieval. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Syllabus

  • Advanced SQL Retrieval Queries in SQLiteStudio
    • In this course you will learn to write advanced SQL (Structured Query Language) retrieval queries using SQLiteStudio. Retrieving data from a relational database is one of the primary methods used by application and web developers to display data and populate web pages. Since a database can be made up of a complex combination of relational tables, retrieving that data can be challenging. You can meet those challenges by gaining experience with some of the more advanced SQL coding techniques. Through hands-on practice you will write SQL code to use functions and grouping, subqueries, calculated fields, and conditional expressions. In addition, you will experiment with alternative methods of joining tables for data retrieval.

Taught by

Judy Richardson and Melissa Al-Shaer

Reviews

4.5 rating at Coursera based on 95 ratings

Start your review of Advanced SQL Retrieval Queries in SQLiteStudio

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.