> Code Storage: DBMS

Code Storage

A Technical blog for those who want to gain knowledge about SQL,MySQL,Data Science and real time query

Responsive Ads Here

Advertisement

Showing posts with label DBMS. Show all posts
Showing posts with label DBMS. Show all posts

Wednesday, April 28, 2021

SEVER TYPE IN SSMS ( Sql Server Managment studio)

When you install the SQL Server management studio and then you want to connect with the SQL Server then there are four types of SQL servers are there, and what is the work of that four types of SQL servers. when we have to use that server. let's see what are they:-
  1. Database Engine
  2. Analysis Services
  3. Reporting Services
  4. Integration Services     

  1. Database Engine:- It is a core component of the database engine here core means the main component of the SQL Server management studio. there are have some purposes to use this database engine. the first purpose is to store the data or table which means rows and columns. the second one is processing means after storing the data we have to perform some operations like insert, delete, update. and the third one is security means to provide security to our data.
  2. Analysis Services:- It is an MSBI Tool (business intelligence management tool) and we have to use this tool in the data warehousing for the data storing purpose. Analysis services have to convert the data from 2D( two dimensional ) or tables (rows & columns) to the 3D(three dimensional) formate means graphical formate.
  3. Reporting Services:- It is also called MSBI Tool or SSRS (SQL Server reporting services).reporting services to store the report or document about the company businesses. To use the reporting services can export the data from database engine to the other platform like (MS Word, MS Excel), etc. When you need to export the data from a database to another platform you can use reporting services.
  4. Integration Services:- It is also called MSBI Tool or SSIS (SQL Server integration services). Integration services are used to converting database tables for another database understandable format. This means if you are working in SQL Server database and then you want to convert into another database like the oracle at that time use the integration services.

Friday, January 17, 2020

Date and Time format in SQL ?

Date and Time format in SQL

In SQL we have date and time format to show the date and time format in different ways lets see what are the date and time formats are there.

Date,Time,format,SQL
                               
                                                                                1.Date and Time format in SQL


FormateQuerySample
1select convert(varchar,getdate(),1)12/30/08
2select convert(varchar,getdate(),2)08.12.30
3select convert(varchar,getdate(),3)30/12/08
4select convert(varchar,getdate(),4)30.12.08
5select convert(varchar,getdate(),5)30-12-08
6select convert(varchar,getdate(),6)30 Dec 08
7select convert(varchar,getdate(),7)Dec 30 08
10select convert(varchar,getdate(),10)12-30-08
11select convert(varchar,getdate(),11)08/12/30
12select convert(varchar,getdate(),12)08 12 30
23select convert(varchar,getdate(),23)2008-12-30
101select convert(varchar,getdate(),101)12/30/2008
102select convert(varchar,getdate(),102)2008.12.30
103select convert(varchar,getdate(),103)30/12/2008
104select convert(varchar,getdate(),104)30.12.2008
105select convert(varchar,getdate(),105)30-12-2008
106select convert(varchar,getdate(),106)30 Dec 2008
107select convert(varchar,getdate(),107)Dec 30 2008
110select convert(varchar,getdate(),110)12/30/2008
111select convert(varchar,getdate(),111)2008/12/30
112select convert(varchar,getdate(),112)2008 12 30

Time only format:-

In SQL have some time only format lets see what are time format are there :-

Formate Query Sample
8 select convert(varchar,getdate(),8) 00:38:53
14 select convert(varchar,getdate(),14) 00:38:53:840
24 select convert(varchar,getdate(),24) 00:38:53
108 select convert(varchar,getdate(),108) 00:38:53
114 select convert(varchar,getdate(),114) 00:38:53:840


Friday, January 10, 2020

SQL language Element ?

SQL,element,datatype,identifiers,
                                                         1.SQL Language Element


SQL Language Element


  1. Identifiers

                      Names of database objects such as tables,views,columns,rows etc.    

      2. Datatypes      

                     
                      Define the type of data that is contain by columns.

      3.Constants


                      Symbols that represent specific data type.

      4.Operators


                      Perform arithmetic,comparison and logical operations.

      5.Function


                      There are two types of functions
                               1.Built-in function
                               2. User define  function

          1.Built-in Function

                                     Built-in  function is perform specific operations.in sql have only built-in                                               function.

          2.User define function 

                                     In this function user can create there own function but to create own function                                       they have some rules.

        6.clauses

                     Constituent component of statement and queries.
                      Example:- var clause

        7.Expression

                           Produce scalar values or tables containing of column and row of data.

        8. Queries

                       Retrieve the data based on specific criteria this is an important element of SQL.

        9.Statement

                          create database ABC
                     
                          create     :- SQL command
                          Database:-Database Keyword
                          ABC      :- User define object_name
                                                      

