Difference Between Data Definition Language (DDL) and Data Manipulation Language (DML)

When working with Structured Query Language (SQL), Data Definition Language (DDL) and Data Manipulation Language (DML) are two subcategories of SQL that have two distinct purposes.

DDL is used to change the structure of the database. It’s a set of commands used to create, modify, delete data structure but not data (Lithmee, 2017). Think of it as setting the rules for defining how your data is going to be stored. For example, a database designer can use DDL to create database objects (tables, indexes, views etc.) and define the access rights to those objects (Coronel, Morris, & Rob, 2010). Here are some examples of DDL commands:

DML is used to manage the data in the database. It’s a set of commands used to add, remove, modify or retrieve data (Lithmee, 2017). Think of it as once we have defined how data is stored (DDL), DML is how we interact with the data. For example, a database user can use DML to insert, delete, update, and retrieve data inside of a database (Coronel, Morris, & Rob, 2010).

The easy way to remember the difference between the two is that if it affects your scheme and the database structure it is DDL. If modifies your content (the rows) then it is DML.

References:

Lithmee. (2017, December 30). Difference between DDL and DML. Retrieved from https://www.differencebetween.com/difference-between-ddl-and-vs-dml/

Coronel, C., Morris, S., & Rob, P. (2010). Database systems: design, implementation, and management. (9th ed.). Boston: Cengage Learning, Inc.

How an organization’s and candidate’s objectives in the recruiting process might conflict

During the recruiting process, the organization and the job candidate may have different objectives in the recruitment process. For the candidate, their objectives may be to just find a stable income, gain experience, and possibly use education, training, and skills they have acquired. From an organization’s perspective, they are most likely looking for people they can develop and turn into valuable assets that commit to the organization’s mission. 

Conflict may arise during the recruitment process when the organization cannot meet the job candidates minimum requirement for accepting employment. This can be in the form of inadequate income to support the candidate’s lifestyle, or the ability to use one’s education, training, and skills on the job, or negative perceptions of the organization’s or industry’s job security.

Likewise, from an organization’s point of view, they may have the objective to hire people with proven experience instead of hiring people with the potential of developing it. Or vice-versa, they would want to hire people who are new to the industry that can be developed. Either way, the organization’s goals, and needs should be linked with the individual career needs of its employees in a way that improves the effectiveness of workers and their satisfaction as well as achieving the firm’s strategic objectives (Snell & Bohlander, 2013). 

References:

Snell, S., Bohlander, G., (2013). Managing Human Resources. Mason, OH. South-Western Cengage. 

The Three Components of Emotional Intelligence and How I Use Them to Enhance My Life

Emotional Intelligence is the ability to be self-aware of one’s own emotions as well as the emotions of others (empathy) while being able to control and manage one’s own emotions (Ferrett, 2018).  

Interpersonal skills, such as self-esteem and stress management, greatly influence emotional intelligence as part of being emotionally intelligent is self-awareness and self-management. When one can acknowledge and comprehend their emotions, then one can manage them better. We need to know what we are feeling and why are feeling this way in order to figure out the best way to react.  

Sometimes, our emotions get the best of us and we react before we can truly think about the situation and we later regret it. This is referred to as emotional hijacking, also know as amygdala hijacking. This phenomenon occurs when our amygdala, the part of the brain that regulates emotions, sends a fight or flight response that doesn’t allow our neocortex, the part of the brain that process rational thinking, to do its job (Nuetrino, 2012). 

In order to best manage this phenomenon, one needs to be aware that this phenomenon exists and can occur. Then, we need to be able to catch ourselves before we allow it to take control. Once we catch ourselves, we should pause for at least ten seconds (or longer) before we do anything else. During this time, our initial adrenaline rush begins to weaken and dissipate, which then allows us to engage in rational thought process (PMSL Training, 20125). After much our steam has cooled off, we should begin to acknowledge what we are feeling and why we feeling that way. This is called mindfulness and this will help us react better to the situation because our neocortex will start doing its job and begin to analyze the situation and rationalize the next actions we should take. 

Self-awareness and control are two key elements of emotional intelligence. The third component, empathy, or the ability to be aware of the emotions of others and understand from their perspective, is an equally vital part of emotional intelligence (“Empathy,” n.d).  By mastering all three components of emotional intelligence (self-awareness, empathy, and management) we can begin to use it to enhance our personal and professional lives. 

Specifically, there are three ways I use emotional intelligence to enhance my life. First, I start with myself. I begin to dig deep into my beliefs and acknowledge the biases and experiences that shape who I am. I ask others their opinions about me and reflect on their answers and compare them with my own. I play devil’s advocate with myself and I seek to try to understand why I think or feel the way I do. 

The second way I enhance my life through emotional intelligence is by getting to know others around me. To truly empathize with others, I must understand who they are, what they are feeling and why they are feeling that way. This means I should set aside my pre-existing beliefs about them and just carefully and actively listen to them. This includes asking thoughtful questions.

