Database and SQL for Beginners
Learn how to retrieve and manipulate data in Database using SQL
Database and SQL for Beginners free download
Learn how to retrieve and manipulate data in Database using SQL
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
