Introduction to Databases

Name: Introduction to Databases
Rating: 4.1 (19 reviews)

Database Design

Created byManasi Kule, Suhana Khan

Last updated 12/2024

English

English [Auto],

What you'll learn

Database
SQL
Database Design
Normalization

Course content

4 sections • 17 lectures • 1h 22m total length

Course Introduction4:57
Explore the fundamentals of databases, SQL basics, CRUD operations, relational design, keys, and normalization in a practical four-week course.
Introduction of Databases3:16
Understand databases as organized collections of data that store customers, transactions, and profiles, and learn the structure: tables, rows, columns, attributes, records, primary key, and data types.
Data and database
Types of Databases2:58
Explore relational, non-relational, in-memory, cloud, graph, and time series databases with examples such as MySQL, MongoDB, Redis, Neo4j, InfluxDB, and practical use cases from banking to social networks and monitoring.
SQL & Commands5:42
SQL, the structured query language, powers relational databases such as MySQL, PostgreSQL, Oracle, and Microsoft SQL Server. Learn data retrieval, data manipulation, data definition, and data control commands.
SQL Syntax

SQL Datatypes6:16
Explore sql data types, including char and varchar2, number (precision and scale), date, and large objects like clob and blob, and understand fixed vs variable memory allocation.
CREATE and DROP database3:57
Learn how to create databases with the create database command and drop them with the drop database command, including syntax, naming rules, backups, and required permissions.
CREATE TABLE statement and INSERT TABLE statement4:16
learn how to create a table with sql create table syntax, define columns and data types, and use insert statements with or without column names to add records.
Create database, create table and insert data
ALTER TABLE statement4:40
Explore how the alter table statement changes an existing table by adding, deleting, or modifying columns, renaming tables or columns, and adjusting constraints and data types.
ALTER TABLE
UPDATE data and DELETE data6:49
Learn update and delete data in sql: modify existing records with the update statement using single or multiple columns and a where clause, and remove rows with delete.
UPDATE & DELETE Data

SQL Arithmetic Operators6:33
Apply SQL arithmetic operators to numerical data in tables using select queries. Use addition, subtraction, multiplication, division, and modulus in select and where clauses to compute salaries, allowances, and taxes.
Arithmetic Operators
SQL Comparison Operators7:00
Explore SQL comparison operators to filter records in the where clause: equality, inequality, greater than, greater than or equal to, less than, and less than or equal to.
Comparison Operators
SQL CLAUSE5:16
Explore sql clauses, including where, order by, distinct, and having, to filter, sort, and retrieve data in invoices and employee tables.
Clauses

Database Schema & Types of database schema6:10
Explore database schema concepts, including physical, logical, and view schemas. Understand how primary and foreign keys define table relationships and constraints.
Database Schema
Keys in depth4:45
Explore keys in SQL to uniquely identify records and link tables using primary keys, foreign keys, and candidate keys while understanding referential integrity.
Keys
Database Normalization8:22
Learn how database normalization reduces redundancy and anomalies by organizing data into 1NF, 2NF, and 3NF, using atomic values and primary and foreign keys.
Normalization
Project0:55
Project Solution0:32

Requirements

There are no prerequisites required for this course as it is a beginner level course.

Description

Are you ready to unlock the power of data? In today’s world, databases are the backbone of every business, application, and technology. "Introduction to Databases" is your gateway to mastering the foundational concepts and skills you need to work with databases effectively, whether you're a student, aspiring data professional, or developer. It is designed to take you from the basics to practical proficiency, equipping you with essential skills to manage and analyze data efficiently.

In this course, you'll:

Demonstrate a working knowledge of the concepts and principles that shows how databases work.

Identify and explain the different types of core technology and management systems used in databases

Identify and interpret basic SQL statements and commands

Manipulate records in a database with the use of SQL statements and commands - Outline alternatives to SQL

plan and design a simple relational database system

This course is designed with beginners in mind, offering step-by-step guidance and interactive lessons to ensure you grasp every concept thoroughly. No prior experience with databases is required—just a willingness to learn and grow!

By the end of the course, you’ll have the knowledge and skills to design and manage databases, write efficient SQL queries, and understand how databases drive applications and decision-making.

Join now and take the first step toward becoming a database expert!

Who this course is for:

This course is for anyone with an interest in data and database.

Introduction to Databases

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 17min

Create, Read Update and Delete (CRUD) operations5 lectures • 26min

SQL operators and sorting and filtering data.3 lectures • 19min

Database Design5 lectures • 21min

Requirements

Description

Who this course is for: