Database Admin - LaunchCode-Code-Connect/CandidateResources GitHub Wiki
Introduction to Database Admin
Database administrators are responsible for the maintenance, security, and operations of the databases their teams use. They also focus on making sure that data is stored and retrieved correctly. In this role, you'll spend a lot of time working with developers to understand their data needs, creating databases for use within the company, and ensuring that things run effectively.
Why we recommend Database Admin
Even if you do not fill a Database Admin role specifically, many companies are looking for developers who are able to interact with databases to accomplish their daily work effectively. Being familiar with SQL, Oracle, or other NoSQL databases will help set you up for success in your career as a developer.
SQL Resources
Course Name | Description | Skills Covered | Time to Complete |
---|---|---|---|
SQLBolt | Using interactive modules, learn the foundations of SQL | SQL | unknown |
Pluralsight Intro to SQL | This course will take you through the foundations of SQL | SQL, Joins, Queries, Subqueries | 2 hours |
SQL: Creating Tables, Selecting, Inserting, and Deleting Data | This course will help you learn the basic database manipulation skills you'll need in order to be successful with SQL | Creating and removing Databases and Tables, Manipulating Tables | 42 minutes |
Learn SQL - Codecademy | Learn the foundations of SQL through interactive lessons. Will require signing up for a free Codecademy Account. | Querires, Aggregate Functions | 5 Hours |
SQL DDL: The Definitive Guide on Data Definition Language | Learn more about DDL Statements and how they are used to change database structures. | Create, Alter, Drop, and Truncate SQL Databases | N/A |
SQL Tutorials | This resource offers concepts, hands-on examples, and interactive quizzes in order to strengthen SQL Skills. | General SQL foundations | N/A |