Create View in MySql

Today we will learn how to create view ( with pictures)

Now we learning in this example creating table, create view and inserting values into view and linking to table that view

CREATE VIEW Syntax 

CREATE [OR REPLACE] 
 [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] 
 [DEFINER = { user | CURRENT_USER }]
 [SQL SECURITY { DEFINER | INVOKER }]
 VIEW view_name [(column_list)] 
 AS select_statement [WITH
[CASCADED | LOCAL] CHECK OPTION]

Here with an example exaplained(pictures)
1. create table t in the database/schema satya
2. insert values into that table
3. create view with the name v to that table t 

now created table and inserting data values.

now inserted data to the table

created view to the required table as above

here we learnt creating view. Thank you for viewing.

Other related topics:

cloud computing

Ubutu Commands

what is Ubuntu Operating ssystem

what is E-commerce

Create table in Mysql

Alter Table in MySqlWorkbench

Today we will learn how to alter table in MySqlWorkbench

ALTER TABLE STATEMENT

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

SQL ALTER TABLE Syntax

To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column):

ALTER TABLE table_name

DROP COLUMN column_name

Here in example, we delete the "empsal" column with the following statement:

 Alter table satya.emp drop column emp.empsal;

Then execute it by clicking on second button.  then it green tick mark available.

We have to refresh it. Then it affects to the table we can see as in the columns list of the table.

 To add a column in a table, use the following syntax:

ALTER TABLE table_name

ADD column_name datatype

In my example, we are going to modify the table "emp" we are going to add a new column "salary"

Alter table emp add column designation varchar(40);

Then Press on execute button

Then if execution with no syntax errors, green tick marks appears.

Then added column name in the column list of the table.

Related Topics:

Create table in MySqlWorkbench

How to create Database Table in MySql(with pictures)

Today we will learn how to create Database Table in MySql workbench:

First we need to create Schema then to that schema we can add tables and insert data into that tables

    1.       Open Mysql Workbench

2. Open Database menu click on Connect to Database

3.       Change Stored Connection: First default with local some server but we have to make it blank

4.       Click Button Store in Value and enter password in the above screen and press OK button

5.       Click on Ok Button

6.       Click on + Database icon for create a new schema  

 

7.       Enter new schema in this example I am using yearly and click and apply button.

8.       Then this screen appears

9.       And again click on apply button

10.   Click finish button

11.   Again click on Apply button

12.   Now schema created next we have to create Tables to that schema

13.   Enter table name And double click

14.    

 

1   5.   Enter column name and Data type

1   6.   Enter double click for Create other columns as per requirement

1   7.    

1   8.    

1    9.   Click on Apply button

      10.   Then this screen appears

      11.    

     12.   Check the syntax and fields and click on Apply Button

     13.   Then click Finish Button. Now table created

 

      14.   In two ways you can add data to table first by using Insert statement and second by Gui grid base

Click on Apply Button

     15.   Click on Finish Button.

     16.   Second method to by Insert Statement for that create new Sql Editor

     17.   Then enter script like this

 

 

    18.   press this execute icon as shown below

    19.   Then to view in grid

    

3 

3  

That’s it we have learnt about creation of table and inserting data values into tables with 2 ways.

Related Topics:

Ubuntu         Cloud Computing        Ecommerce

Useful Ubuntu Commands

1.       ls  list all the files in the current working directory.

  ls dir Lists the specified directory.

2.     rm remove the files from the directory.

3.       clear Clears the current screen of all text.

4.      cat file Concatenates (adds) the contents of the file to your screen.

  It’s like the MS-DOS type command.

5.       more file Displays the file one page at a time.

6.       tail file Displays the file one page at a time from the end of the file.

7.       pwd Shows name of the current directory.

8.      cd dir Changes to the specified directory.

  It’s like the MS-DOS chdir command.

  cd ("change directory") - Changes the directory you are currently working in.
  You can use full paths   to folders or simply the name of a folder within the directory you
  are currently working.
  Some common uses:

 cd / - Takes you to the root directory.

 cd .. - Takes you up one directory level.,

 cd - - Takes you to the previous directory.

9.   cp ("copy") - Allows you to copy a file.You should specify both the file you want copied and the location you want it copied to- for example: cp foo /home/johnwould copy the file "foo" to the directory "/home/john".

