The Complete SQL Bootcamp

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

  • 4th week of November, 2019
  • 2 sessions
  • 3.0 hours/session
The Complete SQL Bootcamp Skillsfuture Courses / skills future courses - pay with skillsfuture credit
$198

Price before GST

See Available Slots

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
Active Course Runs

Lesson Dates/Timings

  • November 26, 20191930 - 2230 hrs
  • November 28, 20191930 - 2230 hrs
  • one-north

    Blk 71 Ayer Rajah Crescent #03-26, S139951

    Instructor

    ZP


    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,236 Students
    • 28 Instructors

    Subscribe to our Newsletter