Diploma in Database Development
Types of Databases
In this lesson, you will gain an understanding of what data is as well as a database, before exploring the different types of databases and where each type is used.
Structured and Unstructured Data
After learning the types of databases, this lesson will give you an idea about structured and unstructured data and also provide NoSQL database and Graph database better understanding in relation to the unstructured data.
Structured Query Language
This lesson will introduce you to SQL and the basics of it, along with how to query the data with basic syntax examples.
Datatypes in SQL
This lesson will delve further into understanding all the data types in SQL.
Data Definition Language in SQL
This lesson will include data definition language statements with real-life examples and explanations.
Data Manipulation Language in SQL
This lesson will include data manipulation language statements with real-life examples and explanation.
Understanding Different Database Platforms
This lesson will give an understanding of the different database platforms and brandings like Microsoft, Oracle and also PostgreSQL.
Database Environment Setup
This lesson will include setting up any one of the database platforms for further practical illustrations of the module and for following a single pattern for better understanding.
Hands-on with MS SQL Server
This lesson will teach you how to set up an MS SQL Server Database environment and get practical experience of using it.