|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/basic-sql-crud/
课程评论：没有评论
课程名称：基础SQL CRUD 课程概述：商业工具不断变化和发展。很久以前，纸和铅笔取代了死记硬背，而最近又被计算机所取代。分析师曾经依赖计算器进行计算，后来转向电子表格应用程序，如Excel。理解SQL曾经是IT人员的专属技能，但如今，SQL正逐渐成为现代工作场所中不可或缺的分析工具。就像电子表格曾经是专业人士的工具，而现在在工作场合普遍使用一样，SQL也开始在各类组织中变得更加普遍。 本课程超越了SQL中的SELECT语句，介绍了创建和删除数据库对象的基本构造，如何导入和导出数据，向数据表中插入和删除数据，以及更新数据。许多企业要求额外的数据库权限，以便让某人执行这些操作。随着越来越多的分析团队开始在数据库中工作，越来越多的商业人士获得了这些权限。 我在工作中学习了SQL的一切，您也可以做到。在教授课程超过10年后，我在我的第一份公司工作中进入了IT部门，从那时起，我在每一个角色中都使用SQL。我了解第一次学习一个关键字的感觉，开始探索其用途，被他人展示使用技巧和技术的经历，最终深入理解其工作原理。我在不同大小的公司，甚至一些财富50强的公司中培训了许多其他人使用SQL。我汇总了自己的经验，并从那些课上提炼出我认为的重要初步步骤，以超越简单的选择，与你分享。我相信你会利用这些知识，并在有机会时与他人分享。 如果您还没有查看Udemy上的基础SQL SELECT课程，请先过目，以确保您熟悉那里的内容。理解SELECT语句和数据库系统中的各种用户界面将使本课程更易于理解。当您准备就绪时，请点击第一讲，这是开始学习本课程的起点。
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 moves beyond the SELECT statement in SQL to basic constructions of creating and dropping database objects, importing into and exporting from the database, inserting into and deleting from the data tables, and updating the data. Many corporations require additional permissions in the database to allow someone to perform these operations, and as more and more analytics teams start working in databases, more businesspeople are being given these permissions.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 beyond simply selecting to share with you. I trust you will take this knowledge, and Spirit willing, share it with others.If you have not yet reviewed Basic SQL SELECT in Udemy, look over that course first to make sure you are familiar with the material there. Understanding the SELECT statement and the various user interfaces in database systems will make this course that much easier to understand. When you are ready, please click on the first lecture in section 1, the starting point to work your way through this course.
