|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-beginners-learn-to-communicate-with-databases/
课程评论：没有评论
课程名称：初学者SQL：学习与数据库的沟通 课程概述：在数据驱动的世界里，学习SQL的价值日益凸显。SQL是一门用于与数据库中数据进行交互的语言，几乎所有日常应用程序（如社交媒体、医院和银行等）都依赖于存储在数据库中的数据。因此，掌握SQL基本技能不仅对数据科学家有帮助，也对各行各业的从业者非常重要。 本课程为初学者设计，重点在于通过与MySQL数据库的互动来学习SQL的基础知识。你将学习从创建新表到在多个表中组织和汇总数据的基本技能，并能立即应用所学知识。 课程内容包括： - 创建数据库和表 - 从数据库表中检索数据 - 更新表中的数据 - 删除数据库表中的数据 - 过滤从数据库表中返回的数据 - 对返回的数据进行排序 - 使用各种运算符检索数据 - 合并来自多个表的数据 - 使用聚合函数处理数据 - 使用子查询 技能收获：完成本课程后，学员将掌握通过SQL与关系型数据库进行沟通的基本能力。
Why Learn SQL?We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.Almost all applications you interact with on a daily basis involves data which are stored in databases. Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.SQL is the language used to interact with the data inside these databases. SQL skills are always in demand due to the ever increasing use and reliance of data.In this beginners course, you will learn the building blocks of SQL by interacting with a MySQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL - and you'll be prepared to apply them right away.Topics include:Creating database and tablesRetrieving data from database tableUpdating data inside a tableDeleting data inside a database tableFiltering data returned from a database tableSorting data returned from a database tableRetrieving data using various operatorsCombining data from multiple tablesUsing aggregate functions to manipulate data.Using subqueriesTake-Away Skills:In this course, you'll learn how to communicate with relational databases through SQL.
