Shaw Academy

Your Future, Your Way!

Course Catalogue

Get 4 Weeks FreeLogin

5000

Graduates
All Levels
Certified

0%

Most of this week’s places have been filled.

Start your course now to guarantee your place.

learn-icon

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

Course Content

module 1

Diploma in Database Development

free

+

-

  1. 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.

  2. Types of Databases

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

  3. 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.

  4. 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.

  5. Datatypes in SQL

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

  6. Data Definition Language in SQL

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

  7. Data Manipulation Language in SQL

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

  8. Understanding Different Database Platforms

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

  9. 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.

  10. 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.

module 2

Intermediate in Database Development

+

-

  1. Creating Tables

    This lesson will help learn and understand how to create a database and how to create a data table in that database.

  2. Data Insertion

    This lesson will include data insertion techniques and statements based on the data types learned in the previous lesson.

  3. 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.

  4. 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.

  5. Clauses in SQL

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

  6. 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.

  7. 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.

  8. Date Functions

    Different date functions as per different database platforms will be included in this lesson.

module 3

Advanced in Database Development

+

-

  1. Types of Indexes

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

  2. 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.

  3. Aliasing

    This lesson will explain how to shorten complicated names of attributes (columns) or tables using aliasing.

  4. 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.

  5. Stored Procedures and Transaction

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

  6. 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.

  7. SQL Injection

    This lesson will include theoretical and practical content on SQL Injection attacks and its types.

  8. 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.

module 4

Proficient in Database Development

+

-

  1. 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.

  2. Defining and Hands On With Data Warehousing

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

  3. 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.

  4. 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.

  5. OLAP and OLTP

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

  6. 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.

  7. Extract-Transform-Load (ETL) Process

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

  8. 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.

Certified by
Globally recognised by
  • Weeks
    16 Weeks

    Duration

  • lessons
    32 Lessons

    Plus assessments

  • modules
    4 Modules

    Online

  • course
    Globally Recognised

    Certification

Avg. Rating

4.8/5

4.8

I enrolled on the 10 part online Foundation Course with Shaw academy, covering financial trading. All the basics, including Forex, stocks and indices and interpreting Japanese candlesticks charts were covered in great detail.

4.6

I am really enjoying The Foundation Trading Course. So far i would say it is the best of its kind for any potential trader because the lessons are such that it is helpful to new traders.

4.5

The team do a great job at cramming so much information into each hourly session. It never feels like cramming though and stays in the memory easily.

4.9

This review is for the Foundation Trading Programme. Great course, to help understand the way markets work.

You might also like

Course Benefits

Flexible online classes
You pick the schedule.
Pause course
Take a break any time.
Educator support
Always get your answers.
Offline mode
Download class recordings.
Globally Recognised Courses
International focus to curriculum.
UNLIMITED Courses
One plan - All content.

Start building your future, your way.

Access to all 100+ courses including:
  • Live educator chat support
  • 20+ hours of learning per course
  • Exams & continuous assessments
  • Unique lessons curated by in-house experts
  • Lifetime access to all lessons
  • Globally accredited certifications

$49.99 / month

FREE for 4 weeks

Start your free course

No commitment

FREE for 4 weeks

No Commitment