Literature review on SQL

Companies are involved in different operations that result in the generation of information. The information is never discarded rather it should be kept for the future references. The question to ask is how to keep the data. The database concept came previously with the usage of the file database until we came to settle on the sequential databases. The primary databases are the SQL databases and the Oracle databases that do perform the same job but with the application of different principles in the implementation of the functionalities. A database is described as the collection of related data that is organized and stored at a collective place for easily accessing, management and administration of the data.

History of databases and SQL
Database came in to ensure that the data stored can be retrieved or shared amongst the users without the know that there is sharing. In 1970, Dr. Codd published a paper “A Relational Model of Data for Large Shared Data Banks” that was the building block of the relational database system. He described a new structure for data within the database that brought the relational database system that is still in use up to current (Sumathi & Esakkirajan, 2007). On the other side, Chamberlin and Boyce (employees at IBM Corporation, Inc) developed a query language they referred to as Specifying Queries As Relational Expressions (SQUARE). The language did apply the set theory a predicate mathematics to have the select of data from the database. SQUARE acted as the building block for another language (Instructional Software Research and Development Group., 2006).

In 1974, Chamberlin and Boyce refined the SQUARE language to publish the Structured English Query Language (SEQUEL). The refinement focused on the data retrieval from the database, and they had taken the focus to applying the top-down programming that required the linear notation, and readable programs which are easy to modify and maintain. The result of the implemented got the description of the SEQUEL as structured (Chamberlin & Boyce, 1974). In 1979, SQL got into its existence by dropping the vowels EUE, the SEQUEL was found out to be a registered mark trade for Hawker Siddeley Aircraft Company that forced IBM to change the SEQUEL to SQL.

SQL Architectural framework
The architecture of Pl/SQL describes its working with the Oracle. The PL/SQL block is made up procedural and SQL statements as it describes how the SQL in Oracle interprets the PL/SQL block. The PL/SQL architecture contains the block, engine, and the Oracle server. The engine is concerned with the compiling and executing the SQL block, and the PL/SQL engine contains the PL/SQL procedural statement executor that executes the procedural statements. On the other side, the Oracle server contains the SQL statement executor that executes the SQL statement (Rosenzweig & Silvestrova, 2004). Therefore, the PL/SQL engine is in coordination with the Oracle Server for purposes of processing the block.

According to Instructional Software Research and Development Group (2006), SQL statements can be classified either;

Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
Data Administration Statements (DAS)
Transaction Control Statements (TCS)
Features of SQL
Structured Query Language (SQL) has got developed and meets the ANSI and the ISO standards as a computer language that can use in creation and manipulation of hierarchical databases. SQL has the capability of allowing the proficient user to undertake some administration activities such as create some views, update, delete records and retrieve the data from the database. It is very simple and easy for one to learn because it is sequential and structured in nature and it is to work with some other desirable database programs such as MS Access, and Sybase (Groff & Weinberg, n.d).

SQL database, the SQL Server 2005 and SQL Server 2008, have the data mining architecture that enabled the models to enhance business intelligence. Business intelligence components can easily get integrated into SQL server that includes the On-line analytical processing (OLAP), SQL Server Integration Services (SSIS) and the reporting services (Crat, Tang & MacLennan, 2013). SQL has been on developed and currently exhibit some attractive, unique features of supporting character sets, collations, and translations. A transaction can roll back on save points. The database language supports Boolean data type and large objects of binary and the character LOBs (Kreines, 2000).

Benefits of SQL
SQL does not require navigational instructions as it is coded without embedded data that simplifies the retrieval of data.
The applications applying the SQL are portable as well as the language gives a high level of abstraction, and its internal implementation makes it independent.
SQL is simple to learn and easily handle complex situations at the same time the language has no ambiguity about the way a query interprets the data.
The SQL is used in definition of the data structure; control the accessibility of data, delete, insertion and modification of data
Proposal
Iteration 1: Orientation
The orientation program captured my attention by familiarizing me to a few identities. I first had to sign the internship acceptance form from the Human Resource department after which I am to be directed to my designated department. Within the working point, I will introduce myself to the work mates and move around to have the familiarization of the company strategic location. I will visit the specified departments starting with the operational section from where I will have to understand the company core business operations, procedures, principles and the goals to achieve. The working conditions will also be provided to avoid the misrepresentation at working point.

