Home Blog

What is a Relational Database?

0
What is Relational Database
What is Relational Database

What is a Relational Database Management Studio, Model, in access, schema, sql, usef for, definition etc..

Hey what’s up everyone. Welcome back to your second database design series. This video we’re going to be talking about the relation very basic. Don’t freak out with this math. We’re not going to go super in-depth with Matthew and know more about the math.

I have blogs on the website about that killed Kurt come forward slash blogs advertising not box advertising house advertising anyway. Basically your relation is just a connection between data. So let’s just think of silly example if we have the two sets of numbers 2 4 and the other set was 6 8 and then we kind of combine these sets. So we kind of life crossed here and then we crossed that again.

And one of these cross is our new sets we have the combined set of six. And know we have a combined set of six for me that combines a tune that combines a and like you’re probably wondering like what the heck does THAT have to do with database design. Well some what we kind of do the same thing with database design relation in relational database comes from this mathematic concept but rather than combining sets of numbers we’re combining attributes of real world things.

So let’s apply this to the database first you need to know two terms. The first one is an entity. The second one is for you. So an entity is anything we store data about attributes are the things that we store. So if an entity is a person an attribute would be their name their username and password their hair color their address their phone number their relationships that the person they’re in a relationship with the orders that they’ve made or whatever whatever it is.

It just depends on what you need to store for that specific application. So Anthony is what we store the data about the tribute is what we store when we apply this to this. This connection with the the relation we have the Freeview types and the attribute values. So let’s say we have this person over here and we’ll name them Caillaud because it’s an awesome name.

All right. And then we will also give them a user name. Caleb Currie with no spaces. And we give them the password PI 2:59 and then over here we have the set of attributes for a table we have name user name and password. We can make this connection of data. So the name is Caleb the user name will curry passwords PI 1 2 3.

That makes sense although graphically it looks like a mess. So we store these in teams which is exactly what we were doing with the relation’s So we have all of your inner columns we have we have a name and then we have the user name and then the password. Don’t worry if you can’t read my handwriting you get it. We started this in a table.

All right. So these are the things we need to connect with this person over here which we named Caleb and I actually raced them whatever. What does that that. So that’s cool. And we want to store this information in this table which is a graphical way to say to illustrate how we’re storing data in a database. So we take his name.

We take his username cable courier we take his password I to three we kind of get this same concept. It almost looks like a spreadsheet that we talk on the last day although it is slightly different and we’ll be talking about as time goes on. This guy is the entity that we’re storing information about. These are the attributes that we need to store about this person or any other person. So we enter specific values for each one of these attributes to make the relation between the attributes and the entity that makes somewhat sense. And if it doesn’t don’t freak out it’s ok.

I mean this is complex thought and you don’t necessarily need to understand every single detail to design a database. So I’m just trying to explain things and we’ll get through it. These are the attributes of this person. This entity an entity is basically just anything we store data about.  It’s something can be a person in this case but it can also be in order.

What is a Relational Database Management Studio?

It can be a customer can be a client it can be a employee an employer whatever it is. It doesn’t have to be a person. So now the relation idea and you kind of understand that we’re just making the connection between the attributes and the entity the value the entity attributes. We’re entering the database. That’s that’s kind of a weak explanation but honestly it doesn’t really matter that much for getting into a basic database design.

So if you can learn more about that look up relational database design you’ll figure it out. So now we have the entity over there. And then we have 36 so in table terms you probably know rows and columns you might not know specifically what they are. I’m going to tell you this right here in a row.  You see that you run that space here. I think we’re good. Yeah.

So this all of these values are erro. So I row is all of the attribute values for a specific entity. So this row and these are just going this this row points to that entity that person pretty simple a column or all of the values for a specific attribute type. So the attributes that we could have another person Billie-Jo up and his name is password can be within you and his name can be. And this is another person in our table. So this is talking about a different person.

We have his first number you seem pretty chill. All this row is talking about this and the user name is a call where we have all of the attribute types. Username. So Caleb. Billy Joe and whatever more we put more values into the table. So once again a little messy. I was going to clean up the race. So just to summarize a bit. We have very first thing we have at the time. That’s the word you want to talk about into these I’ll just tell you what it is.

This is Anthony. And then we have the interview by. So basically the type means it’s a category. So the person was the specific entity that the guy whose name Caleb now wasn’t it was the person that we all saw the entity Joe or Billy or whatever his name was. Those were two separate people two separate entities although you could tell that they were somewhat similar.

They were both in the same table.They were both talking about the username password and so forth. So the Inzaghi time is user a specific entity would be cable or Bill or Jane or Jake or whoever it is. So the internet time is basically in the category of the entities that have restoring the categories of user and all of the all the entities within it should be a user. So my camera stop recording by itself for some reason which is super annoying. But anyway so the type is the category of entities such as user.

