• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Sql
  • php
  • C program
  • Seo

Codelack.com

  • Home
  • C++
  • networking
  • Sql server
    • what is rdbms | one to one | one to many | many to many relation-codlack
    • sql server create table
    • code rules in sql server
  • ASP.NET
    • control state in asp.net
    • cookie in asp.net
    • datalist control in asp .net
    • Using ASP.NET To Send Email
    • application state in asp.net
    • file upload control in asp.net
  • contact us
  • Data structure
    • what is Data structure
    • doubly linked list program in c
    • Array in data structure
    • circular queue in data structure
    • Linear data structure
    • Delete node at any position in singly linked list
    • dequeue in data structure
    • implementation of stack using a Linked list in data structure
    • implementation of stack using array in data structure
    • linked list algorithm
    • linked list in data structure
  • C
    • continue and break in c
    • history of c programming language
    • array program in c
    • c programming practice questions
    • enumeration in c
    • C programs with solutions
    • Characteristic of c
    • print 1 to 100 without using loop in c program
    • two single dimension 2D array in c
  • php
    • php
    • Variables in PHP
    • Scalar data types in php
    • Output function in php
    • how to use php string functions | example of string function
    • point to point configuration
    • error in php
    • Array in  php

introduction of sql

codelack_database

what is sql (STRUCTURE QUERY LANGUAGE)

It is a non procedural language which is used to communicate with any database such as Oracle, sqlserver etc.

This Language was developed by the German Scientist Mr. E.F.Codd in 1968.

ANSI (American National Standard Institute) approved this concept and in 1972 sql was released into the market.

Features of SQL:

SQL is not a case sensitive language it means that all the commands of Sql are not case sensitive.

Every command of sql should ends with a semicolon (;) (It is exemption for SQL Server)

SQL can be pronounced as Sequel (Structured English Query Language)

SQL can be called as Common Language Interface, which is used to communicate with any type of database.

SQL can be called as NLI (Natural Language Interface). It means that all the SQL Commands are almost similar to normal English language.

Structured query language is mainly divided into 4 sub languages

1. DDL (Data Definition Language)

2. DML (Data Manipulation Language)

3. TCL (Transaction Control Language)

4. DCL(Data Control Language)

about sql

what is SQL server

Sql server  is a collection of databases where a database is a again a collection of various objects  likes tables , views procedures , function, triggers, Indexes   etc.

Database under into sql server are divided into two  types

  1. System Database
  2. User Database
System Database

The databases are used by sql for the functionality of sql server and  without there data bases the server will not function users of sql server are not given a direct support for  updating the information under system data bases . the system data bases include  these  four databases.

  1. Master
  2. Model
  3. MsdB
  4. Tempdb
Master :-

These database records on the system level information under associated with the server.

Model:-

It is used as a template for all new databases created on sql server data base . i.e. whenever we create   a  new data base a copy of the  model data base is taken and given with a new name.

MSDB :-

It is used for recording or storing information about alerts, jobs etc that are   per formed  by sql server agent.

Tempdb :-

It is used for holding the temporary tables that are  created under  various databases . once we restart the  server the  tempdb  data base   is destroyed and again that  are created previairly.

User  data bases: 

These are databases created and managed by the users  for sorting their objects like tables views extra.

Primary Sidebar

sql

  • introduction of sql
  • database management system
  • hierarchical database management system
  • what is rdbms | one to one | one to many | many to many relation-codlack
  • codd rules in sql server
  • Character Data Type
  • constraint unique
  • sql server create table

Ads

data structure

  • Data structure
  • Linear data structure
  • Array in data structure
  • What is a algorithm
  • stacks in data structure
  • queue data structure
  • dequeue in data structure
  • Priority queue
  • circular queue in data structure
  • linked list algorithm
  • Delete node in singly linked list
  • tree in data structure
  • implementation of stack using array in data structure
  • implementation of stack using a Linked list in data structure
  • Doubly Linked List Implementation

C programming

  • history of c programming language
  • C programs with solutions
  • Characteristic
  • constraint unique
  • continue and break
  • doubly linked list program in c
  • dynamic memory allocation
  • enumeration
  • print 1 to 100 without using loop
  • Variable declaration

c++

  • Introduction to C++ | similarities of  C++ structure and  class
  • default argument in c++
  • access specifiers in c++
  • Function In C++
  • friend function in c++
  • constructor in c++
  • destructor in c++ | How to call destructor C++
  • exception handling in c++

Categories

array multiplication (1) asp.net (10) B.ed (1) C# (1) c# (1) C++ (2) C program (3) FormView control (1) php (2) Seo (5) Sql (1) Uncategorized (12)
disclaimer

Copyright © 2022 · codelack.com