Big Data University

SQL and Relational Databases 101

Login to enroll
  • Course Number
    DB0101EN
  • Classes Start
    Any time, Self-paced
  • Estimated Effort
    3 hours
  • Audience
  • Course Level
  • Language
  • Tell Your Friends

About This Course

Data is one of the most critical assets of any business. Data needs a database to store and process data quickly. SQL is a language used for a database to query data.

In this introductory course, you'll learn the basics of the SQL language and the relational databases. You'll start by learning about the relational model and relational model concepts and constraints. By the end of this course, you will have learned and used the five basic SQL statements, some advanced SQL syntax, and join statements.

This isn't your typical textbook introduction. You're not just learning through lectures. At the end of each module there are assignments, hands-on exercises, review questions, and also a final exam. Successfully completing this course earns you a certificate. So let's get started!

COURSE SYLLABUS

Module 1 -SQL and Relational Databases 101

  • Introduction to SQL and Relational Databases
  • Information and Data Models
  • Types of Relationships
  • Mapping Entities to Tables
  • Relational Model Concepts

Module 2 - Relational Model Constraints and Data Objects

  • Relational Model Constraints Introduction
  • Relational Model Constraints Advanced

Module 3 - Data Definition Language (DDL) and Data Manipulation Language (DML)

  • CREATE TABLE statement
  • INSERT statement
  • SELECT statement
  • UPDATE and DELETE statements

Module 4 - Advanced SQL

  • String Patterns, Ranges, and Sets
  • Sorting Result Sets
  • Grouping Result Sets

Module 5 - Working with multiple tables

  • Join Overview
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Join

GENERAL INFORMATION

  • This course is free.
  • It is self-paced.
  • It can be taken at any time.
  • It can be audited as many times as you wish.

RECOMMENDED SKILLS PRIOR TO TAKING THIS COURSE

  • None

REQUIREMENTS

  • None

COURSE STAFF

Hima Vasudevan

Hima Vasudevan

Hima Vasudevan is a Data Scientist based out of the Chicago office. She is part of the Emerging Technologies team and focusses on developing course content. Hima joined IBM in 2016 as an Analytics Data Scientist Intern and worked on a data mining project to predict power outages related to storms using IBM SPSS Modeler. She is specialized in data mining and databases and has published a Thesis in Data Mining titled 'Effectively Updating Co-location Patterns in Evolving Databases'. She has a Bachelors Degree in Computer Science Engineering and Masters in Applied Computer Science from Purdue University.

 

Rav Ahuja

Rav Ahuja

Rav Ahuja is a Senior Manager with IBM Canada Lab specializing in AI, Data Science and Big Data analytics. He is part of the Emerging Technologies team and is involved in incubating solutions for Data Scientists and Analytics Professionals. Rav is also a co-founder of Cognitive Class (CC) and leads the work on CC partnerships and offerings for businesses. He presents at events worldwide and has authored numerous papers, articles, books and courses on subjects in managing and analyzing data. Rav holds B. Eng. from McGill University and MBA from Richard Ivey School of Business, University of Western Ontario.

 

Raul F. Chong

Raul F. Chong

Raul F. Chong is a Senior Program Manager based at the IBM Toronto Laboratory. Raul joined IBM in 1997 and has held numerous positions in the company. Raul has taught many DB2 workshops, has published numerous articles, and has contributed to the DB2 Certification exam tutorials. Raul is the lead author of the book Understanding DB2 - Learning Visually with Examples 2nd Edition (ISBN-10: 0131580183). Raul co-founded BDU and has started BDU meetups worldwide.