Yandex

ProgramGuru

sql

Course Index

Basics of SQLBasics of SQL8
❯

  1. 1Introduction to SQL
  2. 2Installing SQL and Using SQL Tools
  3. 3SQL Syntax and Statements
  4. 4SQL Data Types
  5. 5CREATE TABLE Statement
  6. 6INSERT INTO Statement
  7. 7UPDATE Statement in SQL
  8. 8DELETE Statement in SQL

Querying DataQuerying Data10
❯

  1. 1SELECT Statement in SQL
  2. 2SQL WHERE Clause
  3. 3ORDER BY Clause in SQL
  4. 4GROUP BY Clause in SQL
  5. 5HAVING Clause in SQL
  6. 6LIMIT / TOP Clause in SQL
  7. 7DISTINCT Keyword in SQL
  8. 8SQL Operators - AND, OR, NOT, IN, BETWEEN, LIKE
  9. 9SQL Aliases
  10. 10SQL CASE Statement

SQL JoinsSQL Joins6
❯

  1. 1SQL INNER JOIN
  2. 2SQL LEFT JOIN
  3. 3SQL RIGHT JOIN
  4. 4SQL FULL OUTER JOIN
  5. 5SQL SELF JOIN
  6. 6SQL CROSS JOIN

Intermediate SQLIntermediate SQL6
❯

  1. 1SQL Subqueries
  2. 2SQL Views
  3. 3SQL Indexes
  4. 4SQL Constraints
  5. 5SQL Functions – String, Numeric, Date & Aggregate
  6. 6SQL NULL Handling – IS NULL, COALESCE, IFNULL

Advanced SQLAdvanced SQL7
❯

  1. 1SQL Stored Procedures
  2. 2SQL User Defined Functions (UDF)
  3. 3SQL Triggers
  4. 4SQL Transactions – COMMIT, ROLLBACK, SAVEPOINT
  5. 5SQL Cursors
  6. 6SQL Error Handling – BEGIN...HANDLER, SIGNAL
  7. 7Dynamic SQL

Database DesignDatabase Design5
❯

  1. 1Database Normalization – 1NF, 2NF, 3NF, BCNF
  2. 2SQL Denormalization
  3. 3ER Diagrams and Schema Design
  4. 4Primary Key vs Unique Key
  5. 5Foreign Keys and Relationships

OptimizationOptimization3
❯

  1. 1SQL Performance Tuning
  2. 2SQL Execution Plans
  3. 3Index Optimization in SQL

SecuritySecurity2
❯

  1. 1SQL Injection and Security
  2. 2User Management and Permissions in SQL

Advanced QueryingAdvanced Querying4
❯

  1. 1Common Table Expressions in SQL
  2. 2Window Functions in SQL – RANK, ROW_NUMBER, LEAD, LAG
  3. 3SQL Pivot and Unpivot
  4. 4Recursive Queries in SQL

IntegrationsIntegrations4
❯

  1. 1SQL with Python
  2. 2SQL with Java
  3. 3SQL with Excel
  4. 4Connecting to SQL Databases via JDBC/ODBC

Welcome to ProgramGuru

Sign up to start your journey with us

Support ProgramGuru.org❯

You can support this website with a contribution of your choice.

When making a contribution, mention your name, and programguru.org in the message. Your name shall be displayed in the sponsors list.

PayPal

UPI

PhonePe QR

MALLIKARJUNA M