SQL Tutorial

December 12, 2023

SQL Tutorials by Prepinsta: Learn SQL from the Basics to Advanced Topics for All Skill Levels

Our curated SQL tutorials are designed to cater to non CS-IT students, beginners, and experienced coders alike. Whether you’re new to coding or looking to add SQL as a valuable skill, our course covers everything from the fundamentals to advanced concepts. Start from scratch and gain the knowledge needed for effective data preparation and management.

SQL Tutorial for Beginers

SQL Tutorial

Time complexity in Data Structures and Algorithms (DSA) In Python refers to the measure of how the running time of an algorithm grows as the input size increases.

  • Introduction to SQL
  • SQL Syntax
SQL
SQL Select 1

SQL Database

Recursion in Data Structures and Algorithms (DSA) with Python is a programming technique where a function calls itself to solve a problem.

  • In Python, it’s essential to have a base case to prevent infinite recursion. Recursion is commonly used in solving problems like factorials, Fibonacci sequences, and tree traversals.

SQL SELECT (I)

Searching and sorting are fundamental operations in Data Structures and Algorithms (DSA) with Python. Searching involves finding a specific element within a collection of data, using techniques like linear or binary search.

  • Sorting arranges data in a specific order, such as ascending or descending, using algorithms like quicksort or mergesort. Efficient searching and sorting are crucial for optimizing data retrieval and organization in various applications.
  • SQL SELECT and SELECT WHERE
  • SQL AND, OR and NOT
  • SQL SELECT DISTINCT
  • SQL SELECT AS
  • SQL LIMIT, TOP and FETCH FIRST
  • SQL IN And NOT IN Operator
  • SQL BETWEEN Operator
  • SQL IS NULL and NOT NULL
  • SQL MIN() and MAX()
  • SQL COUNT()
  • SQL SUM() and AVG()
Searching and Sorting Python
SQL SELECT II

SQL SELECT (II)

In DSA with Python, a stack is a linear data structure that follows the Last-In-First-Out (LIFO) principle.

  • It’s like a stack of plates—items are added and removed from the top. Stacks are used for managing function calls, tracking history, and more.
  • SQL ORDER BY
  • SQL GROUP BY
  • SQL LIKE
  • SQL Wildcards
  • SQL UNION
  • SQL Subquery
  • SQL ANY and ALL
  • SQL CASE
  • SQL HAVING
  • SQL EXISTS

SQL JOIN

In DSA with Python, a queue is a linear data structure following the First-In-First-Out (FIFO) principle.

  • Elements are added at the rear and removed from the front. Queues are used for tasks like scheduling and managing data waiting to be processed.
  • SQL JOIN
  • SQL INNER JOIN
  • SQL LEFT JOIN
  • SQL RIGHT JOIN
  • SQL FULL OUTER JOIN
Queue DSA with Python
SQL CREATE INSERT

SQL Insert, Update and Delete

In Python, you can implement a linked list data structure using classes.

  • A linked list consists of nodes, where each node has two parts: data and a reference to the next node in the list.
  • SQL Insert Into
  • SQL Update
  • SQL Select Into
  • SQL Insert Into Select
  • SQL Delete and Truncate Rows

SQL Constraints

Trees are hierarchical data structures that consist of nodes connected by edges. They are used to represent hierarchical relationships, such as organizational structures, file systems, and more.

  • One of the most common types of trees is the binary tree, but there are various other types like binary search trees, AVL trees, B-trees, and more.
  • SQL Constraints
  • SQL Not Null Constraint
  • SQL Unique Constraints
  • SQL Primary Key
  • SQL Foreign Key
  • SQL Check
  • SQL Default
  • SQL Create Index
DSA Python Tree
Binary Search Tree In DSA Python

SQL Database & Table

A Binary Search Tree (BST) is a widely used data structure in computer science and programming. It is a type of binary tree with a specific property that makes it particularly useful for searching, sorting, and efficient data retrieval.

  • A BST is organized in a hierarchical manner, and each node in the tree has a value, a left subtree, and a right subtree.
  • SQL Create Table
  • SQL Drop Database
  • SQL Drop Table
  • SQL Alter Table
  • SQL Backup Database

SQL Additional Topics

Hashing in Python is a fundamental concept used for data storage, retrieval, and security. It involves mapping data of arbitrary size to fixed-size values (hash codes) using a hash function.

  • This process allows for efficient data retrieval and is commonly used in data structures like dictionaries and hash tables.
  • SQL Data Types
  • SQL Date and Time
  • SQL Operators
  • SQL Comments
  • SQL Views
  • SQL Stored Procedures
  • SQL Injection
Hashing - DSA in Python