ASP.Net Fullstack Syllabus

1.Introduction to C#:
   ● Installation & Environment settings.
   ● Introduction to C#.

2. Variables, Keywords, Data types and Identifiers.
   ● Variables
   ● Keywords
   ● Data types
   ● Identifiers


3. Operators :
   ● Arithmetic Operators
   ● Logical Operators
   ● Relational Operators
   ● Bitwise operators
   ● Assignment Operators
   ● Membership Operators
   ● Identity Operators

4. Control Statements
   ● Decisional Statements
   ● Looping Statements
   ● Break, Continue

5. Input and Print Statements:
   ● Input statements
   ● Print statements

6. Functions or Methods
   ● Types of Functions
   ● Recursion
   ● Arguments

7. Oops:
   ● Class, Objects
   ● Inheritance
   ● Method Overriding
   ● Access Specifies


8. Exception Handling:
   ● Try
   ● Except and final
   ● Custom Exceptions

9. Web Application Using ASP.Net:
   ● ASP.Net Controls
   ● Crude Operations(Insert/Update/Select/Delete)
   ● Login
   ● Change Password
   ● Dynamic Loading
   ● File Upload/Download

1. Introduction:
   ● What Is Database?
   ● What is Database Management System (DBMS)?
   ● What is Relational Model ?
   ● Introduction to RDBMS .
   ● Brief on E.F CODD .

2.Datatypes and Constraints:
   ● What are Datatypes ?
   ● Types and Examples .
   ● How to use .
   ● What are Constraints?
   ● Types and Examples.
   ● How to use.

3.Statements in SQL :
   ● Data Definition Language (DDL)
   ● Data Manipulation Language (DML)
   ● Transaction Control Language (TCL)
   ● Data Control Language (DCL)
   ● Data Query Language (DQL)

4.Software installation :
   ● Installing and set up of software
   ● Working on Oracle 10g

5. Data Query Language (DQL):
   ● Select
   ● From
   ● Where
   ● Group By
   ● Having
   ● Order By

6.Operators:
   ● Types and Example

7. Functions in SQL :
   ● Single Row Functions
   ● Multi Row Functions
    Max ()
    Min ()
    Sum ()
    Avg ()
   Count ()

8.Sub Query:
   ●Introduction to Sub Query
   ● Working of Sub Query
   ● Query Writing and Execution
   ● Types of Sub Query
   ● 1. Single Row Sub Query
2. Multi Row Sub Query
   ● Nested Sub Query.

9. Pseudo Columns :
   ● Introduction on Pseudo coloumns
   ● ROWID
   ● ROWNUM
   ● Working and Usage.

10. JOINS:
   ● What Is Join?
   ● Types of Joins.
   ● Cartesian Join
   ● Inner Join
   ● Outer Join
   ● Self-Join
   ● Queries and Examples.

11. Co- Related Sub Query
   ● Working and Examples

12. Data Definition Language (DDL)
   ● Create
   ● Rename
   ● Alter
   ● Truncate
   ● Drop

12. Data Manipulation Language (DML)
   ● Insert
   ● Delete
   ● Update

13.Transaction Control Language (TCL):
   ● Commit
   ● Save point
   ● Rollback

14. Data Control Language (DCL)
   ● Grant
   ● Revoke

15. Normalization
   ● Introduction to Normalization
   ● Types of Normal Forms
   ● Examples.

16. E R Diagrams :
   ● Introduction to ERD
   ● Examples.

1. Introduction to Web-technology :
   ● What is web?
   ●What is network?
   ●What is internet?
   ● What is web-development?
   ●What is browser?
   ●What is web-server?
   ● What is http?
   ●What is the use of http?
   ●What is html?
   ●What is website?
   ● What is web-page?
   ●Structure of Web
   ●Definition of all the points
   ●Install of Editors
   ●How to write program using editors

2. Bootstrap :
   *.Introduction:
   ● What is bootstrap
   ● How to apply bootstrap in web-pages
   ● Benefits of using bootstrap
   ● Grid system in bootstrap
   ● Classes in bootstrap
   ● How to create table using bootstrap-class
   ● How to create forms using bootstrap-class
   ● What is carousel in bootstrap
   ● How to apply all of this create one project.
   *.Project Set-up:
   ● Responsive project using Html, Css ,Javascript & bootstrap