Online Course – Certified Professional Internship in Google Database Systems

Start your career in data science! Apply strategies and tools to develop any type of information system.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - התמחות מקצועית מוסמכת במערכות בסיסי נתונים של Google

Professional Certificate

Intermediate level

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Understanding of information systems requirements
  • Knowledge of information systems architectures
  • Ability to analyze performance of information systems
  • Skills in using business intelligence
  • Ability to perform data mining
  • Understanding of data science
  • Knowledge of relational databases
  • Understanding of NoSQL technologies
  • Ability to develop reliable and scalable data applications
  • Experience working with transactional databases
  • Experience working with analytical databases
  • Ability to program and run OLAP queries
  • Experience working with MongoDB
  • Ability to design and implement recommendation systems

What you will learn in the course

Courses for which the course is suitable

  • Information Systems Consultant
  • Data Scientist
  • Database developer
  • Data Analyst
  • Business Intelligence Specialist
  • NoSQL systems developer
  • Scalable data application developer
  • Project Manager in the field of information systems
  • Recommendation system developer
  • Big Data Expert

Internship – 4-part course series

This program is designed for people in the computer field who are interested in entering the information systems field and learning about the different types of requirements, architectures, performance, techniques, and tools that will allow you to know when to use business intelligence, data mining, data science, databases, in-memory databases, or big data.

Over the course of 4 courses, you will delve into the areas of:

  • Relative Databases
  • Business Intelligence and Data Warehousing
  • NoSQL technologies
  • Reliable, scalable, and maintainable data applications

The courses prepare you to become information systems consultants or data scientists.

Hands-on Learning Project

Course 1: Bookstore Project

In this project, you will design, implement, and query a transactional database system for a bookstore. The system will include books, authors, stores, and sales details.

Course 2: Bookstore Analytical Processing Project

In this project, you will design and implement an analytical database system. You will program and run OLAP queries on the data warehouse.

Course 3: NoSQL Systems

Project: Analyzing Book Sales in a NoSQL Database. In this project, you will design, implement, and query a NoSQL database system for a bookstore using MongoDB.

Course 4: Recommendation System

In this project, you will design a recommendation system for reading books and sales stored in a distributed parallel database.

Details of the courses that make up the specialization

Relational database systems

Course 1
15 hours
4.4 (444 ratings)

Course Details

Welcome to the Relational Database Systems Expertise Course. This course will be completed in six weeks, and will be supported by various videos and documents that will allow you to easily learn about different types of information systems and databases.

purpose

A learner will be able to design, test, and implement analytical, transactional, or NoSQL database systems according to business requirements.

Programming languages

  • MySQL

Software for download

  • MySQL
  • Workbench

Skills you will gain

  • Database Design (DB)
  • Relational database
  • SQL
  • entity

Business Intelligence and Data Warehousing

Course 2
10 hours
3.8 (99 ratings)

Course Details

Welcome to the Business Intelligence and Data Warehousing Expertise Course. This course will be completed in six weeks, and will be supported by video and various documents.

After completing this course, the learner will be able to:

  • Create a star or snowflake data model diagram.
  • Create a physical database system.
  • Extract, transform, and load data into a data warehouse.
  • Program analytical queries with SQL.
  • Predictive analysis with RapidMiner.
  • Ingest relational or unstructured data into Hortonworks HDFS.
  • To exclude Map-Reduce jobs.

Programming languages

  • MySQL

Software for download

  • Rapidminer
  • MySQL
  • Excel
  • Hortonworks Hadoop Framework

Skills you will gain

  • Business intelligence
  • Data storage
  • Expected return
  • Sap Hana

NoSQL systems

Course 3
9 hours
4.3 (164 ratings)

Course Details

Welcome to the NoSQL Systems Expertise Course. This course will be completed in six weeks, and will be supported by video and exercises.

After completing this course, the learner will be able to:

  • Identify what type of NoSQL database to implement based on business requirements.
  • Use data models using atomic aggregates and denormalization.

Software for download

  • MongoDB
  • Neo4j
  • SAPIQ
  • Cassandra

Skills you will gain

  • Document warehouse
  • Top column

Designing data-intensive applications

Course 4
6 hours
4.2 (38 ratings)

Course Details

Welcome to the Data-Intensive Application Design Expertise Course. This course will be completed over four weeks, and will be supported by video and exercises.

Skills you will gain

  • Atomicity, Consistency, Isolation, Durability (ACID)
  • Relational database
  • Practical data mining
  • Data mining

Software for download

  • MySQL Workbench
  • Rapidminer
  • Hortonworks Hadoop Framework
  • MongoDB

Related products