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

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.

Sep 14th 2026
3 Weeks
Process Mining: Data science in Action (Coursera) Coursera
Eindhoven University of Technology

Process Mining: Data science in Action (Coursera)

Process mining is the missing link between model-based process analysis and data-oriented analysis techniques. Through concrete data sets and easy to use software the course provides data science knowledge that can be applied directly to analyze and improve processes in a variety of domains. Data science is the profession of the future, because organizations that are unable to use (big) data in a smart way will not survive. It is not sufficient to focus on data storage and data analysis. The data scientist also needs to relate data to process analysis.

Sep 21st 2026
5-12 Weeks
Statistical Inference and Hypothesis Testing in Data Science Applications (Coursera) Coursera
University of Colorado Boulder

Statistical Inference and Hypothesis Testing in Data Science Applications (Coursera)

This course will focus on theory and implementation of hypothesis testing, especially as it relates to applications in data science. Students will learn to use hypothesis tests to make informed decisions from data. Special attention will be given to the general logic of hypothesis testing, error and error rates, power, simulation, and the correct computation and interpretation of p-values. Attention will also be given to the misuse of testing concepts, especially p-values, and the ethical implications of such misuse.

Sep 21st 2026
5-12 Weeks
Talend Data Integration Certification Preparation training (Coursera) Coursera
Talend

Talend Data Integration Certification Preparation training (Coursera)

Talend certification exams measure candidates’ skills to ensure that they have the knowledge to successfully implement quality projects. It is recommended to have at least 6 months experience using Talend products and general knowledge of data integration architecture and advanced features before preparing for a Talend certification.

Sep 21st 2026
3 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.

Sep 14th 2026
5-12 Weeks
Serverless Data Processing with Dataflow: Develop Pipelines (Coursera) Coursera
Google Cloud

Serverless Data Processing with Dataflow: Develop Pipelines (Coursera)

In this second installment of the Dataflow course series, we are going to be diving deeper on developing pipelines using the Beam SDK. We start with a review of Apache Beam concepts. Next, we discuss processing streaming data using windows, watermarks and triggers. We then cover options for sources and sinks in your pipelines, schemas to express your structured data, and how to do stateful transformations using State and Timer APIs.

Sep 21st 2026
3 Weeks
Relational Database Implementation and Applications (Coursera) Coursera
Illinois Tech

Relational Database Implementation and Applications (Coursera)

In today's data-driven world, the ability to work with relational databases is an essential skill for professionals in various fields. This course is designed to equip you with the knowledge and practical skills needed to become proficient in database management and application development. Whether you are pursuing a career as a database administrator, software developer, or data analyst, this course provides you with a strong foundation to excel in your chosen field.

Sep 21st 2026
5-12 Weeks
Developing AI Policy (Coursera) Coursera
Fred Hutchinson Cancer Center

Developing AI Policy (Coursera)

AI tools are already changing how we work, and they will continue to do so for years. Over the next few years, we’re likely going to see AI used in ways we’ve never imagined and are not anticipating. This course will guide you as you lead your organization to adopt AI in a way that’s not unethical, illegal, or wrong. This course empowers you to make informed decisions and confidently create an AI policy that matches your organizational goals.

Sep 21st 2026
1 Week
Precision Medicine (Coursera) Coursera
University of Geneva

Precision Medicine (Coursera)

This course will provide you with the key knowledge and tools to understand the fundamentals and practical implications of precision medicine, its opportunities and challenges. It will address precision-medicine era diagnostics, treatment selection, genetic counseling, public health interventions, and biomedical research. It will also deal with data science and ethical issues. From genomic analysis and genetic counseling to cancer biomarkers, from risk assessment of chronic diseases to the understanding of gene-environment interactions, from pharmacogenomics to multi-omics data integration, experts will walk you through the many aspects of precision medicine, from the bench to the bedside and to population health.

Sep 21st 2026
5-12 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.

Sep 14th 2026
4 Weeks
Introduction to Genomic Technologies (Coursera) Coursera
Johns Hopkins University

Introduction to Genomic Technologies (Coursera)

This course introduces you to the basic biology of modern genomics and the experimental tools that we use to measure it. We'll introduce the Central Dogma of Molecular Biology and cover how next-generation sequencing can be used to measure DNA, RNA, and epigenetic patterns. You'll also get an introduction to the key concepts in computing and data science that you'll need to understand how data from next-generation sequencing experiments are generated and analyzed.

Sep 14th 2026
4 Weeks
Big Data Analysis with Scala and Spark (Scala 2 version) (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Big Data Analysis with Scala and Spark (Scala 2 version) (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.

Sep 14th 2026
4 Weeks