|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-and-postgresql/
课程评论：没有评论
课程名称：SQL 和 PostgreSQL：完整开发者指南 课程概述： 你想了解数据库结构设计、查询调优和优化吗？这个课程将全面教学！无论是设计数据库、存储复杂数据，还是优化查询，你都将掌握一切在生产和可扩展数据库运作中所需的知识。无论是使用 Flutter 构建的移动应用、用 React 制作的网络应用，还是简单的 HTML 页面，所有应用都需要在数据库中存储信息。在众多数据库中，PostgreSQL 凭借其高度可扩展的性能和稳定性，已成为开发者的首选之一。本课程将教你使用 PostgreSQL 的所有必要知识，助你完成下一个重大项目。 针对初学者的课程开始于 SQL 的基础概述，通过大量练习，让你在真实的数据集上获得实践经验。你将学习如何使用强大的命令来存储、获取和更新信息。在掌握基本操作后，将深入了解数据库设计模式，提供多种高效的数据建模结构。 课程内容丰富，包含诸多实操练习和测验，确保你在学习过程中能够立即应用所学的各个主题和特性。此外，课程还将带你了解 PostgreSQL 的内部工作原理，学习其如何在硬盘上逐位存储信息，这对优化查询性能至关重要。 课程涵盖的一些主题包括： - 应用强大的 SQL 命令存储、更新和检索信息 - 使用外键建立表之间的记录关系 - 理解 PostgreSQL 的多种数据类型及其使用场景 - 利用聚合管道生成商业数据报告 - 处理数百万条记录，模拟真实的生产查询 - 使用集合和排序操作提升查询逻辑技巧 - 通过子查询构建可复用的小型查询 - 不同设计模式的有效数据建模 - 将数据库对象划分到不同模式中以便于维护 - 使用简单的“检查”规则验证数据 - 为常见功能如“喜欢”、“关注”和“标签”系统构建完美设计 - 使用索引加速查询，并了解其内部工作原理 - 深入探讨递归公共表表达式处理复杂查询 - 通过事务轻松处理并发问题 这个课程旨在成为初学者学习数据库的完美资源，帮助你掌握数据库的使用与真实设计。今天就注册，迈出掌握 PostgreSQL 的第一步！
Database structure design? It's here. Query tuning and optimization? You'll master it. Complex queries? Yes indeed!This is the only course online that will teach you how to design a database, store complex data, optimize your queries, everything that is needed for operating a production, scalable database!Every app in the world, whether it is a mobile app built with Flutter, a web app constructed with React, or a plain HTML page, needs to store information in a database. Although there are many different databases you can use, PostgreSQL has been a number-one pick for decades, offering scalable performance, rock-solid uptime, and flexible design systems. This course will teach you everything you need to know about PostgreSQL to use it on your next big project!Don't know anything about databases at all? No problem. We begin with an overview of SQL, the language used to interact with PostgreSQL. Through an incredible number of exercises, you'll get practical, hands on experience working with realistic datasets. You will understand how to store, fetch, and update information with a series of powerful commands. After gaining experience with elementary operations, you will move on to understanding database design patterns, offering multiple ways to structure your database for efficient data modeling. You'll see many different scenarios with different types of data, and understand the pros and cons to several approaches.This course is packed with practice exercises and quizzes. You'll get immediate practice on all of the different topics and features that you learn! In addition, you'll understand exactly where to use each of these features in real and practical projects.Besides getting practical hands-on experience, you'll also get a behind-the-scenes look at how PostgreSQL works internally. We'll dive into raw data files, investigating how PostgreSQL stores information on your hard drive bit by bit. This knowledge is invaluable when it comes time to start tuning your queries for performance. By having a natural instinct of how PostgreSQL works, you can plan on being able to get every last bit of performance out of your database.Here is a partial list of some of the topics that are covered in this course:Apply powerful SQL commands to store, update, and retrieve informationBuild relationships between records using foreign keys between tablesUnderstand PostgreSQL's numerous data types, and when to use eachAssemble reports of business data by using aggregation pipelinesWork with millions of records to simulate real production queriesExercise your query logic skills through the use of sets and sorting operatorsCompose queries out of smaller reusable units using subqueriesUse different design patterns to efficiently model your dataSee how to divide database objects into different schemas to maintain them more easilyValidate your data using simple 'check' rulesConstruct perfect designs for common features such as 'like', 'follow', and 'tag' systemsSpeed up your queries with indexes - you'll see exactly how they work behind the scenes!Dive into some of the most complex queries around with recursive common table expressionsDeal with concurrency issues easily by applying transactionsI made this course to be the perfect resource for engineers just getting started with their first database. Master the database itself, and see how to apply it with real designs. Sign up today and master PostgreSQL!
