Data Science Courses in database and Data analysis

DATA SCIENCE

Introduction to Database

This course will explore the database system-advantage of relational databases and Structured Query Language (SQL) for creating and manipulating data. The classes will focus on using Oracle SQL Plus to create tables, populate tables with data, and manage the data: create, update, delete, and retrieve the data.

Introduction to Database Administration

This course will teach you the fundamentals knowledge of databases. Such as what a database is, what is SQL, how to design an Entity Relationship Diagram (ERD) , how databases connect with one another, how to create queries and how a database works.

Introduction to RStudio

RStudio is an Integrated Development Environment for R, a programming language for statistical computing and graphics. In this course, you will learn all the basics about RStudio.

Introduction to Mongo DB

This course guides you step by step on how to install Mongo DB. In addition, it lists advantages of using Mongo DB. You will learn Mongo DB commands and create a mini project.

SQL Server Integration Services(SSIS)

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. In this course, you will learn how to automate maintenance of SQL Server databases and updates to multidimensional cube data.

SQL Server Analysis Services(SSAS)

Microsoft SQL Server Analysis Services (SSAS) is an online analytical processing and data mining tool in Microsoft SQL Server. In this course you will learn how to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.

SQL Server Reporting Services (SSRS)

SQL Server Reporting Service (SSRS) is a reporting software that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users.

Introduction to Orange

Learn to model and analyze data with Orange. Orange is a very simple tool to learn and use, but it is also very powerful tool for data analysis. This course will teach you the basics.

SQLite3 For Begginers

Introduction to SQLite 3 for Beginners" is a concise course that teaches database management with SQLite 3, covering table creation and basic queries through interactive exercises. No prior SQL knowledge required.