课时
3 个部分 · 24 节课 · 4小时28分钟 总时长
第 1 至 10 节10 节课 · 1小时59分钟
- Introduction | SQL | Tutorial 13分钟
- What is a Database? | Let's Learn21分钟
- Tables & Keys | SQL | Tutorial 221分钟
- SQL Basics | SQL | Tutorial 39分钟
- MySQL Windows Installation | SQL | Tutorial 410分钟
- MySQL Mac Installation | SQL | Tutorial 514分钟
- Creating Tables - SQL - Tutorial 616分钟
- Inserting Data - SQL - Tutorial 78分钟
- Constraints - SQL - Tutorial 810分钟
- Update & Delete | SQL | Tutorial 98分钟
第 11 至 20 节10 节课 · 1小时37分钟
- Basic Queries | SQL | Tutorial 1013分钟
- Company Database Intro | SQL | Tutorial 119分钟
- Creating Company Database | SQL | Tutorial 1214分钟
- More Basic Queries | SQL | Tutorial 136分钟
- Functions | SQL | Tutorial 149分钟
- WIldcards | SQL | Tutorial 159分钟
- Union | SQL | Tutorial 168分钟
- Joins | SQL | Tutorial 1711分钟
- Nested Queries | SQL | Tutorial 1810分钟
- On Delete | SQL | Tutorial 199分钟
需要什么
- 无需基础:课程从零讲起。
课程介绍
This course consists of a series of videos where we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.
适合谁
- 从零开始学SQL的人。
这两项是我们根据课程难度得出的判断,课程介绍是作者本人写的。