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
What You'll Learn
- Use SQLiteStudio to analyze data and construct queries
- Apply SQL query techniques to solve complex problems
- Write complex SQL queries involving advanced functions
Prerequisites
- Basic familiarity with the software or workflow used in the project
- Ability to follow step-by-step instructions in English
Instructors
Judy Richardson
Subject Matter Expert