|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-sql-using-postgresql/
课程评论：没有评论
课程名称：掌握 PostgreSQL 的 SQL 课程概述： PostgreSQL 是领先的开源数据库之一，广泛用于网络应用、移动应用和数据记录应用。尽管它是关系数据库，最适合事务性系统（OLTP），但其变种如 Redshift 也被广泛用于分析或决策支持系统。 课程详情： 本课程主要设计用于教授使用 PostgreSQL 数据库的基础和高级 SQL。学习内容包括： - 使用 Docker 设置 PostgreSQL 数据库 - 通过 psql、SQL Workbench、Jupyter 与 SQL 魔法等不同接口连接 PostgreSQL - 理解数据加载工具 - 执行 CRUD 或 DML 操作 - 编写基本 SQL 查询（过滤、连接、聚合、排序等） - 创建表、约束和索引 - 在创建表时使用不同的分区策略 - 使用 PostgreSQL 提供的预定义函数 - 使用分析函数编写高级 SQL 查询 目标观众： - 大学生和初级专业人士，提升 SQL 实践，准备面试 - 经验丰富的应用开发人员，理解数据库关键要点以提高生产力 - 数据工程师和数据仓库开发人员，了解 SQL 及其他关键概念的相关性 - 测试人员，提升查询编写能力，验证数据质量 - 业务分析师，撰写临时查询以更好理解数据或排查数据质量问题 - 任何希望提高查询编写和调优能力的 IT 专业人员 - 非计算机科学或 IT 背景的开发人员，提升其应用开发技能 课程目标： 本课程旨在帮助专业人士实现以下与 PostgreSQL 数据库相关的关键目标： - 解释数据模型 - 使用数据库 IDE 交互 - 数据加载策略 - 编写基本及高级 SQL 查询 - 创建表、分区表、索引等 - 根据需求有效使用约束 - 有效利用 PostgreSQL 提供的功能 - 使用高级特性（如分析函数）编写查询 - 比较 PostgreSQL 与 Redshift 理解 RDBMS 和数据仓库的区别 推荐培训方法： 课程为自学模式，提供参考材料、代码片段和视频。学习者可以使用现有的 PostgreSQL 数据库或通过 Docker 设置自己的环境（查看额外材料）。所有章节将从第一天起提供，建议每周完成 1 到 2 个章节。同时，建议完成每个模块末尾的练习，以确保能够达成所有关键目标。支持将通过 Udemy 平台提供，提问时请不要发送个人消息。
About PostgresqlPostgresql is one of the leading datatabase. It is an open source database and used for different types of applications.Web ApplicationsMobile ApplicationsData Logging ApplicationsEven though it is relational database and best suited for transactional systems (OLTP), it's flavors such as Redshift are extensively used for Analytical or Decision Support Systems.Course DetailsThis course is primarily designed to go through basic and advanced SQL using Postgres Database. You will be learning following aspects of SQL as well as Postgres Database.Setup Postgres Database using DockerConnect to Postgres using different interfaces such as psql, SQL Workbench, Jupyter with SQL magic etc.Understand utilities to load the dataPerforming CRUD or DML OperationsWriting basic SQL Queries such as filtering, joins, aggregations, sorting etcCreating tables, constraints and indexesDifferent partitioning strategies while creating tablesUsing pre-defined functions provided by PostgresqlWriting advanced SQL queries using analytic functionsDesired AudienceHere are the desired audience for this course.College students and entry level professionals to get hands on expertise with respect to SQL to be prepared for the interviews.Experienced application developers to understand key aspects of Databases to improve their productivity.Data Engineers and Data Warehouse Developers to understand the relevance of SQL and other key concepts.Testers to improve their query writing abilities to validate data in the tables as part of running their test cases.Business Analysts to write ad-hoc queries to understand data better or troubleshoot data quality issues.Any other hands on IT Professional who want to improve their query writing and tuning capabilities.Developers from non CS or IT background at times struggle in writing queries and this course will provide required database skills to take their overall application development skills to next level.Key ObjectivesThe course is designed for the professionals to achieve these key objectives related to databases using Postgresql.Ability to interpret data models.Using database IDEs to interact with databases.Data loading strategies to load data into database tables.Write basic as well as advanced SQL queries.Ability to create tables, partition tables, indexes etc.Understand and use constraints effectively based up on the requirements.Effective usage of functions provided by Postgresql.Ability to write queries using advanced features such as Analytic FunctionsDifferences between RDBMS and Data Warehouse concepts by comparing Postgresql with Redshift."This course is primarily designed to gain key database skills for application developers, data engineers, testers, business analysts etc."Recommended Training ApproachHere are the details related to the training approach.It is self paced with reference material, code snippets and videos.One can use existing Postgres Database or setup their own environment using Docker (look at bonus material).All sections will be available from Day 1. However, we recommend to set a target between 1 to 2 sections per week.It is highly recommended to take care of the exercises at the end to ensure that you are able to meet all the key objectives for each module.Support will be provided using Udemy Platform. Just send us the question and our team will respond. Please do not send personal messages in Udemy.
