What will I learn?
Create your database or interact with the existing database.
- Write complex queries to SQL on multiple tables.
- Create a web app using Node JS and MySQL.
- Create real-world data and reports using MySQL.
- Use the data to answer company performance or sales questions.
- No database, MySQL, or MySQL experience required! Welcome to the complete starting point for SQL.
- All you need for this course is a working computer. PC, Mac, and Linux users all welcome.
- No previous programming language experience needed, but it won't hurt.
- In this course, you will learn:
- Learn the inks and outs of SQL syntax.
- Create reports using sales and user data.
- Analyze data using aggregate functions.
- Run complex queries using SQL logical operators and string functions.
- Write down all general SQL inclusions.
- Work with large datasets containing thousands of entries.
- Create a web app using SQL and Node JS.
- Design and implement complex database schemes.
- Learn how to navigate the treacherous world of storing dates and times.
- Clone the database structure of the photo-sharing social network.
- And more!