Profile

Parteek Kumar Bhatia is a Professor in the Department of Computer Science and Engineering and Former Associate Dean of Student Affairs at Thapar Institute of Engineering and Technology, Patiala. Currently working as Visiting Professor at the Department of Computer Science, Whitman College, Walla Walla, Washington State, USA.

He is a Postdoctorate from Tel Aviv University, Israel, and a former Visting Professor at LAMBDA Lab, Tel Aviv University, Israel.

He is the recipient of the Young Faculty Research Fellowship from the Ministry of Electronics & Information Technology, Govt. of India. He has more than twenty years of academic experience, including six years at D.A.V College Amritsar.

He has earned his B.Tech from SLIET and MS from BITS Pilani. He is a doctorate in the field of NLP from Thapar University and a post-doctorate from Tel Aviv University, Israel.

He has published more than 100 research papers and articles in Journals, Conferences, and Magazines of repute. His research work with UNDL foundation, Geneva, Switzerland, involved participation in Advanced UNL School at Alexandria, EGYPT, in 2012, and at Geneva, Switzerland, in 2013 and 2014.

He is a winner of the Gold Medal at the International competition UNL Olympiad II, UNL Olympiad III, and UNL Olympiad IV conducted by the UNDL Foundation in the years 2013 and 2014.

He is a well-known author and published textbooks in Databases and Data Mining. His latest book, “Data Mining and Data Warehousing: Principles and Practical Techniques,” was Published by Cambridge University Press in 2019. He is the author of popular books like “Simplified Approach to DBMS”, “Simplified Approach to Visual Basic” and “Simplified Approach to Oracle,” and “NoSQL in a Day”.

He has handled research projects of more than one crore rupees sponsored by International and National funding agencies. He is acting as Principal Investigator of DST Funded research project on “Automatic Generation of Sign Language from Hindi Text for Communication and Education of Hearing Impaired people”.

He has completed the Royal Academy of Engineering (UK) funded research project on “Innovative Research in Pedagogy with Mini-MOOCs blended with instruction strategies to enhance quality in Higher Education” as Co-PI. He has successfully completed a research Project on the Development of Indradhanush: An Integrated WordNet for Bengali, Gujarati, Kashmiri, Konkani, Oriya, Punjabi, and Urdu Sponsored By the Department of Information Technology, Ministry of Communication and Information Technology, Govt. of India.

He is passionate about teaching the masses through modern platforms like MOOCs. He runs multiple online courses over the Udemy platform and has more than 30,000 students. He is also running his YouTube Channel, “Parteek Bhatia: Simplifying Computer Education,” for sharing video sessions on Machine Learning, Big Data, DBMS, SQL, PL/SQL, and NoSQL.

New Online Course on Explainable AI (XAI) with Python

A simplified way to Learn XAI

He has a research interest in areas of NLP, Machine Learning, and Assistive Technologies. He is a member of IEEE, ACM, and ISTE.

Books

Data Mining and Data Warehousing

Written in lucid language, this valuable textbook brings together fundamental concepts of data mining, machine learning and data warehousing in a single volume. Topics are discussed in detail with their practical implementation using Weka and R language data mining tools.

Table of Contents

Data Mining and Data Warehousing 
Preface
Acknowledgment
Dedication
1. Beginning with machine learning
2. Introduction to data mining
3. Beginning with Weka and R language
4. Data pre-processing
5. Classification
6. Implementing classification in Weka and R
7. Cluster analysis
8. Implementing clustering with Weka and R
9. Association mining
10. Implementing association mining with Weka and R
11. Web mining and search engine
12. Operational data store and data warehouse
13. Data warehouse schema
14. Online analytical processing
15. Big data and NoSQL
Reference
Index.

Simplified Approach to DBMS


One of the best selling book, which explains each and every concept of DBMS in a simplified way. With ample amount of theory and practical questions, it has chapters on SQL and NOSQL as well. Latest topics like data warehousing have also been discussed in detail.

Table of Contents

