MCAL401: Advanced Web Technology and Data Mining and Business Intelligence Lab Syllabus for MCA 4th Sem 2017 Pattern Mumbai University

Advanced Web Technology and Data Mining and Business Intelligence Lab detailed Syllabus Scheme for Master of Computer Applications (MCA), 2017 regulation has been taken from the University of Mumbai official website and presented for the MCA students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below.

For all other Mumbai University MCA 4th Sem Syllabus 2017 Pattern, do visit MCA 4th Sem 2017 Pattern Scheme. The detailed Syllabus Scheme for advanced web technology and data mining and business intelligence lab is as follows.

MCAL401: Advanced Web Technology and Data Mining and Business Intelligence Lab Syllabus for MCA 4th Sem 2017 Pattern Mumbai University

Prerequisites:

• Basic Knowledge of Object Oriented Programming concepts
• Basic Understanding of Database Systems

Course Educational Objectives (CEO):

At the end of the course, the students will be able to

1. Learn advanced windows and web development techniques using dotNET
2. Understand Business Intelligence and Data Mining techniques
3. Prepare Business Intelligence applications using Web Technologies.

Course Outcomes:

At the end of the course, the students will be able to:

1. Develop Windows forms applications and Web Applications using Dot NET Technologies
2. Apply Data warehousing and mining techniques.
3. Design and implement web enabled BI application for industry.

1. Introduction to Dot Net and C#

• Basic Windows Forms Applications
• Windows Forms Applications using Control Structures and Operators
• Advanced Windows Forms Controls 04

2. OOP C#

• Programs using Classes and Objects
• Programs based on Inheritance
• Programs using Static and Constant
• Programs using Interfaces
• Programs using Abstract Classes
• Programs on Collections
• Designing Generic Classes and Methods 10

3. Databases and C#

• Text File Handling
• Text Editing Application
• Binary File Handling
• Database Connectivity in Connected Manner
• Database Connectivity in Disconnected Manner
• LINQ with Object Data Source
• LINQ with DataSet 08

4. Asp.Net Web Applications

• Web Applications using Web Server Controls
• Web Applications using advanced Web Server Controls
• ASP .NET Applications using Web Forms
• ASP.NET Applications using MVC 08

5. Data and State Management in ASP.NET

• ASP.Net Web Applications managing States
• Web Applications using SQL Data Source
• Web Applications using Connected and Disconnected database Connectivity
• Web Applications using ADO.NET Entity Framework
• Web Applications using jquery and database Connectivity
• Web Applications using ASP.NET Ajax
• Websites using Master Pages and Themes 10

6. Web Services

• Creating and Consuming a XML Web Service-Simple and Database
• Creating and Consuming a WCF service – Simple and Database
• Designing Secure Web Application
• Deploying web Site 06

7. Data Warehousing

Data Warehousing using Oracle

• Setting Up and Starting Warehouse Builder
• Introducing OWB Architecture and Configuration
• Defining Source Metadata
• Ensuring Data Quality Using Data Profiling
• Defining Staging Metadata and Mapping Tables
• Deriving Data Rules and Running Correction Mappings 06
• Defining a Relational Dimensional Model
• Handling Slowly Changing Dimensions

OLAP with Oracle

• Analytical Queries
• Grouping Functions
• Windowing Functions
• RollUp and Cube

8. Data Mining

Data Mining Using Weka/R Miner

• Introducing Weka/R Miner
• The Data Mining Process
• Using Classification Models
• Using Regression Models
• Using Clustering Models
• Performing Market Basket Analysis
• Performing Anomaly Detection
• Deploying Data Mining Results 08

9. BI Tools

Open Source BI Tools

• Preparing Reports
• Preparing Dashboards
• Preparing Balanced ScoreCards
• Analysis of Reports 08

10. Mini Project

Mini Project A Mini Projects based on Data Mining and Business Intelligence Techniques using advanced Web Technologies. 10

Reference Books:

• Beginning Visual C# 2012 Programming, Karli Watson, Jacob Vibe Hammer, Jon D. Reid, Morgan Skinner, Daniel Kemper, Christian Nagel,ISBN: 978-1-118-31441-8,Wrox Publication
• Professional C# 2008,Christian Nagel, Bill Evjen, Jay Glynn, Karli Watson, Morgan Skinner, ISBN: 978-1-118-64321-1,Wrox Publication
• Beginning ASP.NET 4.5: in C# and VB,ImarSpaanjaars, ISBN: 978-1-118-31180-6,Wrox Publication
• Professional ASP.NET 4.5 in C# and VB,Jason N. Gaylord, Christian Wenz, Pranav Rastogi, Todd Miranda, Scott Hanselman, Scott Hunter (Foreword by), ISBN: 978-1-118-31182-0,Wrox Publication
• Murachs ASP.NET 4 Web Programming with C# 2010, Anne Boehm,Joel Murrach,SPD, Murrach Books
• Murachs C# 2015,Anne Boehm and Joel Murach,ISBN 978-1-890774-94-3,Murrach
• Murach” s ADO. Net 4 Database Programming with C# 2010 4th Edition
• Pro C# 5.0 and the .NET 4.5 Framework – Andrew Trolsen, APress
• Advance .NET Technology second edition by ChiragPatel- DreamTech Press

Web References:

• MSDN: Learn to Develop with Microsoft Developer Network:

https://msdn.microsoft.com/

• www.weka.org,_www.oracle.comwww.pentahobi .com

For detail syllabus of all other subjects of Master of Computer Applications (MCA), 2017 regulation do visit MCA 4th Sem Subjects syllabus for 2017 regulation.