Welcome to the Data Science & AI learning roadmap! This page provides a progressive path to understanding and mastering the core concepts and techniques in these transformative fields. Each module builds upon the last, guiding you from foundational knowledge to advanced applications, with links to detailed blog posts for every topic. Let’s embark on this journey to unlock insights from data and build intelligent systems.

Module 1: Foundational Skills – Linux

1.1 Linux Fundamentals

• Understanding the Linux, Linux Architecture, command line, file systems, user management, and essential Linux commands for server interaction.
  • Your First Steps into Linux: From Basics to Breakthrough

Module 2: Data Transformation – SQL

2.1 Database and RDBMS

• Understanding Data and Database, Types of Data, Understanding RDBMS, Key Components of RDBMS, Intro to SQL.
  • Diving into Databases and RDBMS: Your Starting Point for SQL.

2.2 MSSQL

• Intro to MSSQL, Architecture of MSSQL, Intro to ODBC, Installing MSSQL (Server) and SSMS (Client).
  • MSSQL: Overview and Your Guide to Installation and Setup
• Fundamentals of queries, deep dive into examples for CRUD operations with various queries from basic to advanced, JOINs, Functions.
  • Mastering SQL Basics: Part 1 – Foundations, Table Design, and Essential Queries
  • Mastering SQL Basics: Part 2 – Going Deep with JOINS
  • SQL Functions: A Deep Dive into Essential Functions
• Automations – Triggers, Stored Procedures, Rules and UDFs.
  • SQL Triggers: Automating Database Actions
  • Stored Procedures and Rules: Enhancing Database Control
  • User-Defined Functions (UDFs): Extending SQL’s Capabilities
• Subqueries and Candidate Keys: Mastering Advanced Queries and Database Design
• Beyond the Basics: Views, Ranking Functions and Aggregation with ROLLUP