Every single entity should be a user. Cable was a user. Billy was a user of Jimmy John we could have got Katherine we could have Caitlin we could have Casandra we can have you get one naturally types basically the categories of attributes. So we had the user name we had the the name we had the password of these or attribute types because we don’t actually have a specific value.

It’s like no one’s name is name. When we actually give these specific values they no longer become types and they become specific examples. So this guy over here here is our anti gun store. So basically here’s a recipe we can store attributes about this entity the user name can be Caleb curry. The name could be Caleb and the password can be PI 2:59. So these are specific attributes about that guy. Now all these are all complex terms and who really cares what really matters is can you put this into a table for people to understand who really cares if you know the terms of it.

I mean I’m sure your professor cares so make him anyways. Table to columns or the attributes so we can have for example an idea a password a user name and email. We can keep going address phone number and whatever else. And then a row is where we give the value for every single one of these attributes. All talking about one entity. So like this guy this guy right here. Well as you do for example 72. His user name is Caitlin curry. His email is cool guy at hotmail dot com blah blah blah blah blah. All of this row talks about this guy.

So basically just think attributes are comb’s entities or individual. So sweet. And then this whole thing right here. This is the table and that is the entity type so the entity type was the user because every single row in this table should be user. Oh another thing I would like to mention real quick of another name in mathematics for a row is a tumble or a tuple. I think it’s trouble.

I don’t know but that is another term you will hear. So yeah Tuttle is a thinking sorry for like yelling Get all intense fun right. So that’s the lesson in this video. If you want to subscribe you better do that like right now with scribe. And if you haven’t subscribed yet you better subscribe and also click like subscribe. Thank you and I will see you guys in the next video where we’ll be talking about relational database management systems.

Another big word which we will explain shortly. So see around.

How to install SQL Server on Mac and Windows

0
How to install SQL Server on Mac and Windows

First I will start with installing a school server on Mac then I will show you how to install a SQL Server on Windows.

In this course you’ll be learning is cute using Microsoft a school server. I will show you how to install a school server on both Mac as well as windows.

Section 1: Microsoft SQL Server on Mac

    • Docker Download

    • Docker Installation

You can see this I downloaded the downloads folder just click on the file you can see it’s asking to drag and drop this drag and drop into the Applications folder. Just wait for it to get copied with applications you can verify that you can see how the docker.

So once you verify this you can just close other windows. So now back to the applications click on the doco file. It’ll ask you Are you sure to open it. Yes click open it will ask for your password so just click OK. And already a password OK. OK.

And now you can see the doc a symbol at the top and you can see dot dot com starting. So after a while it will be running and you can either prevent a door correctly password and log in. Or you can just leave it. It’s not required.So let’s wait for it to start from start to running.

    • Kitematic Introduction

Now you can see the doctor is still up and running. And you can either provide your doctor I.D. and password or you can just leave it. Now we can close this one I’ll show you a tool called kite Matic this kite Matic is a graphical interface using which you’ll be managing your containers. So there is no need for using the terminal so to get this kite Matic just click the here.

    • Kitematic Installation

Yeah you can see the fight getting downloaded here. It will take a few seconds for the download to get completed. Now we can see the file it got downloaded you can just close this one drop this file into the applications go to the applications and yet you can see the file here to conduct and it’s asking audio should you want to open it.

Just click open, you can either provide it username plaza or you can just keep it for now. Now you can see a lot of images here. We are looking for Ms S close server so just type a must obscure and after typing a school you can see there are different images starting with a massive school.

You can see a massive school server another image another one with a massive school. Another one of them a school but you want the one from Microsoft which has more downloads. Just click the create and you can see the image getting downloaded.

    • Configure Docker settings for Microsoft SQL Server

    • Download Azure Data Studio

Next you need to connect to the school server and to connect with a school server. You need a tool called a zero data studio. Just go to Google and type as you data studio. You can see the official link from Microsoft using which you can download as your data studio scroll down and you can see for a macro yes you have the download file this contact.

    • Install Azure Data Studio

    • Download AdventureWorks Sample Database

    • Copy AdventureWorks backup file to Docker container

    • Restore AdventureWorks Sample database to SQL Server

Section 2: Microsoft SQL Server on Windows

    • Download SQL Server 2017 Express Edition

To install a school server on Windows first you need to get the school server 20 something explicit addition. So just go to Google dot com and type in a school server twenty something express addition download.

You can see the SQL Server 2017 express addition in the official Microsoft dot com download. No click see you can see the file getting downloaded the file got downloaded now so just go to the downloads folder. You can see the file that the downloads folder.

    • Install SQL Server 2017 Express Edition

    • Download and Install Azure Data Studio

    • Download AdventureWorks Sample Database

To get this over name go to the notepad. And copy the server name Paisley 70 and authentication type. Leave it as windows and other fields. This leave it as default.

Click connect and know you got connected to the SQL Server and you can verify this connection by writing a simple query click the new Cary using this curry. You can find the version of the SQL Server to which you got connected. Now select the curry patron.

You can see the evolution as a server 2017. And it comes with 4 system databases which you can look at the top but you need a sample database to practice. So to get this sample database go to Google and type adventure works sample database.

And this is the sample database provided by Microsoft. You can find the link for adventure books. Sample database from Microsoft dot com. Click on that link. It will direct you to the download page scroll down. And click.

The adventure looks to be something back of 5. You need adventure books 2017 because you installed a SQL Server 2013 Pixie so God downloaded go to the downloads folder you can see the file here. Next you need to restart this backup file to is Kosovo so just go back to the data studio and you can fight in the restored option here.

    • Restore AdventureWorks Sample Database to SQL Server

But before that let me first copy this downloaded backup file to my local right so in my C right I’m just creating a backup folder that I am going to copy this downloaded backup file and just copying it to this newly created backup folder in my local time.

Now back to the zoo data studio. Click restore and choose the backup file as option and choose the file but backup the C drive backup full of articulated how this backup fine pick. Okay.

And leave the names as default click restore. You can see the database getting restored. Here take a few seconds and you can see the database successfully restored on the Eskil server and we can verify this now by going through this window.

If you don’t see this window just click the button here and you will be seeing this window again. Go to the databases and you can see the sample database code restored let’s write a query against this database click. You could see and we’ll try to find the number of tables in this database.

So let’s write a basic query selected Curti run and it can see the tables and the sample database so these tables already has pre populated data. This in which you can practice it has something on tables so using this 70 on tables we can see our demos.

Microsoft SQL Server 2008 R2 SP2 – Express Edition

0
Logo Microsoft SQL Server 2008 R2
Logo Microsoft SQL Server 2008 R2

Microsoft SQL Server 2008 R2 Express with Service Pack 2 is a free and feature-rich database for developing and deploying SQL Server 2008 R2.

There are multiple files available for this download. Once you click on the “Download” button, you will be prompted to select the files you need.

https://www.microsoft.com/en-us/download/details.aspx?id=30438

Version:10.50.4000.0

File Name:

SQLEXPR_x86_ENU.exe

SQLEXPR_x64_ENU.exe

SQLEXPR32_x86_ENU.exe

SQLEXPRADV_x64_ENU.exe

SQLEXPRADV_x86_ENU.exe

SQLEXPRWT_x64_ENU.exe

SQLEXPRWT_x86_ENU.exe

SQLManagementStudio_x64_ENU.exe

SQLManagementStudio_x86_ENU.exe

Microsoft SQL Server 2008 R2 Express with Service Pack 2 is a free, feature-rich edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.

Key Features Offered By SQL Server 2008 R2 SP2 Express:

  • Supports stored procedures, triggers, functions, and views
  • Store all kinds of business data with native support for relational data, XML, FILESTREAM and spatial data
  • Improved performance, usability, visualization, in addition to integration with the Microsoft 2007 Office System in SQL Server Reporting Services
  • Simplify development efforts by leveraging existing T-SQL skills, ADO.NET Entity Framework and LINQ
  • Closely integrated with Visual Studio and Visual Web Developer

How to Install the Microsoft SQL Server 2008 R2 Express Edition

SQL Server 2008 R2 SP2 Express Editions:

SQL Server 2008 R2 Express with Tools: Core edition of Express that supports development. Includes SQL Server 2008 Database Engine and SQL Server Management Studio Express

SQL Server 2008 R2 Express with Advanced Services : Extends SQL Server 2008 Express with tools to include support for Integrated Full-text Search and Reporting Services

SQL Server 2008 R2 Express (Runtime Only): Includes the SQL Database Engine only and is designed for deployments and ISV redistribution.

SQL Server 2008 R2 SP2 Management Studio Express: Free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 R2 SP2 Express. It can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2008 R2 SP2.

Customers looking to download SQL Server Express and SQL Server Management Studio Express for the first time, please download the bundle: SQL Server 2008 Express with Tools.

KB article 2630458 provides additional information about key fixes in SQL Server 2008 R2 SP2 for all SQL Server Editions. To learn more about SQL Server 2008 R2 SP2 please review SQL Server 2008 R2 SP2 Release Notes.

Prerequisites
To install or update SQL Server 2008 R2 SP2 one will need adminstrative rights on the computer.

Step 1: Install Microsoft .NET Framework 2.0 or later from the

