Posts

oracle sql interview questions for 3 years experience

Image
  http://www.sgraphinfotech.com/blog/oracle-sql-interview-questions-and-answers.html  Q1.) What is the difference between DML and DDL? Ans: DDL (Data Definition Language) is used mainly for defining the database schema. It consists of SQL statements which give an idea about the structure of the database. Some examples of DDL statements are: CREATE: Used to create new database objects ALTER: Used to alter characteristics of already existing database objects DROP: Used to remove database objects TRUNCATE: Used to remove all records including all spaces allocated to record from the table RENAME: Used to rename any database object DML (Data Manipulation Language) are responsible for managing and manipulating various data schemas or database objects. They cannot alter the characteristics of a database object unlike DDL statements. Most common examples are: SELECT: Used to retrieve data from the database INSERT: Used to insert new data/records into the database
1 comment
Read more

How can we learn about Oracle SQL and PLSQL

Image
Oracle SQL and PLSQL are easy to learn database management and programming language. Owing to the recent technological advancements the demand for Oracle SQL DBAs, PLSQL Developers and Oracle SQL Experts have soared. It has become a most sought after job profile by many technology enthusiasts and university students. However, it is not easy to master Oracle SQL. One must delve deep into the advanced concepts for clearly understanding the language effectively.   http://www.sgraphinfotech.com/oracle-plsql-training-institute-in-bangalore.html There are various ways in which one can learn Oracle SQL/PLSQL. From books to training institutes to online training portals. One can find a variety of choices to learn from given their preference and ability. Some of those are as follows: W3Schools The most popular and common web platform for learning and developing your SQL skills is W3Schools. Not only does it provide extensive guide in learning elementary SQL concepts
2 comments
Read more

What You Will Learn In The Android Training Program

Image
Android Training is most suggestive program for all candidates those who have been finished their graduation courses. Android training program is nothing but Android developing and it will describes the functionality that how to make the procedure to get develop the applications in various android mobiles. The installation structure involved on android mobiles are different for different users of mobile phones, so by going through training session of android program, candidates will come to know the details of entire procedure which illustrate the structure and assembling of applications and running method in the device which are accomplished with smart devices. Android training classes can start through online classes where as it will illustrates the specific topic which was completely related to android developing. It will expand the information that will get into particular task with sample code and re use of applications in your devices itself. Entire program of
1 comment
Read more

Future Career Prospect Of MSBI

Image
career opportunities in msbi Microsoft Business Intelligence is the powerful business tool designed by Microsoft that offers excellent solutions for queries related to Business Intelligence and Data Mining.  This tool makes use of Microsoft Visual Studio Data Tools along with SQL Server. Importance of MSBI: MSBI allows the user to access the updated and accurate data which in turn facilitates proper decision making in the organisation. Different processes to be taken up in business intelligence require different set of tools for the solutions and MSBI provides the user with different tools to accomplish the task. It has an important application in Online Transaction Processing. Business Intelligence has a very important role in almost all sorts of business in future. The obvious reason being handling of big data, its analysis and making smart decisions related to organisation is involved in every sector being IT, Engineering, Architecture, Banking, Government a
4 comments
Read more

Example showing Why MSBI?

Image
We should comprehend this photo by taking a case of an association. We should take the case :- Calvin Klein (CK). We have outlets of Calvin Klein (CK) in many parts of India. Each outlet stores their client information in their separate database and it's not obligatory that each outlet is utilizing a similar database. A few outlets may have Sybase as their database, some may utilize prophet or a few stores incline toward putting away their information in basic content documents.  Before continuing ahead with our clarification, we ought to know "what OLTP is"? It remains for Online Transaction Processing . These are essentially the online exchanges (Insert, Update, Delete) performed on database at each outlet by the client. In the wake of putting away day by day information of the clients who went by Calvin Klein outlet at various stores, the information is then incorporated and spared it in a brought together database. This is finished with the assist
Post a Comment
Read more

What is MSBI - Microsoft Business Intelligence

Image
What is MSBI   MSBI remains for Microsoft Business Intelligence. This intense suite is made out of tools which helps in giving best answers for Business Intelligence and Data Mining Queries. This tools utilizes Visual studio alongside SQL server. It enable clients to access precise and progressive data for better basic leadership in an association. It offers distinctive tools for various procedures which are required in Business Intelligence (BI) arrangements.  MSBI Training in Bangalore MSBI is isolated into 3 classifications:- 1. SSIS – SQL Server Integration Services 2. SSAS – SQL Server Analytical Services 3. SSRS – SQL Server Reporting Services 1. SSIS– SQL Server Integration Services :- SSIS: (Sql Server Integration Services) This tool is utilized for the coordination like tricking the information starting with one database then onto the next like from Oracle to SQL Server or from Excel to Sql Server and so on. This device is likewise utilized for mass
2 comments
Read more