Introduction to Databases Archive

Description

As data becomes more important in our day to day lives, learning Structured Query Language (SQL) to manage back-end data is essential in a programmer's journey. SQL is heavily used in various careers such as by Data Scientists, Web Developers, and Mobile Developers. The Introduction to Database series will teach students how to apply SQL fundamentals to create and manage complex sets of data while maintaining a smooth learning curve. By the end of the series, students will be able to apply learned concepts to venture out and create their own projects using SQL.

Curriculum Developers

Pranav N

If you have any questions about the curriculum, need any support, want to submit your code to RCA please reach out to us at redmondcodeassociation@gmail.com.

Day 1

Learning targets:

Introduction to Data
Setting up IDE
SQL Structure
Creating/Connecting to Databases
Creating Tables
Data Types

OC Intro to Databases: Day 1

Day 2

Learning targets:

Inserting Data
Committing Changes
Inserting Multiple Sets of Data

OC Intro to Databases: Day 2

Day 3

Learning targets:

Avoiding Duplicate Data
Filtering Data by Column/Row
Retrieving/Printing Specific Data

OC Intro to Databases: Day 3

Day 4

Learning targets:

Updating Data
Debugging
Unique IDs
Inserting Data by Column

OC Intro to Databases: Day 4

Day 5

Learning targets:

D.R.Y. Concepts
Integrating Variables
Implementing Functions
Deleting Data

OC Intro to Databases: Day 5