The third, but not necessarily last, way I use emotional intelligence to enhance my life is by actively empathizing with others. Actively empathizing means to truly feel how others feel (although, one can’t truly feel how others feel but can get close to it) and to take actions that seek to improve the current situation. This could mean just being there for emotional support. If it’s a professional setting, understanding their needs and accommodating to them may go a long way in the long-run.

Emotional Intelligence involves three distinct components: self-awareness, empathy, and management. Emotional hijacking can occur during the heat of the moment but practicing mindfulness can prevent it. Using emotional intelligence in all areas of one’s life can enhance your relationship with others thus enhancing your overall quality of life. 

References:

Empathy (n.d.). Retrieved from https://www.psychologytoday.com/us/basics/empathy 

Ferret, S. K. (2018). Peak performance: Success in college and beyond (10th ed.). New York, NY: McGraw-Hill Companies, Inc.

Neutrino. (2012, September 8). What is an amygdala hijack? Retrieved May 11, 2017, from http://www.gostrengths.com/what-is-an-amygdala-hijack/

PMSL Training (2015, October 1). Amygdala hijack: English. Retrieved from https://www.youtube.com/watch?v=9u3UvXqArqs&feature=youtu.be  

Why You Should Practice Confident Body Language

Body language can communicate information that is beyond what is being said (semantics, the meaning of words) and heard (auditory input), information such as context. According to this discussion’s background video, Your Body May Shape Who You Are by Amy Cuddy (2012),  she suggests that even if you don’t feel confident, practicing confident body language can increase your self-esteem and make you feel better about yourself. Some of the good body languages you can practice to make yourself more confident are (Cunic, 2018): 

  • Eye contact- having direct eye with another contact denotes interest and can be a sign of truthfulness.
  • Leaning forward– when someone leans forward, it may indicate attention and interest, try this when you are listening to someone. 
  • Standing or sitting straight– this occupies more space than slouching and taking up more space is a sign of power. You can practice this while waiting in line or while sitting down doing homework. 
  • Chin up– walking and talking with your chin up is a sign of confidence as your face is more exposed. One can easily practice this by avoiding looking at the ground. 

Another good way to practice confident body language is to be aware of body language that may convey uncertainty.  These are some of the body languages you should be aware of and avoid:

  • Fidgeting- this is a sign of nervousness and lack of power (Cain, 2018). 
  • Defensive possess- such as crossing your arms, hiding your hands, or holding objects too close to the body convey uncertainty, and mistrust (Cass, 2017). 
  • Forgetting to smile– one way to demonstrate confidence, openness, warmth, and energy is to smile, forgetting to do so demonstrates the exact opposite (Cain, 2018). 

Body language adds another dimension to communication as it informs listeners underlying messages that may not be communicated from the words spoken and heard. By practicing confident body language you can prime yourself to be confident or be perceived as confident. You should also be aware and avoid the body language that conveys uncertainty, hostility, or untrustworthiness. By practicing good body language and avoiding the bad ones, you’ve made a conscious decision to be confident.   

Reference: 

Cain, A. (2018, April 04). 11 horrible body language mistakes that are hard to quit but you’ll be glad you did. Retrieved from http://www.businessinsider.com/bad-body-language-habits-2017-12 (Links to an external site.)Links to an external site.

Cass, W. (2017). Influence: How to raise your profile, manage your reputation, and get noticed. West Sussex, United Kingdom. John Wiley & Sons Ltd. 

Cuddy, A. (2012, June). Your body language may shape who you are. [Video file]. Retrieved from http://www.ted.com/talks/amy_cuddy_your_body_language_shapes_who_you_are

Cunic, A. (2018, January 08). 10 ways to have more confident body language: How to improve your self-esteem Retrieved from https://www.verywellmind.com/ten-ways-to-have-more-confident-body-language-3024855 (Links to an external site.)

Conversation Flow + Halo Effect = Engaging Conversations

Part of being a great communicator is being able to establish engaging conversations that result in positive outcomes.

There is this idea called conversation flow, which basically means to resonate or have friendly rapport with others in a conversation which is essential in developing a close social connection that leads to positive outcomes during conversations (Whitbourne, 2017).  One way to create a conversation flow is to find commonality in others. By finding commonality, the halo effect takes action. 

The halo effect is a cognitive bias where a person makes ambiguous assumptions about person, place, or thing based on concrete information (Kahneman, 2013). When two people find commonality in each other, let’s say that find out they were both grew up in the same city, they will naturally start liking each other more than if they didn’t. This is because commonality with others creates a positive association. 

Finding commonality triggers the halo effect, which caters to the beginning stages of conversation flow, which is essential to having good conversations. Having a good conversation will most likely lead to positive results such as being hired after a job interview or scoring a date after flirting with a potential partner.  

The are other ways to cater to conversation flow, things like active listening and mimicry also promote conversation flow. The idea of conversation flow is to create close social connections that will promote engaging communication that will favor positive outcomes. 

References: 

Kahneman, Daniel (2013). Thinking, fast and slow (1st ed ed.). New York: Farrar, Straus, and Giroux. pp. 82–88.

Whitebourne, S. K. (2017, July, 08). The key to better conversations. Retrieved from https://www.psychologytoday.com/us/blog/fulfillment-any-age/201707/the-key-better-conversations

