The Complete SQL Bootcamp

Master in-demand SQL skills by creating complex databases and building reports for real-world projects.

  • TBD
  • 2 sessions
  • 3.0 hours/session
The Complete SQL Bootcamp
$198

Price before GST

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.

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.

Course Plan

- Overview and installation
- Introducing the concept of data and storage
- Create a database with SQL
- Create a table with SQL
- Inserting data with SQL
- Understanding data structures
- SELECT statement
- Making a query with WHERE SQL
- Building filters
- Updating data
- DELETE statement
- DISTINCT statement
- Sorting data with ORDER BY statement
- Aggregating data with GROUP BY statement
- MIN, MAX, SUM and AVG functions
- Basic data types
- Date time types
- EQUALS and NOT EQUALS, GREATER THAN and LESS THAN statements
- BETWEEN, IN and NOT IN and CASE statements
- Understanding ONE to MANY and MANY to ONE relationships
- Multiple table queries with JOIN statement

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

There are no open runs for this course at the moment. If you're interested in taking this course, you may join the waitlist and you will be notified when there are vacancies.

UpCode Academy

Attend coding classes taught by true experts working in the industry. Get practical instructions and interact with these practitioners during the classes.

  • 28 Courses
  • 1,174 Students
  • 28 Instructors

Subscribe to our Newsletter