Course Overview

• What is SQL?
• Introduction to SQL
• Introduction to Structured Query Language
• What Can SQL do?
• What is Data Base and Table
• Explain SQL Data Types like string, number, date Data types.
• SQL Commands: DDL, DML, and DCL
• Data Retrieval with SELECT Statement
• SELECT Statements Rules
• SQL Operators
• Arithmetic Operators
• Logical Operators
• Comparison Operators
• Concatenate Operator: ||
• Introduction to SQL Functions like String, Numeric, Date and Time Conversion, Aggregate, Date Functions, Aggregate Functions
• What is GROUP BY and Having Clause
• Conditional Statements in SQL
• Explain Different Types of SQL JOINs
• Explain Views