Description
SQL (Structured Query Language), is used to store, modify, and retrieve data from relational databases. The Relation Database System's standard language is SQL. SQL is a standard database language used by all relational database management systems, including MySQL, MS Access, Oracle, Sybase, Informix, Postgres, and SQL Server.Why SQL?
- In relational database management systems, it enables users to access information.
- It enables users to explain the information.
- It enables users to define and modify the data in a database.
- It enables the use of SQL modules, libraries, and pre-compilers for embedding in other languages.
- Databases and tables can be created and dropped by users.
- In a database, it enables users to create views, stored procedures, and functions.
- Permissions for tables, procedures, and views can be set by users.
Target Audience
Data analysts, database administrators, and software developers who must work with and manage relational databases are the main SQL (Structured Query Language) target audience. In addition to these key groups, SQL is useful for cybersecurity experts for threat detection and incident response, as well as digital marketers for audience segmentation and targeting.Prerequisite
Database expertise is a crucial prerequisite for working with SQL, in addition to having a fundamental understanding of computers. A database is a group of organized information or data that is frequently kept on file in a computer system. The data contained in databases is typically structured in columns and rows in tables for ease of access, organization, and management. Database management systems typically oversee databases.Creating altering and dropping a database
Creating Table
SQL Constraints
SQL Identity Column
Super Key | Candidate Key | Primary Key | Composite Key | Unique Key | Foreign Key
SQL Temporary Table
SQL Select with Comparison Operator | Logical Operator
Like Command in SQL | Wildcard Characters
SQL EXIST and NOT EXIST Subqueries
SQL Cascade| Set Null | Set Default with DELETE & UPDATE
SQL String Functions
SQL CAST VS CONVERT Function
SQL Merge Statement
SQL Joins
SQL Derived Table
Data Integrity in DBMS | Entity Integrity | Domain Integrity | Referential Integrity
SQL Set Operators
SQL Indexes
SQL Group By | Where in Group By | Having in Group By | Order By in Group By
SQL Subquery
Sql window function
SQL Stored procedure
SQL Loops
SQL Case Statement
Difference between where and having clause
IF Else Nested in SQL
SQL Error Handling
SQL User Defined Function
SQL Views
SQL Triggers After
SQL Instead Of Trigger
SQL DDL Trigger
Convert data from Rows to Columns
SQL Sequence
SQL PIVOT Complex Query
Dynamic SQL
SQL Normalization
