How to Create Data Structures with SQL

ACCESS the FULL COURSE here: https://academy.zenva.com/product/data-science-mini-degree/?zva_src=youtube-datascience-md

TRANSCRIPT

Hello world and thanks for joining me. My name is Mohit Deshpande and in this course, we'll be learning about how we can create data structures for our database. So, we'll be learning about how we can create and define databases from scratch. We'll learn how to do things like add tables to the database and all that'll involve learning all of different kinds of constraints so that we can add to a database. We'll learn how we can insert data into a database and by the end of this course, you'll know all about, not only how to do querying of the data, but also how to create your own database to use for you own projects. So we'll be discussing how you can create, alter, and delete tables and that includes a different kind of constraints that you can add on a table. You can do things like, say I want this column to only have unique values, for example.

We'll also learn how we can insert data into these tables. We'll learn how we can update the existing data that in this table. We'll learn how to delete data in this table. One interesting goal to discuss is, are called foreign key constraints which allow us to, the backbone behind to how joining works. So we'll learn how we can create these foreign key constraints so that we are always aware of not being able to put data into a table without the reference to another table existing. So we'll learn how we can do all of the things with foreign key constraints. Not only we know about occurring data, but now you'll be able to use, you'll be able to create your own database for your own projects.

We've been making courses since 2012 and we're super excited to have you onboard. Online courses are a fantastic way to learn new skills and I take a lot of online courses myself. Then the courses consist of mainly of video listens that you can watch and re-watch at your own pace as many times as you want. We also have downloadable source code and project files and they can name everything that we've build in the lessons. It's highly recommended that you code along. In my experience, that's the best way to learn something is to participate and get your feet wet or hands dirty, so to speak. And lastly, we've seen that the students who get the most out of these online courses are those who make some kind of weekly plan or schedule and stick with it, depending course of your own availability and learning style. Over the past six years, Zenva has all different kinds of topics on programming and game development. There were 300 thousand students. This is across about 100 courses. Skills that they've learned on these courses are completely transferrable. In fact, some of the students have u ... https://www.youtube.com/watch?v=m_6qGKX9Qxo