Advanced SQL Retrieval Queries in SQLiteStudio

4.6
68 個評分
提供方
Coursera Project Network
2,510 人已註冊
在此指導項目中,您將:

Use SQLiteStudio to analyze data, construct queries, and review results.

Apply SQL query-writing techniques to solve complex problems.

Write complex SQL queries.

Clock55 minutes
Intermediate中級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

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.

您要培養的技能

Database (DBMS)Problem SolvingData AnalysisQueriesSQL

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  1. Database Review

  2. Joining Similar Tables

  3. Functions and Grouping

  4. Grouping with WHERE and HAVING

  5. Subqueries

  6. Calculated Fields

  7. CASE Expressions

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心