Advanced SQL Retrieval Queries in SQLiteStudio
About this course
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.
56/100
CourseAsk score
- What the provider tells you
- 32/45
- Who stands behind it
- 8/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- write advanced SQL queries
- use SQL functions and grouping
- implement subqueries
- create calculated fields
- apply conditional expressions
- experiment with table joins
Price shown by Coursera — confirm on their site.
Enroll on CourseraYou'll be redirected to Coursera to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
More courses like this
edX
Coursera
International Open Academy
Compared on these lists
Where this course ranks against the alternatives.