This project will teach you how to use SQL basic command in SQL server. SQL is an important query language, use in backend and frontend data manipulation and extraction. It's popular among software engineers, data analysts, data scientists, etc. This Guided Project was created by a Coursera community member.

Enroll in course

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

In this Guided Project, you will:

- Learn to download and install SQL Server and SSMS

- Use of Data definition (DDL) commands

- Learn to use basic statement and how to manipulate data in SQL server

Learn step-by-step

- Introduction

- Frist query: CREATE, INSERT and SELECT commands.

- Third query: GROUPBY and ORDERBY

- Setup SQL Server and SQL Server Management Studio.

- Fourth query: UPDATE,DROP, DELETE and ALTER commands.

- Second query: Using WHERE clause and HAVING clause with condition

- Test yourself.