75 docs tagged with "sql"

Learn how to modify existing tables using the ALTER TABLE command. Add columns, drop columns, and change data types without losing data. Complete.

Master BCA Semester 2 with comprehensive RDBMS tutorials, SQL programming, PL/SQL development, and database management. Complete VNSGU BCA student study guide.

Learn how to enforce business logic using CHECK constraints and automate data entry with DEFAULT values in SQL. Practical code guide & notes for student exams.

Understand the advanced types of database keys. Learn about Composite Keys, Alternate Keys, and Super Keys with real-world examples. Complete.

The definitive Computer Science glossary for GSEB, CBSE, ICSE & BCA students in Surat. Plain-language definitions for 50+ terms — OOP, JVM, recursion, SQL.

Learn how to create temporary tables for intermediate processing and how to copy tables for backup or testing purposes in SQL. Free student exam study guide.

Learn how to create a new SQL database using the CREATE DATABASE command. Includes syntax for MySQL, SQL Server, and PostgreSQL with best practices.

Master the CREATE TABLE command. Learn how to define columns, data types, and primary keys to build the structure of your database. Complete.

Learn professional techniques to identify and remove duplicate records from your SQL tables using CTEs, Row IDs, and Group By. Free student exam study guide.

Understand the difference between DROP, TRUNCATE, and DELETE. Learn when to use each command to remove tables or clear data efficiently. Complete.

Learn how to safely delete a database using the DROP DATABASE command. Understanding the risks and differences between DROP and Truncate. Complete.

Learn the foundational concepts of SQL (Structured Query Language). Understand relational databases, SQL syntax. Practical code guide & notes for student exams.

MySQL tutorial — the most popular open-source relational database. Covers setup, DDL, DML, SELECT queries, joins, and stored procedures with examples.

Master Oracle PL/SQL. Learn block structure, variables, cursors, and triggers using our story-driven roadmap. Perfect for BCA and enterprise database learners.

PostgreSQL tutorial — master the most advanced open-source relational database. Covers setup, DDL, DML, SELECT, joins, and PostgreSQL-specific features.

Master the most important SQL constraints: Primary Keys and Foreign Keys. Learn how to uniquely identify rows and link tables together safely.

Learn how to connect Python to databases. Master SQLite (built-in), MySQL, and MongoDB using the Digital Librarian scenario. Complete student exam study guide.

Your central resource for learning SQL and database management. Master universal concepts and explore dialect-specific features for Oracle, MySQL.

Learn how to use SQL aggregate functions to perform calculations on sets of values. In-depth guide to SUM, AVG, COUNT, MIN, and MAX. Complete.

Learn how to use SQL aliases to give temporary, readable names to your columns and tables. Perfect for complex joins and math operations. Complete.

Master the SQL AVG function. Learn how to calculate the arithmetic mean of a column and how to handle NULL values in your averages. Complete.

Learn how to create full and partial database backups in SQL using BACKUP DATABASE, pg_dump, and mysqldump commands with practical examples.

Master the CASE statement for If-Else logic in SQL. Learn how to use the EXISTS operator for efficient existence checks in subqueries. Complete.

Understand the 4 pillars of SQL commands: DDL (Structure), DML (Data), DCL (Permissions), and TCL (Transactions). A complete guide with examples.

SQL commands cheat sheet — DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE), SELECT with WHERE, JOIN, ORDER BY, and GROUP BY. Quick reference.

Learn how to enforce data integrity using SQL constraints. In-depth guide to NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK constraints.

Learn how to use SQL COUNT and SUM functions. Understand the difference between COUNT(*), COUNT(col), and calculating column totals. Complete.

Master the 4 core data operations in SQL: SELECT, INSERT, UPDATE, and DELETE. Learn how to manipulate data within your tables. Free student exam study guide.

Understand the different data types in SQL including CHAR, VARCHAR2, NUMBER, and DATE. Learn how to choose the right type for your database columns.

Master the administration of SQL databases. Learn how to create secure database containers, manage deletions, and perform essential backups.

Learn Data Definition Language (DDL) in Oracle. Master how to create, modify, and delete table structures using the Architect's Blueprint scenario.

Master the SQL DELETE command. Learn how to remove specific rows, clear entire tables, and understand the difference between hard and soft deletes.

Learn how to use the SELECT DISTINCT statement to retrieve unique values from a table. Understand how it works with multiple columns. Complete.

Master Data Manipulation Language (DML) in Oracle. Learn how to add, change, and remove data within your tables using the Warehouse Manager scenario.

Learn how to filter data in SQL using the WHERE clause. Master AND, OR, LIKE, and BETWEEN operators with the Police Investigation scenario. Complete.

Learn how to use the SQL GROUP BY clause to arrange identical data into groups. Often used with aggregate functions for reporting. Complete practical.

Learn how to summarize data in SQL using GROUP BY and aggregate functions like COUNT, SUM, and AVG. Includes the Class Report Card scenario.

Master the SQL HAVING clause. Learn why WHERE cannot be used with aggregates and how to filter your GROUP BY results effectively. Free student exam study guide.

