coursera

Advanced SQL Retrieval Queries in SQLiteStudio


  • flag Coursera
  • student Intermediate
  • database eLearning
  • earth English
  • clock 55h

About

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.

Covered topics:

  • Database (DBMS)
  • Problem Solving
  • Data Analysis
  • Queries
  • SQL