10. mv ("move") - Allows you to move files.You can also rename files by moving them to the directory they are currently in, but under a new name. The usage is the same as cp - mv foo /home/john would move the file "foo" to the directory "/home/john".

11.    rmdir ("remove directory") - Removes an empty directory.

 rm -r ("remove recursively") - Removes a directory along with its content.

12.    mkdir ("make directory") - Allows you to create a new directory. You can specify where you want  the directory created - if you do not do so, it will be created in your current working directory.

13.  history - Displays all of your previous commands up to the history limit.

Acquaint yourself with these help commands

14.   man - Displays a "manual page" on the specified command. Manual pages are usually very detailed, and it's recommended that you read the man pages for any command you are unfamiliar with. Some common uses:

man man - Provides information about the manual itself.

man intro - Displays a brief introduction to Linux commands.

15.   info - Similar to man, but often provides more detailed or precise information.

<command name> -h or <command name> --help provide a third alternative.
While not as detailed as the info or man pages, this will provide a quick overview of the
command and its uses.

Learn some commands related to displaying information about your system

16. df (display file system) - Displays information about the disk space usage of all mounted file  systems.  df -h uses KB, MB, and GB, if this format is preferred.

17.  du (directory usage) - Displays the size of a directory and all of its subdirectories. du -h can be used if KB, MB, and GB are preferred.

18.   free - Displays the amount of free space available on the system. To view the information in MB,  use free -m.

19.   uname -a - Provides a wide range of basic information about the system.

20.  top - Displays the processes using the most system resources at any given time. "q" can be used to exit.

Uses Of Cloud Computing in Real Time

Cloud Computing

Every day our activities without notice we are using Cloud computing like social media, online shopping ordering products, online payments, receiving acknowledgement, billing, verifying bank account statement details.

Benefits are without wasting time and money and completing within deadline. We are not worried about the payments about theft because OTP helps us for, it’s like an interactive responsive that’s most reliable for our transactions are become more secured. The cloud computing fulfilling all the benefits without tension.

It actually improves our lives.

Small and growing business taking full strength of the cloud computing to do their business better with cheap and scalable IT capabilities. Virtualization helps in all the resources of the computers such as hardware, software, skills, networking, infrastructure etc.

The employees working with option work from option.

Future of Cloud Computing

Soon computers and software will become “invisible” in that they are hidden from view. We may simply have to make gestures and a camera will interpret those and provide us what we need, or we simply have to say it. Consider J.A.R.V.I.S. from the Ironman movies, you simply ask something and that information is streamed from the cloud to a projection or a monitor. Most times it could even predict what you need based on past actions and personal behavioural trends.

Google Cloud services are:

• Gmail: is an email service that provides users with 25GB storage, less spam and mobile access. It has an integrated chat applet that stores conversation in the form of email.

• Google Docs: is a service that allows users to create spread sheets, word documents and power point presentations and store them on the cloud servers. The documents are available online so that they can be accessed from anywhere and at anytime. This helps team members located in different countries to cooperate in completing their work. Google docs are secure since the files are encrypted using advanced encryption technology and are only accessed by authorized users.

• Google analytics: is used to monitor the traffic come onto a website.

• Google Ad words and Ad Sense: which are advertising tools? 

• Picasa: which is a tool used to exhibit product and uploading their images in the cloud.

Microsoft Cloud Computing Services are:

    Microsoft provides a cloud platform called Windows Azure platform which consists of a set of cloud services offered to users and application developers. All services run in Microsoft data centers located around the world.

 These services include:

• Windows Azure: a windows environment for storing data and running applications in the cloud.

• SQL Azure: is a relational database services in the cloud that use a special version of Microsoft SQL server.

• Windows Azure App Fabric: provides an infrastructure for applications that run in the cloud or inside an organization.

• Windows Azure Marketplace: is an online market to buy and sell application software and data.

 Amazon Web Services (AWS) are:

  

AWS provides a cloud computing platform for all business sizes. With AWS companies can provision a flexible and cost-effective IT infrastructure and services that can be scaled up and down based on their needs. AWS helps companies select the platform that is suitable for the problem they have and pay only for what they use. In addition, AWS applies advanced physical security and data privacy techniques to protect user’s data. AWS has security certifications and audits such as ISO 27001, FISMA moderate, HIPAA and SAS 70 Type II. AWS is a comprehensive cloud service platform which provides many web services such as:

 • Amazon Elastic Compute Cloud (Amazon EC2): is a web service that provides configurable computing resources in the cloud.

