What is SQL?
What is Database?
Database is nothing but the collection of information about a particular topic or data stored in way that it can be manipulated easily. In general we store the database in tabular format. Storing data in tabular format makes it easy to manipulate and use.
e.g. Buses Database, Flight Database , Student Database.
When we say we have database of buses or students that means we have all information about buses like where from bus starts, where bus stops, what is fair, facilities provided by buses etc.
What is DBMS?
DBMS is called database management system. Manually creating database and manipulating it becomes difficult. DBMS is a application software which enables us to create, manipulate database, it provides set of tools and facilities which help us to manipulate and manage the database. e.g. MS Access, Dbase , Foxpro etc.
What is RDBMS?
RDBMS is called relational Database Management System. Dr. Edgar Codd introduced the relational database model. Dr. Codd found that related data or data with relation is more informative and use full than non related data. So he define 13 rules if any DBMS support or follows these 13 rules we call it as an RDBMS.
The most popular RDBMS are MS SQL Server, Oracle, Informics, DB2, Oracle and MySQL
Every RDBMS has following two important features –
- Every RDBMS supports a Database Independent Programming Language, which allows you to manipulate the data by writing commands.
- Every RDBMS stores data only in the form table, everything that exits in RDBMS will be in the form of table.
SQL: – (Structured Query Language)
SQL stands for ‘Structured Query Language,’ which is an ANSI compliant language for accessing and manipulating database systems. Well, it’s MOSTLY standard across different proprietary DB systems like MS SQL Server, Oracle, My SQL, etc – but each company likes to write its own quirks and general wackiness into each of their database platforms. So a query written in SQL Server will not always work out-of-the-box on an Oracle Server unless you mess with the query a bit.
SQL is query language supported by many databases, using which you can manipulate the data from databases. Basically it is divided into following sections/Parts –
DDL: – data definition language provides you commands or queries using which you can create the structure of database or db. DDL Contains commands / Queries to Create, Alter, Drop any database object.
DCL: – data control language provides you command or queries using which you can control inflow and outflow of the data from database. DCL Provides you constraints, rules, Grant & Revoke.
DML: – data manipulation language provides you command or queries using which you can manipulate the data from database. Provides you commands and queries like Select, Insert, Update, Delete
For demos of SQL we are going to use MS SQL Server so we will learn some basics of MS SQL Server.
What is MS SQL server?
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.
Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft’s implementation of SQL that adds a set of proprietary programming constructs. SQL Server works exclusively on Windows environment for more than 20 years.
MS SQL Server supports following editions –
- MS SQL Express – Free To Use
- MS SQL Standard – Need Licenses
- MS SQL Enterprise – Need Licenses
You can download SQL Express from following link – https://www.microsoft.com/en-in/download/details.aspx?id=42299
please download following files –
Express 32BIT\SQLEXPR_x86_ENU.exe
Express 64BIT\SQLEXPR_x64_ENU.exe
MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe
MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe
SQL Server Supports two types of authentications –
- Windows Authentication
- SQL Server Authentication
Windows Authentication: – in windows authentication to connection SQL server you do not need explicit user id and password. Windows logged in user will login inside SQL Server.
SQL Server Authentication: – in SQL server authentication to connect to SQL server you need separate user id and password.
비아그라 구입
September 29, 2023 at 3:56 amHi there to every body, it’s my first pay a visit of this weblog;
this blog contains remarkable and genuinely good information for visitors.
sliding gate motor installers near me
October 3, 2023 at 4:26 pmExcellent blog here! Also your site loads up fast!
What host are you using? Can I get your affiliate link to your host?
I wish my web site loaded up as quickly as yours lol
비아그라 구입은 비아마켓!! 바로가기
October 30, 2023 at 8:16 amUseful information. Lucky me I found your web site by accident, and I’m
surprised why this twist of fate didn’t took place in advance!
I bookmarked it.
source
November 3, 2023 at 4:17 amHmm it looks like your website ate my first comment (it was extremely long) so I guess
I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog.
I too am an aspiring blog writer but I’m still
new to everything. Do you have any recommendations for
novice blog writers? I’d certainly appreciate it.
what is feetfinder
November 8, 2023 at 4:39 amIf some one needs expert view on the topic of running
a blog afterward i suggest him/her to go to see this website, Keep up
the nice job.
두피문신 후기
November 9, 2023 at 11:24 amSaved as a favorite, I like your blog!
prepared meal delivery
November 16, 2023 at 9:09 pmHi there! I could have sworn I’ve visited your blog before but after going through a few of the articles I realized it’s
new to me. Nonetheless, I’m certainly pleased I discovered it and I’ll be book-marking it
and checking back frequently!
feet pic price
November 17, 2023 at 10:22 amWonderful site. A lot of helpful info here. I am sending it to a few friends ans
also sharing in delicious. And of course, thank you in your sweat!
join feetfinder
November 17, 2023 at 11:09 amThis post will help the internet visitors for building up new weblog or even a weblog from start to end.
buying feet pics
November 17, 2023 at 11:14 amI feel that is among the so much significant info for me.
And i’m happy reading your article. But wanna commentary on few basic
issues, The website style is ideal, the articles is actually excellent
: D. Good activity, cheers
Tryout UTBK
November 21, 2023 at 3:31 pmWow, amazing blog structure! How lengthy have you been running a blog for?
you made running a blog look easy. The total look of your site is great, as well as the
content!
Tryout UTBK
November 21, 2023 at 4:35 pmAfter checking out a few of the blog posts on your site,
I really like your way of writing a blog. I saved it to my bookmark site list and will be checking back
in the near future. Please visit my website too and let me
know what you think.
Tryout UTBK
November 21, 2023 at 5:39 pmThank you for the good writeup. It in fact was a amusement account it.
Look advanced to more added agreeable from you!
By the way, how could we communicate?
비아그라구매 하기는 비아마켓! 클릭 클릭
November 23, 2023 at 5:16 amI loved as much as you will receive carried
out right here. The sketch is attractive, your authored material stylish.
nonetheless, you command get got an edginess over that you wish be delivering the following.
unwell unquestionably come more formerly again as exactly the same nearly a
lot often inside case you shield this increase.
비아그라구매 하기는 비아마켓! 클릭 클릭
November 23, 2023 at 5:39 amEverything is very open with a really clear clarification of the issues.
It was really informative. Your website is extremely helpful.
Thanks for sharing!
비아그라구매 하기는 비아마켓! 클릭 클릭
November 23, 2023 at 5:54 amI constantly spent my half an hour to read this webpage’s content every day along
with a mug of coffee.
gadai bpkb motor
November 24, 2023 at 4:42 amMy developer is trying to convince me to move to
.net from PHP. I have always disliked the idea because of the
costs. But he’s tryiong none the less. I’ve been using Movable-type on several websites for about a year and am nervous about switching to another platform.
I have heard very good things about blogengine.net.
Is there a way I can import all my wordpress content into it?
Any kind of help would be really appreciated!
gadai bpkb jakarta
November 24, 2023 at 5:56 amI’m gone to say to my little brother, that he should also visit this weblog on regular basis to
obtain updated from most up-to-date gossip.
gadai bpkb adira
November 24, 2023 at 7:14 amHowdy! This is my first visit to your blog! We are a group
of volunteers and starting a new project in a community in the
same niche. Your blog provided us valuable information to work on.
You have done a extraordinary job!
gadai bpkb jakarta
November 24, 2023 at 2:11 pmI was wondering if you ever thought of changing the page layout of your site?
Its very well written; I love what youve got
to say. But maybe you could a little more in the way of content
so people could connect with it better. Youve got an awful lot of text for only
having 1 or 2 images. Maybe you could space it
out better?
kitchen company
November 25, 2023 at 2:49 amRight here is the right blog for everyone who would like to find out about
this topic. You realize a whole lot its almost hard to argue with
you (not that I actually would want to…HaHa).
You certainly put a fresh spin on a subject that’s been written about for ages.
Wonderful stuff, just wonderful!
Custom kitchen cabinets
November 25, 2023 at 8:23 amHello there! This is kind of off topic but I need some advice from an established blog.
Is it very difficult to set up your own blog? I’m not
very techincal but I can figure things out pretty fast. I’m thinking about creating my own but I’m not sure where to start.
Do you have any points or suggestions? Many thanks
Family-friendly kitchens
November 25, 2023 at 8:47 amIt’s impressive that you are getting ideas from this paragraph
as well as from our discussion made at this time.
kitchen reviews
November 25, 2023 at 8:14 pmHey there, You’ve done a fantastic job. I’ll definitely digg it
and personally suggest to my friends. I am sure they’ll
be benefited from this site.
Designer kitchen spaces
November 25, 2023 at 11:03 pmMagnificent items from you, man. I’ve consider your stuff
previous to and you’re just too wonderful. I actually like what you’ve got right here, certainly like what you are stating and the best way wherein you assert it.
You make it entertaining and you continue to take care of to stay it wise.
I can’t wait to read far more from you. That is actually a great web site.
https://koperasi1malaysia.com
November 27, 2023 at 2:29 pmHola! I’ve been reading your blog for a while now and finally got the courage to go ahead and give
you a shout out from Dallas Texas! Just wanted to mention keep up
the good job!
business blogs
November 27, 2023 at 2:56 pmWhat i don’t realize is in fact how you are not actually a lot more neatly-appreciated
than you may be now. You are so intelligent. You recognize thus significantly in terms of
this subject, made me for my part believe it from so many numerous angles.
Its like women and men are not interested except it’s
something to accomplish with Girl gaga! Your own stuffs outstanding.
All the time handle it up!