Скачать или смотреть How to Fire SQL Queries🔥 in Your IDE: Tips and Tricks for Database ManagementI

In this tutorial, you'll learn how to connect your database to your IDE (Integrated Development Environment) so that you can access and manage your database within your development environment.

We'll walk you through the process step-by-step, using popular IDEs such as Jupyter notebook, and cover how to connect to different types of databases including PostgreSQL.

By the end of this video, you'll have a clear understanding of how to set up a connection between your database and IDE, making it easier to develop and maintain your database-driven applications.

Timestamp:
00:00 | Basic EDA questions in SQL
00:25 | Check data type
02:26 | Check Null values
05:32 | Seperate integer and object columns
07:26 | Use pd.read_sql_query()
08:18 | Seperate object by using pd.read_sql_query()
10:23 | Complete code to use pandas only
11:30 | Find Highest Salary
16:47 | Top 5 salary candidate
17:44 | 5 lowest salary
18:32 | Display data from highest salary to lowest
18:40 | Find count of people from particular city
23:00 | Find count of people from particular department
24:00 | GRAPHS - Bar Plot
25:58 | GRAPHS - Pie chart

source code - https://github.com/sagarbhamburkarYT/...


(Content language : MARATHI)
Queries to be solved :
How to connect with your database
How to fire your sql query in jupyter notebook
Python code to fetch a data from database with your credentials.
Basics of EDA
Check null values
Separate integer and object columns using List comprehension
Find out highest Salary
Find out Highest Percentage
Find out low salary
Find out top 5 Salary
Display a data from highest salary to lowest
Find count of people from particular city
Find count of particular department
How to use groupby, order by, ASC, DESC
-----------------------------------------------------------------------------------------------------------------------
Basics of EDA -
Connect Your Database to Your IDE Part-1 -    • How to Connect Your Database to Your IDE 🖥...  

• Unlock the Basics...
List Comprehension -

• 30 examples of Li...
Lambda Part 1 -

• Python Lambda wit...
Lambda Part 2 -

• Python Lambda wit...
Lambda Part 3 -

• Python Lambda wit...

-----------------------------------------------------------------------------------------------------------------------
Stay Connected With Me :

Instagram :   / sagar_bhamb.  .
Id : sagar_bhamburkar
Contact : [email protected]

Thanks for Watching 😊
============================================================
#youtube #datascience #sql #sagarbhamburkar #python