Managing Relational Databases
- Offered byCoursera
Managing Relational Databases at Coursera Overview
Duration | 17 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Managing Relational Databases at Coursera Highlights
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Coursera Labs Includes hands on learning projects. Learn more about Coursera Labs External Link
- Beginner Level No background needed.
- Approx. 17 hours to complete
- English Subtitles: English
Managing Relational Databases at Coursera Course details
- 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.
Managing Relational Databases at Coursera Curriculum
Database Fundamentals
Introduction to the ATA Track
Overview of ATA Track
Advice for Completing the ATA
Databases Course Syllabus
Databases
Tables and Keys
Relationships
Structured Query Language (SQL)
Finding the Database Structure
Queries
Conditional Queries
Database Fundamentals Review
Installing VirtualBox
Installing Ubuntu
Configuring the Virtual Machine to Interact with the Host Operating System
Setting Up the Lab Environment
Querying a Database
Relational Database Concepts Assessment
Understand SQL Practice Assessment
Database Fundamentals Graded Assessment
AND and OR Queries
Comparison Operators
Arithmetic Operators
Searching for a Range of Values
The IN Operator
NULL Values
Pattern Matching
Regular Expressions
Multiple Conditions and Complex Criteria Review
Using Multiple Conditions
Using Patterns
Queries with Multiple Conditions Practice Assessment
Queries with Complex Criteria Practice Assessment
Multiple Conditions and Complex Criteria Graded Assessment
Working with Functions
Date Functions
The DISTINCT Key Word
Aggregate Functions
Formatting Text and Numbers
TRIM and SUBSTR Functions
Concatenation
Working with Functions Review
Functions
Date and Time Data Types
Date Functions Reference
Strings
Performing Date Calculations
Using Aggregate Functions
Manipulating String Functions
Perform Date Calculations Practice Assessment
Calculate Data Using Aggregate Functions Practice Assessment
Manipulate String Values Practice Assessment
Working with Functions Graded Assessment
UNION Operator
INTERSECT and EXCEPT Operators
Joins
Multiple Table Joins
Self Joins
Data Sorting
Limit Results
GROUP BY and HAVING Clauses
ROLLUP Operator
Retrieving and Organizing Data from Multiple Tables Review
Combining and Comparing the Results of Two Queries
Retrieving Data by Joining Tables
Organizing Data
Combine the Results of Two Queries Practice Assessment
Retrieve Data by Joining Tables Practice Assessment
Retrieve Data by Joining Tables Practice Assessment
Retrieving and Organizing Data from Multiple Tables Graded Assessment
Using Subqueries
Subqueries
Subqueries in WHERE Clauses
Subqueries in FROM Clauses
Correlated Subqueries
Existing Records
Nested Subqueries
Using Subqueries Review
Using Subqueries
Advanced CSS Selectors Practice Assessment
Provide Alternate Layouts Practice Assessment
Using Subqueries Graded Assessment
Creating Databases and Tables
INSERT Statement
Inserting Multiple Rows
UPDATE Statement
DELETE Statement
TRUNCATE TABLE Statement
Manipulating Table Data Review
Data Types
Inserting Data into a Table
Insert Data Practice Assessment
Modify and Delete Data Practice Assessment
Manipulating Table Data Graded Assessment
Database Fundamentals Capstone
Capstone Introduction
Capstone Instructions
Managing Relational Databases at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?