SQL for Data Analytics : A Step-by-Step Guide for Beginners ??
Belayet Hossain ??
Power BI Developer @ZnZ | Data Analyst | SQL, Python, ETL, DBMS, DAX | Find insight & Making Decision|| Ex-Head of Quality Dept & 09 Y With smartphone Manufacturing & Service | Ex- RFL, VIVO, Symphony || EEE
Don't overwhelm to learn SQL,??
SQL is only this much????
??.?????????? ???? ??????
? Definition
? Purpose
? Relational DBs
? DBMS
??.?????????? ?????? ????????????
? SELECT
? FROM
? WHERE
? ORDER BY
? GROUP BY
??. ???????? ??????????
? Integer
? Floating-Point
? Character
? Date
? VARCHAR
? TEXT
? BLOB
? BOOLEAN
??.?????? ??????????????????
? DML
? DDL
? DQL
? DCL
? TCL
??. ???????? ????????????????????????
? INSERT
? UPDATE
? DELETE
??. ???????? ????????????????????
? CREATE
? ALTER
? DROP
? Indexes
??.?????????? ?????????????????? ?????? ??????????????
? WHERE
? AND
? OR Conditions
? Ascending
? Descending
??. ???????? ??????????????????????
? SUM
? AVG
? COUNT
? MIN
? MAX
??.?????????? ?????? ??????????????????????????
? INNER JOIN
? LEFT JOIN
? RIGHT JOIN
? Self-Joins
? Cross Joins
? FULL OUTER JOIN
????.????????????????????
? Subqueries used in
? Filtering data
? Aggregating data
? Joining tables
? Correlated Subqueries
????.??????????
? Creating
? Modifying
? Dropping Views
????.????????????????????????
? ACID Properties
? COMMIT
? ROLLBACK
? SAVEPOINT
? ROLLBACK TO SAVEPOINT
????.???????????? ????????????????????
? CREATE PROCEDURE
? ALTER PROCEDURE
? DROP PROCEDURE
? EXECUTE PROCEDURE
? User-Defined Functions (UDFs)
????.????????????????
? Trigger Events
? Trigger Execution and Syntax
????. ???????????????? ?????? ??????????????????????
? CREATE USER
? GRANT
? REVOKE
? ALTER USER
? DROP USER
????.??????????????????????????
? Indexing Strategies
? Query Optimization
????.??????????????????????????
? 1NF(Normal Form)
? 2NF
? 3NF
? BCNF
????.???????????? ?????? ????????????????
? Database Backups
? Point-in-Time Recovery
????.?????????? ??????????????????
? MongoDB
? Cassandra etc...
? Key differences
????. ???????? ??????????????????
? Primary Key
? Foreign Key
????.???????????????? ?????? ??????????????
? Window Functions
? Common Table Expressions (CTEs)
????.????????-???????? ????????????
? Full-Text Indexes
? Search Optimization
????. ???????? ???????????? ?????? ????????????
? Importing and Exporting Data (CSV, JSON)
? Using SQL Dump Files
????.???????????????? ????????????
? Entity-Relationship Diagrams (ERDs)
? Normalization Techniques
????.???????????????? ????????????????
? Composite Indexes
? Covering Indexes
????.???????????????? ????????????????????????
? Savepoints and Nested Transactions
? Two-Phase Commit Protocol
????.?????????????????????? ????????????
? Query Profiling and Analysis
? Query Cache Optimization
------------------ END -------------------
???????? ???????? ?????????????????? ???? ?????????? ??????
??.????????????????
? SQLZoo -(It's best) https://lnkd.in/gA5ixAte
? W3Schools https://w3schools.com/sql/
??. ?????????????? ??????????????'??
? FreeCodeCamp: https://lnkd.in/gEZUxkS8
? Programming with Mosh: https://lnkd.in/ga3SJNbv
??. ??????????
? SQL in a Nutshell https://rb.gy/1o3rd
??. ????????????????
? Leetcode
? Hackerrank
#SQL #DataAnalytics #DataAnalysis #PowerBI