Learn how to use SQL IN and BETWEEN operators to filter query results by specific lists or ranges. Simplify your WHERE clauses effectively. Complete.

Learn how SQL Indexes work. Understand Clustered vs. Non-Clustered indexes and how to speed up data retrieval in large databases. Free student exam study guide.

Master the SQL INNER JOIN. Learn how to combine rows from two or more tables based on a related column. Includes visual diagrams and syntax.

Learn how to add new records to your database using the SQL INSERT INTO statement. Covers syntax for partial and full row insertion. Complete.

Master SQL Joins with Venn diagrams and real-world scenarios. Learn how to combine data from multiple tables in Oracle, MySQL, and PostgreSQL.

Comprehensive SQL lab exercise for BCA Sem 2. Includes 23 solved queries covering Joins, Subqueries, and Aggregate Functions with an Employee-Project scenario.

Learn how to use the SQL LIKE operator with % and _ wildcards to perform powerful search queries. Find partial matches in names, emails, and codes.

Learn how to limit the number of rows returned by a query. Syntax for MySQL LIMIT, SQL Server TOP, and Oracle FETCH FIRST. Free practical study guide for exams.

Master SQL logical operators. Learn how to combine multiple conditions in a WHERE clause using AND, OR, and NOT with real-world scenarios. Complete.

Learn how to find the lowest and highest values in your database using SQL MIN and MAX. Works with numbers, strings, and dates. Free student exam study guide.

Learn how to insert multiple rows in a single query and how to copy data from one table to another using INSERT INTO SELECT. Complete student exam study guide.

Learn how to use NOT NULL and UNIQUE constraints in SQL to prevent missing data and duplicate entries. Includes syntax and practical examples.

Master the concept of NULL in SQL. Learn why you cannot use '=' with NULL and how to correctly filter unknown data using IS NULL and COALESCE.

A complete guide to SQL operators. Learn how to perform calculations, compare values, and combine logic using Arithmetic, Comparison, and Logical operators.

Learn how to sort your SQL results alphabetically, numerically, and by date using the ORDER BY clause. Covers ASC and DESC keywords. Complete.

Learn how to use SQL Left, Right, and Full Outer Joins to retrieve unmatched data. Understand how to handle NULL values in joined reports. Complete.

Learn how to use SQL clauses like WHERE, ORDER BY, and LIMIT to refine your search results and improve application performance. Free student exam study guide.

Master the fundamental SQL SELECT and FROM clauses. Learn how to extract data from tables using the Digital Filing Cabinet scenario. Complete.

A one-page SQL cheat sheet for students and developers. Quick lookup for SELECT, INSERT, JOIN, and Aggregate syntax. Free student notes & practical code guide.

Practice your SQL skills with our curated quiz and exercises. Covers basic querying, Joins, Aggregates, and Subqueries. Structured study material & code notes.

Learn how to use Recursive CTEs to query hierarchical data. Perfect for organizational charts, category trees, and graph data structures. Complete.

Your ultimate SQL reference library. Access quick-lookup guides for string functions, SQL keywords, and comprehensive cheat sheets for Oracle and MySQL.

Learn how to defend your database against SQL Injection attacks. Understand Prepared Statements, Parameterized Queries, and the principle of least privilege.

Master the SQL SELECT statement. Learn how to fetch specific columns, use aliases, and perform calculations on retrieved data. Free student exam study guide.

Master advanced SQL joins. Learn how to join a table to itself (Self Join) for hierarchies and how to create Cartesian products with Cross Join.

Learn how to combine query results using SQL Set operators. Understand the difference between UNION and UNION ALL, and how to use INTERSECT and MINUS.

Learn how to write and execute Stored Procedures in SQL. Understand parameters, modularity, and performance benefits of server-side code. Complete.

Master SQL string functions like UPPER, LOWER, TRIM, and SUBSTR. Learn how to format and extract text data effectively in Oracle and MySQL. Complete.

Master SQL Subqueries. Learn how to write queries within queries to solve complex data retrieval problems. Includes Correlated vs. Non-Correlated logic.

Master SQL Subqueries (Nested Queries). Learn how to use a query inside another query with the Inception scenario. Covers Oracle, MySQL, and PostgreSQL.

Master the fundamental syntax rules of SQL. Learn about keywords, identifiers, case sensitivity, semicolons, and comments in Oracle, MySQL, and SQL Server.

Learn how to manage the structure of your database using SQL DDL. Includes creating, altering, and dropping tables with data integrity. Complete.

Learn how to modify records in a table using the SQL UPDATE command. Understand how to update single or multiple columns safely with WHERE clauses.

Learn how to create, update, and drop SQL Views. Understand how Views act as a security layer and simplify complex Joins. Free student study notes & exam guide.

Master the SQL WHERE clause. Learn how to filter rows based on specific conditions using comparison and logical operators. Free practical study guide for exams.

Master the SQL WITH clause. Learn how to create Common Table Expressions (CTEs) to make complex queries readable and modular. Complete student exam study guide.

Free computer science tutorials, programming guides & board exam notes (GSEB, CBSE, ICSE, BCA). Master Python, Java, SQL, HTML, C/C++ with practical code.