Monthly Subscription Starting at AED 99 + VAT

Managing Relational Databases
  • Level Foundation
  • المدة 18 ساعات hours
  • الطبع بواسطة Akamai Technologies, Inc.
  • Offered by

عن

Students will learn about the structure and design of relational databases including primary and foreign key fields, one-to-many and one-to-one relationships. Students will learn about the Structured Query Language (SQL) and use SQL to examine the database structure. They will also learn to create and manage databases, tables, and records. The focus of the course is on data analysis. Students will start with basic SQL queries then learn to add conditional statements, and logical, comparison and arithmetic operators. Students will learn to query for a range of values, and to use pattern matching and regular expressions. Then they will progress to using multiple conditions, and complex criteria, adding functions to create calculated fields, retrieve unique records and aggregate data. Then students will learn to query multiple tables using joins, creating complex queries using subqueries, nested subqueries, and subqueries in the WHERE and FROM clauses. Students will use SQL to control the output of data including parsing text and numbers, grouping results and using ROLLUP. Students will perform labs that give practical experience and then they will complete a capstone project to demonstrate mastery of course objectives.

الوحدات

Overview of networking

    • 4 Videos
    • 1 Readings
Show info about module content

4 Videos

  • Introduction to the ATA Track
  • Overview of ATA Track
  • Advice for Completing the ATA
  • Databases Course Syllabus

1 Readings

  • README

Relational Database Concepts

    • 3 Videos
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Relational Database Concepts Assessment

1 Discussions

  • Flat Databases

3 Videos

  • Databases
  • Tables and Keys
  • Relationships

Understand SQL

    • 4 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Understand SQL Practice Assessment

4 Videos

  • Structured Query Language (SQL)
  • Finding the Database Structure
  • Queries
  • Conditional Queries

Database Fundamentals Labs

    • 5 Readings
Show info about module content

5 Readings

  • Installing VirtualBox
  • Installing Ubuntu
  • Configuring the Virtual Machine to Interact with the Host Operating System
  • Setting Up the Lab Environment
  • Querying a Database

Database Fundamentals Review and Graded Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Database Fundamentals Graded Assessment

1 Videos

  • Database Fundamentals Review

Queries with Multiple Conditions

    • 3 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Queries with Multiple Conditions Practice Assessment

3 Videos

  • AND and OR Queries
  • Comparison Operators
  • Arithmetic Operators

Queries with Complex Criteria

    • 5 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Queries with Complex Criteria Practice Assessment

5 Videos

  • Searching for a Range of Values
  • The IN Operator
  • NULL Values
  • Pattern Matching
  • Regular Expressions

Multiple Conditions and Complex Criteria Labs

    • 2 Readings
Show info about module content

2 Readings

  • Using Multiple Conditions
  • Using Patterns

Multiple Conditions and Complex Criteria Review and Graded Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Multiple Conditions and Complex Criteria Graded Assessment

1 Videos

  • Multiple Conditions and Complex Criteria Review

Perform Date Calculations

    • 1 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Perform Date Calculations Practice Assessment

1 Videos

  • Date Functions

3 Readings

  • Functions
  • Date and Time Data Types
  • Date Functions Reference

Calculate Data Using Aggregate Functions

    • 2 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Calculate Data Using Aggregate Functions Practice Assessment

2 Videos

  • The DISTINCT Key Word
  • Aggregate Functions

Manipulate String Values

    • 3 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Manipulate String Values Practice Assessment

3 Videos

  • Formatting Text and Numbers
  • TRIM and SUBSTR Functions
  • Concatenation

1 Readings

  • Strings

Working with Functions Labs

    • 3 Readings
Show info about module content

3 Readings

  • Performing Date Calculations
  • Using Aggregate Functions
  • Manipulating String Functions

Working with Functions Review and Graded Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Working with Functions Graded Assessment

1 Videos

  • Working with Functions Review

Combine the Results of Two Queries

    • 2 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Combine the Results of Two Queries Practice Assessment

2 Videos

  • UNION Operator
  • INTERSECT and EXCEPT Operators

Retrieve Data by Joining Tables

    • 3 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Retrieve Data by Joining Tables Practice Assessment

3 Videos

  • Joins
  • Multiple Table Joins
  • Self Joins

Organizing Data

    • 4 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Retrieve Data by Joining Tables Practice Assessment

4 Videos

  • Data Sorting
  • Limit Results
  • GROUP BY and HAVING Clauses
  • ROLLUP Operator

Retrieving and Organizing Data from Multiple Tables Labs

    • 3 Readings
Show info about module content

3 Readings

  • Combining and Comparing the Results of Two Queries
  • Retrieving Data by Joining Tables
  • Organizing Data

Retrieving and Organizing Data from Multiple Tables Review and Graded Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Retrieving and Organizing Data from Multiple Tables Graded Assessment

1 Videos

  • Retrieving and Organizing Data from Multiple Tables Review

Basic Subqueries

    • 3 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Advanced CSS Selectors Practice Assessment

3 Videos

  • Subqueries
  • Subqueries in WHERE Clauses
  • Subqueries in FROM Clauses

Advanced Subqueries

    • 3 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Provide Alternate Layouts Practice Assessment

3 Videos

  • Correlated Subqueries
  • Existing Records
  • Nested Subqueries

Subqueries Lab

    • 1 Readings
Show info about module content

1 Readings

  • Using Subqueries

Using Subqueries Review and Graded Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Using Subqueries Graded Assessment

1 Videos

  • Using Subqueries Review

Insert Data

    • 3 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Insert Data Practice Assessment

3 Videos

  • Creating Databases and Tables
  • INSERT Statement
  • Inserting Multiple Rows

1 Readings

  • Data Types

Modify and Delete Data

    • 3 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Modify and Delete Data Practice Assessment

3 Videos

  • UPDATE Statement
  • DELETE Statement
  • TRUNCATE TABLE Statement

Manipulating Table Data Lab

    • 1 Readings
Show info about module content

1 Readings

  • Inserting Data into a Table

Manipulating Table Data Review and Graded Assessment

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Manipulating Table Data Graded Assessment

1 Videos

  • Manipulating Table Data Review

Capstone

    • 2 Videos
    • 1 PeerReview
Show info about module content

1 Peer Review

  • New Peer Review

2 Videos

  • Capstone Introduction
  • Capstone Instructions

Auto Summary

Dive into "Managing Relational Databases" to master the fundamentals of SQL and relational database design! This foundation-level course, led by Coursera, focuses on data analysis within IT & Computer Science. Over 1080 minutes, you'll create and manage databases, learn complex queries, and complete hands-on labs and a capstone project. Available with Starter and Professional subscriptions, this course is perfect for aspiring data analysts and IT professionals.

Shadow Farrell
Instructor

Shadow Farrell