|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-challenges-learn-sql-by-solving-challenging-problems/
课程评论：没有评论
**课程名称：SQL挑战：通过解决难题学习SQL** **课程概述：** 本课程旨在通过解决120个从初级、中级到高级的不同难度的SQL问题，帮助学习者提升SQL技能。SQL是目前最流行的关系数据库管理系统（RDBMS）编程语言，广泛用于管理存储在RDBMS中的数据。本课程强调实践性，通过动手解决实际问题，能够显著提高学习者在日常工作中的SQL运用能力，对数据分析师、数据科学家、数据库管理员（DBA）以及后端开发人员都极具价值。 课程将使用Northwind和AdventureWorks2012数据库进行练习，并结合HackerRank上的SQL挑战。无论您是SQL初学者、中级学习者还是高级用户，本课程都将为您提供全面的提升。 **主要涵盖主题：** * SELECT, WHERE, GROUP BY, ORDER BY 子句 * 理解各种JOIN类型：FULL JOIN, LEFT JOIN, RIGHT JOIN, INNER JOIN * 使用CTE（Common Table Expression） * 在SQL中使用子查询（Subqueries） **学习目标：** 完成本课程后，您将： * 显著提升SQL编程能力。 * 更深入地理解SQL的核心概念，包括JOINs、聚合函数、WHERE子句、GROUP BY、ORDER BY、UNION、子查询表达式以及CTE等。
SQL is most popular RDBMS programming language. It is a domain specific language used in programming and designed for managing data stored in RDBMS. In this course you will solve 120 challenging SQL problems varying from beginner, intermediate to advanced levels. This course is very practical and hands-on, it will hone your SQL skills to the next level and also help you in your daily work. So whether you are a Data Analyst, Data Scientist, DBA or Backend Developer this course will be super beneficial for you. In this course we will be solving problems on the Northwind and AdventureWorks2012 database, and also along with that we will also solve some HackerRank SQL challenges.This course is meant for all levels, so whether you are a beginner, intermediate or advanced you can still take this course.The topics covered in this course are: - SELECT, WHERE, GROUP BY, ORDER BY- Understanding JOINS - FULL JOIN, LEFT JOIN, RIGHT JOIN, INNER JOIN- Using CTE (Common Table Expression)- Using Subqueries in SQLBy the end of this course you will have improved SQL skills and have a better understanding of SQL concepts like JOINS, aggregate functions, WHERE clause, GROUP BY, ORDER BY, UNION, Subquery expression, CTE (Common Table Expression) etc.
