SQL Tutorial for Beginners | SQL for Database Developers, Database Testers, and DBA. | смотреть онлайн

https://www.gcreddy.com/2022/10/sql-tutorial-for-beginners.html

SQL (Structured Query Language) is a standard language for storing, manipulating, and retrieving data in relational databases.

SQL was initially developed at IBM in the 1970s, It became a standard of the American National Standards Institute (ANSI) in 1986.

SQL is the standard database language for Relational Database Management Systems (RDBMS) like Oracle, MySQL, MS SQL Server, MS Access, IBM DB2, Informix, and PostgreSQL, etc.

Although most database management systems use SQL, most of them also have their own additional proprietary extensions that are used on their system only. ex: Pl/SQL in Oracle, Transact-SQL in MS SQL Server.

Subsets of SQL are Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL).

SQL Skills are required for Database Developers, Database Administrators, and Database Testers (Manual Testers and Automated Testers).

1. Introduction to Databases and RDBMS
2. Introduction to SQL
3. Install a Database Engine
4. SQL Syntax
5. SQL Data Types
6. SQL Operators
7. SQL – Data Definition Language
8. SQL – Data Manipulation Language
9. SQL – Data Control Language
10. SQL Functions
11. SQL Stored Procedures
12. SQL Queries and Sub Queries
13. SQL Clauses
14. SQL Joins
15. SQL Views
16. SQL Indexes
17. SQL Transactions
18. SQL Injection
19. SQL Triggers
20. SQL vs. NoSQL