Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. The emphasis in this course is on hands-on and practical learning. Through a series of hands-on labs you will practice building and running SQL queries. No prior knowledge of databases, SQL, Python, or programming is required.

Database Fundamentals Course Content

Module 1

- What is database application?

- Back end vs. front end testing         

Module 2

- Database components

- Database type          

Module 3

- Introduction to Oracle database

- Database testing phase       

Module 4

- Testing methodologies

- Structural database testing

- Functional database testing

Module 5

- SQL coding standard

- SQL Basics – Select, Insert, Update, Delete

Module 6

- Select statement to test data

- Insert statement to generate data  

Module 7

- Update and delete statement to test application accuracy

- Test data integrity   

Module 8

- Joining tables

- Using SQL queries for data verification      

Module 9

- Concurrency issues

- Database objects     

Module 10

- Views

- Indexes

- Stored procedure     

Module 11

- Triggers

- Defined functions

- Schema test 

Module 12

- Keys and indexes

- Integration test for server

- Test back-end via front end