SQL SERVER

Sql സെർവർ ഒരു റിലേഷനൽ ഡാറ്റാബേസ് മാനേജ്മെന്റ് സിസ്റ്റം അഥവാ ആർ ഡി ബി എം യെസ് ആണ്. 1989യിൽ മൈക്രോസോഫ്റ്റും sybaseum ചേർന്ന് പുറത്തിറക്കിയ ഈ സോഫ്റ്റ്‌വെയർ mysql ടെയും oracle ടെയും ഒരു സ്ട്രോങ്ങ്‌ കോംപെട്ടിട്ടൊർ ആയിരുന്നു… sql ലാംഗ്വേജ് സപ്പോർട്ട് ചെയ്യുന്ന ഒരു സ്ട്രോങ്ങ്‌ ഡാറ്റാബേസ് ആണ് sql സെർവർ.
Sql Server Management Studio അഥവാ SSMS ആണ് sql സെർവറിന്റെ ഇന്റർഫേസ് ടൂൾ, അതുകൊണ്ട് തന്നെ അത് 32 ബിറ്റും 64ബിറ്റ് എൻവിറോണ്മെന്റും

SQL SERVER – CONTENTS

—————————————————-

Chapter:-1

Startup Structured Query Language(SOL) service manager,

How to login in SOL Server,

Introduction to Database,

Difference between frontend software and backend software,

Examples of frontend software

Chapter:-2

Introduction to Structured Query Language(SOL),

Use of SOL,

Data base in SOL,

Tables in SQL Data base,

Data Field,

Data Record,

Types of SOL,

  1. DML (Data Manipulation language),
  2. DDL(Data Definition Language)

Chapter:-3

Data Definition Language(DDL),

Different types of DDL ,

Use of DDL

Chapter:-4

CREATE TABLE QUERY,

  1. Syntax of Create table query,
  2. Create table Example “ALTER TABLE QUERY” ,

Syntax of Alter table query ,

Alter table working example ,

Adding and Modifying Fields in a table,

Different data types in SQL ,

“DROP TABLE QUERY” ,

Syntax of Delete table ,

Delete table Example

Chapter:-5

Data Manipulation Language,

Different types of DML,

“INSERT QUERY11,

Syntax of Insert query,

Working example of insert query,

Insert values for selected fields,

“SELECT QUERY”,

Syntax of select query

Working Example of select query

Different options in select query

Different options in select query

How to use “DISTINCT” in select query

Conditional statements

Relational Operators

Syntax and working of select query with condition

“LIKE CONDITION”

Syntax of Like Condition

Working Example of Like condition

Chapter:-6

UPDATE QUERY,

Use of Update Query,

Syntax of Update Query ,

Working Example of Update query ,

“DELETE QUERY” ,

Syntax of Delete Query ,

Working Example of Delete Query ,

Delete Query by using “IS NULL” conditions ,

Delete all rows in a table

Chapter:-7

Arranging data values in SQL ,

Order by Clause ,

Syntax of Order by ,

Working Example of Order by AND—OR” ,

Use of “AND—OR”,

Combine where clause condition with “AND –OR,

Working example of “AND—OR”

Chapter:-8

IN” Operator in SQL ,

Use of “IN” ,

Operator in select query ,

Syntax of “IN” Operator ,

Working Example of “IN” Operator “BETWEEN -AND” Operator ,

Use of “BETWEEN-AND” ,

Syntax of “BETWEEN -AND”  ,

Selecting values by using “BETWEEN-AND” Operator

Chapter:-9

“UNION” STATEMENT,

Use of “UNION”,

Combine select query by using “UNION”,

Syntax of “UNION”,

Working Example of “UNION” ,

“INTERSECT”,

Use of Intersect,

Combine select query by using Intersect

Syntax of “INTERSECT”

Renaming column in select query

Syntax and working example of renaming a column

Arithmetical operations in Select Query

Chapter:-10

BUILT IN FUNCTIONS IN SQL,

Syntax of Built in Functions,

Different types built in Functions,

Examples of Built in functions,

“SELECT INTO QUERY”,

Syntax of select into query,

Working example of “select into” query

Creating back up of table by using select into query

Chapter:-11

JOIN AND KEYS,

How to join more than one table,

Use of keys in SQL,

Primary Key,

Introduction to Primary Key,

Syntax to create primary key for a table,

Constraints in the primary key

Foreign Key

Introduction to Foreign Key

Syntax to create foreign key

Constraints in the foreign key

How to join more than one table

Advantages of Join table

Syntax to join a table

Working example to join a table

Chapter:-12

“INDEX”,

Use of “INDEX”,

Advantages of Index,

Syntax to create an Index,

Syntax to Drop an Index,

Working Example to create and drop Index

Chapter:-13

“VIEW”,

How to create a virtual copy of table,

Use of “VIEW”,

Syntax to create “VIEW”,

Sub quires,

Working example of “VIEW”,

Constraints of “VIEW”,

Different DML statements in “VIEW”

Chapter:-14

“PROCEDURES”,

Use of procedures, ,

How to create procedures ,

Advantages of Procedures,

Syntax to create procedures ,

Calling Procedures ,

Declaring parameter variables in procedure,

Passing values to procedures