Browse by Tags

• analytical applications
• association rules
• book
• business intelligence
• Community Event
• Conference
• constraints
• continuous learning
• course
• data
• data analysis
• logical model
• machine learning
• market basket analysis
• physical model
• Pluralsight
• query optimization
• relational algebra
• relational model
• relational operators
• SQL PASS
• SQL Saturday
• temporal data
• training

• Data Mining Algorithms – Association Rules

  The Association Rules algorithm is specifically designed for use in market basket analyses. This knowledge can additionally help in identifying cross-selling opportunities and in arranging attractive packages of products. This is the most popular algorithm Read More... Posted Tuesday, March 10, 2015 4:19 PM by Dejan Sarka | 2 Comments Filed under: business intelligence, data analysis, continuous learning, Data Modeling, machine learning, market basket analysis, association rules

• Data Modeling Resources

  You can find many different data modeling resources. It is impossible to list all of them. I selected only the most valuable ones for me, and, of course, the ones I contributed to. Books Chris J. Date: An Introduction to Database Systems – IMO a “must” Read More... Posted Tuesday, June 10, 2014 8:21 AM by Dejan Sarka | 5 Comments Filed under: course, book, data, Data Modeling, physical model, logical model, relational model, Conference

• Working with Temporal Data in SQL Server

  My third Pluralsight course, Working with Temporal Data in SQL Server, is published. I am really proud on the second part of the course, where I discuss optimization of temporal queries. This was a nearly impossible task for decades. First solutions appeared Read More... Posted Thursday, May 29, 2014 8:51 AM by Dejan Sarka | 0 Comments Filed under: course, data, Data Modeling, relational model, relational algebra, relational operators, Pluralsight, temporal data, constraints, query optimization

• Truncate Table – DDL or DML Statement?

  Many times, categories of concepts and things overlap. It can be hard to categorize some items in a single category. The SQL TRUNCATE TABLE statement is an example of an item that is not so easy to categorize. Is it a DDL (Data Definition Language) or Read More... Posted Friday, March 28, 2014 11:47 AM by Dejan Sarka | 12 Comments Filed under: Data Modeling, physical model, logical model, relational model, relational algebra, relational operators

• Central Europe Trip with a Reason

  Why wouldn’t you make a nice trip in Central Europe? Besides spending some nice days in beautiful cities, you have also a business-type excuse for the trip. You can join the two SQL Saturday events. The first one is going to take place in Budapest, March Read More... Posted Saturday, February 22, 2014 1:19 PM by Dejan Sarka | 1 Comments Filed under: SQL PASS, SQL Saturday, Data Modeling, physical model, logical model, Community Event, relational model, Conference

• SQL Set Operators. Set? Really?

  UNION, INTERSECT and EXCEPT operators are commonly called Set Operators. For example, in Books Online you can find a topic “ Set Operators ”, where  these three operators are explained. They should represent set operations UNION, INTERSECT and MINUS Read More... Posted Friday, January 10, 2014 3:17 PM by Dejan Sarka | 2 Comments Filed under: Data Modeling

• Logical and Physical Modeling for Analytical Applications

  I am proud to announce that my first course for Pluralsight is released. The course title is Logical and Physical Modeling for Analytical Applications . Here is the description of the course. A bad data model leads to an application that does not perform Read More... Posted Friday, November 1, 2013 9:44 AM by Dejan Sarka | 2 Comments Filed under: course, training, Data Modeling, analytical applications, physical model, logical model