SQL SERVER 2005 - Seminar

SEMINAR ON SQL SERVER 2005
Conducted by PRIYANKA CHOPRA & PARMINDER SINGH SAINI

Introduction to Database:

A database consists of an organized collection of data for one or more uses, typically in digital form. Digital databases are managed using database management systems, which store database contents, allowing data creation and maintenance, and search and other access.

Database management systems
A database management system (DBMS) consists of software that operates databases, providing storage, access, security, backup and other facilities. Database management systems can be categorized according to the database model that they support, such as relational or XML, the type(s) of computer they support, such as a server cluster or a mobile phone, the query language(s) that access the database, such as SQL or XQuery, performance trade-offs, such as maximum scale or maximum speed or others. Some DBMS cover more than one entry in these categories, e.g., supporting multiple query languages.Examples of some commonly used DBMS are MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker,Oracle, RDBMS, dBASE, Clipper,FoxPro,etc. Almost every database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases.

Types of Databases:Basic Queries  which were explained General Structure = SELECT, ALL/DISTINCT ,*, AS, FROM, WHERE
Comparison = IN, BETWEEN, WHERE, “%”, “_”
Grouping = GROUP BY, HAVING, COUNT(), SUM(), AVG(), MAX(), MIN()
Display Oreder =  ORDER BY, ASC/DESC
Logical Operator = AND, OR, NOT
Union = UNIONTypes of Joins
Joins are used to combine more than one or more than one table into single result set using different forms:
1. Inner Join
2. Outer Join
      * Left Outer Join
      * Right Outer Join
3. Self Join
4. NaturalOther topics
Union, Intersection and Cartesian Product Interview Questions on SQL SERVER 2005
This section consists the interview question which are commonly asked  for SQL SERVER 2005 related profiles.
There are different ways to define a database. Most commonly used type is relational database. They are defined below:
Network Database
Hierarchical Database
Relational Database

The Basics of the SQL Database and Advantages of SQL SERVER 2005
SQL (Structured Query language) is the language of choice for most modern multi-user, relational databases. That is because SQL provides the syntax and idioms (language) you need to talk to (query) relational databases in a standardized, cross-platform/product way (structured).

The beauty of SQL is that it idiomizes the relational model. Rather than refer to data as a set of pointers, SQL provides predefined procedures to allow you to use any value in a table to relate other tables in a database. So long as a database is structured using the relational model, SQL will be a natural fit because SQL was designed to make sense in a relational system. SQL by its very design is a language that can be used to talk about relating tables.Queries/Commands
SQL Commands are basically divided into Four type of commands
1. DDL = Data Definition Language that consists of the Create, Alter and Drop commands
2. DML = Data Manipulation Language that consists of Insert, Update and Delete commands
3. DQL = Data Query Language that consists of Select command
4. DCL = Data Control Language that consists of Grant and Revoke commands

Proactive at HCL CDC Janakpuri

It is a joyful result of the joint effort of our PROACTIVE and DEDICATED JANAKPURI team and students who have been working hard to make the centre pillars mark the height in IT industry.

We are working with best technologies and offer different range of HARDWARE /NETWORKING and SOFTWARE courses to our students which boost up their career. I thoroughly make sure to severe the best and bring out young professionals for today’s IT market.

Our MOTO is to mark history in IT industry and to leave steps behind for followers. This centre not only focuses on course contents but also groom their students for centuries. We make sure to upgrade technology, infrastructure and manpower according to time.
For HCL CDC JANAKPURI team their priority is to impart the best they have and to retain the best they can.

Big Bug found in Windows Server 2008 by Dinesh Arya a student of HCL CDC Janakpuri

Activation bug found in Window server 2008

Windows Server 2008 is the latest version of Microsoft’s enterprise server operating system. The Windows Server 2008 family is the successor to the Windows 2000 Server family, which in turn built upon Windows NT Server. Windows Server 2008 introduces many new features and offers significant improvements to many features found in earlier Windows Server operating systems.

But beside these features, big "Activation Bug" found in Window Server 2008 by a student of HCL CDC at Janakpuri Centre.

A shocking bug has been occurred at Janakpuri's HCL CDC in aspect of Windows activatation, Dinesh Arya a student of HCL CDC Janakpuri centre found activation bug in server 2008. He believe that, he could mannully activate the Microsoft Windows Server 2008 without using any tool & software (Crack or Keygen). It seems Microsoft Corporation a big giant in Software & Hardware Development needs attention and improve their security tools.



Dinesh Arya - Student HCL CDC Janakpuri