database-systems : Fundamentals of Database Systems V7

Fundamentals of Database Systems V7
64+ Labs
Rating :
Fundamentals of Database Systems V7 performance-based labs teaches the fundamental concepts required for designing, using, and implementing database systems and database applications. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. Fundamentals of Database Systems V7 labs emphasize the fundamentals of database modeling and design, the languages and models provided by the database management systems, and database system implementation techniques. 

Here's what you will get

Performance based lab

Here's what you will learn

Hands on Activities (Labs)

  • Understanding Physical Schema - ER Model
  • Creating a table
  • Using Referential Integrity constraints in a table
  • Using Check constraints in a table
  • Retrieving the data from the table
  • Using select-project-join query
  • Using alias-naming
  • Retrieving all the attribute values using asterisk
  • Retrieving the data using multiple condition
  • Specifying the cross product of the table
  • Using SELECT DISTINCT statement and UNION operator
  • Using substring pattern matching
  • Using arithmetic operators
  • Retrieving the sorted data using ORDER BY clause
  • Inserting values into a table
  • Inserting values into a table from existing table
  • Deleting the rows from a table
  • Updating the table
  • Retrieving values of a table using nested queries I
  • Retrieving values of a table using nested queries II
  • Retrieving values of a table using JOIN operator
  • Using Aggregate functions
  • Counting all the rows of a table
  • Using the GROUP BY and HAVING clauses
  • Using the CASE clause
  • Specifying general constraints as Assertions
  • Creating view
  • Modifying the table definition
  • Using the SELECT operator
  • Retrieving the distinct rows from the table
  • Using the UNION operator
  • Understanding relational set operator
  • Understanding the object database concepts
  • Normalizing the unnormalized model to 1st normal form I
  • Normalizing the unnormalized model to 1st normal form II
  • Normalizing the 1st normal form to 2nd normal form
  • Normalizing the 2nd normal form to 3rd normal form
  • Analyzing the normal forms
  • Normalizing the 3rd normal form to BCNF
  • Understanding storage device types
  • Identifying the components of disk device
  • Understanding the buffer replacement strategies
  • Understanding program variables
  • Describing the hashing techniques
  • Creating a function-based index
  • Using a function-based index
  • Identifying the steps of processing a high-level query
  • Counting the number of department from the table
  • Using NOT IN operator
  • Using INTERSECT operator
  • Unnesting query
  • Understanding the page replacement method
  • Understanding the transaction states
  • Identifying deadlock dealing techniques
  • Identifying the advantages of distributed databases
  • Identifying the features of databases and IR systems
  • Identifying types of queries
  • Understanding the applications of data mining
  • Identifying database attacks