|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/25-practice-sql-questions-for-beginners/
课程评论：没有评论
课程名称：初学者的25个SQL练习题 课程概述：学习SQL可能会面临挑战。如果你和我一样，希望在一个能够通过实践学习的环境中学习，那么这门课就是为你准备的。研究表明，通过尝试、实践甚至失败来学习，可以显著提高知识的保留和理解。这门课程包括25个SQL练习题，其中大部分问题还包含多个部分，学生将获得多达80个练习题的机会。这为准备面试、复习SQL概念或想要学习SQL的个人提供了充足的实践机会。 本课程的教学水平为“初级”，但参加这门课程的学生需要对SQL有一定的了解，这并不是一门入门课程。学习方式是先尝试回答问题，如有需要可查看提示，然后观看视频解释。视频解释将展示如何回答每个问题，尽管每个问题有多个答案，讲师将展示他是如何回答的。 课程中使用的数据库管理系统为Microsoft SQL Server Management Studio (SSMS)，所有问题均基于Microsoft样本数据库Pubs进行回答。课程中使用的语法为T-SQL，该语法与MySQL、PostgreSQL、Oracle等的语法相似，但需要使用Microsoft SQL Server来加载Pubs数据库。 课程中使用的命令包括：Select, From, Select Top, Where, Order by, Group by, Count, Inner Join, Distinct, Having, Sum, Avg, Min, Max, Create Table, Drop Table, Insert Into, And/Or, In/Not In, Between/Not Between, Like/Not Like, Case When, Concatenation, Format, Isnull, Alter Table, Update, DateName, Delete Row, Drop Column, Left/Right, Left Join, Inner Query (Subquery), Self Join等。
Learning SQL can be a challenge. And if you're like me then you want to learn in an environment that allows you to learn by doing. In fact, I believe this is the best way to learn. Many academic studies have shown that retention and learning is significantly increased by attempting, trying, and even failing. The structure of this course challenges you while giving you the support you need to learn.This course literally includes 25 Practice SQL Questions! In fact, majority of questions include multiple parts. Including those multiple parts students get access to 80 practice questions. This gives individuals ample opportunity to learn. Whether you're preparing for an interviewing, refreshing on SQL concepts, or just wanting to learn this course will help you.The instructional level is listed as "Beginner Level." However, those taking this course do need to have some understanding of SQL. This course is not an introductory course. You will learn by attempting the question, using a hint if needed, then watching the video explanation. Video explanations are provided to show students how to answer the question; however, each question has multiple answers. The instructor simply shows students how he would answer the question.Microsoft SQL Server Management Studio (SSMS) will be the database management system used in the course. All the questions in the course are answered using the Microsoft Sample database, Pubs. The syntax used in SSMS is T-SQL. T-SQL is similar to syntax used in MySQL, PostgreSQL, Oracle, Snowflake, MariaDB, etc., however, Microsoft SQL Server will be needed to load the Pubs database.List of commands used in course questions:Select, From, Select Top, Where, Order by, Group by, Count, Inner Join, Distinct, Having, Sum, Avg, Min, Max, Create Table, Drop Table, Insert Into, And/Or, In/Not In, Between/Not Between, Like/Not Like, Case When, Concatenation, Format, Isnull, Alter Table, Update, DateName, Delete Row, Drop Column, Left/Right, Left Join, Inner Query (Subquery), Self Join
