Lab Practice

General Notes

for more visit Omar Elgabry's Database Blog here

FOR MORE INFORMATION, EXAMPLES, AND EXCERSISES CHECK: w3schools' SQL Tutorial

Lab 1

Videos

Create Schema and table - MYSQL workbench

How to create database and tables in MySql Workbench 6.3 (Steps only, no audio)

How to Create Database and tables in MySql Workbench 8.0 (Part-4) + includes insetting data

Create MySQL Database - MySQL Workbench Tutorial

Websites

Lab 2

Videos

SQL Tutorial - 55: The ALTER TABLE Command

Constraints - SQL - Tutorial 8

Adding a check constraint - Part 6

SQL TUTORIAL-4 (Create table, Alter table, ADD and DROP column, MODIFY Column Data type)

Inserting Data - SQL - Tutorial 7

Websites

Lab 3

Videos

SQL Tutorial - 14: The SELECT Query

Select statement in sql server - Part 10

dml in sql with examples

SQL Advanced - SELECT queries (part 1)

SQL SELECT Tutorial |¦| SQL Tutorial |¦| SQL for Beginners

SQL SELECT Tutorial - Part 2 |¦| SQL Tutorial |¦| SQL for Beginners

SQL Tutorial - 19: The WHERE Clause

SQL Tutorial - 25: The ORDER BY Clause

SQL Tutorial - 23: The LIKE Operator and Wildcard Characters

SQL Tutorial for Beginners: Database, JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIKE, IN, BETWEEN (start from 15:40)

Websites

Lab 4

Videos

SQL Server video :- Explain aggregate functions, group by clause and having keyword ?

Aggregate Functions in SQL

aggregate functions in dbms

SQL Aggregation queries using Group By, Sum, Count and Having

DMS - Aggregate Functions in SQL

Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

EXIST Function in SQL

UNIQUE Function in SQL

Nested Queries | SQL | Tutorial 18

How to do Subqueries in SQL with Examples

63 - Oracle Subqueries - Nested Queries تعليم أوراكل

Websites

Lab 5

Videos

Triggers | SQL | Tutorial 20

SQL VIEWS + Complex Queries, Cross Joins, Unions, and more! |¦| SQL Tutorial

Triggers In SQL | Triggers In Database | SQL Triggers Tutorial For Beginners | Edureka

Joins | SQL | Tutorial 17

SQL: Understanding the JOIN clause in the SELECT statement

SQL Tutorial - CASE Statements

Writing CASE WHEN Statements in SQL (IF/THEN)

Simple Recursion in SQL

Part 3 How does a recursive CTE work

Websites

Lab 6

Videos

Chapter 6 - Relational Algebra - Select Operator - Part 1

Chapter 6 - Relational Algebra Operations - Union , Intersection , Difference - Part 4

relational algebra operations in dbms

CMU Database Systems - 02 Relational Algebra (Fall 2017)

Introduction to Tuple Relational Calculus

DBMS - Introduction to Relational Calculus

DBMS - Tuple Relational Calculus

DBMS - Select Operation in Relational Algebra

other operations in Tutorialspoint Indira's playlist DBMS in Simple Steps from video 37 to 54

Tuple Relational Calculus in dbms | TRC | Bhanu Priya

Relational Calculus | Database Management System

Websites

For more information refer to week 6 in Database Books & Resources and Database Notes

Lab 7

Videos

Functions | SQL | Tutorial 14

Scalar user defined functions in sql server Part 30

Creating And Using Functions in SQL - With Examples!!

SQL Stored Procedures - What They Are, Best Practices, Security, and More..

How to Write Stored Procedure in SQL Server for Beginners

Stored procedures in sql server Part 18

SQL Server Programming Part 1 - Stored Procedure Basics

Oracle interview question Procedure Vs Function | ORACLE PROCEDURE VS FUNCTIONS

Choosing Between Views, Functions, and Stored Procedures in SQL

differences between Stored Procedure and Functions in SQL || Interview Question

Websites

Lab 8

Videos

DBMS Indexing: The Basic Concept

Exercise On Disk Storage and indexing

Indexing in database example| dbms

DBMS - Disk Management

IT344 - Chapter 18 - Indexing Structures for Files - By Hala Ayash

IT344- Database Management Systems -- ch17 p1- Disk Storage, Basic File Structures, and Hashing

09 01 Understanding Indexes

09 02 Indexing Guidelines

09 03 Clustered or Non Clustered

Difference between clustered index and non clustered index

Clustered vs. Nonclustered Index Structures in SQL Server

Learning MySQL - Using Indexes

Websites

For more information refer to week 9 in Database Books & Resources and Database Notes

Page updated

Google Sites

Report abuse