• Amazon Simple Storage Services (Amazon S3): is a scalable, secure and reliable storage for the Internet that can be used to ubiquitously store and retrieve data of any size on the web. 

• Amazon Virtual Private Cloud (Amazon VPC): connects the company’s existing IT infrastructure to AWS cloud via a Virtual Private Network (VPN).

• Amazon CloudFront: is a web service for content delivery that transfers customer’s data with high speed and minimum delay using a global network of edge locations .

• Amazon Route 53: is a scalable and highly available DNS service.

• Amazon Relational Database Services (Amazon RDS): is a web service that helps manage a relational database in the cloud. • Amazon Simple DB: provides the core database functions.

• Amazon Simple Queue Service (Amazon SQS): is a scalable, reliable, hosted queue for storing messages.

• Amazon SNS: is a web service that helps manage and send notifications from the cloud.

• Amazon Elastic Map Reduce: is a web service that enables customers to process vast amount of data on the Cloud.

HP Cloud Services are:

HP provides several services through its public beta and we describe these services below:

 • HP Cloud Compute: provides elastic scalable virtual servers that can be customized on user’s demand as the workload changes. It allows customers to save time wasted in resource configuration and to save money since customers only pay for resources they provisioned. It also provides an open standards environment that ensures portability and prevents vendor lock-in and allows for collaborative work.

• HP Cloud Object Storage: an online massive storage capacity that allows customers to store large amount of data such as audio and video files. It can be scaled up and down on-demand to meet storage change needs and it achieves reliability by replicating objects many times in multiple availability zones so that customers can access their data when they need it.

• HP Cloud Block Storage: allows customers to store data on HP Cloud resources for as long as they need and easily move it from one compute resource to another.

 • HP Cloud CDN: CDN refers to Content Delivery Networks and it is a web service that delivers data from HP Cloud Object Storage to customers around the world at high speed using global network of servers from HP and Akamai.

 • HP Cloud Relational Databases for MySQL: is a web service that provides on-demand access to relational structured databases.

• HP Cloud Identity Service: provides a single method for managing HP cloud users’ identities and authentication.

Sales force Cloud Services Sales force provides cloud computing solutions such as Service Cloud and Sales Cloud:

• Service Cloud: is a platform for customer services that allows for thousands of conversations on the Cloud. It provides different conversation tools that help empower CRM around the world such as online communities, Social networks, Phone, email & chat, Partners and Search. 

• Sales Cloud: provides a comprehensive and easy to customize tools that deliver information to users in real time, at anytime and from anywhere. 

These tools include: 

Chatter, Mobile, Files & libraries, App Exchange and Marketing & leads. 

KEY SERVICES Based on the strong experience in the development of Business Application Services, Zensar has developed following cloud based offerings: g it to the cloud platform with the help of questionnaire, workshop and pilot. 

Cloud Application Management Services : 

These Cloud services allows development / maintenance of applications that runs on cloud infrastructure (public / private / hybrid) providing greater scalability / high availability and leveraging cloud services such as: Storage, Messaging, DB and NoSQL services. 

Cloud Migration Services:

Our Migration services are specifically for moving application from existing infrastructure to the Cloud using IaaS / PaaS / SaaS based service model and thereafter enhancing application considering other cloud services.

Cloud Integration Services : 

The Integration services on cloud platform using open standard APIs, ESB based framework or custom tools such as IBM Cast Iron, Informatica Cloud etc. to connecting from on-premise applications to cloud or cloud applications to another cloud infrastructure. 

Cloud Infrastructure Services : 

Our Infrastructure services provides complete stack of servers, network / bandwidth capacities, storage and database services to the potential customers considering public / private and hybrid cloud scenarios along with backup & restore / DR strategy

BENEFITS OF CLOUD COMPUTING SERVICES

Cloud computing services offer numerous benefits to include:

· Faster implementation and time to value

· Anywhere access to applications and content

· Rapid scalability to meet demand

· Higher utilization of infrastructure investments

· Lower infrastructure, energy, and facility cost

· Greater IT staff productivity and across organization · Enhanced security and protection of information         assets.

Other Related:

What is Cloud Computing