Launch School LS180 Database Foundations Update
1) So far the curriculum focuses on learning the SQL syntax and understanding how to use SQL from the command line.
2) This section focuses on creating and altering Databases and tables.
3) The section gives you a bunch of different exercises that start off with very simple problems and then they progressively get more difficult over time including more complex calculations and joins.
4) The Sections are
a) Intro to the course
b) Schema, Data and SQL
c) Relational data and joins.
5) As you might have guessed the intro section focuses mostly on the Launch School’s SQL book that is part of the Launch School course library. This part of the course features the introductory material to each of the sub-sections of the course. This book teaches you all the basic syntax and give you a few other exercises to start with.
6) Schema, Data and SQL focuses on a number of Sub Topics related to programming with SQL. it touches on things like:
a) DDL, DML, DCL
b) Aggregate functions
c) Group by functions
d) Data Types
e) Constraints
f) The mechanics behind how SQL executes queries.
g) This section has a set of associated practice exercises and ends with a quiz.
7) Relational data and joins focuses on how to structure data and work with multiple tables. In this section you learn about the different levels of database design including conceptual, logical and physical. You also go over many practical exercises using Joins. Like section 2 this section has it’s own set of practice problems and ends with a quiz.
8) Last section I have not taken “optimizing SQL queries” I will report on in my rap up video for this course.
So far this sections has been a welcome return to more structured learning. Each section introduces one or two concepts and then has a whole group of practice exercises related to that concept. It has been hugely beneficial in helping to solidify my understanding of database queries.
If you enjoy this video, feel free to subscribe! Also feel free to show that like button some love below as well! Stick around for more content!
----------
Check Out More Videos:
If You Like This Video You Will Love This ➤
Subscribe for more ➤ https://bit.ly/2NlhmFh
----------
📱Follow Me📱
Instagram: instagram dot com/_opensourced
Facebook: facebook dot com/opensourced
Quora: quora dot com/profile/Ian-Lenny
Twitter: twitter dot com/_Opensourced
-----
Thank you for watching!