YoVDO

SQL, NoSQL, and Relational Database Fundamentals

Offered By: IBM via edX

Tags

Databases Courses Relational Databases Courses NoSQL Databases Courses

Course Description

Overview

The ability to work with data and access databases is one of the most sought-after skills in our data driven economy. SQL and NoSQL skills are essential for anyone working with data and are listed as one of the top skills in job postings for professionals like Data Engineers, Database Administrators, Data Scientists, Data Analysts, Business Analysts, BI Specialists, Software / Application Developers, Data Architects, and Big Data Engineers.

This Professional Certificate is designed to provide you with the foundational knowledge, skills, and hands-on experience required to work with relational database management systems (RDBMSes), SQL (Structured Query Language), and NoSQL databases.

Organizations use relational databases (RDBMS) to manage and store data for its consistency and reliability, and SQL (Structured Query Language) to query and perform analysis for making critical and informed business decisions. Many organizations also deploy NoSQL databases for non-traditional use cases when scalability and high availability are needed.

Upon completing this program, you’ll have developed the skills and experience to work with relational databases like MySQL, PostgreSQL, and IBM Db2; query databases using SQL, as well as perform Create, Read, Update and Delete (CRUD) operations using NoSQL technologies and databases like MongoDB, Cassandra, and Cloudant.

Within each course, you’ll practice your skills with numerous hands-on labs and complete projects to add to your portfolio for demonstrating your proficiency using RDBMSes, SQL, and NoSQL.

To get started, all you need is basic computer literacy and the desire to learn and practice new skills.


Syllabus

Courses under this program:
Course 1: Relational Database Basics

This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS) such as MySQL, PostgreSQL, and IBM Db2.



Course 2: Introduction to SQL

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in Data Engineering, Data Analytics or Data Science.



Course 3: NoSQL Database Basics

This course introduces you to the fundamentals of NoSQL, including the four key non-relational database categories. By the end of the course you will have hands-on skills for working with MongoDB, Cassandra and IBM Cloudant NoSQL databases.




Courses

  • 0 reviews

    5 weeks, 2-3 hours a week, 2-3 hours a week

    View details

    This course will provide you with technical hands-on knowledge of NoSQL databases and Database-as-a-Service (DaaS) offerings. With the advent of Big Data and agile development methodologies, NoSQL databases have gained a lot of relevance in the database landscape. Their main advantage is the ability to effectively handle scalability and flexibility issues raised by modern applications.

    You will start by learning the history and the basics of NoSQL databases and discover their key characteristics and benefits. You will learn about the four categories of NoSQL databases and how they differ from each other.

    You will explore the architecture and features of several different implementations of NoSQL databases, namely MongoDB, Cassandra, and IBM Cloudant.

    Throughout the course you will get practical experience using these NoSQL databases to perform standard database management tasks, such as creating and replicating databases, loading and querying data, modifying database permissions, indexing and aggregating data, and sharding (or partitioning) data.

    The course ends with a hands-on project to test your understanding of some of the basics of working with several NoSQL database offerings.

  • 0 reviews

    5 weeks, 2-4 hours a week, 2-4 hours a week

    View details

    Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is necessary for anyone who wants to start a career in Data Engineering, Data Analytics or Data Science. The purpose of this course is to introduce relational database (RDBMS) concepts and help you learn and apply foundational and intermediate knowledge of the SQL language.

    You will start with performing basic Create, Read, Update and Delete (CRUD) operations using CREATE, SELECT, INSERT, UPDATE and DELETE statements. You will then learn to filter, order, sort, and aggregate data. You will also work with functions, perform sub-selects and nested queries, as well as access multiple tables in the database.

    The emphasis in this course is on hands-on, practical learning. As such, you will work with real database systems, use real tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs, you will practice building and running SQL queries. At the end of the course you will apply and demonstrate your skills with a final project.

    The SQL skills you learn in this course will be applicable to a variety of RDBMSes such as MySQL, PostgreSQL, IBM Db2, Oracle, SQL Server and others.

    No prior knowledge of databases, SQL or programming is required, however some basic data literacy is beneficial.


Taught by

Rav Ahuja, Steve Ryan, Ramesh Sannareddy, Lin Joyner and Rose Malcolm

Tags

Related Courses

Introduction to Databases
Meta via Coursera Web Development
Udacity MongoDB for Developers
MongoDB University MongoDB for DBAs
MongoDB University MongoDB for Java Developers
MongoDB University