Skip to content
/ LearningSQLByDoing Public

This Repository is created to understand the working of SQL (MySQL DB used for reference.).

1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

razat-thapar/LearningSQLByDoing

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits

media

media

 
 

01-a-intro-to-dbms-sql.md

01-a-intro-to-dbms-sql.md

 
 

01-b-data-Integrity-and-ER-Diagrams.md

01-b-data-Integrity-and-ER-Diagrams.md

 
 

01-c-normalisation-and-crud-operations.md

01-c-normalisation-and-crud-operations.md

 
 

02-crud-operations.md

02-crud-operations.md

 
 

03-crud2.md

03-crud2.md

 
 

04-joins-2.md

04-joins-2.md

 
 

04-joins-aggregation.md

04-joins-aggregation.md

 
 

05-aggregate-subqueries.md

05-aggregate-subqueries.md

 
 

05-subqueries-mysql_functions.md

05-subqueries-mysql_functions.md

 
 

06-indexing.md

06-indexing.md

 
 

07-transactions-and-indexing-with-diagrams.md

07-transactions-and-indexing-with-diagrams.md

 
 

07-transactions.md

07-transactions.md

 
 

08-schema-design-a-case-study.md

08-schema-design-a-case-study.md

 
 

08-schema-design1.md

08-schema-design1.md

 
 

09-schema-design.md

09-schema-design.md

 
 

10-views-and-window-function.md

10-views-and-window-function.md

 
 

11-views-and-queryOptimization.md

11-views-and-queryOptimization.md

 
 

Deadlock_Session1.sql

Deadlock_Session1.sql

 
 

Deadlock_Session2.sql

Deadlock_Session2.sql

 
 

README.md

README.md

 
 

Read_Committed_Isolation_Level_Scenarios_Session1.sql

Read_Committed_Isolation_Level_Scenarios_Session1.sql

 
 

Read_Committed_Isolation_Level_Scenarios_Session2.sql

Read_Committed_Isolation_Level_Scenarios_Session2.sql

 
 

Read_Uncommitted_Isolation_Level_Scenarios_Session1.sql

Read_Uncommitted_Isolation_Level_Scenarios_Session1.sql

 
 

Read_Uncommitted_Isolation_Level_Scenarios_Session2.sql

Read_Uncommitted_Isolation_Level_Scenarios_Session2.sql

 
 

Repeatable_Read_Isolation_Level_Scenarios_Session1.sql

Repeatable_Read_Isolation_Level_Scenarios_Session1.sql

 
 

Repeatable_Read_Isolation_Level_Scenarios_Session2.sql

Repeatable_Read_Isolation_Level_Scenarios_Session2.sql

 
 

Serializable_Isolation_Level_Scenarios_Session1.sql

Serializable_Isolation_Level_Scenarios_Session1.sql

 
 

Serializable_Isolation_Level_Scenarios_Session2.sql

Serializable_Isolation_Level_Scenarios_Session2.sql

 
 

aggregateQueries.sql

aggregateQueries.sql

 
 

atomicity_using_transaction_demo.sql

atomicity_using_transaction_demo.sql

 
 

crud.sql

crud.sql

 
 

foreignkey.sql

foreignkey.sql

 
 

indexing.sql

indexing.sql

 
 

joins.sql

joins.sql

 
 

subqueries.sql

subqueries.sql

 
 

transactions.sql

transactions.sql

 
 

Repository files navigation

LearningSQLByDoing

  • This Repository is created to understand the working of SQL (MySQL DB used for reference.).

About

This Repository is created to understand the working of SQL (MySQL DB used for reference.).

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published