|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-with-mysql/
课程评论：没有评论
**Coursera 课程“SQL 入门：通过动手练习快速学习 SQL”内容总结** 本课程专为希望从零开始学习数据库和 SQL 的初学者设计。课程将循序渐进地教授 SQL 的基础知识和高级查询技巧，并通过大量的实践示例、测验和编码练习帮助学员掌握。 **核心学习内容：** * **数据库基础：** 理解核心数据库概念以及数据库的用途。 * **MySQL 设置与管理：** 学习如何在计算机上设置和配置 MySQL，以及如何创建和管理数据库。 * **SQL 基础操作：** 掌握使用 SQL 插入、编辑和删除数据的基本语法。 * **数据提取与查询：** * 学习编写简单查询以从数据库中提取数据。 * 掌握使用 JOINs、GROUP BY 和子查询编写复杂查询。 * **查询优化：** 了解如何优化 SQL 查询以提高性能。 * **实践应用：** 通过使用 MySQL（世界流行的数据库管理系统之一）进行实践，巩固所学知识。 **课程亮点：** * **零基础入门：** 无需任何先验知识，非常适合初学者。 * **实践驱动：** 提供清晰的、循序渐进的课程内容，并辅以大量实践示例。 * **技能提升：** 帮助学员掌握实用的 SQL 技能，可用于工作或自由职业项目。 * **丰富资源：** 提供终身访问课程材料，并包含可下载的资源。 * **成果认证：** 完成课程后可获得结业证书，以展示新获得的技能。 本课程是学习 SQL 的绝佳途径，通过动手实践和清晰的讲解，帮助任何背景的学习者快速掌握这一重要的技能。
Learn the fundamentals of databases and SQL, from scratch, step-by-step. In this hands-on course, you'll learn everything from the basics of SQL syntax to advanced query techniques. You'll do this with practical examples, quizzes, and coding exercises.Learn and Master SQL Fundamentals Quickly Using One of the World's Most Popular Database Management SystemsWhat you'll learn:Set up and configure MySQL on your computerUnderstand core database conceptsCreate and manage databasesWrite SQL to insert, edit and delete dataCreate simple queries to extract data from a databaseWrite complex queries using JOINs, GROUP BY, and subqueriesOptimise your queries for better performanceLearn SQL fundamentals from scratch using MySQLSQL is one of the most in-demand skills you could learn. In this hands-on course, you'll learn the basics of databases and SQL syntax, through to advanced query techniques. You'll do this quickly by learning with practical examples, and reinforcing them with quizzes and in-browser coding exercises. We'll do this using MySQL - one of the world's most popular and database systems.Starting from first principles, you'll learn what databases are and how they are used.Then you'll learn what SQL is, and how it's used to interact with relational databases like MySQL.At all stages practical examples are used, which you're encouraged to experiment with yourself.You'll learn how to create and manage databases, at all times using best practices for doing so.Then you'll learn the SQL to manage data inside databases - inserting new data and editing and deleting existing data.Following this you'll learn the basics of how to get data from a database, then more advanced queries, including best practices and how to optimise them.Why Take This Course?No prior experience required - perfect for beginnersClear, step-by-step lessons with practical examplesBuild real skills you can use at work or in freelance projectsLifetime access to course materialsHands-on content and downloadable resourcesCertificate of Completion to showcase your new skills
