|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-sql23/
课程评论：没有评论
课程名称：完整的 SQL 和 MySQL 课程 - 从初学者到专家 课程概述：本课程旨在教授数据管理的基本概念，您将学习使用最流行的数据操作编程语言 SQL 和 MySQL 的查询技巧。课程主要围绕 SQL 命令，让您掌握查询的基础知识。 学习内容： - **第一部分 - 环境设置**：了解如何设置环境及安装 MySQL 服务器。 - **第二部分 - 数据库理论**：学习数据库及数据库管理系统（DBMS）的定义，数据库语言，以及支持数据库的数据结构（B树）等概念。 - **第三部分 - 创建和操作表**：掌握基本数据类型，如何创建数据库，插入、删除和更新数据项。 - **第四部分 - 基础 SQL**：学习基本的 SQL 和 MySQL 命令，比如选择、条件查询和逻辑运算符。 - **第五部分 - 多表操作**：了解如何连接多个数据库表，包括内连接、左连接和右连接。 - **第六部分 - 数据库规范化**：学习数据库规范化的概念及各个规范化形式（NF1、NF2、NF3）。 - **第七部分 - 子查询**：掌握何为子查询，包括关联子查询和非关联子查询。 - **第八部分 - 事务处理**：学习数据库锁定的概念，ACID 原则，以及如何使用 COMMIT、ROLLBACK 和 SAVEPOINT。 - **第九部分 - 视图**：理解视图的重要性，以及如何创建、更新和删除视图。 - **第十部分 - 索引和约束**：了解索引的作用及使用方法，重点学习主键、外键、复合键及各种约束。 - **第十一部分 - 数据库背后的数据结构**：学习页面的概念及分页的基本原理，以及 B 树和 B+ 树数据结构。 - **第十二部分 - 存储过程**：了解存储过程的含义，以及变量、循环、条件语句和游标的使用。 学习 SQL 和 MySQL 的基础知识是一个明智的选择，这能让您掌握一项强大的技能。SQL 易于学习并拥有出色的文档支持，广泛应用于软件工程、财务分析等多个领域。掌握这些概念和基本语言特性将极具市场价值。 感谢您加入本课程，让我们开始学习吧！
In this course you can learn the fundamental basics of data management with SQL and MySQL. Learn everything that you will need to make queries with the most popular data manipulating programming language - SQL. This course is about SQL commands in the main. You will learn the basics of queries. Let's take a look at what you are going to learn in this course:Section 1 - Setting up The Environment:setting up the environmentinstalling MySQL serverSection 2 - Database Theorywhat are databases?what are database management systems (DBMSs)?what are database languages?the data structures (B-trees) behind databasesprocedural and non-procedural programming languagesSection 3 - Creating and Manipulating Tablesbasic data types (integers, floating point numbers and characters)enums and dateshow to create databases?how to insert and remove items?how to update existing items or database tables?Section 4 - Basic SQLbasic SQL and MySQL commandsselect, where and wildcardslogical operatorsORDER BY and GROUP BY commandsSection 5 - Multiple Tablesjoining multiple database tablesinner joinleft and right joinSection 6 - Database Normalizationwhat is database normalisation?first normal form (NF1)second normal form (NF2)third normal form (NF3)Section 7 - Subqueries:advanced SQL and MySQLwhat are subqueries?correlated and non-correlated subqueriesSection 8 - Transactionswhat is database locking?the ACID principlesCOMMIT, ROLLBACK and SAVEPOINTSection 9 - Viewswhat are views and why are they crucial?creating viewsupdating viewsdropping viewsSection 10 - Indexes and Constraintswhat are indexes and why to use them?primary keys and foreign keys revisitedcomposite keyswhat are constraints?check constraints unique constraintsdefault constraintsSection 11 - Data Structures Behind Databaseswhat are pages?the basic concept of paging in operating systemsexternal memory and internal memoryB tree data structureB+ tree data structureSection 12 - Stored Procedureswhat are stored procedures?variablesloopsconditional statementscursorsLearning the fundamentals of SQL and MySQL is a good choice and puts a powerful tool at your fingertips. SQL is easy to learn as well as it has excellent documentations. The most important fact about SQL that it is used in almost every field from software engineering to financial analysis so understanding the concepts and basic language features can prove to be very marketable.Thanks for joining the course, let's get started!
