Skip to content

Akshen22/Beginner-to-Advance-MySQL-Notes

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

134 Commits
classicmodelsdatabase
classicmodelsdatabase
 
 
hr database
hr database
 
 
(1) DDL Columns Attributes.sql
(1) DDL Columns Attributes.sql
 
 
(2) DML Rows.sql
(2) DML Rows.sql
 
 
(3) Query(Select).sql
(3) Query(Select).sql
 
 
(4) Constraints.sql
(4) Constraints.sql
 
 
(5) Set Operations.sql
(5) Set Operations.sql
 
 
(6) Missing Value.sql
(6) Missing Value.sql
 
 
(7) Duplicate Rows and Operations Precedence.sql
(7) Duplicate Rows and Operations Precedence.sql
 
 
(8) Constraints 2.sql
(8) Constraints 2.sql
 
 
(9) Practise.sql
(9) Practise.sql
 
 
10) String function.sql
10) String function.sql
 
 
11) Numeric Function.sql
11) Numeric Function.sql
 
 
12) Date Function.sql
12) Date Function.sql
 
 
13) Advance function.sql
13) Advance function.sql
 
 
14) Aggregate Function(groupby).sql
14) Aggregate Function(groupby).sql
 
 
15) Aggregate Function 2.sql
15) Aggregate Function 2.sql
 
 
16) Group by.sql
16) Group by.sql
 
 
17) Joins.sql
17) Joins.sql
 
 
18) Natural & Equi Joins.sql
18) Natural & Equi Joins.sql
 
 
19) Practise joins.sql
19) Practise joins.sql
 
 
20) Classicmodels database joins.sql
20) Classicmodels database joins.sql
 
 
21) in,any,all,exists subquery.sql
21) in,any,all,exists subquery.sql
 
 
22) Types of Subquery.sql
22) Types of Subquery.sql
 
 
23) Single row, Multi rows subquery.sql
23) Single row, Multi rows subquery.sql
 
 
24) From & With clause Subquery 5.sql
24) From & With clause Subquery 5.sql
 
 
25) Windows Functions.sql
25) Windows Functions.sql
 
 
26) Subquery Practise 1.sql
26) Subquery Practise 1.sql
 
 
27) Subquery Practise 2.sql
27) Subquery Practise 2.sql
 
 
28) Subquery Practise 3.sql
28) Subquery Practise 3.sql
 
 
29) Subquery Practise 4.sql
29) Subquery Practise 4.sql
 
 
30) Anomaly, Normalization, Data Integrity.sql
30) Anomaly, Normalization, Data Integrity.sql
 
 
31) TCL.sql
31) TCL.sql
 
 
32) ACID.sql
32) ACID.sql
 
 
33) Isolation hands on practise.sql
33) Isolation hands on practise.sql
 
 
34) Locking.sql
34) Locking.sql
 
 
35) View.sql
35) View.sql
 
 
LICENSE
LICENSE
 
 
README.md
README.md
 
 
SECURITY.md
SECURITY.md
 
 
SQL.pdf
SQL.pdf
 
 

Repository files navigation

🚀 Welcome to the SQL Mastery Repository! 🚀

Embark on a journey of SQL expertise with this comprehensive collection of topic-wise files designed to elevate your database skills. 📊✨ I've meticulously compiled a range of SQL concepts, ensuring a clear and structured approach to learning. Whether you're a seasoned developer or just starting, this repository is your go-to resource for mastering the art of SQL.

Explore the intricacies of database management, from fundamental queries to advanced topics, all neatly organized for a seamless learning experience. Each file dives deep into a specific SQL concept, providing explanations, examples, and hands-on exercises to solidify your understanding.

🌐 Why Dive In?

  • Structured Learning: Navigate through a well-organized repository, covering everything from basic SELECT statements to complex JOIN operations.
  • Hands-On Practice: Reinforce your knowledge with practical examples and exercises, ensuring a hands-on understanding of each concept.
  • Comprehensive Coverage: No SQL stone left unturned! From data manipulation to database design principles, find it all in one place.

🔥 How to Use This Repository:

  1. 📂 Browse by Topic: Easily locate the SQL concept you want to explore.
  2. 📖 Read the Explanation: Dive into the theory, accompanied by real-world examples.
  3. 💻 Practice with Code: Apply your knowledge using provided code snippets and exercises.

🌈 Your SQL Mastery Awaits! Whether you're building on your existing skills or starting from scratch, this repository is your companion in mastering SQL. Let the journey begin! 🚀

Feel free to contribute, share your insights, or raise issues. Let's collectively enhance our SQL expertise and make this repository a dynamic hub for SQL enthusiasts.

Contact: akshendhami@gmail.com, https://www.linkedin.com/in/akshen-dhami22

Happy coding! 🎉✨

About

🚀 Welcome to the SQL Mastery Repository! 🚀

Topics

mysql query sql string date view dml tcl numeric locking constraints ddl acid joins isolation groupby subquery windowsfunction

Resources

Readme

License

MIT license

Security policy

Security policy
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published