Rating 4.85 out of 5 (36 ratings in Udemy)
What you'll learn- Understand what SQL databases are and how to work with them
- Be able to jump in a project requiring SQL knowledge
- Create your own SQL database with multiple tables
- Write simple SQL queries to fetch the data you need
- Have a stable basis for further exploration of more advanced SQL topics
- Find community help and documentation for SQL
- Use SQL databases in Python, Java and other programming languages
Description Rating 4.85 out of 5 (36 ratings in Udemy)
What you'll learn- Understand what SQL databases are and how to work with them
- Be able to jump in a project requiring SQL knowledge
- Create your own SQL database with multiple tables
- Write simple SQL queries to fetch the data you need
- Have a stable basis for further exploration of more advanced SQL topics
- Find community help and documentation for SQL
- Use SQL databases in Python, Java and other programming languages
DescriptionThis is an intensive crash-course of SQLdatabases, the absolute essence. It contains everything you need to know to jump into real SQL database projects. And you can do it in a single weekend!
You will learn:
What SQL databases are and how they are structured
How to set up the necessary tools to get started
How to CREATETABLEs and modify their structure later
How to export the data and table structure to a backup-file, and restore a database from a backup
How to INSERTdata
How to write queries to SELECTthe necessary data, including WHEREconditions, ORDERing, aggregation and GROUP BY, conditions * and functions.
What the mysterious NULL values are and why they behave so weirdly
How to DELETEdata
How to UPDATEdata
How to link together tables and select data from multiple tables using JOINs
Thecourse contains a great deal of practical exercises:
Short quizzes to test your understanding along the way
Exercises in every section, including an extensive set of exercises using multi-table SELECTs with JOIN
Acourse project in Python and Java where you will read data from an SQLdatabases in your program
We will use the MySQLdatabase engine - one of the most popular choices of SQL, a free and open-source solution.
Check out the free videos and see you in the course!