Skip to main content

Posts

Showing posts from May, 2018

Featured post

Retired From International Cricket But Never From Our Hearts! We love you #MSDhoni ❤️

“Best Finisher”, “Captain Cool”, “Lightening fast hands”. As one sees these phrases, the first person that clicks to the mind is none other than MS Dhoni. MSD has always been given various names like these by his fans. Then the question arises that is he really justifying the names given to him? Or, they are just given on just 2 or 3 performances? We’ll try to figure it out in the sections to come. #MS #Dhoni - One of the finest mind the game of cricket has ever witnessed. His cool and calm composure on and off the field, and his approach to make things simpler has always #motivated me and taught me how to #deal with problems in life. His approach to focus on the #process rather than #outcome has always helped me in #developing new skills. Not a die hard fan of MS Dhoni initially, but got inspired by his very unique Leadership style. - Backing his team members: In spite of many initial failures, he backed Rohit Sharma and Virat Kohli continuously. Today, they are the best batsmen...
1 comment
Read more

What is Structured Query Language?

Structured Query Language Used to manage data in a Relational Database Management System ( RDBMS ). Declarative, unlike its predecessors Can be procedural tool ! (PL/SQL) Inspired by Codd's Relational Model SQL Language Elements: Statements (SELECT clause + WHERE clause). SELECT clause                          SELECT *  FROM Employee WHERE clause                 WHERE id = 123 AND is_admin = 'true'   Predicate     : 123 Expression  :  'true'   Expression :  An Expression  is like which produces  scalar values(like 1+3 produces 4) or produces a table values(like result of another select query inside select query produces table). Predicate :  Predicate allows us to specify conditions and these are generally evaluated either true or false or undefined.
Post a Comment
Read more

Relational Algebra vs. Relational Calculus.

Relational Algebra vs. Relational Calculus If you can express any ideas in  Relational Calculus  ways then there is a  Relation Algebra  equivalent to it and they are logically equivalent and they are the same thing. Movies Hrithik Roshan is in Relation Algebra Join Movie and Actor over actorId Filter the results to only those include Hrithik Roshan Select the movieTitle and year columns. Relational Calculus Get movieTitle and year for Movie such that there exists an Actor A who was in the movie and has the name Hrithik Roshan
Post a Comment
Read more

What is Codd's Relational Model in SQL ?

Codd's Relational Model : A relation is a set of tuples ( d 1, d 2, d 3, d 4, ... d n). Each element in a tuple d j is a member of D j, a data domain. These elements are called attribute values , and are associated with an attribute . Relation                               :       Table Tuples                                  :       Rows   Element in a tuple             :      Cell Value Attribute values                 :      Cell Value Data Domain                      :      Set of allowed values Attribute                      ...
Post a Comment
Read more

What's New in Node 10 "Dubnium"?

Full support for N-API Easy getting started with Time-Travel Debugging via a new  Visual Studio Code Extension TTD support for generators and async functions Support for Inspector protocol Increased stability and other assorted improvements
Post a Comment
Read more