|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-postgresql-for-beginners/
课程评论：没有评论
课程名称：学习PostgreSQL基础课程（适合初学者） 概述：欢迎参加《学习PostgreSQL基础课程》。本课程是一份实用指南，旨在帮助初学者掌握PostgreSQL及pgAdmin的基础知识。PostgreSQL是一种强大的开源对象关系数据库系统，经过30多年的活跃开发，因其可靠性、功能强大和性能而享有良好的声誉。学习PostgreSQL是提升职业发展的最佳途径之一，越来越多的知名企业将PostgreSQL作为其关系数据库。 本课程将从零基础开始，逐步提升，解答学员可能提出的各种问题，例如：什么是PostgreSQL？什么是关系数据库？什么是云数据库？课程内容包括如何在本地机器上逐步安装PostgreSQL，创建个人云数据库（使用市场上最受欢迎的云服务提供商之一——亚马逊网络服务（AWS）），并了解DBaaS和亚马逊关系数据库服务（RDS）等概念。 主要内容包括： - 如何安装PostgreSQL - 如何安装和使用pgAdmin - 使用PostgreSQL创建数据库 - 理解什么是模式及如何创建模式 - 使用SQL脚本创建表 - 使用pgAdmin创建表 - 掌握PostgreSQL中可用的不同数据类型 - 如何创建视图 - 理解DBaaS的含义 - 如何创建用户并根据特定权限授予访问数据库的权限 - 创建不同的约束条件 - 在PostgreSQL中创建主键 - 在PostgreSQL中创建外键 - 如何批量导入和导出数据库的数据 - 使用另一款强大的工具DbVisualizer生成实体关系图（ERD） 通过学习PostgreSQL，您将大幅提升简历竞争力！不要犹豫，快来注册吧！
Welcome to Learn The Basics of PostgreSQL course, The practical guide to learn the basics of PostgreSQL and pgAdmin.PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. Learning PostgreSQL is one of the best ways to boost your career! As it is getting popular each day and many giant companies are using PostgreSQL as a relational database. This course will start with you from zero level experience in PostgreSQL and relational databases, starting to level up as we are going through the course. explaining all the questions you maybe asking yourself such as What is a PostgreSQL? what is relational database? what is a cloud database?This course will guide you how to install PostgreSQL on a local machine step by step and even how to create your own cloud databases on the one of the most required cloud services providers in the market...Amazon Web Services (AWS).You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS) Some of the points we will be covering: How to install the PostgreSQL.How to install and use pgAdmin.Create databases with PostgreSQL.Understand what is schema and how to create a schema.How create tables using SQL script.How to create tables using pgAdmin.Use different datatypes available in PostgreSQL.How to create views.Understand what does DBaaS mean.You will learn how to create users to access your database based on specific permissions you gave them.How to create different constraints.Create primary keys in PostgreSQL.Create foreign keys in PostgreSQL. How to import a bulk of data in and out of your database.Generate Entity Relationship Diagram (ERD) using another powerful tool called DbVisualizer.Give your CV a huge boost by learning PostgreSQL...do not hesitate enrolling.
