Objectives
In this course, you’ll learn to:- Install the MySQL server in your local system
- Set up and configure the MySQL database server
- Create databases and queries
- Use logical operators and manipulate tables/rows/data
- Use the “join” function
At the end of the course, you'll be able to interact with and query any SQL database out there. You'll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.
Lessons
About this course
Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others.
If you have no technical background, don't be afraid! We've distilled our knowledge and experience using SQL into a short course so that by the end, you'll have the raw skills to do some real data analysis for your company using SQL - a language virtually EVERY company uses. If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you.
Whether you:- work in sales or marketing,
- want to be a data scientist,
- or you want to build your own apps,
mastering MySQL is crucial to answering complex business problems and questions using insights from data.
The content will be taught across 2 sessions for the bootcamp, where you will be coding along with the instructor.
Prerequisites
There are no prerequisites for this bootcamp.This course is perfect for:
- Anyone interested in learning SQL to help with their current job or to find a new role
- Anyone looking to answer complex business problems and generate reports using data
- Business owners and people in sales or marketing roles who are interested in understanding their company data better
- Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL
ZP
