edX: Try It: Learn SQL

If you are looking to get into data analytics, SQL would be a great starting point.

Duration: 1 weeks
Difficulty Level: Introductory

edX: Try It: Learn SQL

About this Course

This introductory course in SQL is designed for individuals eager to learn about database design and SQL, aiming to apply these skills across various tech and data fields, further their education in data analytics or back-end development, or enhance their current career with a valuable skill.

Course Description

Throughout this course, you will gain foundational knowledge and skills about SQL, which include defining and explaining SQL's benefits, understanding databases, recognizing SQL data types, and creating basic SQL statements.

What Students Will Learn

Understanding the use and benefits of SQL
Identifying what a database is and explore various SQL data types
Developing the ability to write and execute basic SQL statements
Applying SQL knowledge to real-world contexts

Pre-requisites or Skills Necessary to Complete the Course

No prerequisites are required for this course, making it suitable for beginners who are new to database technology or SQL.

Course Coverage

Definition and benefits of SQL
Overview of databases and SQL data types
Creation of basic SQL statements

Who This Course Is For

This course is ideal for aspiring tech professionals, current employees seeking to upskill in the field of data analytics or back-end development, and anyone interested in understanding database management through SQL.

Application of Skills in the Real World

Skills acquired from this course can be utilized in roles such as data analysis, database management, and system administration, providing a competitive edge in the tech industry and improving job performance in tech-centric roles.

ASUx: Data Engineering

ASUx: Data Engineering

In Data Engineering, learn how to interact with databases using SQL.

HarvardX: CS50's Introduction to Databases with SQL

HarvardX: CS50's Introduction to Databases with SQL

An introduction to databases using a language called SQL.

IBM: SQL for Data Science with R

IBM: SQL for Data Science with R

Build a baseline understanding about relational database concepts and learn how to apply foundational knowledge of the SQL and R languages through a series of hands-on labs to practice building and running SQL queries.

WisconsinX: SQL Fundamentals

WisconsinX: SQL Fundamentals

Learn the fundamentals of SQL and database management.

StanfordOnline: Databases: Semistructured Data

StanfordOnline: Databases: Semistructured Data

This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org.

Part of the Databases series, this is a standalone course; learners seeking to develop an understanding of topics in this course do not need to take other Databases courses. This course covers the JSON and XML standards for semistructured data, along with query languages and schema declaration features for XML.

The XML Data section of this course introduces the XML model for semistructured and self-describing data, including DTDs and some features of XML Schema.
The JSON Data section of this course introduces the JSON model for human-readable structured or semistructured data.
The XPath and XQuery section of this course covers the XPath language for processing XML data, along with many features of the more advanced XQuery language.
The XSLT section of this course provides a general introduction to the XSLT rule-based language for querying and transforming XML data.

DavidsonX: Introduction to SQL

DavidsonX: Introduction to SQL

In this introduction to SQL Online Course you will gain strong underdstanding and utilize SQL to aggregate, manipulate, and analyze data in your field.

ASUx: Business Intelligence and Data Analytics

ASUx: Business Intelligence and Data Analytics

Using Excel, learn the basics of business analytics and the importance of the role to obtaining crucial information for the organization.

UMBC: Relational Database Management Systems

UMBC: Relational Database Management Systems

Learn how to create and interact with a relational database. The course includes Data Definition Language (DDL) used for database creation and Data Manipulation Language (DML) used for inserting, updating and deleting data in the database.

StanfordOnline: Databases: OLAP and Recursion

StanfordOnline: Databases: OLAP and Recursion

This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org.

This course builds on concepts introduced in Databases: Relational Databases and SQL and is recommended for learners seeking to understand On-Line Analytical Processing (OLAP) and/or recursion in the SQL language.

The On-Line Analytical Processing section of this course introduces star schemas, the data cube concept, and OLAP features in relational databases including the Cube and Rollup operators.
The Recursion section of this course covers the SQL standard for queries over recursively-defined relations.