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
