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

Machine Learning Introduction for Everyone (Coursera) Coursera
IBM

Machine Learning Introduction for Everyone (Coursera)

This three-module course introduces machine learning and data science for everyone with a foundational understanding of machine learning models. You’ll learn about the history of machine learning, applications of machine learning, the machine learning model lifecycle, and tools for machine learning. You’ll also learn about supervised versus unsupervised learning, classification, regression, evaluating machine learning models, and more.

Sep 14th 2026
3 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.

Sep 7th 2026
5-12 Weeks
Excel Essentials and Beyond (Coursera) Coursera
Board Infinity

Excel Essentials and Beyond (Coursera)

Dive into "Excel Essentials and Beyond", a comprehensive exploration of Excel, the world's leading spreadsheet tool. This course is thoughtfully crafted for both newcomers to Excel and also for those aiming for mastery. We begin by introducing Excel's robust interface and foundational features, ensuring a firm grasp of data organization techniques. As you advance, you'll delve into data visualization, transforming raw data into captivating stories.

Sep 14th 2026
5-12 Weeks
Exam Prep DP-300: Azure Database Administrator Associate (Coursera) Coursera
Whizlabs

Exam Prep DP-300: Azure Database Administrator Associate (Coursera)

Database administration is one of the basic necessities of every enterprise. The growth of cloud and On-premises relational databases continues to create the need for professional database administrators. Therefore, an updated certification such as DP-300 could open up favorable options for employment of database administrators.

Sep 14th 2026
5-12 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
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.

Sep 14th 2026
3 Weeks
Data Science in Stratified Healthcare and Precision Medicine (Coursera) Coursera
University of Edinburgh

Data Science in Stratified Healthcare and Precision Medicine (Coursera)

An increasing volume of data is becoming available in biomedicine and healthcare, from genomic data, to electronic patient records and data collected by wearable devices. Recent advances in data science are transforming the life sciences, leading to precision medicine and stratified healthcare. In this course, you will learn about some of the different types of data and computational methods involved in stratified healthcare and precision medicine.

Sep 7th 2026
5-12 Weeks
Excel aplicado a los negocios (Nivel Avanzado) (Coursera) Coursera
Universidad Austral

Excel aplicado a los negocios (Nivel Avanzado) (Coursera)

Objetivos Generales: Al finalizar el curso, podrás: 1.- ENTENDER y profundizar convenientemente aspectos específicos de diferentes formas de trabajo (individual o grupal), 2.- EVALUAR el uso de funciones avanzadas para manipular datos y CREAR tus propios análisis utilizando técnicas específicas tales como tablas dinámicas, análisis de hipótesis, administración de escenarios, tablas de simple y doble entrada, análisis de optimización de recursos. 3.- ANALIZAR cómo vincular Excel con otras aplicaciones importando información desde archivos de texto y bases de datos, exportando información a archivos de texto de diversas formas. 4.- ENTENDER el uso de macros lo que te permitirá vislumbrar otro universo de aplicaciones que harán mucho más productiva tu labor.

Sep 7th 2026
5-12 Weeks
Ferramentas para Ciência de Dados: Introdução ao R (Coursera) Coursera
FIA Business School

Ferramentas para Ciência de Dados: Introdução ao R (Coursera)

Nossas boas-vindas ao Curso Ferramentas para Ciência de Dados: Introdução ao R. Neste curso, você aprenderá que o mundo evoluiu muito quando o assunto é tomada de decisão baseada em dados e já não é possível comparar a quantidade de informações a que temos acesso atualmente com o que tínhamos disponíveis décadas atrás.

Sep 7th 2026
4 Weeks