Database Development Course

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.

This lesson will explore the different types of databases and where each type is used.

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.

This lesson will introduce you to SQL and the basics of it, along with how to query the data with basic syntax examples.

This lesson will delve further into understanding all the data types in SQL.

This lesson will include data definition language statements with real-life examples and explanations.

This lesson will include data manipulation language statements with real-life examples and explanation.

This lesson will give an understanding of the different database platforms and brandings like Microsoft, Oracle and also PostgreSQL.

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.

This lesson will teach you how to set up an MS SQL Server Database environment and get practical experience of using it.

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.

This lesson will include different types of constraints and keys which are used for data design, security, encryption and modelling.

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.

This lesson comprises on all clauses used in SQL whether it's conditional or non-conditional clause.

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.

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.

This lesson includes all types of indexes and why it is used and what is the importance of that particular index.

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.

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.

This lesson includes stored procedures and transactions. This lesson will be dealing with Transact-SQL (T-SQL).

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.

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.

This lesson will include more complex commands with more complex queries which will help students to get a better track of database language.

This lesson will include introduction to data warehousing which consists of data mart and metadata like concepts.

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.

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.

Online Analytical Processing and Online Transaction Processing are being compared with different factors and their applications in this lesson.

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.

This lesson will include ETL process of the data warehouse using Integration services practical content and theoretical explanation.

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.