What is DBMS.Advantage of DBMS.Types of DBMS.

DBMS,SQL,type if dbms,
                                            
                                                                    1.What is DBMS,Advantage,Type of DBMS


What is DBMS


  • A database management system is a software designed to assist in maintaining and utilizing large collection of data.
            Example:- Oracle,MySql,SQL.
  •  The alternative to use a DBMS is to store the data in files and write application specific to manage it.
  • DBMS allows users to create their own databases as per requirement.
  •  It provides an interface between the data and the software application.

Advantage of DBMS

  • Data independence. 
  • Efficient data access
  • Data integrity and security
  • Data Administration 
  • Concurrent access and data recovery
  • Reduce application development time

Types of DBMS 

  1. Hierarchical DBMS
  2. Network DBMS
  3. Relational DBMS
  4. Object Oriented

1.Hierarchical DBMS

  • In Hierarchical database, model data is organized in a tree like structure.
  • Data is stored hierarchically (top down or bottom down ) format .
  • Data is represented using a parent child relationship.
  • In hierarchical DBMS parent may have many children,but children have only one parent.

2.Network DBMS

  • The network database model allow each child to have multiple parents.
  • It helps you to address the need to model more complex relationship like many to many relationship.
  • In this model,entities are organized in a graph which can accessed through several paths.

3.Relational DBMS 

  • Relational DBMS is the widely used DBMS model in the industries because it is one of the easiest.
  • Relational DBMS based on the normalization data in the row and column of the tables.
  • It is stored in a fixed structures and manipulated using SQL.

4.Object Oriented 

  • In object oriented model data data stored in a form of objects. 
  • The structure we called is class we stored data within the class.
  • It define a database as a collection of objects which store both data members values and operations.

Thursday, January 9, 2020

Database fundamental.what is database and table and record.

Database,table,record,SQL,fundamental
                                                      1. Database fundamental,table,record


DataBase Fundamental


  • Database server instance contains multiple database.
  • Database contain multiples tables.
  • Data have two important form:
                  1. File form
                  2. Table form 

1. File Form      

  • SQL server database have three types of file:
                        a.Primary File
                        b.Secondary File
                        c. Transaction Log  

a.Primary File:-       

  • The primary data file contains the startup information for the database and point to the others file in database.
  • User data and object can be stored in this file or secondary data file.
  • Every database has one primary data file.
  • The recommended file name extension for primary data file is ".mdf ".         

b.Secondary File:-      

  • Secondary data files are optional,are user defined and store user data.
  • Secondary files can be  used  to spread data across multiple disk by putting each file on a different disk drive.
  • If a database exceeds the maximum size for a single windows file you can use secondary data files so the database can continue grow.
  • The recommended file name extension for secondary data files is ".ndf".

c.Transaction Log:-

  • The  transaction log files hold the log information that is used to recover the database.
  • There must be at least one log file for each database.
  • The recommended file name extension for transaction log is ".ldf".

2.Table Form

  • SQL table is a collection of data which is organized in terms of rows and columns.
  • In DBMS,the table as known as relation and row as a tuples.
  • Table is a simple form of  data storage.A table  is also convenient representation of relation.
  • Tables contains multiple records (Rows and Columns ).

What is Database

  • A database is a systematic collection of data .
  • Database support storage and manipulation of data.
  • Database make data management easy.

Table And Record

  • A table in a relational database is a predefined format of rows and column that define an entity.
  • Each column contains a different type of attribute and each row corresponds to a single record.
  • Each table is provided with a name.
Example:-
                    SID              Name          Address             Contact
                   1001              Shiva            Delhi                  123456
                   1002              Ram            Mumbai               987658
                   1003               Sri               Pune                   435675  --------> Record(Row)

SEVER TYPE IN SSMS ( Sql Server Managment studio)

When you install the SQL Server management studio and then you want to connect with the SQL Server then there are four types of SQL servers ...