Power BI Components Power BI is a powerful Business Intelligence and data visualization application. In this article, we will learn about different Power BI components. Gartner report places both Power BI and Tableau in the leadership quadrant. Difference between Power BI and Tableau. Power BI desktop Power BI desktop is an authoring tool and is…
Read MoreCreate Your First Tableau Visualization Tableau is a popular Business Intelligence and data visualization application. In this article we will learn how to create your first Tableau Visualization. This blog will also discuss how to connect Microsoft Excel database from Tableau. Download Tableau Tableau desktop trial version is available for two weeks. Tableau public is…
Read MoreJoins in SQL Joins allow us to combine data from two or more tables based on Primary and Foreign keys. In this article, we will learn how Joins in SQL are implemented. Though join concepts are the same in all databases, here we will learn about joins in Oracle. If you are new to Oracle,…
Read MoreDownload and Install AdventureWorks Sample Database In this blog, we will learn how to Download and Install AdventureWorks Sample Database. We will be using AdventureWorks2017.bak database. Same steps are applicable to restore any database from the backup. Error – No backupset selected to be restored If you get an error – “No backupset selected to…
Read MoreInstall 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 MoreWhat 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 MoreOracle 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 MoreAfter 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 MorePrimary 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 MoreBasics 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