Iteration 2: Understanding the SQL concepts
After the understanding of the company operations and my expectations, I will take some critical time to have the deep understanding of the SQL concepts. Databases go by experience and understanding of what the requirements are according to the company procedures. During the iteration, I will make some consultation from my working mates so that I take to know where I need to take the concentration of understanding. Secondly, I will undertake some online research to have the deep experience of coding and the most critical operations of the SQL. The model accordance to the Model will be under study. The personal studying will further involve the data analytics and the understanding of the big data. The iteration will be the preparation for the training that I will be taken through by the assigned supervisor. At the end of the iteration, I would have sharpened my knowledge and have the best theoretical understanding of SQL as far as the database is concerned.

Iteration 3: Training
The training will go through the application of the SQL and the implementation of the Oracle databases. The training will be conducted primarily to have the clear, practical understanding of the Oracle database and the SQL database. Define the principles of the application modes of the databases. The training will be conducted through the labs of the company where normal staff training and seminars take place. The process will be the preparation of the primary object of designing a database exercising gall the database administration and maintenance. Therefore, by the end of the training session, I would have gained the practical skills and experience of database administration.

Iteration 4: SQL Database designing
The iteration will get me through the steps prior designing and development of a database. First, I will have to undertake some feasibility so that I may be able to define the requirements of the company and the end users to be adhered to during the SQL database development. After then the designing of the application will take its course by applying primarily all the knowledge of SQL database to have the database that meets the determined requirements after that the last iteration will follow.

Iteration 5: SQL database administration and management
The iteration is the other critical activity that I will be involved. The primary expectations are ensuring that the database is up to date the demands of the end users are accomplished. During the process I will be updating the database, deleting some entries. Furthermore, create the views procedures and the queries as well as reports and more so enhance the security within the database. Actually, at the end of it all, I would have got the best knowledge than ever that will get me into the market with the desirable experience and skills.

Expert Career Advice Change

Do you feel you might need a change in careers?
Many individuals reach a point where they get tired of working at the same company and having the same career. There are many ways to decide if you are tired of the career you are in and how to seek a new career. Career advice helps you change something that may not be satisfying you any more. And I am sure that if you want to change career, you need new perfect resume, so i want to give you an advice – write to the executive resume writers online and you will get help really fast.

First, evaluate where you are in terms of job. Are you happy? To you still have satisfaction in doing a great job? Ask yourself if you are bored with the current position and you feel you need a change. The answer to these questions will determine if you should start looking for a new career. Many individuals stay in a job they are no longer happy with for a couple of reasons. One- they have friends at their job and these friends make the rest of the career worth staying with that company or career. Sometimes it is a lack of confidence or fear of having to find a new career. They are comfortable and do not wish to shake that feeling. It also helps to write in a journal or on a piece of paper what likes/ dislikes you have about your career. You may find the company you work for is still great, but you want more from the company like more of a career.

Free Palestine
What are your interests, what do you value from a career? Do you have skills for another career you are interested in or would it require schooling? These questions help you determine just how much you might want to change careers. First, your career should be interesting to you. You should not base a career on the monetary gain. If you do that you will never find a career, you can be happy in. You should also have some aptitude for this job. If you follow career advice change, you might find what you were looking for. Let us look at what you might value in a job above happiness. Do you like a job that is demanding mentally or physically? Do you prefer a desk job or something that gets you outdoors or in a car? These questions are important to determining what you value.

Around the Web
Sponsored
One Cup of This Today Can Help Burn Your Belly Fat Like Crazy!
One Cup of This Today Can Help Burn Your Belly Fat Like Crazy!
Puravive
When you think of the answers to the above questions think about the careers that might fit your values or needs. Chances are you can come up with several careers that you might be interested in pursuing. The next step is to find out if you have an aptitude for those jobs and what education you might need. You can always go back to school to obtain a new job, do not let that stop you.

