|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-python-postgresql-database-course/
课程评论：没有评论
课程名称：《完整的Python/PostgreSQL课程2.0》 课程概述： 本课程将教授学员如何掌握PostgreSQL，并在Python应用中使用它。Python和PostgreSQL是当今需求量最大的技能之一。完成此课程后，您将能够自信地将这两个技能添加到您的简历中。课程内容不仅适用于PostgreSQL，也对其他数据库系统（例如MySQL、Microsoft SQL Server或Oracle）具有参考价值。 课程内容： - 了解不同类型数据库（内存数据库、SQLite和PostgreSQL），并学会在Python应用中选择适当的数据库。 - 构建编程日志项目，将SQLite数据库添加到Python应用中。 - 逐步改进数据库设计，不受初始设计的限制。 - 使用PostgreSQL建模不同的关系，包括一对多和多对多关系。 - 通过Python和Alembic应用数据库迁移，减少错误。 - 建立投票应用，学习使用GROUP BY、PostgreSQL窗口函数和嵌套查询进行高级数据分析。 - 处理PostgreSQL中的日期和时间，避免常见的时区问题。 - 以专业的方式构建Python应用，简化开发过程。 - 使用matplotlib生成数据分析报告和图表。 高级主题： - 用户定义函数 - 存储过程 - 锁定机制 - 异步数据库连接 课程特点： 本课程强调简约和高效，确保每节课内容精炼，没有多余的时间浪费。我们使用几十个图表来解释数据库概念，并提供代码演示视频。学员将亲自开发项目，以获得实际操作经验，掌握PostgreSQL。此外，课程中还提供数据集和练习，帮助学员巩固所学知识。 讲师背景： 讲师在网上教学和指导学生超过8年，课程是其教学经验的总结，旨在帮助学员快速、有效地理解概念。 完成课程后，您将能够： - 利用PostgreSQL扩展您的Python应用数据库功能。 - 使用数据回答复杂问题并生成报告。 - 将PostgreSQL列为您最强的技能之一。 欢迎查看免费的预览视频以获取更多信息并尝试课程!期待在课程中见到您！
Master PostgreSQL and use it in your Python apps!Python and PostgreSQL are two of the most in-demand skills in the world. After completing this course, you'll be confident in adding both to your resume/CV.Everything you'll learn in this course is relevant to other database systems too, like MySQL, Microsoft SQL Server, or Oracle.With this course, you'll master PostgreSQL and how to work with it from Python. If you use Python and you want to augment your skills with a database, you'll love this course!You will:Work with different types of databases (in-memory, SQLite, and PostgreSQL), and understand when to use each in your Python apps.Build a programming journal project to add a SQLite database to your Python application.Improve a database design incrementally so you're not bound by your initial design.Model different relationships with PostgreSQL, including one-to-many and many-to-many.Reduce errors by applying database changes using database migrations with Python and alembic.Build a polling app to learn about advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.Work with dates and times in PostgreSQL, and avoid common timezone pitfalls.Structure Python apps like a professional, to make development much easier.Produce data analysis reports and charts using matplotlib with PostgreSQL data.You'll also tackle advanced PostgreSQL topics, such as:User-Defined FunctionsStored ProceduresLockingAsync database connectionsAs you can see, you're going to learn a lot!But this is a no-nonsense, no-frills course. We have planned, crafted, and edited every lecture to be concise and compact. No time wasted, so you can master PostgreSQL in record time.We've created dozens of diagrams to explain database concepts, as well as code-along videos. But you won't just be watching me code! You'll develop the projects yourself first, to gain hands-on experience and master PostgreSQL.Also, throughout the course, I provide data sets with challenges and exercises for you to practice what you've learned.I've been teaching and helping students online for over 8 years, and this course is the culmination of my teaching experience. I know how to help you understand concepts fully and quickly, in the best way for you.When you complete this course you'll be able to:Extend your Python applications with database functionality using PostgreSQL.Answer complex questions using data and generate reports.List PostgreSQL as one of your strongest skills.Check out the free preview videos for more information and to try out the course!I'll see you on the inside!
