SQL Category
SQL resources
Learn SQL to manage and query relational databases.
Available sections
Start with the fundamentals, then move into hands-on builds.
SQL Basics
5 resourcesIntroduces the fundamentals of SQL, including basic syntax, queries, and data retrieval.
Start learningSQL Data Manipulation
5 resourcesCovers inserting, updating, and deleting records in a database.
Start learningSQL Data Definition
5 resourcesCovers creating, modifying, and deleting database structures.
Start learningSQL Joins and Relationships
5 resourcesExplores different types of joins and their use in combining data from multiple tables.
Start learningSQL Aggregation and Grouping
5 resourcesIntroduces aggregation functions and grouping data for analysis.
Start learningSQL Subqueries and Nested Queries
5 resourcesExplores how to use subqueries and nested queries for advanced data retrieval.
Start learningSQL Indexes and Optimization
5 resourcesIntroduces SQL indexing concepts and query optimization techniques.
Start learningSQL Views and Stored Procedures
5 resourcesExplores the use of views and stored procedures for managing data.
Start learningSQL Triggers and Events
5 resourcesCovers creating and using triggers and events for automated database actions.
Start learningSQL Security and Access Control
5 resourcesExplores securing SQL databases and managing user access.
Start learningAdvanced SQL Concepts
5 resourcesCovers advanced SQL techniques and best practices for efficient querying.
Start learningSQL Data Warehousing
5 resourcesExplores data warehousing concepts, ETL processes, and OLAP in SQL.
Start learningRelated topics
Keep learning with adjacent tracks.
Popular tools
Helpful utilities for quick tasks.
Latest articles
Fresh insights from the CodiWiki team.
AI in Drug Discovery: Accelerating Medical Breakthroughs
In the rapidly evolving landscape of healthcare and pharmaceuticals, Artificial Intelligence (AI) in drug dis…
Read articleAI in Retail: Personalized Shopping and Inventory Management
In the rapidly evolving retail landscape, the integration of Artificial Intelligence (AI) is revolutionizing …
Read articleAI in Public Safety: Predictive Policing and Crime Prevention
In the realm of public safety, the integration of Artificial Intelligence (AI) stands as a beacon of innovati…
Read articleAI in Mental Health: Assisting with Therapy and Diagnostics
In the realm of mental health, the integration of Artificial Intelligence (AI) stands as a beacon of hope and…
Read articleAI in Legal Compliance: Ensuring Regulatory Adherence
In an era where technology continually reshapes the boundaries of industries, Artificial Intelligence (AI) in…
Read article