Simplified approach to DBMS
1. Fundamentals of Database Management System
2. The architecture of Database Management System
3. Data Models
4. Relational Database Management System
5. Relational Algebra and Calculus
6. Entity-Relationship Model
7. Conversion of ER Diagrams to Tables
8. Normalization for refinement of data
9. Physical Database design
10. Transaction Management
11. Concurrency Control
12. Security and Integrity of data
13. Recovery of data
14. Distributed Database
15. Object-Oriented Databases and expert system
16. DBTG Model
17. Data Warehouse and Data mining
18. No-SQL Database
19. Enterprise Database Products
20. Beginning with SQL
21. Invoking SQL* Plus
22. Performing basic SQL operations
23. Basic SELECT statement
24. Inbuilt functions
25. Grouping of data
26. Joining of tables
27. Sub Queries
28. Managing Tables
29. Database objects, DCL and TCL statements
30. Pl/SQL Fundamentals and its statements
31. Error Handling
32. Cursor Management
33. Subprograms and packages
34. Database triggers
25. Advanced Topics
Index

Beginning with SQL

It covers the creation of tables, joining of tables, a grouping of data, subqueries, etc. in a simplified manner to train learners on basic concepts quickly and better prepare them for placements and interviews.

PL/SQL for beginners

Covers PL/SQL in a simplified manner and specially designed in kindle format to facilitate learning anywhere, any time from smartphone

.

NOSQL in a day

It covers NoSQL, Its models, and Big Data in a simplified manner to train learners on advanced concepts quickly and better prepare them for placements and interviews. It is specially designed in kindle format to facilitate learning anywhere, anytime from smartphone.

Designing Databases with ER Model


This book on Designing Databases with ER Model designed to better equip the learners for their University examination and placement interviews. This book is aimed at beginners, but it will give you enough information to get mastery on the subject. 
This book covers the need of ER Model, Basics Constructs of ER Models, ER Notations, Concepts of Total and Partial Participation, Strong and Weak Entity Sets, Specialization, Generalization and Aggregation. .

Free Course on Udemy

YouTube Channel

To learn anywhere any time and your own place

[vgwt_print_responsive_video_slider_with_thumbnail]

Softwares developed under various research projects

Automatic Text to Sign Language Generation System:

Website, Android Application and a Chrome Extension

For experiencing the online ISL portal, click:

For experiencing Sanket app on your Android Phone, click:

Punjabi WordNet Project

Punjabi WordNet is an online lexical resource. It is more than a conventional Punjabi dictionary. It is a combination of a dictionary and a thesaurus and much more. It provides information about a word from different perspectives with intra-word relationships.

A user can search for a Punjabi word and get its meaning. In addition, it gives the grammatical category namely noun, verb, adjective or adverb for the word being searched.  Apart from the category for each sense, the Punjabi WordNet also provides information about the meaning of the word, example of the word usage, its synonyms (words with similar meanings), its antonyms and semantic and lexical relations of the selected word.

Hindi sentiment analysis system

This system provides real-time sentiments of input Hindi sentences.      This system performs the sentiment analysis at three levels such as aspect, sentence and document level. At aspect level, the system accepts the input sentence and pre-processes it using Hindi dependency parser. The system extracts its relevant aspects and sentiment-bearing words and generates the dependency graph. Finally, the system assigns the polarity of sentiment word to its corresponding aspect on the basis of minimum path distance.

At the sentence level, the system takes the sentence as input and computes its polarity based on ML algorithms. The system is also able to perform sentiment analysis of tweets. It accepts the tweets on the basis of user-defined hash-tag and computes the overall polarity of hash-tag using machine learning and deep learning algorithms. This is system also has the facility to transliterate the input Hindi text using Google transliteration API.

Research Scholars


To Contact:
Dr. Parteek Bhatia
Professor
Deptt of Computer Sc & Engg
Thapar Institute of Engineering and Technology, Patiala
Phone (Office) :0175-2393374
Phone (Res) :0175-2393476
Mobile : 09876175046
E-mail: parteek.bhatia@thapar.edu
parteek.bhatia@gmail.com

Visiting Professor, Department of Computer Science,

Whitman College, Walla Walla, WA, USA.

kumarp@whitman.edu