Introduction to Databases and Data Mining

Beginner 0(0 Ratings) 0 Students enrolled English
Created by Admin corner
Last updated Wed, 08-Jun-2022
+ View more
Course overview
Overview

Databases and other collections of data are everywhere. Retailers use data about customers and their purchases to make decisions that increase profits. Researchers analyze data about the human genome to find treatments for diseases. Policymakers analyze socioeconomic data to gain insights that guide their decisions. Online music and video services perform data mining to deliver customized recommendations. How does all this work? CS 105 explores the ways in which collections of data are organized, stored, and analyzed. Topics include relational databases and the SQL query language, the writing of simple programs to process data, data visualization and the graphical display of data, and data-mining techniques for discovering patterns in data. Applications from a variety of domains (including business, the arts, the life sciences, and the social sciences) are used to illustrate the course's key concepts.
Curriculum for this course
32 Lessons 03:46:04 Hours
Lecture
32 Lessons 03:46:04 Hours
  • Fundamental Facts About Data
    Preview 00:06:19
  • The Relational Model
    00:03:25
  • Keys, Candidate Keys, and Primary Keys
    00:05:42
  • Capturing Relationships Using Foreign Keys
    00:06:00
  • Constraints and Null Values
    00:07:11
  • SQL: Simple SELECT Commands
    00:07:43
  • SQL: Pattern Matching; Comparisons Involving NULL
    00:06:07
  • SQL: Removing Duplicates; Aggregate Functions
    00:05:33
  • Subqueries in SQL
    00:06:52
  • SQL: Queries Involving Subgroups
    00:05:55
  • SQL: Data Types; Creating Tables and Inserting Rows
    00:08:54
  • SQL: Cartesian Product; Joins
    00:06:10
  • SQL: Joins Revisited
    00:09:24
  • SQL: Outer Joins
    00:07:05
  • SQL: Other Commands
    00:07:02
  • Getting Started with Python
    00:05:51
  • Python Building Blocks
    00:09:54
  • Python: Built-In Functions and User Input
    00:07:04
  • Python: A First Look at Lists; the range() Function
    00:02:37
  • for Loops in Python
    00:04:29
  • Writing Your Own Functions
    00:08:29
  • Cumulative Computations
    00:04:09
  • Making Decisions: Conditional Execution
    00:08:43
  • Working with Strings and Lists
    00:08:26
  • Using Objects; Splitting and Joining Strings
    00:09:00
  • Accessing a Database from Python
    00:09:25
  • Working with Text Files; File Writing
    00:06:40
  • Reading from a Text File
    00:08:09
  • Data Mining Fundamentals
    00:07:48
  • Evaluating a Model Learned in Data Mining
    00:07:44
  • Classification Learning Using 1R
    00:08:39
  • Classification Learning: Learning a Decision Tree
    00:09:35
+ View more
Other related courses
01:08:35 Hours
Updated Tue, 17-May-2022
0 2 Free
04:17:22 Hours
Updated Tue, 17-May-2022
0 0 Free
01:02:24 Hours
Updated Tue, 17-May-2022
0 0 Free
03:16:00 Hours
Updated Tue, 17-May-2022
0 0 Free
00:44:21 Hours
Updated Tue, 17-May-2022
0 0 Free
About instructor

Admin corner

0 Reviews | 5 Students | 47 Courses
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

Free
Includes: