ADVANCED MICROSOFT SQL SERVER

Course SynopsisDatabase Design and Implementation – The course is tailored for beginners aiming to master coding in Database design and implementation. It spans 80 hours, combining lectures and labs with a focus on hands-on experience. Labs, scheduled on specific dates, are mandatory and graded. The course underscores the vital role of lab exercises ineffective software programming learning, penalizing late submissions. Instructors provide essential lecture/lab material as needed, via handouts or email. An optional concluding exam gauges students' grasp of the covered content—both practical and theoretical—essential for progression. Evaluation criteria encompass attendance, lab tasks, and the final test. Required TextbooksWalter Shields, “SQL QuickStart Guide”, ClydeBank Media.Allen G. Taylor, “SQL All-in-One for Dummies”, Wiley. Completion CriteriaAfter fulfilling all of the following criteria, the student will be deemed to have finished the Module:Has attended 90% of all classes held.Has received an average grade of 80% on all assignments.Has received an average of 60% in assessments.The tutor believes the student has grasped all of the concepts and is ready to go on to the second module. PrerequisitesBasic knowledge about programming, bits/bytes, procedures, classes, computer architecture, etc. If you just have theoretical knowledge that is perfectly okay but you should have strong convictions on what programming is, and what you hope to achieve from this class.Willing and eager to spend at least 10-20 hours (varying from student-to-student) per week outside of the training class to read/write codes in JavaScript (self-study and practice).There is no prior educational level requirement for this course. Anyone from 10+2 students to someone who is doing their PHD are welcome to take this course.If you are only interested in theory and have no interest/patience in spending at least 10 hours every week throughout the duration of the course, then this course might not be for you.If you have absolutely no idea about programming or do not see yourself doing programming in the next six - odd months, then this class may not be for you.

ADVANCED OFFICE PACKAGE

Course SynopsisMS Excel - Level 1 course is designed to teach essential Excel skills, including navigating the user interface, worksheet calculations, basic math, statistics, and logic functions. MS Excel - Level 2 course is designed for beginners who wish to learn how to Create Charts, Analyze Data using Pivot Tables, Slicers and Pivot Charts, Goal Seek and Solver, and Use Macro in Microsoft Excel. MS Excel-Level 3 is designed to learn syntax, near match techniques, and effective lookup table management. Handle missing data seamlessly. Ideal for Excel users seeking advanced data retrieval skills. Required Textbooks Excel All-in-one for Dummies 2019. Book 2: Slaying the Excel Dragon: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun.Book 3: Excel Basics in 30 Minutes (3rd Edition): The Quick Guide to Excel and Google Sheets. Completion CriteriaAfter fulfilling all of the following criteria, the student will be deemed to have finished the Module: Has attended 90% of all classes held.Has received an average grade of 80% on all assignment. Has received an average of 60% in assessments.The tutor believes the student has grasped all of the concepts and is ready to go on to the next module. PrerequisitesThere is no prior educational level requirement for this course. If you are only interested in theory and have no interest/patience in spending at least 10 hours every week throughout the duration of the course, then this course might not be for you.If you have absolutely no idea about programming or do not see yourself doing programming in the next six -odd months, then this class may not be for you!

Agentic AI with Python

Big Data Programming and Hadoop Analysis

Course SynopsisBig Data Programming and Hadoop Analytics introduces learners to the core concepts of Big Data, Hadoop ecosystem, and distributed data processing. The course focuses on hands-on experience with HDFS, YARN, MapReduce, Hive, Pig, and Apache Spark. Students will learn to build scalable data pipelines, manage Hadoop clusters, perform large-scale data analytics, and develop end-to-end Big Data solutions using real-world datasets in a hybrid learning environment.Required TextbooksTom White, Hadoop: The Definitive Guide, O’Reilly Media.Holden Karau et al., Learning Spark: Lightning-Fast Big Data Analytics, O’Reilly Media.Recommended Resources:Hadoop and Spark official documentation, GitHub lab repositories, cloud platform free-tier resources, and selected research papers.Completion CriteriaAfter fulfilling all of the following criteria, the student will be deemed to have finished the Module:Has attended 90% of all classes heldHas received an average grade of 80% on all assignmentsHas received an average of 60% in assessmentsThe tutor believes the student has grasped all core concepts and is ready to proceed to the next modulePrerequisitesBasic understanding of the Linux command lineFundamental programming knowledge (Python or Java preferred)Familiarity with SQL conceptsBasic understanding of data structures

DIPLOMA IN BIG DATA ANALYTICS WITH MONGODB

Course SummaryThe Diploma in Big Data Analytics is a comprehensive program focusing on the analysis and utilization of large and complex datasets. Students learn data collection, cleaning, integration, storage, and visualization techniques. They gain proficiency in programming languages, big data technologies, and advanced statistical and machine learning techniques. . It equips them with the skills and knowledge to extract valuable insights from big data and utilize them to drive business strategies and decision-making processes.  Required Textbooks1. "Big Data Analytics: Methods and Applications" by S. Srinivasan.2. "Big Data Analytics with R and Hadoop" by Vignesh Prajapati.3. "Big Data Analytics with Spark and Hadoop" by Venkat Ankam. Completion CriteriaAfter fulfilling all of the following criteria, the student will be deemed to have finished the Module:1. Has attended 90% of all classes held2. Has received an average grade of 80% on all assignments3. Has received an average of 60% in assessments4. The tutor believes the student has grasped all of the concepts and is ready to go on to the second module. Prerequisites1. Fundamental understanding of programming, bits/bytes, procedures, classes, and computer architecture. It's absolutely acceptable if you only have a theoretical understanding of programming, but you should be certain about what programming is and what you intend to gain from this session.2. If you are only interested in theory and have no interest/patience in spending at least 10 hours every week throughout the duration of the course, then this course might not be for you.3. If you have absolutely no idea about programming or do not see yourself doing programming in the next six-odd months, then this class may not be for you.