|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-masterclass-for-data-analysis/
课程评论：没有评论
**Coursera SQL Masterclass 课程内容总结** 本课程是关于SQL（Structured Query Language）的在线入门到进阶课程。SQL是一种用于管理关系型数据库管理系统（RDBMS）中数据的语言，是数据科学家和数据分析师必备的技能，它对于数据库的创建、删除、数据检索和修改至关重要。 **课程主要内容包括：** * **SQL基础：** 数据库和表的创建，基础SQL查询的构建。 * **SQL函数与操作：** 数字函数、字符串函数、HAVING子句、LIKE操作符过滤。 * **SQL命令与数据类型：** DDL（数据定义语言）与DML（数据操纵语言）命令，各种数据类型。 * **约束与键：** 主键（primary key）和外键（foreign key）的学习，以及各种约束条件。 * **SQL连接（Joins）：** 学习LEFT JOIN、RIGHT JOIN、INNER JOIN、COMPOUND JOIN和MULTIPLE JOIN。 * **高级SQL：** 子查询（subqueries）的使用。 * **实战应用：** 学习如何连接Python与MySQL。 * **经验分享：** 学习通常需要多年SQL经验才能掌握的技巧和知识。 **课程特色：** * 提供大量来自知名编程平台HackerRank的练习题，供学员实践。 * 包含测验（quizzes）以巩固学习。 * 提供课程中使用到的所有资源。 * 提供快速的讲师支持，解答学员疑问。 * 学完本课程后，学员将能成为SQL专家。 本课程旨在帮助学员从零开始，掌握SQL的各项技能，并能灵活运用于实际数据分析工作。
Welcome to the best online course on SQL.SQL stands for Structured Query Language.It is designed for managing data in a relational database management system (RDBMS). SQL is a database language, it is used for database creation, deletion, fetching rows, and modifying rows, etc.SQL is needed for Data Scientists to get data and to work with that data.Without databases, data science is meaningless.A Data Analyst can use SQL to access, read, manipulate and analyze the data stored in a database and generate useful insights to drive an informed decision making process.This course is best for you to learn SQL.It covers basic to advanced level SQL concepts.In this course, you will cover:-Learn about creating databases and tables in SQLLearn about building basic SQL queriesLearn about Numerical, string functions in SQLLearn about HAVING clauseLearn about filtering using LIKE operator in SQLLearn about different DDL and DML commandsLearn about the different datatypes in SQLLear about ConstraintsLearn about primary key and foreign keyLearn about the different Joins in SQL- LEFT, RIGHT, INNER, COMPOUND, MULTIPLE.Learn about subqueries in SQLLearn connecting Python and MySQLGet tips and knowledge that is usually only learned through years of SQL experience.And much more...Not only this, you will get to practice lots and lots of exercises from the world famous coding platform "HackerRank".After finishing this course, you will become an expert in SQL.We are also providing quizzes.You will also have access to all the resources used in this course.Instructor Support - Quick Instructor Support for any queries.Enroll now and make the best use of this course.
