Hari Thapliyaal

Dr. Hari Thapliyal is a seasoned professional and prolific blogger with a multifaceted background that spans the realms of Data Science, Project Management, and Advait-Vedanta Philosophy. Holding a Doctorate in AI/NLP from SSBM (Geneva, Switzerland), Hari has earned Master’s degrees in Computers, Business Management, Data Science, and Economics, reflecting his dedication to continuous learning and a diverse skill set. With over three decades of experience in management and leadership, Hari has proven expertise in training, consulting, and coaching within the technology sector. His extensive 16+ years in all phases of software product development are complemented by a decade-long focus on course design, training, coaching, and consulting in Project Management. In the dynamic field of Data Science, Hari stands out with more than three years of hands-on experience in software development, training course development, training, and mentoring professionals. His areas of specialization include Data Science, AI, Computer Vision, NLP, complex machine learning algorithms, statistical modeling, pattern identification, and extraction of valuable insights. Hari’s professional journey showcases his diverse experience in planning and executing multiple types of projects. He excels in driving stakeholders to identify and resolve business problems, consistently delivering excellent results. Beyond the professional sphere, Hari finds solace in long meditation, often seeking secluded places or immersing himself in the embrace of nature.

RDBMS

Relational Database Management Systems (RDBMS)

A brief summary of the topics covered in this course is as below. This is 60 hours course, it is suggested to complete this course in 1 month.

An introduction to Database

  • Introduction Database
  • RDBMS
  • SQL Database
  • No-SQL Databases

Basics of SQL

  • Data Retrieval with SQL
  • Compound Functions and Relational Operators
  • Pattern Matching with Wildcards
  • Basics of Sorting
  • Session Summary
  • Order by Clause

Advanced SQL

  • Aggregate Functions
  • Group by Clause 
  • Having Clause
  • Nested Queries
  • Inner Join
  • Multi Join
  • Outer Join
  • Summary

Database design

  • Defining Data Warehouse
  • Structure of Data Warehouse
  • OLAP vs. OLTP
  • Star Schema
  • How to Use a Star Schema – A Demonstration
  • Data Warehouse Schema- Industry Example

Updating Table

  • Introduction
  • Adding and Deleting Columns
  • Changing Column Name and Data Type
  • Creating Table from existing table
  • Changing Constraints (Primary key)
  • Changing Constraints (Foreign key)
  • String Manipulation
  • Date Manipulation

Window Functions

  • Introduction
  • Introduction to Windowing Functions
  • Frames
  • Named Windows
  • Window Functions’ Restrictions

User Defined Functions and Stored Procedures

  • Introduction
  • Introduction to User defined Functions
  • User defined functions (Application)
  • Introduction to Stored Procedures
  • Stored Procedures (Application)

Query Optimisation

  • Introduction
  • Optimisation in Select Clause
  • Optimisation in Where Clause
  • Optimisation in Group by and Order by
  • Optimisation in Joins
  • Optimisation in Window Function