CieloSolutions

16/02/2019

Hello All,
Everyone knows about horrible terrorist attack.Please donate some amount for soldiers and share this post as much as you can. Link is given below you can get the same from google or play store.

This is the time for stand our country.

Link : https://bharatkeveer.gov.in

With Regards
CieloSolutions

You can donate directly to individual braveheart's account (upto max of Rs 15 lakhs).

26/02/2017

Nice

01/01/2017

Wishing you very Happy New Year.
God bless you

14/11/2016

Hello Everyone,

Hope you are doing great. In our last post we were discussed about analysis. Today we will discuss very small real analysis scenario on excel.
Analysis of data is a process of inspecting, cleaning, transforming, and modelling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making.. We can use very small commands for achieving our goal of analysis. For Example.
If you have 2 excel sheets and you want to merge both the sheets based on common column this is very easy. For this task you can apply vlookup but if you have duplicate records and you want to sum the volume based on that common columns for this you can use sumif.
above are the just two commands of excel but this will solve your multiple problemsWe will discuss on multiple analysis techniques on multiple tools in our next post. You can ask anything about analysis.

Note : For any question and discussion anyone can call, sms or comment on post.

13/11/2016

Hello Everyone,
As you all know today we have huge sets of data and it is rapidly increasing. So with this data we are facing big challenges in core business data analysis. There is multiple analysis one is Business analysis and second is Data Analysis. Currently we have multiple tools for data & business analysis.
Below are the some best tools for core business analysis.

1. Tableau
2. OpenRefine
3. RapidMiner
4. Google Fusion Tables
5. Google Search Operators

We will discuss on multiple analysis techniques on multiple tools in our next post. You can ask anything about analysis.

Note : For any question and discussion anyone can call, sms or comment on post.

12/10/2016

Hello Friends,
Today we are talking about data integrity. Actually this is one of the most important base of Ideal database table.

Data integrity is enforced to keep the data in a database accurate, consistent, and reliable. It is broadly classified into the following categories :

1. Entity Integrity : Ensures that each row can be uniquely identified
by an attribute called the primary key.
2. Domain integrity : Ensure that only a valid range of values is allowed to be stored in a column.
3. Referential integrity : Ensures that the values of the foreign key match the value of the corresponding primary key.
4. User-defined integrity : Refers to a set of rules specified by a user, which do not belong to the entity, domain, and referential integrity categories.

25/09/2016

Today we are going to discuss real life professional mini task .

Victor is working in an MNC as database developer. He did multiple developments on SQL queries and he has 3 years of experience Today his boss called him and gave him a task. The task is to automate 1000 SQL queries so that queries will run automatically and directly transfer to client system without any human efforts. If victor has completed this task then he will save the multiple and late night working hours but he has neither type of automation tools.
Anyone can help him to do above task.
Note : For any question and discussion anyone can call, sms or comment on post.

12/09/2016

* Oracle Database 12c: Plug Into the Cloud.

Designed for the cloud, Oracle Database 12c and Oracle Multitenant enables customers to make
more efficient use of their IT resources while continuing to improve their users’ service levels and
reduce IT costs. The latest release of Oracle Database 12c, Release 12.1.0.2 now features a
unique in-memory column store and support for JSON document stores. Oracle Database 12c
offers customers a variety of innovations to embrace the cloud and analyze enterprise data in real
time through:
» Consolidating databases and enabling Database as a Service with Oracle Multitenant
» Real time analytics with database in-memory optimizations
» Automatically optimizing data storage and compression according to usage patterns
» Providing continuous access with Oracle’s Maximum Availability Architecture
» Securing enterprise data with a comprehensive defense-in-depth strategy
» Simplifying the analysis and integration of Big Data
» Efficient database management using Enterprise Manager Cloud Control.

We will discuss about oracle 12c in next post. You can ask question

05/09/2016

Below are the Database Technologies currently in tread. If we are Data professional then we must focus on below points.
1. Databases that bridge SQL/NoSQL
2. Databases in the cloud/Platform as a Service
3. Automated management
4. An increased focus on security

04/09/2016

04/09/2016

Enhancements in Oracle 11g PL/SQL
1. DML triggers are up to 25% faster. This especially impacts row level triggers doing updates against other tables (think Audit trigger).
2.Fine Grained Dependency Tracking (FGDT?). This means that when you add a column to a table, or a cursor to a package spec, you don't invalidate objects that are dependant on them. Sweet!
3. Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library. I will definately talk more about this later.
4. New Data Type: simple_integer. Always NOT NULL, wraps instead of overflows and is faster than PLS_INTEGER.
5. Intra-unit inlining. In C, you can write a macro that gets inline when called. Now any stored procedure is eligible for in lining if Oracle thinks it will improve performance. No change to your code is required. Now you have no reason for not making everything a subroutine!
6. SQL and PL/SQL result caching. Yep, you read that right. Now there is a result cache that can store actual results from queries and stored procedures. Later calls are almost instantaneous. Another SWEET on this one.
7. Compound triggers. How would you like a trigger that is a before, after, row and statement all in one? And it maintains its statements between each? Now you have it.
8. Dynamic SQL. DBMS_SQL is here to stay. It's faster and is being enhanced. DBMS_SQL and NDS can now accept CLOBs (no more 32k limit on NDS). A ref cursor can become a DBMS_SQL cursor and vice versa. DBMS_SQL now supprts user defined types and bulk operations. Sweet!
9. FGAC for UTL_SMTP, UTL_TCP and UTL_HTTP. You can define security on ports and URLs.
10. Support for SUPER references in Oracle Object Type methods. Sweet again!
11. Read only tables
12. Specify Trigger firing order.
13. Compiler warning for when others with no raise.
14. Still no identity column!
15. Continue statement is added. Personally, I find the continue to be too much like a go to.
16. You can now used named notation when calling a stored procedure from SQL.