Database and SQL for Beginners

This course covers the following topics:

• What is a Database

• DBMS and RDBMS

• Relational Database Terminology - Primary key, Foreign key etc.

• Structured Query Language (SQL)

• Types of SQL commands - DDL, DCL, DML and Query

• How to use SQLite Database System

• How to install SQLite Studio and use it to create SQLite Database and interact with it

• Designing and creating Tables

• Constraints and Data Integrity - how to implement integrity rules

• Querying data using SELECT command

• Projection - selecting a few columns

• Selection - selecting a few rows

• ORDER BY clause and how to order by multiple columns

• SQL Operators - BETWEEN .. AND, IN and LIKE 

• Manipulating data using INSERT, DELETE and UPDATE commands

• Transaction Management - COMMIT and ROLLBACK

• What is a function and how to use it in SQL commands

• How to use Numeric functions

• How to use String function to process strings

• How to use DateTime functions

• How to use Miscellaneous functions to deal with null values

• How to use Group functions to get aggregates

• Grouping data using GROUP BY clause

• Selecting rows and then grouping them

• Using HAVING clause to select groups

• Joining tables

• Using NATURAL JOIN and JOIN clauses

• How to use outer join

• Subqueries

• Using subqueries in DML and DDL

• Nested and multiple subqueries

• Correlated Subquery

• How to use Join, Subquery and Grouping together

• What is a view

• Where view is needed and its advantages

• How to create a view and use it

• What is an Index

• How an index improves performance of a query

• How to know whether index is being used in a query