|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/t-sql-for-data-analysts/
课程评论：没有评论
课程名称：数据分析师的T-SQL入门 课程概述：本课程旨在教授数据分析师所需的核心Transact SQL (T-SQL)技能和任务，包括如何连接数据库、定义数据提取、查询和格式化数据。作为一门速成课程，学生将在1小时内建立扎实的T-SQL基础知识。这门课程与其他T-SQL课程的不同之处在于，它专注于数据分析师所需的技能，避免了数据库管理员和设计师关注的用户权限定义、索引构建和数据库设计等任务。由于该课程专为希望发展数据分析师技能的学生量身定制，因此内容非常紧凑，在60分钟内，学生将理解30个核心T-SQL任务。课程及支持材料旨在让学生与讲师实时互动。课程包括6节讲座，假设学生没有使用Microsoft SQL Server或编写代码的先前知识或经验。课程提供的T-SQL代码适用于Microsoft SQL Server 2008至2016版本，也适用于所有版本的SQL Server。课程还讨论了如何获得Microsoft SQL Server的免费或低成本副本。
This course teaches students the core Transact SQL (T-SQL) skills and tasks that Data Analysts need to perform, such as how to connect to databases, define data extracts, query, & format data. This is a crash course, and in just over 1 hour, students will build a strong foundation knowledge of T-SQL. This course is different from most other T-SQL courses, in that it focuses on skills required by data analysts. It avoids other tasks such as defining user permissions, building indexing, and designing databases that database administrators and designers focus on. Because this course is tailored towards students wanting to develop data analyst skills, it is very compressed and in 60 minutes students will develop an understanding of 30 of the core T-SQL tasks data analysts perform. The course, and supporting material is designed to enable students to follow along in real-time with the instructor. The course consists of 6 lectures, and assumes no prior understanding or experience with Microsoft SQL Server or writing code. The T-SQL code provided with the course works with Microsoft SQL Server 2008 to 2016. It will also work with all editions of SQL Server. How to obtain either a free, or low cost copy of Microsoft SQL Server is discussed in the course.
