SQL Self Learning

These self-learning notes consist of a complete guide that is suitable for a beginner who has the desire to learn about SQL.

Items in the note:
1. Microsoft SQL Server & SSMS Installation on Windows 10/11 (Notes & Video)
2. Import CSV files into Microsoft SQL (Notes & Video)
3. SQL Coding (Notes)
4. Database Excel
5. SQL Database

The explanation for each item:

1. Microsoft SQL Server & SSMS Installation on Windows 10/11
A complete guide screen by screen on how to install the Microsoft SQL Server and SSMS
Contents:
a. MICROSOFT SQL SERVER INSTALLATION
b. SQL SERVER MANAGEMENT STUDIO (SSMS) INSTALLATION

2. Import CSV files into Microsoft SQL
A complete guide on how to import data from a CSV file
Contents:
a. MICROSOFT SQL SERVER INSTALLATION
b. SQL SERVER MANAGEMENT STUDIO (SSMS) INSTALLATION

3. Notes of SQL coding that included 32 SQL Statements together with examples and the output:
SQL SELECT Statement SQL JOIN
SQL SELECT DISTINCT Statement SQL INNER JOIN Keyword
SQL WHERE Clause SQL LEFT JOIN Keyword
SQL AND, OR and NOT Operators SQL RIGHT JOIN Keyword
SQL ORDER BY Keyword SQL FULL OUTER JOIN Keyword
SQL INSERT INTO Statement SQL Self Join
SQL NULL Values SQL UNION Operator
SQL UPDATE Statement SQL GROUP BY Statement
SQL DELETE Statement SQL HAVING Clause
SQL TOP Clause SQL EXISTS Operator
SQL SELECT TOP Clause SQL ANY and ALL Operator
SQL MIN() and MAX() Functions SQL SELECT INTO Statement
SQL COUNT(), AVG() and SUM() Functions SQL INSERT INTO SELECT Statement
SQL LIKE Operator SQL CASE Expression
SQL Wildcard Characters SQL Stored Procedures for SQL Server
SQL IN Operator SQL Comments
SQL BETWEEN Operator SQL Operators
SQL Aliases

4. Database excel
8 excel sheets that contain data which use in the SQL Coding note:
a. Customers table
b. Products table
c. Categories table
d. OrderDetails table
e. Supplier table
f. Orders table
g. Shipper table
h. Employees table

5. SQL Database
SQL CREATE DATABASE Statement SQL DROP DATABASE Statement
SQL BACKUP DATABASE Statement SQL BACKUP Statement
SQL BACKUP WITH DIFFERENTIAL Statement SQL CREATE TABLE Statement
SQL DROP and TRUNCATE TABLE Statement SQL ALTER TABLE Statement
SQL Create Constraints SQL NOT NULL Constraint
SQL UNIQUE Constraint SQL PRIMARY KEY Constraint
SQL FOREIGN KEY Constraint SQL CHECK Constraint
SQL DEFAULT Constraint SQL CREATE INDEX Statement
SQL AUTO INCREMENT Field SQL Dates
SQL Date Data Types SQL VIEWS
SQL Injection SQL Hosting