|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-mysql-for-data-manipulation/
课程评论：没有评论
Coursera 课程：SQL - MySQL 数据处理 本课程教授使用 MySQL 来创建数据库项目，与现有数据库交互，以及进行数据处理和分析。您将学习基础和高级 SQL 查询，包括 SELECT（查询）、UPDATE（更新）、DELETE（删除）等常用操作和各种实用函数。 课程通过构建一个酒店预订系统作为示例，帮助您掌握如何在数据库中执行 CRUD（创建、读取、更新、删除）操作，以及使用通配符、子查询、连接多个表、处理日期等高级技巧。这些技能对于构建实际的大型应用程序至关重要。 **核心概念包括：** * SQL（结构化查询语言）及其语法 * JOINs（连接）的使用 * MySQL（流行数据库）的特性 * MySQL 逻辑运算符及其他函数 * 数据库设计与开发 * 数据分析 * CRUD 操作 * 子查询 * 多表数据查询 * 基于数据操作的查询 课程鼓励学员动手实践，掌握核心的 MySQL 数据处理技能。
In this course, you will be able to learn how to use MySQL to create any database project that you would like to. Also you will be able to interact with existing database, manipulate data, and use the most used queries either to display data (select) or to perform any kind of analysis. The course covers basics and advanced SQL queries such as select / display, update, delete, and so many useful functions. A hotel reservation system is created for the purpose of an example so that you can create your own project after you take this course.You will learn best MySQL queries such as: (CRUD (Create, Read, Update, Delete), wildcards, subqueries, connecting more tables together, working with dates, and many more operations for data manipulation in any database) that will help you creating big real-world applications.Key concepts:SQL (Structured Query Language - in-demand technology)SQL syntaxUnderstand SQL JoinsMySQL (one of the most popular and widely used databases)Use MySQL logical operators and other functionsDatabase Design & DevelopmentData AnalysisDifferencesOf course CRUDSubqueriesDisplaying data from many tablesDisplaying data that do not have to be on your table, but you perform operations to get them as resultTake your time, practice, and get ready for more. Avoid having too much information on too many technologies, they are all very nice and useful things to learn and build great apps.All the best with learning!In case you missed the big sale, please visit our website or our Instagram.
