Advanced SQL Retrieval Queries in SQLiteStudio

4.6
68 个评分
提供方
Coursera Project Network
2,584 人已注册
在此指导项目中,您将:

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

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心