My SQL

Introduction to My SQL

• What is SQL?
• SQL applications.
• SQL v/s NoSQL.
• Types of SQL Commands.
• Some of The Most Important SQL Commands.
  • SELECT.
  • UPDATE.
  • DELETE.
  • INSERT INTO.
  • CREATE DATABASE.
  • ALTER DATABASE.
  • CREATE TABLE.
  • ALTER TABLE.
  • DROP TABLE.
• What Can SQL do?

Introduction to Database and Data

• What is Database?
• What Is data?
• Excel v/s Database.
• DATA TYPES
  • String char varchar etc
  • Numeric int float bool etc
  • Date and time date datetime etc

Database CreationCommands

• How To Create Database.
• How To Execute Database.
• How To Drop Database.
• How To Rename Database.
• How To USE Database.

Table Creation Commands

• How To Create Table.
• How To Insert Values in Table.
• How To select all the available fields in the table.
• How To Update Values in Table.
• How To Alter Table.
• How To Delete Values in Table.
• How To Drop Values in Table.
• How To Rename Column name.
• How To Drop Column from Table.
• How To Truncate Table.
• How To Drop Table.

Introduction to Constraints

• What is Constraints?
• Types Of Constraints.
• 1. NOT NULL Constraint
  • NOT NULL With Table Creation.
  • NOT NULL on ALTER TABLE
• 2. UNIQUE KEY Constraint.
  • Unique constraint With Table Creation.
  • Unique constraint on ALTER TABLE.
  • How to Drop Unique key constraint?
• 3. PRIMARY KEY Constraint.
  • Primary constraint With Table Creation.
  • Primary constraint on ALTER TABLE.
  • How to Drop primary key constraint?
• 4. CHECK Constraint.
  • Check constraint With Table Creation.
  • Check constraint on ALTER TABLE.
  • How to Drop Check constraint?
• 5. DEFAULT Constraint.
  • Default constraint With Table Creation.
  • Default constraint on ALTER TABLE.

SQL CLAUSE

• SELECT Clause
• WHERE Clause
• ORDER BY clause
• GROUP BY Clause
• HAVING Clause

Import Excel File To SQL

• Import Excel File To SQL.
• Export SQL File to Excel.

SQL Operators

• What is operators?
• What is the type of operators?
• Arithmetic Operators.
• Comparison Operators.
• SQL Logical Operators.

SQL Functions

• What is Function?
• What are The Type of Function.
• SQL String Functions.
  • CONCAT ().
  • LEN ().
  • LEFT ().
  • LOWER ().
  • RIGHT ().
  • SUBSTRING ().
  • UPPER ().
• SQL Aggregate /Numeric Functions.
  ABS ().
  • AVG ().
  • COUNT ().
  • COS ().
  • COT ().
  • MAX ().
  • MIN ().
  • POWER ().
  • ROUND ().
  • SUM ().
  • SQRT ().
  • TAN ().
• SQL Date Function.
  DAY ().
  • MONTH ().
  • YEAR ().
  • EOMONTH ().
  • GETDATE ().
  • DATEADD ().
  • DATEDIFF ().

SQL JOINS

• WHAT IS JOINS?
• EXAMPLES OF JOINS.
• JOIN TYPES.
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
• What is Inner Join?
• What is Left Join?
• What is Right Join?
• What is Full Join?
• What is Cross join?

CASE Expression

• What is CASE Expression?
• CASE Expression Syntax.
• CASE Expression Examples.

SQL Backup and Restore

• How to Backup SQL Database.
• How to Restore SQL Database.