Skill
SQL for Data Practitioners: Manipulating Databases
April 2022 with Jonathan Barrios
- Entry
- 7 videos
- 51 mins
So far, you've learned database fundamentals to create a database and table, way to go! Now that you have a new database with three tables inside, it's time to start inserting data and even manipulating that data. In this set of videos, you'll learn how to INSERT, UPDATE, DELETE, ALTER, and DROP data. Finally, you'll use the CHECK command to ensure that certain conditions are met. For example, gold members must purchase over $1000 monthly to become or stay a gold members. The CHECK constraint can ensure the payment column is >= to 1000. Enough talking; let's dive into manipulating the database and tables.
Recommended Experience
Jonathan Barrios has been a CBT Nuggets trainer since 2021. His expertise areas include full-stack software development, data science, and machine learning. He has experience using the following technologies: HTML, CSS, JavaScript, PHP, Python, SQL, NoSQL, and frameworks/libraries such as Vue, React, Django, NumPy, Pandas, Matplotlilb, Scrappy, BeautifulSoup, SciPy, Seaborn, Plotly, Scikit-learn, Tensorflow, and PySpark.
- None
- Data Analysts
- Data Practitioners
- SQL Developers
Jonathan Barrios has been a CBT Nuggets trainer since 2021. His expertise areas include full-stack software development, data science, and machine learning. He has experience using the following technologies: HTML, CSS, JavaScript, PHP, Python, SQL, NoSQL, and frameworks/libraries such as Vue, React, Django, NumPy, Pandas, Matplotlilb, Scrappy, BeautifulSoup, SciPy, Seaborn, Plotly, Scikit-learn, Tensorflow, and PySpark.
Trainer