Active Listening the Key to Engagement

Being able to communicate effectively is an essential skill to have, especially conversations with people that are engaging and that can create a sense of trust and friendship. 

The best advice to become a more engaging person to talk to is to become an active listener. This means giving a person your full attention, letting them finish their thought, display behaviors that show you are listening (like nodding your head or providing verbal feedback), being actually interested, asking questions, and clarifying (Ishak, 2016).  

I remember a recent conversation with a friend who wanted to vent about his current relationship. The conversation was mostly one way as he didn’t allow me to become interested in it by not letting me finish sentences that were designed to ask questions and clarify. I quickly lost interest in the conversation as it started to become an announcement or instead of a conversation. 

My friend could have improved our conversation if he had only shown the same interest in listening to his story as he did with my feedback. However, because I felt it was not a conversation, I quickly lost interest and only provided faux feedback so that he could finish his story and I can move on with my day.  

The idea of active listening is a two-way street. Both parties need to engage in each other’s stories so that neither party loses interest in the other. Once interest is lost, it’s pretty much a waste of time because the quality of information that is being transferred or created is sub-par. 

Reference:

Ishak R. (2016 July 29). 11 ways to be more engaging in your conversations & make friends. Retrieved from https://www.bustle.com/articles/169621-11-ways-to-be-more-engaging-in-your-conversations-make-more-friends

Speech Patterns: The Proposition-to-Proof versus The Problem-Solution Method

Knowing different methods for creating persuasive speeches is useful so that you can use a variety of styles while being aware of each style’s drawbacks. The two methods I’ll be discussing will be the proposition-to-proof method and the problem-solution method. 

The proposition-to-proof method uses a pattern by which the speaker begins with a statement of one’s proposition, then follow with proofs that support it. For example, if your purpose is to influence others to vote for a specific proposal, you would begin by stating, “Vote for Proposition H, a ballot proposition that reduces the penalties for criminals of non-violent crimes.” Then you would continue with reasons that support your proposition such as facts and logic. For example, you may say something like:

  • “We spend more money on building prisons than schools.” 
  • “Criminals of non-violent crimes such as stealing are people of color of color, due to systematic discrimination in our laws”
  • “The victim of non-violent crimes such as drug abuse is themselves, by further punishing them with harsh penalties such as prison sentences, we are further victimizing them and creating burdens to society instead of rehabilitating them back as productive member of society”

One drawback to this method is that the speaker may not discuss the opposite position in the first place, in our example’s case it would be why penalties are TOO severe for non-violent crimes. This is known as playing devil’s advocate, a position in which someone takes that they don’t necessarily agree with for the sake of exploring the topic further or debate (Smith, 2017).

I believe it is necessary to play devil’s advocate when giving a speech so that your listener’s can get  both angles of a story. Then once you are done discussing the opposite position (by playing devil’s advocate) you can take the devil’s mask off and refute all those points. 

The Problem-Solution Method

Another method that public speakers like to use is the problem-solution method of public speaking introduces a problem and discusses the solutions for it (Brent, 2018). At first glance, it may seem similar to the proposition-to-proof method, however, if you observe both methods clearly, you’ll notice that they are opposites of each other. The proposition-to-proof-method provides a call to action or solution, then discusses the problem, while the problem-solution method does the opposite by discussing a problem and then discussing the solution.

One drawback to problem solution method is that the solution may be a false dilemma. A false dilemma is a fallacy in which the speaker only provides two solutions to a problem,  when in reality there may exist other options (Hendrick’s, 2018). This A or B thinking is dangerous as it tricks listeners into thinking that there are only two possible solutions to a problem, which then disregards other possible solutions that may exist.

Conclusion

It is important to know different structures of persuasive speech so that one can identify the drawbacks to each and be prepared to tackle them when they are brought up. The proposition-to-proof method suffers from not playing devil’s advocate and the problem-solution method may be weakened by the false dilemma fallacy. In fact, both methods could suffer from either of those drawbacks. The key is to know how speeches are structured and be prepared to handle drawbacks when they are brought up.

References:

Brent, M. (2018, January 16). What are the five organizational patterns for public speaking?. Retrieved from https://bizfluent.com/info-8540323-five-organizational-patterns-public-speaking.html (Links to an external site.)Links to an external site.

Hendricks, S. (2018, February). 10 logical mistakes you make every day, and what to do instead. Retrieved from http://bigthink.com/scotty-hendricks/ten-logical-mistakes-you-make-everyday-and-what-to-instead (Links to an external site.)Links to an external site.

“Persuade with power.” (2018) Lunch Toastmasters. Retrieved from http://www.lucantoastmasters.com/competent-communication/persuade-with-power/ (Links to an external site.)Links to an external site.

Smith, S. (2017, July 27). Using the devil’s advocate” to your advantage, even when sometimes it feels insane. Retrieved from https://itscoffeeti.me/using-the-devils-advocate-to-your-advantage-even-when-sometimes-it-feels-insane-435788c9c4b7

%d bloggers like this: