Skip to content
/ MY-SQL Public

SQL Exercise Repository - Sharpen Your Skills! Welcome to the SQL Exercise Repository! This repository is designed to help you practice and enhance your SQL skills. Whether you're a beginner looking to learn the basics or an experienced developer aiming to sharpen your SQL proficiency.

Notifications You must be signed in to change notification settings

Aradata/MY-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

MY SQL

SQL Exercise Repository

Welcome to the SQL Exercise Repository! This repository is designed to help you practice and enhance your SQL skills. Whether you're a beginner looking to learn the basics or an experienced developer aiming to sharpen your SQL proficiency, you'll find a variety of exercises covering a wide range of topics.

Table of Contents Introduction Getting Started Exercise Topics Basic SQL Operations WHERE Clause and Operators CREATE and INSERT Statements JOIN Types ORDER BY Temporary Tables Window Functions and Case Statements Math Functions GROUP BY and Aggregate Functions Table Views and Connecting SQL to Python Contributing

Introduction This repository contains a series of SQL exercises to help you practice and improve your SQL skills. Each exercise is designed to focus on specific aspects of SQL, from basic operations to more advanced topics like window functions, joins, and connecting SQL to Python.

Getting Started To get started, clone this repository to your local machine:

https://github.com/Aradata/MY-SQL

Navigate to the repository and explore the exercises in the relevant folders. Each exercise may include SQL scripts, sample data, and instructions to guide you through the process.

Exercise Topics Basic SQL Operations Understand and practice fundamental SQL operations.

WHERE Clause and Operators Learn how to filter data using the WHERE clause and various operators.

CREATE and INSERT Statements Practice creating tables and inserting data into them.

JOIN Types Explore different types of joins (INNER, LEFT, RIGHT, FULL) to combine data from multiple tables.

ORDER BY Sort query results using the ORDER BY clause.

Temporary Tables Use temporary tables to store and manipulate intermediate results.

Window Functions and Case Statements Learn about window functions and use case statements for conditional logic.

Math Functions Explore mathematical functions available in SQL.

GROUP BY and Aggregate Functions Group data and perform aggregate functions like SUM, AVG, COUNT, etc.

Table Views and Connecting SQL to Python Create and use table views and explore how to connect SQL to Python.

**Contributing **Contributions are welcome! If you have additional exercises, improvements, or corrections, please submit a pull request.

About

SQL Exercise Repository - Sharpen Your Skills! Welcome to the SQL Exercise Repository! This repository is designed to help you practice and enhance your SQL skills. Whether you're a beginner looking to learn the basics or an experienced developer aiming to sharpen your SQL proficiency.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published