|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-database-101-csv-files-to-sql/
课程评论：没有评论
课程名称：SQL数据库基础：SQLite3、Python和Flask应用程序 课程概述：该课程是面向初学者的SQL数据库入门课程，旨在传授通用的数据库技能，并以SQLite3为基础。课程内容覆盖数据库使用和设计的基本原则，学习SQL查询的基础知识，设计数据库以及向数据库中添加数据。最后，我们还将使用Flask和HTML展示SQL数据库。此课程特别适合没有或几乎没有SQL经验的学员，无论是完全不知道SQL，还是仅仅进行过数据提取的学员，如果您有一台电脑、互联网连接并愿意学习，这门课就是为您而设。 Python是一种非常流行的编程语言，学习这门课程将使您能够利用Python解决工作负担过重的问题，创建新的有趣应用程序或软件。SQL是与广泛使用的SQL数据库进行交互的语言，掌握SQL将帮助您很好地处理数据和数据库，并能够将其与Python代码集成，创建动态的自动化系统，结合编程和数据的强大功能。Python和SQL还可以将您存储在CSV或多个Excel文件中的数据转化为组织良好、易于查看和操作的结构。 本课程将使用Python中的SQLite3，学习如何通过Python执行SQL命令，创建、连接、使用和管理本地SQL数据库。最终，我们将利用Flask创建一个HTML网页应用，用于展示您的SQL数据库。
SQL database for beginners, with transferable skills to other types of databases.Learn the pillars of database usage and design, the SQLlite3. We will understand the basics or SQL queries to designing a database and adding data to this database. And, finally displaying the SQL database using a Web application using Flask and HTMLThis class is designed for people with little to no experience: If you don't know SQL, and never used SQL or if you've only fetched data then this course is for you. All you need is a computer, internet and willingness to learn.Python is one of the most popular programming languages (and this is important because if you get stuck there should be plenty of help on the internet for you). Python is found in applications everywhere, ranging from research to industry, as well as entertainment industry. Programming in general allows for you to greatly reduce workload, as well as solve problems that would be impossible to solve by hand, or create great, new, and fun applications/software.SQL is the language that you can use to interact with one major database type (SQL databases), one that is very wide-spread in today's world. Knowing SQL will give you a nice ability and understanding of how to handle data and databases, and being able to integrate it into Python code enables you to create great, dynamic, and automatic systems that combine the power of programming and data. Python and SQL can also convert all your data sitting in CSV or numerous excel files into an organised structure which is both light to view and easy to manipulate. This course will be using SQLite3 in Python, which allows us to execute SQL commands through python, and will allow you to create, connect, use, and manage local SQL-based databases. And finally we will utilise Flask to create a HTML web application to dislpay your SQL database.
