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.