Certificate IN DATA ANALYST ( S-SICT-DATA ANALYST )

·         What is SQL and its purpose?

·         Understanding relational databases

·         Setting up MySQL (or your preferred SQL environment)

Ø  Creating and Managing Databases

·         Creating a database

·         Setting default schema

·         Dropping a database (and why to be careful)

Ø  Creating and Managing Tables

·         Creating tables with different data types:

·         INT, VARCHAR, TEXT, ENUM, DATE, TIMESTAMP

·         Applying constraints:

·         PRIMARY KEY, AUTO_INCREMENT, NOT NULL, UNIQUE, DEFAULT

·         Foreign keys and referential integrity:

·         Defining foreign keys

·         Altering tables:

·         Adding, dropping, modifying columns

·         Renaming tables

Ø  Inserting Data

·         Insert data into tables:

·         Without specifying columns (full insert)

·         Best practice: specifying columns

·         Inserting multiple rows at once

Ø  Querying Data

·         SELECT basics:

·         Selecting all columns vs specific columns

·         Filtering data using WHERE:

·         Comparison operators (=, !=, <, >, <=, >=)

·         Handling NULL values

·         Using BETWEEN, IN, LIKE for filtering

·         Combining conditions with AND, OR

·         Sorting with ORDER BY

·         Limiting results with LIMIT

Ø  Updating and Deleting Data

·         Updating rows using UPDATE

·         Deleting rows using DELETE

·         Deleting all rows but keeping table structure (TRUNCATE)

·         Dropping tables

·         Best practices to avoid accidental data loss

Ø  Joins and Combining Data

·         Understanding why joins are used

·         Types of joins:

·         INNER JOIN

·         LEFT JOIN

·         RIGHT JOIN

·         (Overview of FULL JOIN)

·         Using JOIN with ON and USING

·         Cross joins and self joins

·         Practical examples

Ø  Using Subqueries

·         What are subqueries?

·         Types of subqueries:

·         Scalar, row, and table subqueries

·         Subqueries in WHERE, FROM clauses

·         Examples and when to use subqueries vs joins

Ø  SQL Functions

·         Aggregate functions: COUNT(), SUM(), AVG(), MIN(), MAX()

·         String functions: LENGTH(), LOWER(), UPPER(), CONCAT()

·         Date functions: NOW(), CURDATE(), YEAR(), DATEDIFF()

·         Mathematical functions: ROUND(), CEIL(), FLOOR(), MOD()

·         Conditional functions: IF()

Ø  Date Conversion and Formatting

·         Converting strings to dates

·         Formatting date outputs

·         Calculating date differences

Ø  Exploring Database Structure

·         Listing all tables in a database:

·         Viewing the structure of a table:

·         Using these commands to understand existing databases

Exporting and Importing Data

• Exporting or importing query results to CSV or other formats

Ø  Introduction to EER Diagrams

Ø  Practice exercises (provided separately)

Ø  Sample databases for hands-on learning