Microsoft Download Center

Step 2: Download SQL Server Express by clicking the SQLEXPR.EXE or SQLEXPR32.EXE link on this page. To start the installation immediately, click Run. To install SQL Server Express at a later time, click Save.

Note: SQLEXPR32.EXE is a smaller package that can be used to install SQL Server Express on 32-bit operating systems only. The SQLEXPR.EXE package supports installing onto both 32-bit and 64-bit (WOW install) operating systems. There is no other difference between these packages.

Step 3: Follow the installation instructions provided in the Readme. Known issues may be found in the

SQL Server 2008 R2 SP2 Release Notes

 

Choose the download you want

SQLEXPRWT_x64_ENU.exe247.5 MB
SQLEXPRWT_x86_ENU.exe235.5 MB

https://www.microsoft.com/en-us/download/details.aspx?id=23650

SQL Server 2008 R2 RTM and SQL 2008 R2 Express Downloads

SQL Server 2008 R2 was released to manufacturing.  As usual, a free (and limited scale/functionality) Express edition was also released.  There are three packages, from the version just with the core components, the version with management functionality, and the version that has management and more advanced features:

  • SQL Server 2008 R2 Express: The Microsoft® SQL Server® 2008 R2 Express RTM is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded applications, lightweight Web Sites and applications, and local data stores. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft’s System Preparation Utility for Microsoft Windows operating system deployment.
  • SQL 2008 R2 Express with Management Tools: an easy-to-use version of the SQL Server Express data platform that includes the graphical management tool SQL Server Management Studio (SMSS) Express
  • SQL 2008 R2 Express with Advanced Services: an easy-to-use version of the SQL Server Express data platform that includes the graphical management tool SQL Server Management Studio (SMSS) Express, powerful features for reporting, and advanced text-based search capabilities

The requirements for the Express edition are:

  • Windows 7; Windows Server 2003; Windows Server 2008; Windows Server 2008 R2; Windows Vista; Windows XP
  • 32-bit systems: Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.)
  • 64-bit systems: 1.4 GHz or faster processor
  • Minimum of 512 MB of RAM (2 GB or more is recommended.)
  • 2.2 GB of available hard disk space

[WPCR_SHOW POSTID=”ALL” NUM=”5″ PAGINATE=”1″ PERPAGE=”5″ SHOWFORM=”1″ HIDEREVIEWS=”0″ HIDERESPONSE=”0″ SNIPPET=”” MORE=”” HIDECUSTOM=”0″ ]

How to use a basic ORDER BY clause? Section8

0
Using-the-ORDER-BY-clause
Facilitates sorting of data results in a particular order / direction. The order by clause consists of column identifies that the result is to be sorted on, separated by commas. The column identifier can be a column name / expression / alias / position. Sorting is done in ascending (ASC) or descending (DESC) order on any combination of columns, regardless of whether that column appears in the result. Sorting is by default ascending. Basic SELECT Statements.

It the previous article we’ve discussed about select statement in a sequence of which. We’ve seen a basic select statement the sequel. We discuss how we can be able to manage plate number treeing and deathly Trotz.

We’ve also discussed how we can be able to carry columns from a table how we can be able to perform some condition. I’ve always been using this way in as well as functions how we can be able to perform some mathematical operations as well as how we can be able to use some building function inside a select state.

In this article we’ll discuss about order by a cause. Another important state and one in sequent language. Let’s assume we’re working as and at least we were tasked to create a report that is going to follow some sort of an order and to be able to produce these.We’re going to have to implement an ORDER BY clause. There are two kinds of order.

There is ascending order. Then we have to use a s c then b a descending order or D s c a d forth ordering. If we don’t specify an ascending order then if I execute this statement you will see that the state I said is order. Yes and the order population.

Basic ORDER BY clause?

ORDER BY clause we can also be able to sort using two or more columns for example. We will like to order Montaigne’s by name then by their elevation in a descending order if I execute this statement you will see that this data is sorted by name first and then by elevation.

For example if we look at Rocky Mountains you’ll see that the top peak of the mountain or Moland elbow comes first then the second topic of Montaigne’s which is peaks Pike comes back to the status it is or it is Montaigne’s in ascending form and then with elevation in the informant.

The SQL ORDER BY syntax

So you can keep adding more columns as you wish for an order by clause. Another way to do an ordering is you can be able to refinance the column order Montaigne’s. The second call on the select statements so this. What this means is use mandis for your first ordering in an ascending format and use elevation on the third column.

This is not recommended practice in production but when you are doing any testing you can quickly type the number to be able to sort but another developer columns here then your orders will not be the same. If you’re using an order number instead of a column name or order by.

http://www.sqlservertutorial.net/sql-server-basics/sql-server-order-by/