Rating 0 out of 5 (0 ratings in Udemy)
What you'll learn- Learn the fundamentals of SQL
- Develop Junior to Mid Level developer skills in MySQL
- Understand the role databases have in an application
- Learn how to search, create, update, delete and manage data in a full stack application.
DescriptionIn this course we're going to cover everything that a Junior Developer would need to know when working with databases andSQL. At the end of this course you will be able to confidently build the …
Rating 0 out of 5 (0 ratings in Udemy)
What you'll learn- Learn the fundamentals of SQL
- Develop Junior to Mid Level developer skills in MySQL
- Understand the role databases have in an application
- Learn how to search, create, update, delete and manage data in a full stack application.
DescriptionIn this course we're going to cover everything that a Junior Developer would need to know when working with databases andSQL. At the end of this course you will be able to confidently build the database portion of any web or mobile application.
In this course we'll cover the following:
Installing a full development environment with SQL, PHP, Apache Webserver
Creating Tables and Databases to store information
Adding and deleting rows of information in a table.
Updating data in a table
Various ways of querying and retrieving data from the tables
Duplicating tables
Altering the structure of a table, such as the column name, data type, and adding or removing columns
Foreign Key constraints and data integrity.
Joining tables together and preventing duplicate data.
One to Many Relationships
Many to Many relationships
And More tutorials coming in the future!
This SQL course is designed to be QUICK. We want to get you up to speed in SQL fast, so you can start building out your full stack application immediately.
Why Join this SQLCourse?
Each lesson is self-contained. You can watch any video in any order because the full working code is included with each video.
Get started immediately. We've covered all of the most important concepts in the beginning.
Practice exercises and solutions to help you get comfortable with what you've learned.
We're always adding more content as we learn more and encounter new challenges.