Skip to content
/ Databases-and-SQL-for-Data-Science-with-Python Public

Learn to work with databases and SQL using Python. Connect to databases, perform basic operations, write SQL queries to retrieve, filter, sort, group and join data. Cover advanced topics such as working with large datasets, optimizing queries, and using non-relational databases.

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

Shaharuf/Databases-and-SQL-for-Data-Science-with-Python

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
Databases and SQL for Data Science with Python-Peer Graded Assignment.ipynb
Databases and SQL for Data Science with Python-Peer Graded Assignment.ipynb
 
 
SWeek 3-QL-Cheat-Sheet-Functions.md.pdf
SWeek 3-QL-Cheat-Sheet-Functions.md.pdf
 
 
Week 1-Hands-on Lab-COUNT, DISTINCT, LIMIT.pdf
Week 1-Hands-on Lab-COUNT, DISTINCT, LIMIT.pdf
 
 
Week 1-Hands-on Lab-INSERT, UPDATE, and DELETE.pdf
Week 1-Hands-on Lab-INSERT, UPDATE, and DELETE.pdf
 
 
Week 1-Hands-on Lab-Simple SELECT Statements.pdf
Week 1-Hands-on Lab-Simple SELECT Statements.pdf
 
 
Week 1-SQL-Cheat-Sheet-Bascis.md.pdf
Week 1-SQL-Cheat-Sheet-Bascis.md.pdf
 
 
Week 2-Create_and _Load.md.pdf
Week 2-Create_and _Load.md.pdf
 
 
Week 2-DB0201-l2 _M2_CREATE_DROP.md.pdf
Week 2-DB0201-l2 _M2_CREATE_DROP.md.pdf
 
 
Week 2-Hands-on Lab-CREATE, ALTER, TRUNCATE, DROP.pdf
Week 2-Hands-on Lab-CREATE, ALTER, TRUNCATE, DROP.pdf
 
 
Week 2-Hands-on Lab-Create Tables using SQL Scripts and Load Data into Tables.pdf
Week 2-Hands-on Lab-Create Tables using SQL Scripts and Load Data into Tables.pdf
 
 
Week 2-Hands-on Lab-String Patterns, Sorting and Grouping-instructional-labs.md.pdf
Week 2-Hands-on Lab-String Patterns, Sorting and Grouping-instructional-labs.md.pdf
 
 
Week 2-SQL-Cheat-Sheet-Create-Table.md.pdf
Week 2-SQL-Cheat-Sheet-Create-Table.md.pdf
 
 
Week 2-instructional-labs.md.pdf
Week 2-instructional-labs.md.pdf
 
 
Week 3-Builtinfunctions.md.pdf
Week 3-Builtinfunctions.md.pdf
 
 
Week 3-Hands-on_Lab__Built-in_Functions.md.pdf
Week 3-Hands-on_Lab__Built-in_Functions.md.pdf
 
 
Week 3-SQL-Cheat-Sheet-Intermediate.md.pdf
Week 3-SQL-Cheat-Sheet-Intermediate.md.pdf
 
 
Week 3-Sorting_grouping.md.pdf
Week 3-Sorting_grouping.md.pdf
 
 
Week 3-instructional-labs.md.pdf
Week 3-instructional-labs.md.pdf
 
 
Week 3-multipletables_queries.md.pdf
Week 3-multipletables_queries.md.pdf
 
 
Week 3-subqueries_nestedselects.md.pdf
Week 3-subqueries_nestedselects.md.pdf
 
 
Week 4-Analyzing a real World Data Set-II.ipynb
Week 4-Analyzing a real World Data Set-II.ipynb
 
 
Week 4-Analyzing a real World Data Set.ipynb
Week 4-Analyzing a real World Data Set.ipynb
 
 
Week 4-Hands-on Lab Connecting to a database instance.ipynb
Week 4-Hands-on Lab Connecting to a database instance.ipynb
 
 
Week 4-Hands-on Lab Creating tables, inserting and querying Data.ipynb
Week 4-Hands-on Lab Creating tables, inserting and querying Data.ipynb
 
 
Week 4-Hands-on Tutorial Accessing Databases with SQL magic-II.ipynb
Week 4-Hands-on Tutorial Accessing Databases with SQL magic-II.ipynb
 
 
Week 4-Hands-on Tutorial Accessing Databases with SQL magic.ipynb
Week 4-Hands-on Tutorial Accessing Databases with SQL magic.ipynb
 
 
Week 4-IntroducingSQLMagic.md.pdf
Week 4-IntroducingSQLMagic.md.pdf
 
 
Week 4-LAB-0v6_Create_Database_Credentials.md.pdf
Week 4-LAB-0v6_Create_Database_Credentials.md.pdf
 
 
Week 5- Hands-on Lab-Working with a real world data-set.ipynb
Week 5- Hands-on Lab-Working with a real world data-set.ipynb
 
 
Week 5-Hands-on LabPeer graded assignment based on SQLite-II.ipynb
Week 5-Hands-on LabPeer graded assignment based on SQLite-II.ipynb
 
 
Week 5-Jupyter Notebook with Problems for Peer Reviewed Assignment.ipynb
Week 5-Jupyter Notebook with Problems for Peer Reviewed Assignment.ipynb
 
 
Week 5-Practice Querying Real World Datasets.ipynb
Week 5-Practice Querying Real World Datasets.ipynb
 
 
Week 5-Reading_Loading_Data.md.pdf
Week 5-Reading_Loading_Data.md.pdf
 
 
Week4_Insert_Update_SQLite.ipynb
Week4_Insert_Update_SQLite.ipynb
 
 

About

Learn to work with databases and SQL using Python. Connect to databases, perform basic operations, write SQL queries to retrieve, filter, sort, group and join data. Cover advanced topics such as working with large datasets, optimizing queries, and using non-relational databases.

Activity

Stars

2 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages