Relational Databases

Introduction to Relational Databases (RDBMS) with escription on data, databases, relational databases, models, cloud databases, relational model.

• SQL Basics for Data Analysis, Fundamentals of SQL Query
• Dealing With Multiple Tables, Advanced SQL Joins
• Type Casting & Math Functions, DateTime & String Functions
• Window Functions, Complex queries using CTE & Pivoting
• Data Exploration With SQL & Python
• Database Management & Schema Design

Module concludes

Case Studies, Research Paper, Lesson Quiz & Coding Practice, Quiz Challenge, End Course Summative Assessment.

Explore Numerical Programming in Python & much more

From data structures, fundamentals, wrangling and visualization to latest tips & best practices, this course is a comprehensive discourse on the subject.

• Data Structures Fundamentals, Efficient String Operations, Recursion Fundamentals
• Mastering Recursion Concept, Algorithm Fundamentals
• Getting Started with Pandas & Numpy, Mastering Data Wrangling
• Advanced Data Wrangling (Concepts, Code Optimisation, Different Data Formats)
• Data Management Libraries, Web Scraping using Python
• Data Visualization with Matplotlib & Seaborn, Tips & Best practices

Introduction of computer programming with Python

Best inclusive methodology for gaining the foundational understanding of a subject & popular tools like Python.

• Introduction to Python Programming, Data Types in Python, Indexing & Slicing
• Operators in Data Types, In-Built Functions & Methods
• Statements, Indentation & Conditionals, Loops & Iterations
• Conditional & Infinite Looping, Custom Functions in Python
• Advanced Looping Concepts, OOPs in Python
• Exception Handling, Pair Programming Using AI ChatGPT

Module concludes

Research Paper, Lesson Quiz & Coding Practice, Quiz Challenge, End Course Summative Assessment.