Install SQL Server 2019 Express Edition on Windows 10 SQL Server Express Edition is a good way to learn a database. It is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications. In this blog, we will tell you how to install SQL Server 2019 Express…
Read More
What is System Development Life Cycle (SDLC) An understanding of SDLC is essential if you are starting a career in Information Technology. In this blog, we will learn What is System Development Life Cycle (SDLC). System Development Life Cycle (SDLC) System or Software Development Life Cycle (SDLC) refers to the process involved in the development…
Read More
Oracle PL/SQL practice questions On request of our students, please find below Oracle PL/SQL practice questions. These examples will use tables in Oracle’s sample database Scott. These exercises will require Oracle Installation. Please provide your solution/code in the comment section. Note: This blog does not contain the solutions, since it will fail the purpose. If…
Read More
After Oracle installation is done, it’s time to learn how to verify Oracle installation on windows 10. Following the below mentioned steps you can verify your installation and unlocking of the databases. How to verify Oracle Installation Go to your windows start program and type Oracle – HOME_NAME and select Open file location. This will take…
Read More
Primary Key and Foreign Key with example Primary keys and Foreign keys define the relationship between tables in a relational database system. In this blog, we will learn the concepts of Primary Key and Foreign Key with an example. What is a Primary Key? Every table in a database must have a Primary key. The…
Read More
Basics of RDBMS We have installed Oracle and learned about Codd rules, now we should dive a little more and learn the basics of RDBMS (Relational Database Management System). These concepts are the same for all databases such as Oracle, SQL Server, Db2 etc. because they are driven by the Codd rules. Basics of RDBMS…
Read More
What are the 12 Codd rules of RDBMS In the previous blog, we installed Oracle. In this blog, we will learn What are the 12 Codd Rules of RDBMS. These rules define the structure of a RDBMS. Building blocks of RDBMS are based on these rules. RDBMS Stands for Relational Database Management System. It is…
Read MoreIf you are from a non-IT background and want to switch your career to IT, learning Oracle SQL and PL/SQL will be a good place to start. This blog will explain how to install Oracle 11g and unlock sample schemas so that you can set yourself on a path to a rewarding IT career. If you…
Read More
Sometimes Students find it hard to make a breakthrough into the Job market. In today’s competitive world, employers expect students to have specific skills to succeed in their job. In this blog, we will discuss 6 easy steps toward employment in IT. Even during campus interviews, companies test students on these skills. In this video,…
Read More
The Myth and the Reality of Information Technology There is lot of myth associated with Information Technology(IT). A newcomer gets intimidated with different aspects of IT. But there is some level of Myth associated to this information. This article will enlighten you with some of the Myth and the Reality of Information Technology. MYTH 1: A…
Read More