Next, when following job advice change you will want to learn about these different options. What is the job really like? What are some of the downsides to this job? Speak with an individual about the job you are looking at and find out information. Do not just change jobs without checking it out first.

When you follow career advice change in your job, you will find happiness in a new job. Answering the questions above can lead you to understanding if you are happy with the job you have, but are tired of the company you work for. There are many reasons for a career change, but knowing the most important reasons for changing will help you decide what your next move should be. No one should be in a career for all the wrong reasons. We all experience some a need for change from time to time and if you follow yours dreams, you may find the rewards with a different job.

Factors that influence disease

Hemophilia
Case

A 24-year-old white man has a diagnosis of hemophilia at the age of about 5 to 6 years. He has recently visited the hematology clinic for the follow-up after hospitalization for an accidental knife cut that caused excessive bleeding. The patient has a history of excessive bleeding from tooth extraction, excessive bruising since childhood and the upper gastrointestinal bleeding in the past three years. He has reported chronic pain of his joints and ankles and denied hemarthroses. The patient has given reports about the episodes of excessive bleeding treatment by use of factor VIII and fresh frozen plasma (Remor, 2013).

The patient has the FVIII deficiency (hemophilia A) which is a common type of hemophilia that affects about 5, 000 males at births. The disease approximately affects about 25, 000 people in the United States. Individuals with hemophilia suffer from deficiencies in clotting factor. The mild hemophilia bleedings problems do mainly occur after surgery, trauma and injury. The condition can accompany some symptoms. Almost 25% of the population with hemophilia has the mild deficiency. Those with moderate hemophilia experience bleeding episodes after minor injuries and may lead to spontaneous episodes of bleeding. The server hemophilia happens after trauma, injury and surgery. It has the spontaneous bleeding into muscles and joints characteristics. Recurrent bleeding of the joints also known as hemarthrosis causes hemophilic arthropathy that causes disability at a very young age (Department of Genetics 2015).

Causes

Hemophilia is a disease happening as a result of gene mutation, and it is a genetic disease. About 70% of hemophilia cases are inheritable from parents. However, the other 30% of patients do not have the family history. In such cases, the main cause of the condition is by a spontaneous gene mutation during the fertilization stage. Hemophilia is also a condition that is linked to sex since the FIX and FVIII geneses are found on the X chromosome. It is the chromosome X that determines the gender of the baby. Thus, the condition’s clinical manifestation has a link to sex. Therefore, females may not express the bleeding symptom like the males (McPhee, & Hammer, 2012).

Pathophysiology
The main source of factor VIII (FVIII) production is thought to be from the reticuloendothelial and the liver system. Transplantation of the liver can correct FVIII deficiency to persons with hemophilia. It is because of the increasing cases of individuals with mild hemophilia having progressive liver diseases. Thus, it is an indication that the liver is the main site for FVIII synthesis (Cayir, Yavuzer, and Sayli, 2014).

The RNA messenger for FVIII is also detectable in spleen and liver among other issues. Studies indicate that the production of FVIII in cells lines that are transferable show that after synthesis the FVIII shifts to the endoplasmic reticulum lumen. It is then within other protection that functions in regulating secretion. It particularly regulates the immunoglobulin binding protein in which it has to dissociate in a process that depends on energy. The FVIII’s signal peptide cleavage, as well as oligosaccharides, also takes place in the endoplasmic reticulum. The calnexin, chaperone proteins, and calreticulin, enhance both FVIII degradation and secretion. Regarding genes, the location of the FVIII (F8C) is at the X chromosome arm at Xq28 region. This gene becomes large comprising of 25 intones and 26 exons. A mature FVIII will have about 2332 amino acids. FVIII deficiency is as a result of gene inversion that causes disrupt to the FVIII gene. The disruptions are insertions, point mutations, and deletions. The low levels of FVIII happen as results of external FVIII gene defects.