SQL Masterclass: SQL for Data Analytics
Created by Abhishek And Pukhraj, Last Updated 26-Oct-2019, Language:English
SQL Masterclass: SQL for Data Analytics
SQL course covering basic to advanced SQL topics for SQL Database ( PostgreSQL ). Elucidates SQL Database for beginners
Created by Abhishek And Pukhraj, Last Updated 26-Oct-2019, Language:English
What Will I Get ?
- 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
Requirements
- Just a PC with any web browser
Description
6 Reasons why you should choose this SQL course
Carefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businesses
Comprehensive - covers basics, advanced SQL statements, interview tips and performance tuning tips as well
Business related examples and case studies
Ample practice exercises because SQL requires practice
Downloadable resources
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.
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.
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.
Who this course is for:
- Working Professionals beginning their Data journey
- Anyone curious to master SQL from beginner to Advanced in short span of time
- Students about to join their first corporate job
Course Content
-
Introduction
1 Lectures 00:04:38-
Course Overview
Preview00:04:38
-
-
Installation and getting started
1 Lectures 00:06:24-
Installation
Preview00:06:24
-
-
Case Study : Demo
3 Lectures 00:10:44-
Course Resources
-
Case Study Part 1
Preview00:04:27 -
Case Study Part 2
Preview00:06:17
-
-
Fundamental SQL statements
14 Lectures 01:17:31-
CREATE
Preview00:11:46 -
Exercise 1: Create DB and Table
00:01:24 -
INSERT
00:09:07 -
Import data from File
00:04:59 -
Exercise 2: Inserting and Importing
00:00:57 -
SELECT statement
00:03:45 -
SELECT DISTINCT
00:06:05 -
WHERE
00:04:02 -
Logical Operators
00:06:10 -
Exercise 3: SELECT & WHERE
00:01:16 -
UPDATE
00:05:25 -
DELETE
00:04:11 -
ALTER
00:17:21 -
Exercise 4: Updating Table
00:01:03
-
-
Restore and Back-up
2 Lectures 00:08:29-
Restore and Back-up
00:07:38 -
Exercise 5: Restore and Back-up
00:00:51
-
-
Selection commands: Filtering
4 Lectures 00:19:47-
IN
00:04:24 -
BETWEEN
00:05:40 -
LIKE
00:08:52 -
Exercise 6: In, Like & Between
00:00:51
-
-
Selection commands: Ordering
4 Lectures 00:13:27-
Side Lecture: Commenting in SQL
00:01:20 -
ORDER BY
00:07:42 -
LIMIT
00:03:38 -
Exercise 7: Sorting
00:00:47
-
-
Alias
1 Lectures 00:03:33-
AS
00:03:33
-
-
Aggregate Commands
5 Lectures 00:17:06-
COUNT
00:05:13 -
SUM
00:03:24 -
AVERAGE
00:02:53 -
MIN & MAX
00:04:17 -
Exercise 8: Aggregate functions
00:01:19
-
-
Group By Commands
3 Lectures 00:18:09-
GROUP BY
00:11:52 -
HAVING
00:05:04 -
Exercise 9: Group By
00:01:13
-
-
Conditional Statement
1 Lectures 00:05:18-
CASE WHEN
00:05:18
-
-
Joins
9 Lectures 00:41:20-
Introduction to Joins
00:02:25 -
Inner Join
00:08:05 -
Left Join
00:07:32 -
Right Join
00:06:27 -
Full Outer Join
00:04:59 -
Cross Join
00:04:21 -
Except
00:03:00 -
Union
00:03:13 -
Exercise 10: Joins
00:01:18
-
-
Subqueries
2 Lectures 00:15:56-
Subqueries
00:14:35 -
Exercise 11: Subqueries
00:01:21
-
-
Views and Indexes
3 Lectures 00:14:47-
VIEWS
00:07:21 -
INDEXES
00:06:39 -
Exercise 12: Views
00:00:47
-
-
String Functions
8 Lectures 00:33:15-
LENGTH
00:03:31 -
UPPER LOWER
00:02:10 -
REPLACE
00:04:13 -
TRIM, LTRIM, RTRIM
00:06:56 -
CONCATENATION
00:02:56 -
SUBSTRING
00:06:01 -
LIST AGGREGATION
00:05:01 -
Exercise 13: String Functions
00:02:27
-
-
Mathematical Functions
6 Lectures 00:19:16-
CEIL & FLOOR
00:03:34 -
RANDOM
00:05:06 -
SETSEED
00:04:11 -
ROUND
00:02:27 -
POWER
00:02:25 -
Exercise 14: Mathematical Functions
00:01:33
-
-
Date-Time Functions
4 Lectures 00:18:01-
CURRENT DATE & TIME
00:04:31 -
AGE
00:03:50 -
EXTRACT
00:08:17 -
Exercise 15: Date-time functions
00:01:23
-
-
PATTERN (STRING) MATCHING
3 Lectures 00:24:47-
PATTERN MATCHING BASICS
00:07:44 -
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
00:15:21 -
Exercise 16: Pattern Matching
00:01:42
-
-
Data Type conversion functions
2 Lectures 00:16:45-
Converting Numbers/ Date to String
00:10:52 -
Converting String to Numbers/ Date
00:05:53
-
-
User Access Control Functions
1 Lectures 00:13:41-
User Access Control
00:13:41
-
-
Bonus Section: Nail that Interview!
4 Lectures 00:20:44-
Tablespace
00:05:44 -
PRIMARY KEY & FOREIGN KEY
00:05:09 -
ACID compliance
00:05:57 -
Truncate
00:03:54
-
-
Performance tuning tips
8 Lectures 00:26:56-
TIP 1 (EXPLAIN)
00:11:26 -
TIP 2
00:01:17 -
TIP 3
00:02:32 -
TIP 4 (VACCUM)
00:00:34 -
TIP 5
00:01:59 -
TIP 6 (STRING FUNCTIONS)
00:02:20 -
TIP 7 (JOINS)
00:01:57 -
TIP 8 (SCHEMAS)
00:04:51
-
-
Bonus Section : Database Basics
4 Lectures 00:12:20-
What is SQL?
00:01:56 -
Tables and DBMS
00:03:10 -
Types of SQL commands
00:04:44 -
PostgreSQL
00:02:30
-
-
Attachement Files
1 Lectures-
Attachement Files
-
Abhishek And Pukhraj
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.
Founded by Abhishek Bansal and Pukhraj Parikh.
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.
