Diksha IT Training Centre

Benefits of Computer Coding for School Kids. Hello Everyone, Today I will discuss on different topic related to computer science only. As we all know in new Education System Coding is going to start in every school from class 6 th onward. So we will discuss why kids should learn code. There are several reasons to learn programming as Programming helps children to learn problem-solving . Coding for kids is the collection of opportunities available for children to get involved in coding. These opportunities aim to be fun to keep the young mind engaged.   As we know computer machine understand binary digit only that is 0 and 1 but through Coding we can make it into readable format by using programming logic and also we can communicate with computers, and what we use to build and run websites, apps, games etc. Let discuss Benefits of coding for School Kids, For starters, basic coding courses in schools provide students with how to develop their own websites, apps and computer softwa...

Agile and Waterfall Model uses and difference in SDLC. Hello Everyone, Today we will discuss about how both the model uses in Software Projects and why agile preferred over traditional Waterfall Model. In previous blogs i discussed about Agile model and SDLC so please go through my below blogs for better understanding. https://dheeraj60.blogspot.com/2020/07/overview-of-agile-modelmethodology.html https://dheeraj60.blogspot.com/2020/07/concept-of-software-development-life.html   First we need to understand Waterfall Model ,The waterfall model is a classical model used in system development life cycle (SDLC)to create a system with a linear and sequential approach. It is termed as waterfall because the model develops systematically from one phase to another in a downward fashion. In waterfall model the sequence of pre -defined phases including feasibility, planning, design, build, test, production, and support. But On the other hand, we know Agile development methodology follows...

Concept of Software Development life Cycle in IT industry.   Hello Everyone, In my previous blog we discussed about Agile Model which is also a part of SDLC, but today we discussed about Software Development life cycle in details and how being software products developed or services provided through SDLC. I suggest you to please go through my previous blog that is related to Agile model also a part of SDLC which permits a company to develop software in small, quick segments. https://dheeraj60.blogspot.com/2020/07/overview-of-agile-modelmethodology.html Let’s discuss about SDLC as its play very important role in developing software products as well as providing services to the clients in simple word we can say SDLC(Software Development life Cycle ) is a process that produces software with the highest quality and lowest cost in the shortest time. SDLC includes a detailed plan for how to develop, alter, maintain, and replace a software system .SDLC is also known as Software devel...

Overview of Agile Model/Methodology. Hello Everyone, Today we will discuss about Agile Model, Nowadays Agile model is very popular in IT industry as Agile SDLC model is a combination of iterative and incremental process models with focus on process adaptability and customer satisfaction by rapid delivery of working software product. We will discuss traditional SDLC model like waterfall, spiral etc in next blogs where we will focus mainly on SDLC phases as in today we will discuss about Agile Model only. Agile Model is a combination of the Iterative and incremental model. This model focuses more on flexibility while developing a product rather than on the requirement. In Agile, a product is broken into small incremental builds. It is not developed as a complete product in one go. Each builds increments in terms of features. The next build is built on previous functionality. In agile iterations are termed as sprints. Each sprint lasts for 2-4 weeks. At the end of each sprint, the pro...

  Benefits/Features of Oracle Database.   Hello Everyone, Today we will discuss about features of Oracle Database .There are many database available like Microsoft SQL server , DB2 , MYSQL etc but Oracle is one of the most secured database used in many domains like Banking, telecom etc as Oracle  Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. There are several features available in Oracle database to write program in easy way and make program secure. Oracle Database is a simple, widely understood, unified data model. It is used as a standalone in many applications, but it is also invoked directly from Java (JDBC), Oracle Call Interface (OCI) and Oracle C++ Call Interface (OCCI). Stored packages, procedures, and triggers can all be written in PL/SQL or in Java.SQL and PL/SQL is the core of Oracle’s application development stack. Most enterprises run SQL in back-ends...

Materialized View uses and Benefits in Database. Hello Everyone, Today we will discuss about Materialized view as it’s play important role in database. We already discussed about Simple Views and complex views in my previous blog. Before Materialized view go through my previous blog which related to simple view. https://dheeraj60.blogspot.com/2020/05/benefits-of-creating-and-using-view-in.html As we know View is not a database object and not like table which is stored in database, but view can be created from base table a view is an SQL statement that’s stored in the database. This statement, or view, has a name.A view looks and acts a lot like a table. It has columns and rows, and can be included in SELECT queries just like a table. In other word we can say View is a virtual/logical table which is basically used for security purpose. Let’s understand   about   Materialized view : A materialized view is a view that stores the results of the view’s query. Whenever you que...

