Overview
Context
Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases.
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, in this Introduction to SQL course offered by Data Camp.
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.
Programme Structure
What you will learn during this course:
- Define SQL and explain how relational databases organize and store structured data.
- Identify tables, fields, records, and data types within a database schema.
- Write basic SQL queries to select and retrieve data from relational tables.
- Apply SQL clauses like SELECT, FROM, DISTINCT, and AS to customize query results.
- Compare SQL flavors and recognize how SQL syntax varies across common database systems.
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
Language
Delivered
Campus Location
- New York City, United States
Disciplines
Data Analytics View 176 other Short Courses in Data Analytics in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- There are no prerequisites for this course
- This course is perfect for those who are new to SQL. The course starts with a chapter on the fundamentals of SQL and relational databases, introducing topics such as data organization, tables, and best practices for database construction.
Tuition Fees
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions