Course description

6 Reasons why you should choose this SQL course

  1. Carefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businesses
  2. Comprehensive - covers basics, advanced SQL statements, interview tips and performance tuning tips as well
  3. Business related examples and case studies
  4. Ample practice exercises because SQL requires practice
  5. Downloadable resources
  6. Your queries will be responded by the Instructor himself


A Verifiable Certificate of Completion is presented to all students who undertake this SQL course.

Why should you choose this course?

This is a complete tutorial on SQL which can be completed within a weekend. SQL is the most sought after skill for Data analysis roles in all the companies. So whether you want to start a career as a data scientist or just grow you data analysis skills, this course will cover everything you need to know to do that.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade.

We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of SQL as an analytical tools. Kudos to the instructor! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Solution to Assignment is also shared so that you can review your performance. 

By the end of this course, your confidence in using SQL will soar. You'll have a thorough understanding of how to use SQL for Data analytics as a career opportunity.

Go ahead and click the enroll button, and I'll see you in lesson 1!

Cheers

Start-Tech Academy

 

Requirements:

  • Just a PC with any web browser


What you'll learn:

  • Knowledge of all the essential SQL commands
  • Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
  • Become competent in using sorting and filtering commands in SQL
  • Master SQL's most popular string, mathematical and date-time functions
  • Enhance the performance of your Database by using Views and Indexes
  • Increase your efficiency by learning the best practices while writing SQL queries
  • Relevant theoretical concepts also covered so that you excel in BI Job interviews and Vivas
  • Solid understanding of SQL

Course curriculum

  • 1
    Introduction
  • 2
    Installation and getting started
    • 002 Installation
  • 3
    Case Study : Demo
    • 003 Case Study Part 1
    • 004 Case Study Part 2
  • 4
    Fundamental SQL statements
    • 005 CREATE
    • 006 Exercise 1 Create DB and Table
    • 008 INSERT
    • 009 Import data from File
    • 010 Exercise 2 Inserting and Importing
    • 011 SELECT statement
    • 012 SELECT DISTINCT
    • 013 WHERE
    • 014 Logical Operators
    • 015 Exercise 3 SELECT WHERE
    • 016 UPDATE
    • 017 DELETE
    • 018 ALTER
    • 019 Exercise 4 Updating Table
  • 5
    Restore and Back-up
    • 020 Restore and Back-up
    • 022 Exercise 5 Restore and Back-up
  • 6
    Selection commands: Filtering
    • 023 IN
    • 024 BETWEEN
    • 025 LIKE
    • 026 Exercise 6 In Like Between
  • 7
    Selection commands: Ordering
    • 027 Side Lecture Commenting in SQL
    • 028 ORDER BY
    • 029 LIMIT
    • 030 Exercise 7 Sorting
  • 8
    Alias
    • 031 AS
  • 9
    Aggregate Commands
    • 032 COUNT
    • 033 SUM
    • 034 AVERAGE
    • 035 MIN MAX
    • 036 Exercise 8 Aggregate functions
  • 10
    Group By Commands
    • 037 GROUP BY
    • 038 HAVING
    • 039 Exercise 9 Group By
  • 11
    Conditional Statement
    • 040 CASE WHEN
  • 12
    JOINS
    • 041 Introduction to Joins
    • 042 Inner Join
    • 043 Left Join
    • 044 Right Join
    • 045 Full Outer Join
    • 046 Cross Join
    • 047 Except
    • 048 Union
    • 049 Exercise 10 Joins
  • 13
    Subqueries
    • 050 Subqueries
    • 051 Exercise 11 Subqueries
  • 14
    Views and Indexes
    • 052 VIEWS
    • 053 INDEX
    • 054 Exercise 12 Views
  • 15
    String Functions
    • 055 LENGTH
    • 056 UPPER LOWER
    • 057 REPLACE
    • 058 TRIM LTRIM RTRIM
    • 059 CONCATENATION
    • 060 SUBSTRING
    • 061 LIST AGGREGATION
    • 062 Exercise 13 String Functions
  • 16
    Mathematical Functions
    • 063 CEIL FLOOR
    • 064 RANDOM
    • 065 SETSEED
    • 066 ROUND
    • 067 POWER
    • 068 Exercise 14 Mathematical Functions
  • 17
    Date-Time Functions
    • 069 CURRENT DATE TIME
    • 070 AGE
    • 071 EXTRACT
    • 072 Exercise 15 Date-time functions
  • 18
    PATTERN (STRING) MATCHING
    • 073 PATTERN MATCHING BASICS
    • 074 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
    • 075 Exercise 16 Pattern Matching
  • 19
    Data Type conversion functions
    • 076 Converting Numbers Date to String
    • 077 Converting String to Numbers Date
  • 20
    User Access Control Functions
    • 078 User Access Control
  • 21
    Bonus Section: Nail that Interview!
    • 079 Tablespace
    • 080 PRIMARY KEY FOREIGN KEY
    • 081 ACID compliance
    • 082 Truncate
  • 22
    Performance tuning tips
    • 083 TIP 1 (EXPLAIN)
    • 084 TIP 2
    • 085 TIP 3
    • 086 TIP 4 (VACCUM)
    • 087 TIP 5
    • 088 TIP 6 (STRING FUNCTIONS)
    • 089 TIP 7 (JOINS)
    • 090 TIP 8 (SCHEMAS)
  • 23
    Bonus Section : Database Basics
    • 091 What is SQL
    • 092 Tables and DBMS
    • 093 Types of SQL commands
    • 094 PostgreSQL

Meet your instructor!

Start-Tech Academy
A technology-based analytics education company


Founded by Abhishek Bansal and Pukhraj Parikh, Start-Tech Academy is a technology-based analytics education company and aims at bringing together the analytics companies and interested Learners. 

Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. 

Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in  MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.

Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Take this course today!

"SQL Masterclass: SQL for Data Analytics"

Bundle including this course!