Overview of NO SQL Database. Hello Everyone, Today we will discuss about NO SQL database which is very popular nowadays.   Before NOSQL database go through my previous blog for other IT related topics. As we know SQL follows RDBMS but NoSQL database not follows RDBMS concept. NOSQL means   "not only SQL"   are non tabular, and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. NOSQL   provide flexible schemas and scale easily with large amounts of data and high user loads. In present day, as we are handling huge amount of data, data being organized and well-structured actually creates a problem, especially at extremely large volumes. Structured approach of RDBMS database like SQL slows down performance as data volume or size gets bigger and it is also not scalable to meet the needs of Big Data. So NoSQL was conceived as a completely different framework of databases that allows for high-performance,...

Role of Database Developer in IT Company. Hello Everyone , In Previous blog we discussed about the role of Data Analyst and today I will discuss about the Roles and Responsibilities of Database developer in any Organisation. I suggest you to please go through my Oracle SQL, PL/SQL blogs in archive folder for better understanding. dheeraj60.blogspot.com. About Database Developer: Database Developers, also known as database programmers, are primarily responsible for creating and implementing computer databases. Database Developer determine the best database management system for a particular client, as well as test database programs for efficiency and performance and troubleshoot and correct problems. Database Developers are also responsible for data gathering before development of a database. DB developer design, develop, test, implement and maintain new and existing databases. Database developers create management methods and systems to access efficiently to information stored in ...

Role of Data Analyst in Organization. Hello Everyone , Today I will discuss about the Roles and Responsibilities of Data Analyst in any Organisation. To understand SQL, PL/SQL and other IT related topics you can explore it in archive folder in my blog. dheeraj60.blogspot.com Before starting the Roles and Responsibilities of Data Analyst , First we need to understand Data analysis . Data Analysis is the concerned with the Nature and use of data. It involves the identification of the data elements which are needed to support the data processing system of the organisation, the placing of these elements into logical groups and the definition of the relationship between the resulting groups. System Analysts often in practice, go directly from fact finding to implementation dependent data analysis. DBMS has encouraged a higher level of analysis, where the data elements are defined by logical model or schema. Schema in the context of DBMS, the effect of alternative design on the efficien...

Database Management System Importance and benefits in any Organization.   Hello Everyone, Today I will discuss about the importance of Database in any Organization , As we know data is important for any application and without database we will not able to organize or manages data efficiently and not allows customer to perform multiple task . Please go through my previous blogs related to Oracle Database SQL and PL/SQL in archive folder for your reference to understand uses of database through examples. dheeraj60.blogspot.com Let’s understand Database in simple word. A database is a collection of data, usually stored in electronic form. A database is typically designed so that it is easy to store and access information. A good database is crucial to any company or organization. A database management system is important because it manages data efficiently and allows users to perform multiple tasks with ease. A database management system stores, organizes and manages a large amoun...

SQL QUIZ with Answer Part 5.   Hello Everyone, Today I will start SQL Quiz part 4, this is important for those guys who is preparing for OCA(Oracle certified Associate) certification. I suggest you to go through my previous Oracle SQL and PL/SQL blogs in Archive folder for your reference. Note: This Type of SQL and PL/SQL questions asked in Oracle Certification exams as well as good for you to check your SQL and PL/SQL skills. also Good for Candidate who is preparing for interview. Before part 3 please explore my below blogs SQL Quiz Part1 SQL Quiz Part2 , SQL Quiz Part3 and SQL Quiz Part4 . https://dheeraj60.blogspot.com/2020/07/sql-quiz-with-answer-part-3-dotcmdb.html https://dheeraj60.blogspot.com/2020/07/sql-quiz-with-answer-part-2-dotcmdb.html https://dheeraj60.blogspot.com/2020/07/sql-quiz-practice-for-oca-with-answer.html https://dheeraj60.blogspot.com/2020/07/sql-quiz-with-answer-part-4-dotcmdb.html   Let’s start the quiz with Questions and Answers:   ...