|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-sql-course-with-mysql-database-learn-by-doing/
课程评论：没有评论
课程名称：全级别SQL训练营 - 学习MySQL - MySQL数据库 课程概述：本课程旨在帮助学员像专业人士一样准确且高效地撰写SQL。在这里，您将学习如何在关系数据库（MySQL）中阅读和编写复杂的SQL查询。这些技能同样适用于其他主要数据库系统，如PostgreSQL、Oracle Database和SQL Server等。掌握SQL是实现职业目标的最快途径之一，因为SQL在科技和商业领域的需求始终处于高位。能够高效处理和操纵数据的人才在未来的市场上将继续受到追捧。SQL让您在工作中更加独立，能够迅速获得想要的信息。虽然SQL看似简单，但实际上很容易变得复杂，很多人磕碰到的错误主要是因为在写SQL查询时未能察觉返回了错误结果。本课程重点关注准确性和理解力，帮助您避免常见的SQL撰写错误。同时，您还将通过可视化指导逐步了解SQL语言的工作原理。 本课程包含超过80个编程挑战，让您实践撰写SQL查询及创建数据库对象（如表和存储过程）。这些挑战基于真实场景，旨在帮助您深入理解SQL的各个方面。您将在课程中学习掌握SQL所需的所有内容，包括： - 入门MySQL数据库和MySQL工作台，全球最流行的SQL工具之一 - 使用SQL进行数据分析与数据分析，包括高级查询技术 - 学习关系模型和SQL语言的基本知识 - 使用GROUP BY命令分析数据的聚合函数 - 写出包含字符串和日期函数的高级查询 - 使用逻辑运算符为SQL查询添加逻辑流 - 撰写自包含和相关子查询 - 使用窗口函数进行跨分区行的计算 - 使用不同类型的JOIN命令连接数据 - 更复杂的连接，例如连接多个表及在多个列上连接 - 创建表和完整性约束 - 更新、插入和删除数据的相关知识 - 了解MySQL中的事务 - 编写高级SQL，包括存储过程、窗口函数和公共表表达式 - 理解和应用数据库设计，正确构造关系数据库中的数据，包括数据规范化到Boyce-Codd范式 本课程将让您在学习过程中控制主动权，您可以在整个课程中撰写SQL，而不是观看别人编码。通过根据真实任务和情境设计的新挑战来提升您的技能。 其他课程优势： - 课程中的SQL代码预先编写，这与需要观看他人输入代码的课程不同，从而节省您的时间。 - 以商业为中心的内容：教授SQL在商业智能和数据分析中的应用。 - 独特主题：涵盖难以在其他地方找到的主题，让您获得SQL专业人士所需的所有技能。
Learn how to write accurate and efficient SQL like a professional!In this course, you will learn how to both read and write complex SQL queries in a relational database (MySQL). The skills you will learn are also largely applicable to any other major database system, such as PostgreSQL, Oracle Database, SQL Server, 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 one of the most in-demand skill in the tech and business sectors. People who can work with data and manipulate it efficiently will be in high demand for many years to come. SQL allows you to be independent at work. It gives you the freedom to immediately get the answers to the questions you want to ask. 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 such as tables and stored procedures. 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 MySQL Database and MySQL workbench, two of the world's most popular SQL tools· Learn how to do data analysis and data analytics using SQL. Including advanced query techniques· Start by learning the fundamentals of the relational model and the SQL language· Analyzing data using aggregate functions with the GROUP BY command· Writing advanced queries with string and date functions· Learn to use logical operators to add logic flow to your SQL queries· Learn how to write both self-contained and correlated sub queries.· Learn how to do calculations across partitioned rows using window functions.· Learn how to join data by using the different types of JOIN commands· Learn how to do more advanced joins such as joining more than two tables and joining on multiple columns· Learn to create tables and integrity constraints· How to update, insert and delete data· Learn about transactions in MySQL· Learn to write advanced SQL such as stored procedures, window functions, and common table expressions· Understand and Apply Database Design - Learn how to structure your data correctly in a relational database. This section 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. Build your skill level with fresh challenges, modeled after real-world tasks and situations.Other Course Benefits:- The SQL code in the course is written beforehand. This is in contrast to code-along courses where a lot of time is spent watching someone else type code. In other words, this course values your time!- Business-centered content: I teach you how SQL is being used for business intelligence and data analytics. - Exclusive topics: This course covers topics that are difficult to find elsewhere. This allows you get to gain all the skills of a SQL professional.
