Sign In Relational Database
TOPIC
Relational Database
A relational database is a type of database management system (DBMS) that stores and manages data in a tabular format, using a collection of tables with rows and columns. It is based on the principles of the relational model, which was introduced by Dr. E.F. Codd in 1970.
The terminal allows you to send text commands to your computer that can manipulate the file system, run programs, automate tasks, and much more.
In this 170-lesson course, you will learn terminal commands by creating a website boilerplate using only the command line.
A relational database organizes data into tables that are linked together through relationships.
In this 165-lesson course, you will learn the basics of a relational database by creating a PostgreSQL database filled with video game characters.
This is one of the required projects to earn your certification.
For this project, you will build a database of celestial bodies using PostgreSQL.
Bash scripts combine terminal commands and logic into programs that can execute or automate tasks, and much more.
In this 220-lesson course, you will learn more terminal commands and how to use them within Bash scripts by creating five small programs.
SQL, or Structured Query Language, is the language for communicating with a relational database.
In this 140-lesson course, you will create a Bash script that uses SQL to enter information about your computer science students into PostgreSQL.
SQL join commands are used to combine information from multiple tables in a relational database
In this 140-lesson course, you will complete your student database while diving deeper into SQL commands.
This is one of the required projects to earn your certification.
For this project, you will create a Bash script that enters information from World Cup games into PostgreSQL, then query the database for useful statistics.
There’s more to Bash commands than you might think.
In this 140-lesson course, you will learn some more complex commands, and the details of how commands work.
In this 210-lesson course, you will build an interactive Bash program that stores rental information for your bike rental shop using PostgreSQL.
This is one of the required projects to earn your certification.
For this project, you will create an interactive Bash program that uses PostgreSQL to track the customers and appointments for your salon.
Nano is a program that allows you to edit files right in the terminal.
In this 40-lesson course, you will learn how to edit files in the terminal with Nano while building a castle.
Git is a version control system that keeps track of all the changes you make to your codebase.
In this 240-lesson course, you will learn how Git keeps track of your code by creating an object containing commonly used SQL commands.
This is one of the required projects to earn your certification.
For this project, you will create Bash a script to get information about chemical elements from a periodic table database.
This is one of the required projects to earn your certification.
For this project, you will use Bash scripting, PostgreSQL, and Git to create a number guessing game that runs in the terminal and saves user information.
