Basics of the RDBMS and SQL

Define and Understand the Basics of the RDBMS

  • A relational database consists of collections of data known as tables. A table
    could be a list of ship names and some statistics about each ship. Another table
    might be a list of employees who work on different ships. The “relational”
    aspect to a “relational database” has to do with the common information that
    “relates” two tables together—for example, the list of employees might include
    an entry for each employee’s ship assignment, which would relate back to the
    list of ships and each ship’s statistics.
  • A relational database management system, or RDBMS, is a system in which
    these relational tables and related objects can be created easily, using common
    functions to add, change, and remove data and database objects from
    the RDBMS.

Understand the Unique Role of SQL in Modern Software Systems

  • SQL is most widely used fourth-generation language (4GL) in commercial
    use today.
  • SQL is the only language for interacting with the RDBMS. Any other
    programming language must use embedded SQL calls to interact with the
  • The constantly changing nature of databases makes them a tricky place
    to test software. If a SQL script is written and tested successfully today, it’s
    entirely possible that it may break down and produce erroneous information
    later on. The solution is that the script must not only be tested, but must
    originally be designed and written by a capable SQL developer who understands
    proper database design and is thoroughly versed in the RDBMS and
    SQL syntax.

Study online marketing – definition and 9 core aspects

Found this note from Evernote. Nowadays, online marketing is the most efficient way of marketing. No one, I mean no one, can afford to ignore it. It is not only cost effective, but also gives massive Domino effect to help boost business.

Online Marketing Defined

  • awareness: find out the most effective ways of building awareness
  • communication: who we are, what we do, whom we serve, why we are worth working with
  • connection: get people to know us, like us, trust us
  • service: FAQs, sharing good experience, smooth web page browsing, being found in search engine
  • sales: all together for boosting sales

9 Channels/Aspects of Online Marketing

  1. Online Advertising
  2. SEM (Search Engine Marketing)
  3. SEO (Search Engine Optimisation)
  4. EMAIL
  5. Social Media
  6. Content Marketing
  7. Web Analytics
  8. Online PR
  9. Website Design

How the most successful people treat everything–Including Problems–As An Asset.

I read this article ( by Paul B. Brown on, and thought it’s truly inspirational.

I need to learn treating everything – including problems – as an Asset.

“The key is to focus on your goal and not on the plan that you initially drew up to get there.”

“With this approach, your objective doesn’t change, but you accept the fact that how you may get there might. For anyone who has put together a five year plan or even an annual budget, this is going to require thinking differently, something which is never a walk in the park. But it can be done.

To see how we need to begin by taking a step back.

However, in today’s world, it is all about exploiting the contingencies and leveraging the uncertainty by treating unexpected events as an opportunity to exercise control over the emerging situation. (Don’t believe me? Think of the last time you drew up a plan to accomplish something and it went off without a hitch.)

Those who are successful in starting companies, or creating anything new for that matter, learn not only to work with the surprise factor, but also to take advantage of it.”

“Plan B can be good, too”

“In most contingency plans, surprises are bad; the “what if?” scenarios are usually worst-case ones. But people who accept the world is much more complex today do not tie themselves to any theorized or preconceived market, strategic universe, or fixed path for making their idea a reality. For them, problems are a potential resource, as opposed to a disadvantage. They very often do something with the things that surprise them, treating those surprises as a potential asset.

How do you get creative with a surprise? Well, if the surprise is a good one, you take full advantage of it. For example, you thought the world would love your new iPhone accessory. But you have been overwhelmed by demand. The logical thing to do is to ramp up production, add distributors (perhaps worldwide), and think about creating additional products not only for the iPhone but for all other smart phones as well.

If that surprise was a negative one—i.e., your actions did not go as you thought they would; you encountered a problem or even a setback—it is then time to figure out a way of using that negative to your advantage. Problems and even setbacks are resources to be employed to your advantage.”

“Problems = Advantage

“Running headlong into a problem and then solving it can give you a barrier to competition, or at least a remarkable head start in the marketplace. Why? Because you acted, and the competition didn’t. As a result, you know something they don’t.

Isadore Sharp, founder of the extremely upscale Four Seasons hotel chain, serves as a case in point. When he started out, he assumed that the only thing that would matter for him was to be in the best locations. The problem he ran into was that every other hotel chain had the same idea. That was a huge negative surprise. If you are doing what everyone else is, you don’t have an advantage.

In solving that problem, he stumbled on what turned out to be the Four Seasons’ ultimate competitive advantage. He created a two-pronged barrier to entry, as he explains in his autobiography, Four Seasons: The Story of a Business Philosophy. “One was our inventory of hotels . . . the largest group of authentically first-class hotels in the world, a physical product no other company had to the same degree.”

The advantage was that he could offer the frequent traveler who wanted luxury one-stop shopping when it came to staying in any of the world’s major cities. The other advantage was his people. “Three decades ago, we had decided that what our customers most desired was whatever would make time away from home most pleasurable and productive, so we set about raising service levels to match our first-class decor, an historic judgment call that had made superior service the major determinant of hotel profitability and competitiveness, and while finally recognized now by every hotel company in the world, we had a long head start, so that all our staff in all our hotels were service-oriented, and every employee was focused on delivering service no other company could match.”

According to Sharp, “Location was no longer foremost in getting and keeping customers, it was people, people, people. This was now the decisive factor in our two-fold barrier to entry.”

That negative surprise you encounter can ultimately become a barrier to competition, if you treat it as an asset as Sharp did. He accepted the problem that what he thought was going to be an advantage—location—wasn’t. (Everyone else could build in the same place.) He then took that fact (we have terrific locations, but many other people do too) and asked what he could do with that. His conclusion: We can provide excellent service at these superior locations. That has given him a terrific edge in the marketplace.”

“Coming full circle”

“We began by talking about business clichés. Let’s end the same way. The takeaway from this post is clear. If you come across lemons—otherwise known as business problems/obstacles—do indeed make lemonade.

Try this approach next time you encounter something unexpected. Despite how unpleasant it seems, say, “This is really good news,” and then try to make it so.

The big idea here is you want to develop the ability to turn the unexpected into the profitable. That means your default position should be that there is never a problem without a potential profitable/pleasant solution lurking somewhere. The understanding that a) not all surprises are bad, and b) surprises, whether good or bad, can be used to create something new, is a central to the way we need to think going forward.

The thing is to do something positive with those surprises.”


Paul B. Brown is the co-author (along with Leonard A. Schlesinger and Charles F. Kiefer) of Just Start: Take Action; Embrace Uncertainty and Create the Future recently published by Harvard Business Review Press.

Please note the Action Trumps Everything blog now appears every Sunday and Wednesday. 

Click on the “follow” link on the top of this post to receive every Action Trumps Everything blog the moment it goes live


Something new and worth doing in the Year of Snake (and ever after)

Installed a new wordpress blog and a Piwigo gallery for myself.

Piwigo gallery is a simple open source photo/image management system. I give credit to Piwigo gallery for two main reasons:

  1. Metadata display option –  this is important to a photographer (even to an amateur like myself)
  2. Cross platform photo management applications (desktop, mobile, third party plug-in) –  how sweat is that!

I’m starting using blog and gallery to record my shine and shit, happiness and sadness, work and play. Most importantly, the joy with my baby girl Emma Yanxi Feng, and my misses – Cookie.