|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/comprehensive-sql-course-hands-on-project-coding-exercises/
课程评论：没有评论
**课程名称：** 综合 SQL 课程，面向数据专业人士 [全新] **课程概述：** 本课程旨在帮助您掌握 SQL 这一数据专业人士必备的基础技能。SQL 是成为数据工程师、数据分析师、数据科学家、Web 开发人员、应用程序开发人员等职位的关键技能。如果您有志成为一名优秀的数据专业人士，本课程正是为您量身打造！ **课程方法：** 这是一门全面的实操课程，包含 120 多个 SQL 编码练习，以及一个真实世界的项目——为热门体育赛事创建一个数据库，并编写赛事网站所需的所有 SQL 语句。讲师拥有 25 年的行业 SQL 工作经验和在 Udemy 上教授 160,000 名学生的经验，精心设计了全方位的课程体系。课程中将指导您编写 SQL 语句的最佳实践，并结合实际案例。课程节奏快、直击重点，采用简洁易懂的英语，避免使用行话。课程从基础知识开始，逐步深入到复杂主题，最终使您精通 SQL。 **课程内容：** * **初级：** 数据库与 SQL 简介、SQL 语句基础、数据查询、数据过滤 * **中级：** 简单 SQL 函数、日期函数、条件表达式与函数、聚合函数、分组数据、SQL JOIN、SQL Constraints、主键与外键及关系 * **高级：** 数据库设计与实体关系图 (ERD)、子查询、公共表表达式 (CTEs)、视图、窗口/分析函数 * **项目：** 需求收集与数据库设计、为网站编写 SQL 查询 **ANSI SQL：** 本课程遵循 ANSI SQL 标准，完成课程后，您将能够使用 MySQL, PostgreSQL, SQLite, Oracle, SQL Server 等所有主流数据库，以及 Spark SQL, Hive SQL, Snowflake, Google BigQuery, Azure Synapse 等大数据和并行处理引擎。 **课程成果：** 完成所有 SQL 编码练习和项目后，您将能够自信地在真实世界的数据项目中使用 SQL。 **学生反馈：** 多位学生表示课程内容全面，从基础到高级循序渐进，实操练习是巩固知识的最佳方式，易于理解。讲师善于讲解概念及其应用场景，对实际工作项目非常有帮助。
Welcome! I am looking forward to helping you to become proficient in SQL, one of the fundamental skills required to become a data professional. SQL is one of the important skill required to become data engineer, data analyst, data scientist, web developer, application developer etc. So, if you aspire to be a competent data professional, this is course is for you! Course Approach:This is a comprehensive hands-on course with 120+ SQL coding exercises and a Real World Project of building a database for one of the popular sporting tournaments, and writing all the SQL statements required for the tournament website. I have combined my experience working with SQL in the industry for 25 years with teaching on Udemy for 160,000 students to create this comprehensive curriculum. Throughout the course, I provide guidance on using best practices for writing SQL statements and also take you through real world examples. I value your time as much as I do mine. So, I have designed this SQL course to be fast-paced and to the point. Also, the course has been taught with simple English and no jargons. I start the course from basics and progress to complex topics, and by the end of the course you will be proficient in SQL. Comprehensive Curriculum:Beginner Level Topic:Introduction to Databases and SQLBasics of SQL statementsQuerying DataFiltering DataIntermediate Level Topic:Simple SQL functionsDate FunctionsConditional Expressions & FunctionsAggregate FunctionsGrouping DataSQL JoinsSQL ConstraintsPrimary & Foreign Keys and RelationshipsAdvanced Level Topic:Database Design & Entity Relationship DiagramsSubqueriesCommon Table Expressions (CTEs)ViewsWindow/ Analytical FunctionsProject:Requirements gathering & Database DesignWriting SQL Queries for a WebsiteANSI SQL:This course follows the ANSI standard for SQL. So, once you complete the course, you will be able to with with SQL on all major databases such as MySQL, PostgreSQL, SQLite, Oracle, SQL Server etc, and also with any big data and parallel processing engines such as Spark SQL, Hive SQL, Snowflake, Google BigQuery, Azure Synapse etc. Course Outcome:Once you have completed the course including all the SQL coding exercises and the project, I genuinely believe that you will be in a position to start working in a real world data project using SQL.Student Feedback:Here are some of the reviews from existing students which may help you make the decision, but also please feel free to go through the reviews from others at the bottom of this page! Ayantika N [5*] - This is my first-hand experience with SQL. I thoroughly enjoyed the course, especially being a student with no background in computer language. I found the course well-thought out and beneficial for me. The hands-on examples are really well explained. I look forward to coming back to your courses in future as well. Kudos to you!!:)Mayank S [5*] - A very comprehensive course which starts with the basics then slowly moves on to intermediate and advanced concepts. The best part is the practice exercises to solidify one's understanding. Easy to follow along.Ritesh T [5*] - I have purchased all his courses. The best part of him is that, he explains the concepts + the use cases where it would be used. Just like his databricks, azure df, azure synapse courses, the theories are there as well as the scenarios where such concepts could / would / should be used. There are times when a student like me who is working on live projects could use a particular concept, and bingo, his lectures come life saving.
