Purpose & Basics Of SQL Database

Week 1:

• What is Database
• Basic Database Concepts DBMS, RDBMS
• Purpose of Database
• Advantages of Database
• Disadvantages of Database
• Difrerences in Database, files & Other Data Storages

Week 2:

• Installation of MS-SQL
• CREATE Database
• List or see Databases
• Use/Select Databases
• DROP/Delete Database
• CREATE TABLES/SQL Data Types
• Create Table Using Another Table
• DROP TABLE

Week 3:

• SQL SELECT
• SELECT DISTINCT
• Single, Multiple, All Coulumns
• Filter rows using SQL WHERE
• Operators in The WHERE
• AND/OR/NOT

Week 4:

• SQL ORDER BY/Sorting
• Data Insert using SQL INSERT
• Insert Multiple Rows
• SQL NULL Values/How to handel NULLs
• SQL UPDATE and DELETE
• SQL TOP, LIMIT

Week 5:

• SQL Aggrigate Functions
• MIN/MAX/AVG/SUM/COUNT
• SQL String funstions
• Left/Right/LEN/TRIM/
• Like/WildCards

Week 6:

• Working With Dates in SQL
• Column Calculations
• ALTER TABLE
• ADD/Drop Columns

Week 7:

• IN/Between Operator
• Aliase in SQL
• SQL Joins
• LEFT/RIGHT/INNER/FULL/SELF

Week 8:

• SQL UNION
• Group By
• HAVING Clause
• SQL CASE Expression
• Comments