Microsoft Development using SQL
The structured query language is a query language that is useful in the relational databases. A database is a store of huge amounts of data particularly in a form that can be handled using a computer. SQL is a relational database language. It does not itself make a DBMS, but it is only a medium of that is leveraged in communicating to the DBMS to tell it what you want to do (Bowman, Emerson & Darnovsky, 1996). The SQL commands are English-like statements that query, insert, delete, or update the data in storage in the database. By saying that SQL uses English-like statements, it means that it is easier to learn and comprehend as compared to most of the other computer languages. SQL is used as a front end to some databases including PostgreSQL, MySQL, Sybase, and Oracle (McFadden, Prescott & Hoffer, 1998).
Why is SQL Needed?
SQL is a database language used in retrieving and managing the information in relational database management systems. An SQL retrieves data from the database, and it can also execute queries on the database using such statements as CREATE, DELETE, UPDATE, among other statements (Faroult & Robson, 2006). SQL is applied in many places, and especially in this digitized world that embodies massive amounts of data collected daily and stored in databases, the knowledge of SQL programming is crucial. SQL queries can be utilized to retrieve massive amounts of records from the RDMS quickly and efficiently (Connolly & Begg, 2005). It also consists of well-established standard that has been adopted by the ISO and ANSI. With SQL, there is also no coding required since it is easy for one to manage the database systems minus writing the substantial amounts of code. SQL is also the database language that contains the object storage capabilities that are in the requirement in today’s Object Oriented DBMS (Faroult & Robson, 2006).
Types of Schemes Needed for Microsoft SQL Developer
The schemas in the SQL developer are very helpful because they aid in saving time by the fact that they automatically generate the documentation. They are also very helpful in eliminating the tedious as well as the time-consuming manual work. The SQL developers should be aware of the SQL Developer Migrations that are useful in creating Migration Repository. That is a database schema that is used to store the metadata that has been collected and is to be transformed in the migration process. it is useful to configure a dedicated database schema as it will be leveraged in creating that repository. Also, in managing the database management systems, the SQL developers should have the knowledge of various schemes that involves the security measures within the database, the monitoring stored procedures as well as the execution time, and the schemes of improving efficiency (Bowman, Emerson & Darnovsky, 2001).
Types of Microsoft SQL designs that are not compatible with this generation and its disadvantages
In the SQL databases, just like in other relational database management systems, there are logical design, conceptual design, physical design, and organizational design. “All these are compatible with the Microsoft SQL. There is none compatible as per the research. The conceptual design has the purpose of validating the application concept. That entails the representation statement of purpose and the general overview of the functionality to be provided by the application” (Wang et al., (2002). The logical design entails the design of the data elements, the descriptions, as well as the relationships that are useful in providing the needed business functionality. The physical design entails the translation of the logical to the physical including the conformance to available standards, performance tweaking, and mapping of the appropriate. The organizational SQL database design is smaller in scope, although it is not less essential as compared to the other designs. The design addresses the enterprise-wide considerations of an organization corresponding to the application on which the design is taking place (Nielsen & Parui, 2011). It entails the way the SQL database or application interacts with other systems within the organization.
The research will involve the gathering of information and also engage in the practical tasks that will be helpful in enhancing my insight regarding the MS SQL development. My research will leverage the Action Research design process for the purpose of making sure that I gain maximally from the research work and improve my skills as a Microsoft SQL developer. The research will move from the planning phase through to the Action phase, the observation, and then end with the reflection phase. Below is the way the iterations will have an arrangement from the first to the fourth.
Iteration 1: Gathering Knowledge about Microsoft SQL Server
In my first iteration, I will learn about the MS SQL because it is on the MS platform, I would have a requirement to develop applications’ using the SQL language. I will learn about the features and strengths of the MS SQL server and how the SQL is used in the same to carry out various tasks including the querying of the database and security. Action Research requires the researcher to have participation with other researchers as well as the domain experts so as to make sure that the success is achieved (Ozanne & Saatcioglu, 2008). Thus I will meet various experts in this area and the collaboration with them will help me to gain maximally from the iteration.
Iteration 2: Gathering the Requirements
In this iteration, I will gather the requirements concerning the Microsoft developer qualifications. That will help me to know the areas on which I ought to focus for the purpose of becoming a competent SQL developer in the future. The other aim of gathering requirements will also to help me guide my training process so as to acquire those skills and be more effective in my career as an SQL developer. I will also get to understand the challenges faced by SQL developers and how to address them in my profession.
Iteration 3: Training
In the training session, I will meet the SQL developers that have been in the field for a long time because they will impart much knowledge to me that will enable me to become a competent SQL developer. The training will involve the way of developing SQL applications on the Microsoft platform that have a market orientation. I will learn about the various tools that assist in the development, the methods, strategies, and the system development lifecycle process.
Iteration 4: Project Development
In the fourth iteration, I will utilize the knowledge acquired from the previous iterations and work on real-time examples that entail MS SQL development. I will use the Transact-SQL and the Dot Net framework to create database objects including the stored procedures and triggers, as well as to retrieve and update data in storage in the MS SQL Server databases.
Top of Form
Bottom of Form
Bowman, J. S., Emerson, S. L., & Darnovsky, M. (1996). The practical SQL handbook: using structured query language. Addison-Wesley Longman Publishing Co., Inc..
Bowman, J. S., Emerson, S. L., & Darnovsky, M. (2001). The practical SQL handbook. Addison-Wesley.
Connolly, T. M., & Begg, C. E. (2005). Database systems: a practical approach to design, implementation, and management. Pearson Education.
Faroult, S., & Robson, P. (2006). The art of SQL. Sebastopol, Calif: O’Reilly.
McFadden, F. R., Prescott, M. B., & Hoffer, J. A. (1998). Modern database management. Addison-Wesley Longman Publishing Co., Inc..
Nielsen, P., & Parui, U. (2011). Microsoft SQL server 2008 bible (Vol. 607). John Wiley & Sons.
Ozanne, J. L., & Saatcioglu, B. (2008). Participatory action research. Journal of consumer research, 35(3), 423-439.
Wang, L., Shen, W., Xie, H., Neelamkavil, J., & Pardasani, A. (2002). Collaborative conceptual design—state of the art and future trends.Computer-Aided Design, 34(13), 981-996.