|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/practical-sql-with-python-in-3-days/
课程评论：没有评论
**实用 SQL 与 Python 三日速成：从入门到精通** 本课程是学习在 Python 中使用 SQL 的绝佳在线资源。Python 和 SQL 是当今数据相关或数据邻近领域中最受欢迎的两种技能。在本课程中，我们将使用 SQLite、MySQL 和 PostgreSQL 来构建三个复杂度递增的项目，为您在 Python 应用中运用 SQL 打下坚实的基础。 **课程亮点：** * **内容丰富：** 超过 17 小时，包含 50 个编码练习，让您全面掌握 SQL 和 Python，以及数十种编程和计算机科学概念。 * **实践导向：** 强调从零开始编写代码，而非复制粘贴。大量的实践练习将帮助您牢固掌握所学概念和技术。 * **系统讲解：** 每个练习都附有详细的解决方案和解释。 * **项目驱动：** 通过构建“货运经理”、“学校注册系统”和“访客留言簿 API”三个项目，深入学习 SQL 和 Python 的实际应用。 * **三天速成：** 经过三天的沉浸式学习，您将熟练掌握 SQL 和 Python，并能将其添加到您的简历中。 **课程大纲：** * **第一天：SQLite** * 理解 `sqlite3` 中的连接、游标和事务 * 参数化和执行查询 * 理解和防范 SQL 注入 * DBAPI 简介 * 构建“货运经理”项目（9 个编码练习） * **第二天：MySQL** * 使用 `mysql-connector` 重新学习连接、游标和事务 * 构建预处理语句 * 探索字典、缓冲和命名元组游标 * 构建“学校注册系统”项目（19 个编码练习） * **第三天：PostgreSQL** * 使用 `psycopg2` 重新学习连接、游标和事务 * 从 Python 代码生成动态 SQL * 构建“访客留言簿 API”项目（22 个编码练习），涵盖面向对象编程、密码哈希等更多内容。 本课程是您掌握当今最有价值的两项技能的终极沉浸式入门。期待在课程中与您相见！
Welcome to the best resource online for learning to work with SQL in python.Python and SQL are two of the most in-demand skills in any data-related or data-adjacent role today. In this course, we'll use SQLite, MySQL and PostreSQL to build three projects of increasing complexity that will give you a solid foundation in using SQL in python applications.Over 17 hours and 50 coding assignments, you will gain practical mastery of, not only SQL and python, but also tens of programming and computer science concepts.In building these projects, you won't be copy/pasting code. Instead, we will be writing code from scratch, and we will be writing lots of it.This "forced" practice will help solidify your understanding of the concepts and techniques we cover. Each assignment will be followed by a detailed solution and explanation.By the end of the course, after 3 immersive days, SQL and python will be on your resume!----- Structure & Curriculum -----· Day 1: SQLite· understanding connections, cursors, transactions in sqlite3· parameterizing and executing queries· understanding and preventing SQL injections· introduction to DBAPI· building the Freight Manager (9 coding assignments)· Day 2: MySQL· revisiting connections, cursors, transactions with mysql-connector· building prepared statements· exploring dictionary, buffered and namedtuple cursors· building the School Registrar (19 coding assignments)· Day 3: PostgreSQL· revisiting connections, cursors, transactions with psycopg2· generating dynamic SQL from python code· building the Guestbook API (22 coding assignments)· with object oriented programming, password hashing, and moreThis is the ultimate, immersive introduction to two of the most valuable skills today. I'll see you inside!
