|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-postgresql-pgadmin-sql-and-jdbc-crud-application/
课程评论：没有评论
课程总结：PostgreSQL、PGadmin、SQL教程及迷你项目！ 本课程将介绍PostgreSQL——一种业界广泛使用的开源关系数据库，具备高度的标准合规性（ACID合规），并能在大量并发用户环境下保持优秀的可靠性、稳定性和性能。PostgreSQL与现代网页框架如Django（Python）、node.js（JavaScript）、Hibernate（Java）、Ruby on Rails、PHP等兼容良好，具备出色的可扩展性和数据复制能力，适用于企业级应用。 本课程的设计初衷是针对完全没有数据库基础的学员，从最基础的“什么是数据库？”入手，逐步深入到更高级的概念。您将学习到SQL（PostgreSQL特定），PGadmin（数据库管理员的管理工具）、JDBC（用于应用程序与数据库交互的连接代码），并通过创建CRUD应用程序来整合所有组件，遵循MVC设计模式。 课程还将涵盖多个主题，包括DBMS组件及架构、关系数据库术语、SQL基本操作、数据查询、事务管理、数据库视图、存储过程、触发器以及PgAdmin的使用。讲师拥有超过11年的企业Java应用开发经验，并拥有6年的在线/离线教学经验，能够为学员填补与数据库相关的知识空白。 课程反馈也十分积极，学员们称赞课程组织良好、内容清晰，尤其是包含的迷你项目，帮助加深了对所学知识的理解。 本课程是学习PostgreSQL的理想之选，无论您是数据库新手还是有意提升技术水平的开发者，都能在这里找到合适的学习内容。期待您的加入！
PostgreSQL is the most advanced and the most popular Open Source Relational Database used in the industry for enterprise applications. Postgresql is known for it's standard compliance (ACID compliant), and ensures great reliability, robustness, and performance, even with large set of concurrent users.PostgreSQL works fine with all modern web frameworks including but not limited to,: Django (Python), node.js (JavaScript), Hibernate (Java), Ruby on rails, PHP, and many more. Due to PostgreSQL's robustness and replication capabilities, websites can easily be scaled out to as many database servers as you need.It has wonderful analytical capabilities and offers a powerful SQL engine, which makes processing large amounts of data in efficient manner.Why PostgreSQL?Posrgresql offer,Better standard compliance to ACID propertiesBetter performance for read and write operations (Crucial for performing Data Analysis and Data Warehousing)Better performance in handling complex queriesBetter security with builtin SSL Support and communication is encryptedGreat support for cloud infrastructures like AWS, Microsoft Azure, etcSupports NoSQL FeaturesSupports a wide range of programming languages (C, C++, Java, Python, Java Script, R, Perl, Ruby, etc..)Offers rich set of features for administrationZero downtime upgradesWhy this course?This course will start with an assumption that you don't know anything about Database. We will start, right form the very basic question, "What is Database?" to more and more advanced concepts (refer course content below). In short, if you want to learn PostgreSQL and you don't even have knowledge on RDBMS, then you are in the right place! You will love this course.Here are some organic reviews I received from students who took this course,"This is another excellent course in the database with this tutor. I am now some part of the course and it is very engaging.""This course is well organized and clear explanation. No unnecessary junk, just the right content!""I recommend this course to anyone who want to get started with postgresql. The instructor is knowledgeable and knows his stuff well. The mini project in the end is useful"Apart from PostgreSQL, You will learn about 'PGadmin' which is administrative tool for Database Administrators. You will learn 'SQL' (Postgresql specific) which is a language to communicate with the Database. You will learn about 'JDBC' with is essentially a glue code, that will enable your application to interact with the Database.We are also going to create a CRUD Application by combining all the components. We will follow the MVC design pattern to do so.I have over 11 Years of corporate experience in creating enterprise Java applications and been teaching online/offline for over 6 years. I've contributed to many ambitious projects in the industry. Although, I did not work as a Database Administrator specifically, I have used PostgreSQL as the Database solution for the projects I worked on. I have great exposure to the entire stack of Java technologies and in this course, I will fill the gaps related to the Database and specifically PostgreSQL.High Level Course ContentIntroduction to the courseComponents of DBMS and its architectureRDBMS terminologiesStructured Query Language with PostgreSQLBasic OperationsSQL ConstraintsWorking with RelationsFetching DataSQL JoinsQueries and Result SetsSub QueriesDBMS through PostgreSQL and PgAdminPostgreSQL Users and RolesDatabase ViewsTransactionsPgAdmin Stored ProceduresTriggersSchema ObjectsDDL, DML, DCL, TCL, and Postgres CommandsPgAdmin ComponentsDesigning a database and good practices!MVC Architecture and Mini ProjectI hope to see you there!
