SQL Programming Resources
SELECT * FROM products LIMIT 10;
--This retrieves the first 10 rows from the "products" table.
👍12❤4
Use the ORDER BY clause to sort the results in ascending or descending order.
👍11❤4
INSERT INTO employees (first_name, last_name) VALUES ('John', 'Doe');
--This inserts a new employee named John Doe into the "employees" table.
--This inserts a new employee named John Doe into the "employees" table.
👍6❤4
UPDATE customers SET email = 'new@email.com' WHERE customer_id = 123;
--This updates the email address for the customer with ID 123.
--This updates the email address for the customer with ID 123.
👍6
Joins allow you to combine data from multiple tables based on related columns
👍10
Forwarded from Data Analytics
SQL Notes PART-4
Data Wrangling functions on string data types 😄👍
Data Wrangling functions on string data types 😄👍
👍9❤3
Free resources to learn SQL
Udacity free course- https://imp.i115008.net/AoAg7K
For Practice- https://stratascratch.com/?via=free
Udacity free course- https://imp.i115008.net/AoAg7K
For Practice- https://stratascratch.com/?via=free
👍13❤3
If you are trying to transition into the data analytics domain and getting started with SQL, focus on the most useful concept that will help you solve the majority of the problems, and then try to learn the rest of the topics:
👉🏻 Basic Aggregation function:
1️⃣ AVG
2️⃣ COUNT
3️⃣ SUM
4️⃣ MIN
5️⃣ MAX
👉🏻 JOINS
1️⃣ Left
2️⃣ Inner
3️⃣ Self (Important, Practice questions on self join)
👉🏻 Windows Function (Important)
1️⃣ Learn how partitioning works
2️⃣ Learn the different use cases where Ranking/Numbering Functions are used? ( ROW_NUMBER,RANK, DENSE_RANK, NTILE)
3️⃣ Use Cases of LEAD & LAG functions
4️⃣ Use cases of Aggregate window functions
👉🏻 GROUP BY
👉🏻 WHERE vs HAVING
👉🏻 CASE STATEMENT
👉🏻 UNION vs Union ALL
👉🏻 LOGICAL OPERATORS
Other Commonly used functions:
👉🏻 IFNULL
👉🏻 COALESCE
👉🏻 ROUND
👉🏻 Working with Date Functions
1️⃣ EXTRACTING YEAR/MONTH/WEEK/DAY
2️⃣ Calculating date differences
👉🏻CTE
👉🏻Views & Triggers (optional)
Here is an amazing resources to learn & practice SQL: https://bit.ly/3FxxKPz
Share with credits: https://t.me/sqlspecialist
Hope it helps :)
👉🏻 Basic Aggregation function:
1️⃣ AVG
2️⃣ COUNT
3️⃣ SUM
4️⃣ MIN
5️⃣ MAX
👉🏻 JOINS
1️⃣ Left
2️⃣ Inner
3️⃣ Self (Important, Practice questions on self join)
👉🏻 Windows Function (Important)
1️⃣ Learn how partitioning works
2️⃣ Learn the different use cases where Ranking/Numbering Functions are used? ( ROW_NUMBER,RANK, DENSE_RANK, NTILE)
3️⃣ Use Cases of LEAD & LAG functions
4️⃣ Use cases of Aggregate window functions
👉🏻 GROUP BY
👉🏻 WHERE vs HAVING
👉🏻 CASE STATEMENT
👉🏻 UNION vs Union ALL
👉🏻 LOGICAL OPERATORS
Other Commonly used functions:
👉🏻 IFNULL
👉🏻 COALESCE
👉🏻 ROUND
👉🏻 Working with Date Functions
1️⃣ EXTRACTING YEAR/MONTH/WEEK/DAY
2️⃣ Calculating date differences
👉🏻CTE
👉🏻Views & Triggers (optional)
Here is an amazing resources to learn & practice SQL: https://bit.ly/3FxxKPz
Share with credits: https://t.me/sqlspecialist
Hope it helps :)
👍25❤3