What you'll learn
- Understand the basics of SQL through to the advance structure of queries
- Understand different types of databases and structure of database design
- MS SQL Server, MS Visual Studio, Oracle Database, PostgreSQL
- Gain expertise in the ETL process using MS Visual Studio
- Get familiar with real life database applications in various industries
Diploma in Database Development
Defining Data and Database
Welcome to the world of database development! This lesson will include brief introduction about data and its formats, along with how data is being stored in a database and what is a database, how it came into existence and what's the use of it.
Types of Databases
This lesson will explore 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.
Intermediate in Database Development
This lesson will help learn and understand how to create a database and how to create a data table in that database.
This lesson will include data insertion techniques and statements based on the data types learned in the previous lesson.
Types of Constraints and Keys
This lesson will include different types of constraints and keys which are used for data design, security, encryption and modelling.
Select Statement and Aggregate functions in SQL
This lesson will include examples and uses of select statements in all aspects, that is in how many different ways a select statement can be used alone as well as along with aggregate functions.
Clauses in SQL
This lesson comprises on all clauses used in SQL whether it's conditional or non-conditional clause.
Querying and Sub Querying Data
Reaching this lessons basics will be strong for an individual so this lesson will focus more on complex query structures and how subqueries are used to retrieve complex forms of data from a data table.
Pivoting and Unpivoting Tables
This lesson includes pivot tables and unpivot tables which will require prior basic understanding of table pivoting in MS Excel. No prior knowledge of pivoting tables will not be an issue.
Different date functions as per different database platforms will be included in this lesson.
Advanced in Database Development
Types of Indexes
This lesson includes all types of indexes and why it is used and what is the importance of that particular index.
Joins in SQL
This lesson includes one of the most important concepts of database which is Joins. It will include practical content as well as theoretical content of SQL Joins.
This lesson will explain how to shorten complicated names of attributes (columns) or tables using aliasing.
Views and Triggers
This is another major lesson with two of the important concepts in SQL databases which are views and triggers. This lesson includes detailed practical content about types of views and types of triggers.
Stored Procedures and Transaction
This lesson includes stored procedures and transactions. This lesson will be dealing with Transact-SQL (T-SQL).
Database Export and Import
This lesson will include exporting and importing of data from database and into the database. The export and import process will also include explanation about flat file sources of data.
This lesson will include theoretical and practical content on SQL Injection attacks and its types.
Oracle Database Setup
As discussed in the previous lesson for setting up the database environment. this lesson will include the Oracle database setup process along with getting practically started with it.
Proficient in Database Development
Additional Advance SQL Commands
This lesson will include more complex commands with more complex queries which will help students to get a better track of database language.
Defining and Hands On With Data Warehousing
This lesson will include introduction to data warehousing which consists of data mart and metadata like concepts.
Fact and Dimensions
This lesson includes the main pillars of the data warehouse which are Fact tables and Dimension Tables. This lesson explains the entity relationship between facts and dimensions of the data warehouse.
Types of Schemas
This lesson includes the practical content along with the theoretical content of the data warehouse design by explaining different types of schemas of the relational database.
OLAP and OLTP
Online Analytical Processing and Online Transaction Processing are being compared with different factors and their applications in this lesson.
MS Visual Studio SSIS and SSRS
This lesson will include setting up of MS Visual Studio for Data Warehouse development using SSDT tools, SQL Server Integration services (SSIS) and SQL Server Reporting Services.
Extract-Transform-Load (ETL) Process
This lesson will include ETL process of the data warehouse using Integration services practical content and theoretical explanation.
Data Warehouse Applications
This lesson will be the final lesson of the last module of the course and will include the data warehouse applications in real life IT industries and so on.