|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learnsql/
课程评论：没有评论
**课程名称：** 6天学会SQL **课程概述：** 本课程旨在提供SQL基础知识，涵盖数据库、表的基本概念，以及如何使用SQL语句进行数据管理，包括添加、编辑和删除数据。课程详细讲解了数据检索的概念，包括排序、过滤、多表连接、子查询以及在检索语句中使用函数。 **课程主要内容：** * 数据库基础 * 数据库模式（Schema） * 数据库和表管理 * 数据填充 * 数据检索 * SQL函数 * 创建小计 * 子查询 * 附加练习（关于简单SELECT语句） **学习建议：** 本课程预计总时长为4.5小时，但建议学习者将其分配到6天内完成，以确保对概念有更深入的理解。 **教学方法：** 课程结构清晰，每部分都先讲解概念，然后通过具体示例演示如何编写SQL语句解决问题，帮助学习者更好地掌握知识。所有示例均基于课程“数据库模式”部分介绍的模式。 **课程目标：** 通过本课程的学习，学习者将能够自信地使用SQL进行数据操作。 **附加练习：** 课程最后包含关于简单SELECT语句的附加练习，旨在巩固和加深对简单SELECT语句的理解，共约10个练习。
"Learn SQL in 6 days" Video Course provides a basic understanding of databases, tables, as well as how to manipulate data with functions like add, edit or delete data from tables and databases. Data retrieval concepts, which includes sorting, filtering, multi-table join, sub-queries and using functions in retrieval statements are discussed in detail.This course covers the following topics:· Database Basics· Schema· Managing Database and Tables· Populating Data· Retrieving Data· Functions· Creating Sub-totals· Sub-queries· Bonus exercises (on Simple Select)This course requires approximately 4.5 hours to complete. But we would recommend you to split it into 6 days to have a complete understanding of the concepts.Each section is well structured and is designed in such a way that the concept is explained first, then I have taken example and explained how to write the SQL for the problem statement. This might help you to understand the concepts better. To make it easier for the learner, all the examples are based on the schema explained in the Schema section.This course is structured in such a way that one can start writing SQL in hours with confidence.The bonus exercises section is an add-on, where I made some simple and lighter exercises to give some more input on Simple Select statements. The bonus section has around 10 exercises only on simple select statement.
