Week 1: SQL Course Overview

Welcome to Week 1 of your SQL learning journey!

This week introduces you to the solid foundation for understanding databases, the power of SQL and how to start writing basic commands to manage and query data. By the end of the week, you will have your SQL environment set up and be comfortable with fundamental SQL operations.

Day 1 – Introduction to Databases

Get introduced to the concept of databases, their types, and the career opportunities SQL offers.

• What is a Database?
• Types of Databases
• SQL Career Path: Roles, Skills & Salaries

Day 2 – Getting Started with SQL

Understand about SQL fundamentals and knowledge of Database Management Systems (DBMS).

• What is SQL?
• Introduction to DBMS (Database Management System)

Day 3 – Setting Up SQL Environment

Learn to install and manage your SQL server and connect to it via command line.

• Install MySQL on Windows
• Start & Stop MySQL Server
• Connecting to MySQL Using Command Line Options

Day 4 – Basic SQL Commands: DDL

Begin working with Data Definition Language (DDL) commands to create and modify database structures.

• CREATE and ALTER Commands
• DROP and TRUNCATE Commands
• SQL Data Types
• CREATE TABLE Statement

Day 5 – Basic SQL Commands: DML

Learn Data Manipulation Language (DML) commands to insert, update, and delete data in your tables.

• INSERT INTO Statement
• UPDATE Statement
• DELETE Statement

Day 6 – Querying with SELECT

Start querying data using the SELECT statement and explore common clauses to filter and sort results.

• Basic SELECT Query
• SELECT DISTINCT
• Using Aliases
• WHERE Clause
• ORDER BY Clause

Day 7 – SQL Operators

Explore various SQL operators to build more powerful and precise queries.

• Overview of SQL Operators
• Comparison Operators
• Logical Operators
• Arithmetic Operators