|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-programming-for-beginners/
课程评论：没有评论
课程名称：初学者的SQL编程 课程概述：在当今数据驱动的世界中，许多信息都存储在数据库中。为了获取这些数据库中存储的信息和见解，我们需要一种询问数据的方法。SQL（结构化查询语言）是用于查询和修改数据库中数据的通用语言。无论是在移动设备中的小型SQLite数据库，还是为博客和应用程序提供数据的MySQL服务器，甚至是为数十亿公司运行的企业级Oracle和Microsoft SQL Server数据库，SQL都扮演着重要的角色。本课程的目标是让您熟悉SQL语言的基础知识，并使用MySQL进行实践。我们将探讨如何从多个数据库表中获取信息，并介绍SQL的更多功能与特性。接下来，我们将了解如何在数据库中已存在的表中添加和修改数据。本课程将帮助您为编程或数据报告应用中的SQL工作做好准备，并为更深入的数据库管理、高级SQL及数据开发奠定基础。 课程内容包括：安装MySQL、SQL概述、使用SELECT查询数据、限制数据库响应、组织响应、从两个或更多表中请求数据、理解连接类型和数据类型、使用存储过程、删除重复记录、添加和修改表中的数据。
Our world is driven by data and a lot of that data is stored in databases. In order to unlock the information and insights stored in databases, we need a way of asking for data. One common language for asking about and modifying data in databases is SQL. SQL in some form or another is used in database products across the spectrum. From small SQLite databases in mobile devices to my MySQL servers, hosting data for blogs and other apps, to enterprise scale Oracle and Microsoft SQL server databases running multi-billion dollar corporations. The goal for this course is to get you comfortable working with the basics of the language, using MySQL. We'll look at how to get information from more than one database table, and I'll introduce some more features and functions of SQL.After that, we'll take a look at adding and modifying data in tables that already exist in a database. This course will help prepare you to work with SQL in programming or data reporting applications, and it will provide a foundation for deeper learning about database administration, advanced SQL, and developing with data.SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MongoDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a database server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. Topics include:Installing MySQLWhat is SQL?Requesting for data with SELECTLimiting database responsesOrganizing responsesRequesting for data from two or more tablesUnderstanding join types and data typesUsing stored procedureRemoving duplicate recordsAdding and modifying data in a table
