深受数千家公司学习者的喜爱
培训2人或更多？
试用DataCamp for Business课程描述
Get an Introduction to SQL in Two Hours
Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Being able to wrangle and extract data from these databases using SQL is an essential skill within the data industry and in increasing demand.In just two hours, you'll get to know the theory and the practice through bite-sized videos and interactive exercises where you can put your new-found skills to the test.
Learn how Relational Databases are Organized
SQL is an essential language for building and maintaining relational databases, which opens the door to a range of careers in the data industry and beyond. You’ll start this course by covering data organization, tables, and best practices for database construction.Write Your First SQL Queries
The second half of this course looks at creating SQL queries for selecting data that you need from your database. You’ll have the chance to practice your querying skills before moving on to customizing and saving your results.Understand the Difference Between PostgreSQL and SQL Server
PostgreSQL and SQL Server are two of the most popular SQL flavors. You’ll finish off this course by looking at the differences, benefits, and applications of each. By the end of the course, you’ll have some hands-on experience in learning SQL and the grounding to start applying it to projects or continue your learning in a more specialized direction.先决条件
本课程无先修要求1
SQL 入门
初识数据库与 SQL
你将了解什么是数据库、它们的表结构，以及 SQL 在数据处理中的作用。
编写你的第一个 SQL
你将编写你的第一批 SQL 查询，实现对数据库表记录的选择、限制、排序，并查找排名靠前或靠后的记录。
完善你的 SQL 基础
您将通过学习如何处理唯一值、重命名列、了解 SQL flavors，并掌握数据库在实践中的运作方式，来完善您的 SQL 基础。
Introduction to SQL
课程完成 通过 DataCamp for Mobile 提升您的数据技能
随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。