The full form of SQL is structured query language. The SQL is a standard language for the accessing and manipulating the database. This is a language of ANSI (American national standard institute) standard one. By using this language we can execute queries against the database. We can retrieve data from the database, we insert records in a database, we can delete records from the database, we can update records from the database, we can create new database, we can create store procedures in the database, and we can set up permissions on tables, procedures and views.
The basic concept needed for SQL is RDBMS (Relational Database Management System) and even for all the database systems. RDBMS data is stored in Table form where a Table is a collection of records. Record is a collection of Rows and Columns. Most of the database tables contain 1 or more tables. Every table is identified with it specific name. The actions performed on the database are done by sql statement that is nothing but queries.
Structured query language is a case sensitive. Some database language query should be ended with the semicolon. But for SQL server2000 and MS access doesn’t need semicolon at the end of the query.
Structured query language (SQL) has classified into 2 parts:
1.Datamanupulation Language(DML)
2.Data Definition Language(DDL)
1. Datamanupulation Language(DML) commands for writing a query:
a. Select command –
Select command is used to extract selected data from the database.
b.Update command-
Update command is used to update the data in the database.
c.Delete command –
Delete command is used to Delete the data in the database.
d.Insert command –
Insert command is used to insert new data in the database.
2. Data definition Language (DDL):
In SQL, DDL commands permits the database to create and update the tables. The DDL commands are:
a. Create Database command –
This command is used to create a new database.
b. Alter Database command –
This command is used to modify database.
c. Create Table command –
This command is used to create a new table.
d. Alter Table command –
This command is used to modify tables.
e. Drop table command –
This command is used to delete Table.
f. Drop index command –
This command is used to delete an index.
Statements:
1. The select statements:
The data from the database can be selected by using select statement of sql. This result of the sql statement will be stored in result- set.
Syntax:
Select column_name from table_name
Or
Select * from table_name
2. Select distinct statement:
A table may contain duplicate values in the column. We can list only distinct values by using select distint statement.
Syntax:
Select Distinct colum_nname from table_name
3. Select where clause:
To extract particular data from the table we can use where clause.
Syntax:
Select column_name from table_name where column_name operator value.
The operators allowed in the where clause :
1. = equal
2. >< Not equal
3. > Greater than
4. < Less than
5. >=greater than or equal
6. <= Less than or equal
7. BETWEEN – Between an inclusive range.
8. LIKE – to Search for the pattern
9. IN – to return the exact value for a column.
4. And & or operator:
The records can be filtered using a condition by using And & or operator. If first condition and the second condition is true, then the And operator displays the record. If the first condition or the second condition is true then the Or operator displays the record.
Syntax:
Select * from table_name where column_name= value And Column_name= Value
5. Orderby Clause:
OrderBy clause is used to sort the result set. We can sort the record by using orderby clause command. We can sort the record in ascending order and descending order. The default of sorting the record is ascending order.
Syntax:
Select column_name from table_name orderby column_name Asc|Dec
6.Insert inti statement:
To insert new record into the table Insert Into command is used. There are two forms of insert into command.
To insert only values
Syntax:
Insert into Table_Name Values (value1, value2, value3……………..)
To insert both columns and values
Syntax:
Insert into table_name( column1, column2, column3……………..) values(value1,value2,value3………)
7.Update statement:
To update the existing records in a table we can use update statement.
Syntax:
Update table_name SET column1 = value, column2= value...where some_column = some_value
If the where clause is omitted then all the columns in the records gets updated.
8.Delete statement:
To delete record in the table, we can use delete statement.
Syntax:
Delete from table_name where some _column= some_value
A beautiful design. That is what the Mac systems from Apple, but the operating system called osx that will come standard with the Mac systems may not support the applications you use. They also want a full-fledged operating system more advanced than OSX.
Thanks to the Intel-based CPU `s currently in the Mac systems are placed, it is possible to easily install Windows on your Mac. Previously available systems, the Mac does not have a CPU that supports standard Windows was. Through some tricks it was possible to run Windows on these systems to install everything there was a lack of good drivers.
BootCamp assistant
Besides the fact that the Intel-based Mac systems, Apple has made it possible to install Windows using Boot Camp Assistant. Apparently they want to design a quality operating system that supports all, and therefore Apple will come with this tool is that it is possible to install Windows on the Mac.
Installing Windows 7
Installing Windows 7 is as easy as starting up your Mac system. To install Windows 7 is a disk that Windows 7 is an original license (or a trial version). To insert the disk into your Mac system, Windows 7 and wait until the disc geladen.Vervolgens go to the folder `s and then followed by a sub folder` s Tool This last folder is the Boot Camp Assistant utility. Double-click this tool and will launch the program.
BootCamp Assistant has a clear step by step setup you can go through. BootCamp assistant will ask you how large you want the partition where you want to install Windows 7. I recommend you to at least half of the hard disk if you want to use Windows 7.
If the setup has completed, restart the Mac, and then begin installing Windows 7. You get back a setup window that certain things are required. It is also possible here to format the partition, you must do this. Windows 7 will not ask but working to get Windows 7, you must first format the Windows partition 7.
Then you can simply run the setup, and Windows 7 will begin the installation process. It takes about half hour to three quarters. The Mac will reboot a few times, this is all part of the process of installation.
When the desktop Windows 7, you have to do one thing before you can use Windows on your Mac 7. The correct drivers are not installed by Windows 7, therefore you need to drive in Snow Leopard throw and go through the installation of this disc. This ensures that all features of Mac operating systems such as the keyboard but also the sound and the webcam will work on your Mac.
After installing all kinds of functions on your Mac as it should work, you can now update your Windows 7 and install your applications.
Standard Windows 7 launch
After installation, Windows 7 is set as the default operating system on your Mac. This means that if your Mac will automatically start Windows 7 starts. If you really want to get OSX and default operating system starts you can feel it afterwards as well. You do this by booting from the Mac the option key and hold, this is the left alt key on the keyboard. Now there are two disks appear where you can select. One, Windows 7 and the other OSX, click the drive with OSX on it and the old operating system will boot.
You have not yet OSX and operating system are standard, a tool that lets you setup in the Utilities folder `s.
Other operating systems
It is with Boot Camp assisant possible to install older versions of Windows including XP and Vista. It is also possible to install Linux or Ubuntu using Boot Camp assisant.
UNIX
Most Computer users have a very little concept about Operating Systems. Let us make some light upon a very different Operating system called UNIX. It is much more than the MSDOS. Talking about its history, it was built at the AT&T Laboratories in late 1960s. A design was made by Rudd Canady and later this design was improved to UNIX by Ken Thompson and Dennis Ritchie. Its earlier name was UNICS or Uni-plexed Information and Computing System that finally changed into UNIX. It is written in C language. There were many reasons for the popularity of UNIX. Different commands were there for performing different tasks. More than one command can be connected to perform tasks simultaneously. The system provides pattern-matching feature. One cannot use just file name for pattern matching but also can provide expressions. The wild card characters i.e., “*” and “?” can be used for this. UNIX system treats all file alike. Files can contain anything i.e., text, directory structures etc. the system is portable. Unlike MSDOS, UNIX can be provided to different clients through server. This implies that UNIX is a multi-user system i.e., it can be used simultaneously at more than one system. It is also multi-tasking, i.e., an user can run more than one task process simultaneously. UNIX provides online help facility with a command. This displays name with syntax of specified command.
Alongwith these merits, there are some demerits too with UNIX. As there are different commands to perform different tasks, it makes the list of commands lengthy and difficult to remember each command, about its use and syntax. Of all the commands can be combined with each other. UNIX was designed for programmers but not for any end-user. Only the persons knowing the commands can work on it. It does not provide user-friendly environment as it is offered in today’s Operating Systems like Windows.
Beside all this, UNIX has very strong security system i.e., only the registered users can use the system. The user is provided with login ID and password. So, there is no chance of changing the documents by any user.
Working on ERP is challenging
Why it is challenging? you will know by my following decription.
This time I am working in Mumbai . That company have lot of project and technical persons for development works are very less. I am already alloted for three project.
So workload is very much high. Person belongs to Axapta development is very less in India so lot of companies project, work but there is no good skilled person.
So they hire more fresher to trained them when they trained then they resign because they go opportunity at other companies so pending work always done by exsisting key person.
This type of challenges facing most of IT companies. I got treatment from boss daily but I am still working with high pressure environment I know one day i will realize my ability.
Good confidence and interest needed during work to handle clients. Sometime I think Its better if I do some own business. Atleast I will release from daily tension.
With tension life is going silly. Could anyone advice me what should I do.
I am facing this problem so I am sharing it. One other think I want to share with you I am not interested for job but its requirement so its other type of pressure create automatically.
If some one face same thing then please share it to the world to know you better.
I am writing this article because I have time and today is sunday. I will share lot of thingk other day.
Friends I think 3 idiots movie is best to live life in right direction.
Accountants and auditors cost very much money. Accounting software is an entrepreneur huge time and money. This article will have information in what situation is best for accounting software can be selected and what should be watched closely when selecting and buying it.
..:: Accounting Software Now
The accounting software purchase can be very useful when there is a lot of paperwork to be processed monthly period or if the accountant is very costly. It is good to consider whether it really is worth the plunge to move into accounting software. The conversion is such that all manner of records storage, and delivery process completely changed. A completely different system then to be brought through an effective accounting system to process. There are several accounting programs on the market, some of which cost a few hundred dollars and some thousands to tens of thousands of euros. The more expensive the more programs it can. In that sense I myself am quite skeptical about the accounting that tens of thousands of dollars. These packages are often a lot of functions that personnel in many cases, a course must follow to well with this accounting program to cope. In that sense, you wonder if this is in addition to the investment of the investment staff of the accounting program is worth it.
..:: When and when not to use accounting software?
Nowadays there are many business owners are only 1 to 5 invoices per month are processed. When the administration adopts such small shapes it is wise to any accounting software to purchase, however, the administration here manually. It makes little difference whether the invoices are processed manually in your own records or get some invoices in accounting software processed. In a series of invoices in 20 to 50 months you will soon face different items which must be booked separately and should be systematically monitored. In these cases, it may be useful to use an accounting program. When this is also a cash coming in is quite handy to keep daily records through an accounting program. When your company go so well and get good margins each month may be wise to buy software and someone to arguing he inboekt your records for you in the software. When you unlock your own time with this and this time winning sales and profits compared to the cost of the journal entry of the administration in the sense commercially smarter for your records to be processed by someone else.
..:: Selecting a good accounting package
Many accounting packages now have very good support. When calling with questions is good and large companies on a team that is ready accounting software and proficient so they can quickly and professionally can help you. When selecting a good accounting program is certainly wise to look into these aspects so that later you maximum comfort can be experienced from the various facilities on certain accounting software entails. It is also important to see if there is a subscription to the accounting package is tight and if so what it will cost per month. If you have multiple workstations to work or daily accounting personnel to enter is he wise to select an accounting program that many automated processing and posting online books. This way there is often employed by these online backup so there is always a safe backup of the updated records exist.
..:: Buying accounting software and the deductibility of
Buying accounting software is deductible for companies because it costs the company must make. Always keep in mind how much time you think a particular software package to save and weigh it against the costs or earnings per hour in this way to get an educated choice. Individuals who want to buy accounting software, these costs are not deducted from income tax in many cases, it therefore costs a few bucks to which this rule is actually not even apply and really no comparison. An accounting package that saves domestic releases are in many cases to trial so it can then download a free period to use. It can briefly and digital household expenditure be kept.
Keywords :- accounting software |software |small business |payroll |download |business |small businesses |small business accounting software |products |product |modules |quickbooks |invoices |inventory |web based accounting |transactions |transaction |software accounting |simply accounting |reviews |quickbooks accounting software |purchases |peachtree accounting software |peachtree |payroll software |newspapers |netsuite |invoicing |inventory control |intuit |integrated accounting software |implementation |hitech |gnucash |general ledger |free accounting software |financials |financial software |financial accounting |enterprise |company |business software |business accounting software |business accounting |budget |bank reconciliation |application |accounts receivable |accounts payable |accounting solutions |accounting system |accounting software solutions |accounting software solution |accounting software packages |accounting
More Articles …
Subcategories
Web Hosting
Web Hosting is a service offered by web hosting providers to the individuals and organizations to make their websites accessible on the internet. Depending on the requirement, one can avail different types of web hosting such as shared hosting, dedicated hosting, virtual private hosting, cloud hosting etc.
Page 59 of 193