|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/top-database-bundle-mysql-postgresql-sqlite3-sql-server/
课程评论：没有评论
**课程名称：** 顶级数据库组合：MySQL, PostgreSQL, SQLite3, SQL Server **课程概述：** 本课程将带领您从零基础到精通四大热门数据库：MySQL, PostgreSQL, SQLite, 和 Microsoft SQL Server。无论您是否有任何编程或数据库经验，本课程都适合您。 **课程内容：** * **入门准备：** * 免费下载和安装所有四种数据库。 * 学习安装 Git Bash 终端。 * 掌握连接到数据库的方法。 * 学习创建数据库。 * **基础数据库概念：** * 什么是数据库。 * 创建数据表。 * 插入单条和多条记录。 * 理解数据类型。 * 查询数据（SELECT）。 * 格式化查询结果。 * 使用 WHERE 子句进行条件筛选。 * 使用 LIKE 子句和通配符进行模糊匹配。 * 使用 AND 和 OR 连接条件。 * 更新记录（UPDATE）。 * 限制和排序结果（LIMIT, ORDER BY）。 * 删除记录（DELETE）。 * 删除数据表（DROP TABLE）。 * 数据库备份。 * **高级主题：** * 外键（Foreign Keys）。 * 内连接（Inner Joins）。 * JOIN WHERE 技巧。 * 以及更多... **学习路径：** 课程将按照 MySQL -> PostgreSQL -> SQLite -> Microsoft SQL Server 的顺序进行教学。 **一站式学习体验：** 本课程是四门受欢迎数据库课程的合集，旨在以最简单的方式让您掌握这四种最流行且需求量大的数据库。 **让我们一起开始学习数据库之旅吧！**
In this course we'll learn the MySQL Database, the POSTGRES Database, the SQLite Database, and the Microsoft SQL Server from an absolute Beginner level all the way to Advanced in no time at all!This course is aimed at the absolute beginner, you don't need any coding or database experience at all!We'll start out by downloading and installing each of these databases - all for free. This will give you all the tools you need to start writing and running code for your databases. Then, we'll dive into very basic database concepts. Things like:What Is A DatabaseHow To Install Each DatabaseHow To Install Git Bash TerminalHow To Connect To Your DatabaseHow To Create A DatabaseAfter that, we'll move into more intermediate topics like:How To Create A TableHow To Insert One Record Into TableHow To Insert Many Records Into TableUnderstanding Data TypesHow To Select Data From TableHow To Format Our ResultsHow To Use The Where ClauseHow To Use The Like Clause and WildcardsHow To Use AND and ORHow To Updating RecordsHow To Limit and Order ResultsHow To Delete RecordsHow To Delete (Drop) A Table And BackupsFinally we'll finish up with more advanced topics like:Foreign KeysInner JoinsJoin Where HacksAnd More...We'll learn all of those things for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server. We'll start with MySQL, and then move over to PostgreSQL, then hit SQLite before finishing up with Microsoft SQL Server. This is a bundle course of four of my other popular courses.These databases are four of the greatest databases to learn, and learning has never been this easy! They're the most popular and in demand for a reason! Let's learn some databases!I'll see you on the inside!-John Elder
