Create ,manage and interact with IBM DB2 Database Objects
IBM Db2 is a family of related data management products, including relational database servers, developed and marketed by IBM. Since the 1970s, IBM has developed a complete family of database servers, started on mainframe platforms such as Virtual Machine (VM), Virtual Storage Extended (VSE), and Multiple Virtual Storage(MVS).
What you’ll learn
- Install IBM DB2 Database Server.
- Install IBM Data Studio Client.
- Create a database.
- Create multiple tables.
- Insert data into tables.
- Fetch data from database.
- Sort data fetched from database.
- Filter data fetched from database.
- Remove duplicate data from database.
Course Content
- IBM DB2 Setup –> 5 lectures • 22min.
- Creating and manipulating IBM DB2 Database Objects –> 10 lectures • 50min.
Requirements
IBM Db2 is a family of related data management products, including relational database servers, developed and marketed by IBM. Since the 1970s, IBM has developed a complete family of database servers, started on mainframe platforms such as Virtual Machine (VM), Virtual Storage Extended (VSE), and Multiple Virtual Storage(MVS).
In 1996, IBM released Db2 Universal Database for distributed platforms, or Db2 UDB version 5. This was the first Db2 version that IBM designed to optimize for the web. Since the DB2 UDB version 5, IBM continued delivering a number of releases of Db2 over the years with lots of innovations such as pureXML that supports XML documents in 2006. In 2009, IBM introduced the Db2 SQL compatibility feature that makes it easy for customers to migrate from other relational database products to Db2.
In 2012, IBM released Db2 10.1 with several features that help customers reduce operational costs. A notable feature was multi-temperature storage. For example, you can classify the data as hot and cold. The hot data is the data that you access often, which will be resided in the fastest and more expensive hardware. While the cold data is the data you rarely access, which will be stored in slower and cheaper devices. In 2013, IBM released Db2 10.4 that introduced BLU acceleration, a memory-based column store which leverages parallel vector processing power, dynamic memory capability, and advanced storage disk technology. In 2016, IBM released Db2 11.1 that delivered key innovation which reduces the total cost of ownership. Db2 11.1 also enhanced analytics and increased availability, reliability, and security for your business-critical applications. In mid-2017, IBM re-branded its DB2 and dashDB product offerings to Db2.