When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I purchase the Certificate?

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

SQL Querying: Fundamentals

4 days left! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

SQL Querying: Fundamentals

Instructor: Bill Rosenthal

Included with

Learn more

7 modules

Gain insight into a topic and learn the fundamentals.

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

7 modules

Gain insight into a topic and learn the fundamentals.

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

In this course, you will compose SQL queries to retrieve desired information from a database.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 7 modules in this course

Organizations typically store their most critical information—the information used to manage day-to-day operations—within a database. The ability to retrieve and analyze this information is essential to the functioning of the organization. Structured Query Language (SQL) is the primary language used to accomplish such tasks. Essentially, SQL is the language you use to interact with a database.

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools. This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases. This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, who want to use SQL to query databases. In this course, you will: connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize the data obtained from a query before it is displayed onscreen, retrieve data from multiple tables, and export the results of a query. This course requires that you have Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.

Module details

In this course, you will query an SQL database using fundamental query techniques. Simple queries form the basis of building your querying skills. In this lesson, you will begin by composing and executing a simple SQL statement to retrieve information from a database. You will then modify and save a query so that you can use it later

What's included

8 plugins

At this point, you have connected to a server, written a simple query and executed it, and saved that query to a file. With simple queries, you typically retrieve all the information in a table. In a production environment, however, you rarely need to view all the information in a table. Instead, you want to retrieve only the rows in a table that meet certain criteria. In this lesson, you will add criteria to your SELECT statements so that you can perform more sophisticated queries.

What's included

6 plugins

You have retrieved specific data from a table by using a WHERE clause. But you can do more than just display data that is in a table. You can perform calculations and other operations on data and present it in a desired format. In this lesson, you will use various functions to perform calculations on data to obtain meaningful output from the database.

What's included

6 plugins

Retrieving data is the main purpose of most SQL queries. Organizing the data that appears in the result set helps you identify the information that you need instead of searching for it among the retrieved data. In this lesson, you will sort and group data so that the required output is displayed.

What's included

9 plugins

Up to now, you have been retrieving and organizing data from a single table using various clauses and functions in SQL. In this lesson, you will retrieve data from multiple tables.

What's included

6 plugins

So far in this course, you have queried tables and viewed the results in the Results pane in Microsoft® SQL Server® Management Studio (SSMS). SQL professionals would have no problem with viewing and understanding such results. End users, on the other hand, typically don't have SSMS installed on their computers. For this reason, you need to be able to provide users with data in formats they can use in the applications they do have available to them. In this lesson, you will obtain query results in formats that users can use in other applications and tools.