SQL
Basically, SQL stands for Structured Query Language which is basically a language used by databases. This language allows to handle the information using tables and shows a language to query these tables and other objects related (views, functions, procedures, etc.). Most of the databases like SQL Server, Oracle, PostgreSQL, MySQL, MariaDB handle this language (with some extensions and variations) to handle the data.
MySQL is a Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). It is also free and open source and is commonly used with programs developed in PHP.
SQL (Structured Query Language) Syllabus
- Lesson 1. Introduction to SQL
- Lesson 2. What is SQL?
- Lesson 3. Purpose of SQL
- Lesson 4. Who should learn SQL?
- Lesson 5. What are the subsets of SQL?
- Lesson 6. Data Definition Language, Data Manipulation Language, Data Control Language, and SQL vs. NoSQL
Introduction to Databases and RDBMS
- Lesson 1. What is a Database?
- Lesson 2. Database Objects,
- Lesson 3. Database Tables,
- Lesson 4. Table Records,
- Lesson 5. Types of Database Management Systems,
- Lesson 6. Relational Database Management Systems.
- Lesson 7. How to Install Data Base
SQL Syntax
- Lesson 1. Focus on SQL Syntax,
- Lesson 2. SQL keywords,
- Lesson 3. SQL is not case sensitive,
- Lesson 4. SQL Comments, SQL Commands,
- Lesson 5. and writing SQL Statements.
SQL Data Types
- Lesson 1. SQL Numeric data types,
- Lesson 2. Date and Time data types,
- Lesson 3. Character and String data types,
- Lesson 4. Unicode character string data types,
- Lesson 5. Binary data types, and Miscellaneous data types.
SQL Oprators
- Lesson 1. SQL Arithmetic Operators,
- Lesson 2. Comparison Operators,
- Lesson 3. Logical Operators, and Bitwise Operators
SQL Expressions
- Lesson 1. SQL Boolean Expression,
- Lesson 2. SQL Numeric Expression,
- Lesson 3. SQL Date Expression
SQL Comments
- Lesson 1. Comments are used to explain sections of SQL statements,
- Lesson 2. prevent the execution of SQL statements.
- Lesson 3. Single-Line Comments, and Multi-line Comments
SQL - Data Defination Language and Operations
- Lesson 1. SQL Data Definition Language Commands
- Lesson 2. Create, Alter, Drop, Truncate, and Rename
- Lesson 3. Create a Database,
- Lesson 4. Use Database,
- Lesson 5. Rename a Database,
- Lesson 6. Drop Database,
- Lesson 7. Create a Table,
- Lesson 8. Rename Table,
- Lesson 9. Add a Column to exiting Table,
- Lesson 10. Add multiple columns to existing Table,
- Lesson 12. Modify an existing column,
- Lesson 13. Rename a Column,
- Lesson 14. Drop a Column,
- Lesson 15. Truncate a Table,
- Lesson 16. Drop a Table
SQL - Data Management Language Commands and Oprations
- Lesson 1. Data Manipulation Language Commands, SELECT, INSERT, UPDATE, and DELETE.
- Lesson 2. Data Manipulation Language Operations,
- Lesson 3. Retrieving data from a table
- Lesson 4. Inserting data into a table,
- Lesson 5. Updating existing data into a table,
- Lesson 6. Deleting all records from a table
SQL Functions
- Lesson 1. SQL Aggregate Functions
- Lesson 2. SQL String Functions,
- Lesson 3. SQL Date Functions, and SQL Scalar functions.
