4.
5.
6.
• Aggregate Functions
• Grouping the Results of Query
Tables and Joins
• Features and designing of SQL Server Tables
• Creating tables
• Applying column constraints
• Inserting values in a table
• Removing a table
• Types of joins – Equi
- Cartesian
- Outer
Indexes
• Guidelines for creating indexes
• Types of Indexes
• Clustered Index
• Non-clustered Index
• Unique Index
• Composite Index
Introduction to Views
• Creating a view
• Advantages of a view
• Dropping views
• Renaming views
• Maintaining data using views
Class XII (C Language)
1.
Fundamentals & Data Types
• The beginning of C
• When and why is C used
• The C program structure
91