Learn SQL basic commands. (Coursera)

Learn SQL basic commands. (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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.
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Introduction to Relational Databases (Coursera) Coursera
Illinois Tech

Introduction to Relational Databases (Coursera)

Database management systems are a crucial part of most large-scale industry and open-source systems. This course will introduce you to important concepts of database systems and design. We will learn what relational databases are, what they are used for, the theory underlying their design, and how to query and modify a database using the declarative SQL language.

Nov 9th 2026
4 Weeks
Database Design and Operational Business Intelligence (Coursera) Coursera
Edureka

Database Design and Operational Business Intelligence (Coursera)

Welcome to the course on Database Design and Operational Business Intelligence. This course is strategically crafted to empower you with the skills needed to design a robust database and efficiently manage intricate datasets. Throughout this course, you will acquire the expertise to develop well-formatted databases that are seamlessly designed to integrate with Power BI.

Nov 9th 2026
4 Weeks
Data Science in Health Technology Assessment (Coursera) Coursera
Genentech

Data Science in Health Technology Assessment (Coursera)

This course explores key concepts and methods in Health Economics and Health Technology Assessment (HTA) and is intended for learners who have a foundation in data science, clinical science, regulatory and are new to this field and would like to understand basic principles used by payers for their reimbursement decisions.

Nov 9th 2026
3 Weeks
Oracle SQL Performance Tuning (Coursera) Coursera
EDUCBA

Oracle SQL Performance Tuning (Coursera)

This course is designed to provide you with skills needed to improve query performance in Oracle databases. In real-world scenarios, slow report generation and query execution often result from the sheer volume of data. To address this issue, this course covers topics such as Query Compilation and Execution, Indexing, Materialized Views, Common Table Expressions etc. Emphasis is on practical learning with step-by-step demonstrations.

Nov 2nd 2026
4 Weeks
Snowflake - SnowPro Core Certification Preparation (Coursera) Coursera
Board Infinity

Snowflake - SnowPro Core Certification Preparation (Coursera)

"Snowflake - SnowPro Core Certification Preparation" is a comprehensive course meticulously crafted to guide learners through the essentials of Snowflake, preparing them for the SnowPro Core Certification. Spanning three modules, the course begins with the fundamentals of Snowflake, exploring its architecture, data loading, and modeling. The second module delves into operational and management aspects, including account management, performance optimization, and security.

Nov 9th 2026
3 Weeks
Data Science Math Skills (Coursera) Coursera
Duke University

Data Science Math Skills (Coursera)

Data science courses contain math—no avoiding that! This course is designed to teach learners the basic math you will need in order to be successful in almost any data science math course and was created for learners who have basic math skills but may not have taken algebra or pre-calculus. Data Science Math Skills introduces the core math that data science is built upon, with no extra complexity, introducing unfamiliar ideas and math symbols one-at-a-time.

Nov 2nd 2026
4 Weeks
Materials Data Sciences and Informatics (Coursera) Coursera
Georgia Institute of Technology

Materials Data Sciences and Informatics (Coursera)

This course aims to provide a succinct overview of the emerging discipline of Materials Informatics at the intersection of materials science, computational science, and information science. Attention is drawn to specific opportunities afforded by this new field in accelerating materials development and deployment efforts.

Nov 2nd 2026
5-12 Weeks
BigQuery Fundamentals for Oracle Professionals (Coursera) Coursera
Google Cloud

BigQuery Fundamentals for Oracle Professionals (Coursera)

This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Oracle and want to begin working in BigQuery. Through interactive lecture content and hands-on labs, you learn how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery. Drawing upon your knowledge of Oracle, you also learn about similarities and differences between Oracle and BigQuery to help you get started with data warehouses in BigQuery.

Nov 9th 2026
2 Weeks
Data science perspectives on pandemic management (Coursera) Coursera
Politecnico di Milano

Data science perspectives on pandemic management (Coursera)

The COVID-19 pandemic is one of the first world-wide scenarios where data made a difference in capturing and analyzing the diffusion and impact of the disease. We offer an introductory course for decision makers, policy makers, public bodies, NGOs, and private organizations about methods, tools, and experiences on the use of data for managing current and future pandemic scenarios.

Nov 2nd 2026
5-12 Weeks
Big Data Analysis with Scala and Spark (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Big Data Analysis with Scala and Spark (Coursera)

Manipulating big data distributed over a cluster using functional concepts is rampant in industry, and is arguably one of the first widespread industrial uses of functional ideas. This is evidenced by the popularity of MapReduce and Hadoop, and most recently Apache Spark, a fast, in-memory distributed collections framework written in Scala. In this course, we'll see how the data parallel paradigm can be extended to the distributed case, using Spark throughout.

Nov 9th 2026
4 Weeks
Programming and Application Foundations (Coursera) Coursera
Illinois Tech

Programming and Application Foundations (Coursera)

This course introduces the students to the creation and deployment of modern, standards-compliant web pages written in HTML, CSS, and JavaScript in the context of the client-server architecture of the web. The course also covers the fundamentals of programming in a modern programming language, basic data modeling, database design, implementation, and administration of single-user and shared multi-user database applications using a contemporary relational database management system.

Nov 9th 2026
5-12 Weeks