freeCodeCamp: Relational Databases Certification

• Relational Databases
  • Code Editors
    • Working with Code Editors and IDEs (Theory)
      What Is a Code Editor and IDE?
      • Text/Code editors focus primarily on the text contents of the file, where the IDEs expose various tools to manage your code.
      • Cloud based code editors allow you to write code directly from a web browser. Some examples include github codespaces, Replit, Ona and Vscode Dev(VS Code Online)
      How to Install Visual Studio Code onto Your Computer
      How to Create a Project and Run Your Code Locally in VS Code
      What Are Several Useful Keyboard Shortcuts for Maximizing Productivity in VS Code? What Are Some Good VS Code Extensions You Can Use in Your Editor?
  • Bash Fundamentals
    • Understanding the Command Line and Working with Bash (Theory)
      What Is the Terminal, and How Does It Differ from the Command Line? What Are Some Shortcuts You Can Use in the Command Line to Speed Up Productivity? What Is Bash, and What Are Some Basic Commands? What Are Some Command Options and Flags?
    • Build a Boilerplate (Workshop)
    • Bash Commands Review (Review)
    • Bash Commands Quiz (Quiz)
  • SQL and PostgreSQL
    • Working with Relational Databases (Theory)
      What Are Relational Databases, and How Do They Differ from Non-Relational Databases? What Are Some Common Relational Databases, and How Do You Install and Use Postgres? What Is SQL, and How Can You Create a Database with Tables? What Are the Basic Data Types in SQL?