Introduction to SQL and relational databases from edX

The biggest asset of today's companies is their data, and data that is mostly stored in online relational databases.

Virtually all relational database management systems in use today use SQL as a tool for manipulating and querying the data they contain.

SQL language is an international standard that allows, in a simple way, powerful data extraction and summarization queries to be performed with very few commands.

If you want to make a career in business intelligence, web application programming or any other activity that requires querying or updating data, mastering SQL is a basic requirement.

In this course we will teach you the basic concepts needed to manage a database and we will introduce you gradually and practically to the use of SQL, starting with the simple query to get all the data stored in a table and ending with complex queries able to summarize the data contained in several related tables, queries that you will be able to replicate in a SQL emulator in the cloud during the course.

What you'll learn

Basic concepts of databases and relational databases such as table, record, field, relation, primary key or secondary key.

* Use of the SELECT command with the WHERE clause and various tools such as IN, BETWEEN or LIKE to query databases using string and range patterns.

* The SQL commands for creating, changing and deleting tables and databases: CREATE, ALTER and DROP

* The SQL commands for modifying the contents of database tables: INSERT, UPDATE and DELETE.

* How to group and sort the results of a SQL query with ORDER BY, GROUP BY and how to summarize them with functions such as SUM, AVG, MAX or MIN.

* How to perform complex queries that return the results of several tables with JOIN and UNION

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches SQL, which is a standard relational database language

Covers SQL commands for a range of tasks, from simple data extraction to complex summaries

Provides hands-on practice with an SQL emulator in the cloud

Builds a strong foundation for beginners in relational database management

Suited for individuals seeking a career in business intelligence, web application programming, or other data-related fields

Career center

Learners who complete Introduction to SQL and relational databases will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data analysts collect, clean, analyze, and interpret data to help businesses make better decisions. This course provides a solid foundation in SQL, a key skill for data analysts. With a strong understanding of SQL, you'll be able to effectively extract and analyze data from relational databases, a common data storage system used by businesses. This course can help you develop the skills needed to succeed as a data analyst.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

Business intelligence analysts use data to identify trends, patterns, and opportunities to help businesses make better decisions. This course provides a strong foundation in SQL, a crucial skill for business intelligence analysts. With a deep understanding of SQL, you'll be able to effectively query and analyze data from relational databases, a common data storage system used by businesses. This course can help you develop the skills needed to succeed as a business intelligence analyst.

See salaries and explore the career path for Business Intelligence Analyst

Database Administrator

Database administrators are responsible for managing and maintaining databases, ensuring data integrity and availability. This course provides a comprehensive introduction to SQL and relational databases, essential knowledge for database administrators. You'll learn how to create, modify, and delete databases and tables, as well as how to perform complex queries to retrieve and manipulate data. This course can help you develop the foundational skills needed to succeed as a database administrator.

See salaries and explore the career path for Database Administrator

Software Engineer

Software engineers design, develop, and maintain software systems. This course provides a strong foundation in SQL, a key skill for software engineers who work with relational databases. With a deep understanding of SQL, you'll be able to effectively query and manipulate data from relational databases, a common data storage system used by businesses. This course can help you develop the skills needed to succeed as a software engineer.

See salaries and explore the career path for Software Engineer

Data Scientist

Data scientists use scientific methods and algorithms to extract knowledge and insights from data. This course provides a solid foundation in SQL, a key skill for data scientists. With a strong understanding of SQL, you'll be able to effectively query and analyze data from relational databases, a common data storage system used by businesses. This course can help you develop the foundational skills needed to succeed as a data scientist.

See salaries and explore the career path for Data Scientist

Web Developer

Web developers design and develop websites and web applications. This course provides a solid foundation in SQL, a key skill for web developers who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and manipulate data from relational databases, a common data storage system used by businesses. This course can help you develop the skills needed to succeed as a web developer.

See salaries and explore the career path for Web Developer

Financial Analyst

Financial analysts use financial data to evaluate and make recommendations on investments. This course provides a solid foundation in SQL, a key skill for financial analysts who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze financial data to identify trends and make informed investment decisions. This course can help you develop the skills needed to succeed as a financial analyst.

See salaries and explore the career path for Financial Analyst

Operations Research Analyst

Operations research analysts use mathematical and analytical techniques to solve business problems. This course provides a solid foundation in SQL, a key skill for operations research analysts who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze data from relational databases to identify and solve business problems. This course can help you develop the skills needed to succeed as an operations research analyst.

See salaries and explore the career path for Operations Research Analyst

Information Security Analyst

Information security analysts protect computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. This course provides a solid foundation in SQL, a key skill for information security analysts who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze data from relational databases to identify and mitigate security risks. This course can help you develop the skills needed to succeed as an information security analyst.

See salaries and explore the career path for Information Security Analyst

Product Manager

Product managers are responsible for the development and launch of new products. This course provides a solid foundation in SQL, a key skill for product managers who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze product data to identify trends and make informed product decisions. This course can help you develop the skills needed to succeed as a product manager.

See salaries and explore the career path for Product Manager

Market Researcher

Market researchers study market trends and consumer behavior to help businesses make better decisions. This course provides a solid foundation in SQL, a key skill for market researchers who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze market data to identify trends and consumer preferences. This course can help you develop the skills needed to succeed as a market researcher.

See salaries and explore the career path for Market Researcher

Salesforce Administrator

Salesforce administrators manage and maintain Salesforce systems, a cloud-based customer relationship management (CRM) platform. This course provides a solid foundation in SQL, a key skill for Salesforce administrators who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze data from relational databases to identify trends and make informed decisions. This course can help you develop the skills needed to succeed as a Salesforce administrator.

See salaries and explore the career path for Salesforce Administrator

User Experience (UX) Researcher

User experience (UX) researchers study how users interact with products and services to improve the user experience. This course provides a solid foundation in SQL, a key skill for UX researchers who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze data from relational databases to identify trends and make informed design decisions. This course can help you develop the skills needed to succeed as a UX researcher.

See salaries and explore the career path for User Experience (UX) Researcher

Technical Writer

Technical writers create and maintain documentation for software, hardware, and other technical products. This course provides a solid foundation in SQL, a key skill for technical writers who document relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze data from relational databases to create accurate and informative documentation. This course can help you develop the skills needed to succeed as a technical writer.

See salaries and explore the career path for Technical Writer

Data Entry Clerk

Data entry clerks input and manage data into computer systems. This course provides a solid foundation in SQL, a key skill for data entry clerks who work with relational databases. With a strong understanding of SQL, you'll be able to effectively query and analyze data from relational databases to ensure data accuracy and completeness. This course can help you develop the skills needed to succeed as a data entry clerk.

See salaries and explore the career path for Data Entry Clerk