|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-sql-course-2021-learn-by-doing/
课程评论：没有评论
课程名称：2025年完整SQL课程 - 通过实践学习 - SQL Server 课程概述： 本课程旨在教授如何编写有效且准确的SQL代码。您将学习如何在关系数据库（SQL Server）中阅读和编写复杂的SQL查询。这些技能在其他主要数据库系统（如MySQL、PostgreSQL、Oracle数据库等）中也同样适用。了解SQL是实现职业目标的快速途径之一，因为SQL始终是科技行业中需求量最大的技能之一。 本课程特别强调准确性和理解力，旨在帮助您避免写SQL时常见的错误。您将通过逐步查看查询的工作原理，获得SQL语言的可视化指导。课程涵盖了掌握SQL语言所需的所有核心技能。 为了让您更好地学习SQL，本课程包含80多个编码挑战，您将在这些挑战中编写SQL查询和创建数据库对象。这些挑战基于现实世界的场景，旨在最大程度上提高理解力。 在本课程中，您将学习以下内容： - 使用SQL Server和SSMS（世界上最流行的SQL工具之一）开始SQL学习 - 如何在Windows和Mac-OS计算机上安装SQL Server（请注意，Mac用户需要使用Azure Data Studio而非SSMS） - 使用SQL进行数据分析和数据分析，包括高级查询技巧 - 理解关系模型和SQL语言的基础知识 - 使用GROUP BY命令进行数据分析 - 使用字符串和日期函数编写高级查询 - 使用逻辑运算符为SQL查询添加逻辑流 - 编写自包含和关联子查询 - 使用不同类型的JOIN命令连接数据 - 进行更高级的连接，例如连接多个表和多列连接 - 创建表和完整性约束 - 更新、插入和删除数据 - 创建索引 - 使查询更快的技巧（如SARGable） - 编写高级SQL，如存储过程、窗口函数和公共表表达式 - 数据库设计的额外部分，包括数据规范化，直至博伊斯-科德范式（Boyce-Codd Normal Form）及更多内容 本课程让您控制学习过程，鼓励您在整个学习过程中编写SQL代码，而不是观看他人编码。每个章节都有新的挑战，模拟真实世界的任务和情境。这个全面的课程允许您通过互动环境以自己的节奏学习，从基础知识开始，迅速掌握高级SQL查询编写技能。
Learn how to write effective and accurate SQL with this course!You will learn how to read and write complex SQL queries in a relational database (SQL Server). The skills you will learn are also largely applicable to any other major database system, such as MySQL, PostgreSQL, Oracle Database, and much more.Knowing how to write SQL is one of the fastest ways to reach your career goals. This is because SQL is consistently the most in-demand skills in the tech sector. SQL can seem simple at first but it can quickly become complicated. It is common for people to a write SQL query without realizing they are getting an incorrect result returned. This course is designed with a focus on accuracy and understanding. You will learn how to avoid the common mistakes people make when writing SQL. Not only that.. but you will get a visual guide to the SQL language by seeing how queries work step-by-step. This is a complete course which covers all the core skills you need to master the SQL language. I believe that the best way to learn SQL is by writing lots of SQL. For that reason, this course includes over 80 coding challenges where you get to write SQL queries and create database objects. These challenges are based on real-world scenarios and are designed for optimal understanding.In this course you will learn everything you need to master SQL! Including:Get started with SQL Server and SSMS, two of the world's most popular SQL toolsHow to install SQL Server on Windows and Mac-OS computersNote: that Mac users will need to use Azure Data Studio rather than SSMSLearn how to do data analysis and data analytics using SQL. Including advanced query techniquesStart by learning the fundamentals of the relational model and SQL languageAnalyzing data using aggregate functions with the GROUP BY commandWriting advanced queries with string and date functionsLearn to use logical operators to add logic flow to your SQL queriesLearn how to write both self-contained and correlated sub queriesLearn how to join data by using the different types of JOIN commandsLearn how to do more advanced joins such as joining more than two tables and joining on multiple columnsLearn to create tables and integrity constraintsHow to update, insert and delete dataHow to create indexesHow to make your queries run faster by making them SARGableLearn to write advanced SQL such as stored procedures, window functions, and common table expressionsBonus section on Database Design - includes data normalization up to and including Boyce-Codd Normal Form.and much, much more!This course is one that puts you in control. Where you get to write SQL throughout the course, instead of watching someone else code. Every section comes with fresh challenges, modeled after real-world tasks and situations.This comprehensive course allows you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself writing advanced SQL queries.
