The Complete SQL Bootcamp

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

  • 4th week of July, 2020
  • 2 sessions
  • 3.0 hours/session

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

meeting_room 5h 00mClassroom
description 4h 00mAssignment
Overview

Welcome to our SQL Bootcamp! To prepare for this course, you will need to install SQL Workbench and download the provided employee.sql file.

Overview

In this lesson, we will learn about data storage in SQL (Structured Query Language) databases. Students will be using a demo employees database and making queries to filter and search for results.

Students will also be taught about different data types that can be stored in a tabular format. Through understanding of data types, students will know how to perform logical operators across different columns in databases.

At the end of this class, you will be equipped with the ability to retrieve any data within a table with filters and operators.

Lesson Plan
1. Introduction to MySQL
15:00
2. Introducing the concept of data and storage
15:00
3. SELECT Statments
30:00
4. Understanding Data Types
15:00
5. Querying with WHERE
45:00
6. Logical Operators
30:00
7. Relationships: Understanding Primary and Foreign Keys
45:00
Overview

In our first exercise, we will be working on our Employees database and attempting to query data based on questions similar to real life scenarios.

Students will expect to answer questions such as the following:

  1. What is the gender breakdown of the employees in our company?
  2. What is the total salary that is paid to all employees in the year of 1996?
  3. What is the average age of the employees in our company?

Overview

This lesson will be taught in two parts.

In part 1, we will be addressing how to CREATE, INSERT, UPDATE and DELETE databases, tables and records using SQL. We will revisit the concept of data types and how to store data in the proper format and location.

For part 2, we will be looking at relationships between different tables in a database and how to JOIN multiple tables with our SQL queries. Students will learn how to filter and query results across multiple different tables to present desired data.

Lesson Plan
1. Refining Queries
45:00
2. Aggregating Data with GROUP BY
15:00
3. MIN, MAX, SUM and AVG functions
45:00
4. Creating Database and Tables
15:00
5. Inserting and Deleting Data
15:00
6. Multiple Table Queries with JOIN
30:00
Overview

In our final assignment, we will be putting ourselves in the shoes of an SQL Database engineer to tackle different scenarios where you can challenge your SQL knowledge. The questions in this assignment are similar to use cases faced by a professional SQL engineer. If you are able to solve these questions, you will be equipped and ready to take on future SQL challenges in your workspace!

Cohort - 21 Jul, 2020
Current: 0
Max: 10

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
The Complete SQL Bootcamp Skillsfuture Courses / skills future courses - pay with skillsfuture credit
UpCode Academy

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

  • 33 Courses
  • 1,375 Students
  • 33 Instructors

Subscribe to our Newsletter