TY B.Com Syllabus Mumbai University

How I can get the TY B.Com course syllabus from net of Mumbai University because I have need of this course syllabus of Mumbai University so want to get it from net so please tell me for get this course syllabus from net

[Shaleen]

As you are looking for syllabus of B.Com third year form Mumbai University so this information is available on one of our respective site I am sharing with you link of that page where you can get information regarding this.

Syllabus for Tybcom of Mumbai University_2011 - 2012 -2013 StudyChaCha

Hello sir I want TY B.Com Syllabus Mumbai University of 5th semester so here can you please give me details ?

[Kiran Chandar]

Hey as The University of Mumbai is one of the first three state universities in India and the oldest in Maharashtra. It is abbreviated as "MU" for Mumbai University

Syllabus


Data Communication, Networking and Internet (18 L)


Data Communication Component, Data representation, Distributed processing (Concepts only)

Network Basics and Infrastructure

Definition, Types (LAN, MAN, WAN) Advantages.

Network Structures – Server Based, Client server, Peer to Peer.

Topologies – Star, Bus, Ring.

Network Media, Wired and Wireless.

Network Hardware: Hubs, Bridges, Switches, Routers.

Network Protocols – TCP/IP, OSI Model.

Internet

Definition, Types of connections, sharing internet connection.
Services on net- WWW, Email-Blogs. IP addresses, Domain names, URLs.

Searching Directories, Search engines, Boolean search (AND, OR, NOT),
Advanced search, Meta Search Engines.

Email – POP/SMTP accounts in Email, Different parts of an Email address.
Receiving and sending emails with attachments by scanning attachments for viruses.

Unit II Database and SQL (18 Lectures)

Introduction :

To Databases, Relational and Non-relational database system MySQL as a Non-procedural Language. View of data.

SQL Basics :

Statements (Schema Statements, Data statements, Transaction statements, names (table & column names), data types (Char, Varchar, Text, Mediumtext, Longtext, Smallint, Bigint, Boolean, Decimal, Float, Double, Date, Date Time, Timestamp, Year, Time, Creating Database, inserting data, Updating data, Deleting data, expressions, built-in-functions, missing data(NULL and NOT NULL DEFAULT values) CREATE,USE, ALTER (Add, Remove, Change columns), RENAME, SHOW, DESCRIBE (CREATE TABLE, COLUMNS, STATUS and DATABASES only) and DROP (TABLE, COLUMN, DATABASES statements), PRIMARY KEY FOREIGN KEY (One and more columns) Simple Validity checking using
CONSTRAINTS.

Simple queries:

TheSELECT statement (From, Where, Group By, Having, Order By, Distinct, Filtering Data by using conditions. Simple and complex conditions using logical, arithmetic and relational operators (=, !,=, <, >, <>, AND, OR, NOT, LIKE, BETWEEN

Multi-table queries:

Simple joins (INNER JOIN), SQL considerations for multi table queries (table aliases, qualified column names, all column selections self joins).

Nested Queries (Only up to two levels) :

Using sub queries, sub query search conditions, sub queries & joins, nested sub queries, correlated sub queries, sub queries in the HAVING clause.
Simple Transaction illustrating START, COMMIT, and ROLLBACK.

Unit III Spreadsheet ( 9 Lectures)

Creating and Navigating worksheets and adding information to worksheets
Types of data, entering different types of data such as texts, numbers, dates,
functions.

Quick way to add data Auto complete, Autocorrect, Auto fill, Auto fit. Undo and
Redo.

Moving data, contiguous and non contiguous selections, Selecting with keyboard.
Cut-Copy, Paste. Adding and moving columns or rows. Inserting columns and
rows.

Find and replace values. Spell check.

Formatting cells, Numbers, Date
, Times, Font, Colors, Borders, Fills.
b) Multiple Spreadsheets

Adding, removing, hiding and renaming worksheets.

Add headers/Footers to a Workbook. Page breaks, preview.

Creating formulas, inserting functions, cell references, Absolute, Relative (within
a worksheet, other worksheets and other workbooks).

Functions

Financial functions: FV, PV, PMT, PPMT, IPMT, NPER, RATE, NPV, IRR

Mathematical and statistical functions. ROUND, ROUNDDOWN, ROUNDUP,
CEILING, FLOOR, INT, MAX, MIN, MOD, SQRT, ABS, AVERAGE

Data Analysis

Sorting, Subtotal.

Pivot Tables- Building Pivot Tables, Pivot Table regions, Rearranging Pivot Table.


Address:

University of Mumbai

CST Road, Kalina,

Santacruz East,

Mumbai,

Maharashtra 400098

Phone: 022 2654 3000