|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/basic-sql-select/
课程评论：没有评论
课程名称：基础SQL SELECT 课程概述：商业工具不断变化与发展。早期，纸笔替代了死记硬背，随后计算机的出现更是引领了一场变革。分析师们曾依赖计算器进行计算，后来转向电子表格应用程序，如Excel。以往，掌握SQL被认为是IT人员的专业技能，而如今，SQL正逐渐成为现代工作环境中不可或缺的分析工具。就如电子表格曾是专家使用的工具，但如今却在工作中无处不在，SQL也开始在组织中变得更加普及。 本课程重点讲解SQL中的SELECT语句，专注于数据查询语言（DQL）命令。尽管听起来这一定义比较局限，理解SELECT语句对其他许多命令至关重要，因为通常在进行其他操作之前，首先需要选择数据。此外，许多标准及复杂的命令和函数都可以通过SELECT语句轻松展示，掌握这套基础知识将为进一步深入探索SQL打下良好的基础。 我所了解的SQL知识均是在工作中获得的，你也可以做到。在我的教学生涯中，我曾被引入IT领域并在每个岗位上都使用SQL。我知道第一次学习一个关键词的感受，了解其用途的过程，以及在他人指导下掌握技巧的经历，最终深入理解其工作原理。我曾在大大小小的公司，包括一些《财富》前50强企业中培训多人SQL。我整理了自己的经验，并从中提炼出重要的初步步骤与大家分享。（与我过去培训过的学员可能会对这些课程内容有所熟悉！）我相信你们能够领会这些知识，愿意的话也会与他人分享。 那么，不再啰嗦，课程正式开始。请点击第一讲，开始你的学习之旅。
The tools of business continue to change and grow. Long ago, paper and pencil replaced rote memory and more recently were themselves replaced by computers. Analysts used to work out calculations on calculators, then switched to spreadsheet applications, like Excel. Understanding SQL used to be a skill reserved for IT personnel; now, SQL is becoming an indispensable analytical tool in the modern workplace. Just like spreadsheets were once a tool known only to specialists but are now ubiquitous in the workplace, likewise SQL is beginning to become more accessible throughout organizations.This course focuses on the SELECT statement in SQL so stays squarely in the realm of Data Query Language (DQL) commands. Although this focus may sound limiting, understanding the SELECT statement is essential for many of the other commands, since typically the data will need to be selected first before doing something else with it. As well, many of the standard and exotic commands and functions can be easily presented with a SELECT statement, and mastery of this beginning set will prepare people for further explorations into SQL.I learned everything I know about SQL on the job, and so can you. After teaching for 10 years, I was pulled into IT at my first corporate position and have used SQL in every role since then. I know what it is like to learn a keyword for the first time, to start exploring its uses, to be shown tricks and techniques using it by others, and to eventually gain a deeper understanding of why it works the way it does. I have trained many others in SQL in companies large and small, including some Fortune 50 companies. I have compiled my experiences and curated from those lessons what I believe to be the important initial steps to share with you. (Those of you from my past training sessions will likely recognize parts of these lessons!) I trust you will take this knowledge, and Spirit willing, share it with others.So, without further ado, let's begin. Please click on the first lecture in section 1, the starting point to work your way through this course.
