Sagar's Data Journey
👋 Hi everyone, welcome to my channel!
I’m Sagar, a Risk Analyst (CAT Modelling) at Xceedance, where I work hands-on with Excel, SQL, VBA, and AIR Touchstone.
On this channel, you’ll find:
🔹 SQL/T-SQL, Excel, and VBA tutorials designed for data-focused careers like Data Analyst, Risk Analyst, and more
🔹 Practical tips to prepare for interviews and strengthen your problem-solving skills
🔹 Exclusive content on the Risk Analyst / CAT Modelling domain to help freshers kick-start their career in this field
Whether you’re looking to master technical skills or gain domain knowledge, this is the place for you. 🚀
👉 Stay connected and don’t forget to check out the links below!
Sagar's Data Journey
Which SQL window function assigns a rank to each row within a partition, allowing for ties to share the same rank?
1 year ago | [YT] | 5
View 0 replies
Sagar's Data Journey
Which SQL window function would you use to solve ranking issues?
1 year ago | [YT] | 3
View 0 replies
Sagar's Data Journey
Which SQL window function calculates the running total of a column?
1 year ago | [YT] | 7
View 0 replies
Sagar's Data Journey
Which SQL window function returns the value of a specified column from the previous row within the same result set?
1 year ago | [YT] | 6
View 0 replies
Sagar's Data Journey
Which SQL window function assigns a rank to rows within a partition, with gaps in the ranking?
1 year ago | [YT] | 6
View 0 replies
Sagar's Data Journey
Which SQL window function returns the average of a column over a specified window of rows?
1 year ago | [YT] | 4
View 0 replies
Sagar's Data Journey
Complete SQL road map
👇👇
1.Intro to SQL
• Definition
• Purpose
• Relational DBs
• DBMS
2.Basic SQL Syntax
• SELECT
• FROM
• WHERE
• ORDER BY
• GROUP BY
3. Data Types
• Integer
• Floating-Point
• Character
• Date
• VARCHAR
• TEXT
• BLOB
• BOOLEAN
4.Sub languages
• DML
• DDL
• DQL
• DCL
• TCL
5. Data Manipulation
• INSERT
• UPDATE
• DELETE
6. Data Definition
• CREATE
• ALTER
• DROP
• Indexes
7.Query Filtering and Sorting
• WHERE
• AND
• OR Conditions
• Ascending
• Descending
8. Data Aggregation
• SUM
• AVG
• COUNT
• MIN
• MAX
9.Joins and Relationships
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• Self-Joins
• Cross Joins
• FULL OUTER JOIN
10.Subqueries
• Subqueries used in
• Filtering data
• Aggregating data
• Joining tables
• Correlated Subqueries
11.Views
• Creating
• Modifying
• Dropping Views
12.Transactions
• ACID Properties
• COMMIT
• ROLLBACK
• SAVEPOINT
• ROLLBACK TO SAVEPOINT
13.Stored Procedures
• CREATE PROCEDURE
• ALTER PROCEDURE
• DROP PROCEDURE
• EXECUTE PROCEDURE
• User-Defined Functions (UDFs)
14.Triggers
• Trigger Events
• Trigger Execution and Syntax
15. Security and Permissions
• CREATE USER
• GRANT
• REVOKE
• ALTER USER
• DROP USER
16.Optimizations
• Indexing Strategies
• Query Optimization
17.Normalization
• 1NF(Normal Form)
• 2NF
• 3NF
• BCNF
18.Backup and Recovery
• Database Backups
• Point-in-Time Recovery
19.NoSQL Databases
• MongoDB
• Cassandra etc...
• Key differences
20. Data Integrity
• Primary Key
• Foreign Key
21.Advanced SQL Queries
• Window Functions
• Common Table Expressions (CTEs)
22.Full-Text Search
• Full-Text Indexes
• Search Optimization
23. Data Import and Export
• Importing Data
• Exporting Data (CSV, JSON)
• Using SQL Dump Files
24.Database Design
• Entity-Relationship Diagrams
• Normalization Techniques
25.Advanced Indexing
• Composite Indexes
• Covering Indexes
26.Database Transactions
• Savepoints
• Nested Transactions
• Two-Phase Commit Protocol
27.Performance Tuning
• Query Profiling and Analysis
• Query Cache Optimization
-------@SagarsDataJourney -------
Like this post if it was helpful content ✨️ ✅️♥️👍
ENJOY LEARNING ✅️✅️
1 year ago | [YT] | 3
View 0 replies