|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-developers-mysql-java-go-postgresql/
课程评论：没有评论
课程名称：掌握SQL（使用MySQL、Java和Go） 课程概述：学习SQL（结构化查询语言）是您职业生涯中最重要的决定之一。这种数据库语言在求职市场中备受追捧，是管理关系数据库管理系统（RDBMS）中数据的主要语言。SQL可与任何编程语言轻松连接，是数据分析的自然语言，贯穿每一个决策过程。作为一门高效的语言，它可以执行数据CRUD（创建、读取、更新、删除）操作，适用于数据科学家、数据分析师、前端和后端开发人员、业务与系统分析师，以及任何希望分析数据的人。 在本实用课程中，您将学习到： - CRUD操作的基础 - 复杂查询的创建，包括跨多个表的查询 - 数据分析与相应报告的生成 - 复杂连接的写作（内连接、外连接、全连接） - 使用聚合函数的汇总查询 - 子查询的编写 - 使用字符串、数值和日期时间函数 - 数据分析，相关数据的分组、表之间的关系建立（1-1，1-m，m-m），以及应用引用完整性 - 创建视图、触发器、存储过程、游标和存储函数 课程还包括四个综合作业：从头开始创建四个示例数据库，并为每个作业编写高级查询。作业内容涵盖了视图、触发器、存储过程、游标和存储函数的互动。同时，您还将学习如何将MySQL和PostgreSQL连接到Java和Go（Google Golang）。 这门课程将帮助您全面掌握SQL，提升您的数据处理和分析技能，为您的职业发展奠定坚实的基础。
Learning SQL (Structured Query Language), as the most commonly used database language, can be one of the greatest career decisions you make. SQL is one of the most sought-after skills by hiring employers.SQL that is the primary language responsible for managing data within a relational database management system (RDBMS) can be easily connected to any programming language.SQL is a natural language for data analysis that is the center of every decision making process.SQL is a productive language for writing queries and for performing CRUD (Create, Read, Update, Delete) operations on data.SQL can be used by data scientists, data analysts, front- and back-end developers, business and systems analysts and in short anyone who's willing to analyze data.In this practical course, you will:Learn CRUD (Create, Read, Update, Delete) operationsCreate complex queries across multiple tablesAnalyze data and create reports accordinglyWrite complex joins (inner, outer, full)Write summary queries using aggregate functionsWrite sub-queriesUtilize String/Numeric/Datetime functionsAnalyze data, group the related data into separate entities (tables), establish relationships (1-1, 1-m, m-m) between tables, and apply referential integrity on tablesWrite views, triggers, stored procedures, cursors, and stored functionsFour Comprehensive Assignments: Create four sample databases from scratch, as well as to write advanced queries for each assignmentAssignments: Learn how views, triggers, stored procedures, cursors, and stored functions can interactConnect MySQL and PostgreSQL to JavaConnect MySQL and PostgreSQL to Go (Google Golang)
