It’s Festive Season! Enjoy 30% Off

Use code FESTIVE30 at checkout
watching now
3 Students
93 Lessons
Beginner

What Will You 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

Curriculum

7h 23m
Section 1: Introduction
11:05
Section 3: Fundamental SQL statements
1:17:39
Exercise 1 Create DB and Table
01:25
INSERT
09:08
Import data from File
04:59
Exercise 2 Inserting and Importing
00:58
SELECT statement
03:46
SELECT DISTINCT
06:06
WHERE
04:02
Logical Operators
06:11
Exercise 3 SELECT WHERE
01:16
UPDATE
05:25
DELETE
04:12
ALTER
17:21
Exercise 4 Updating Table
01:04
Section 4: Restore and Back-up
08:30
Restore and Back-up
07:38
Exercise 5 Restore and Back-up
00:52
Section 5: Selection commands: Filtering
19:48
IN Query
04:24
BETWEEN
05:41
LIKE Query
08:52
Exercise 6 In Like Between
00:51
Section 6: Selection commands: Ordering
13:30
Side Lecture Commenting in SQL
01:21
ORDER BY
07:42
LIMIT
03:39
Exercise 7 Sorting
00:48
Section 7: Alias
03:33
AS Query
03:33
Section 8: Aggregate Commands
17:10
COUNT
05:14
SUM Query
03:25
AVERAGE
02:54
MIN MAX
04:18
Exercise 8 Aggregate functions
01:19
Section 9: Group By Commands
18:11
GROUP BY
11:53
HAVING
05:04
Exercise 9 Group By
01:14
Section 10: Conditional Statement
05:19
CASE WHEN
05:19
Section 11: JOINS
41:24
Introduction to Joins
02:26
Inner Join
08:06
Left Join
07:32
Right Join
06:27
Full Outer Join
04:59
Cross Join
04:22
Except
03:01
Union
03:13
Exercise 10 Joins
01:18
Section 12: Subqueries
15:56
Subqueries
14:35
Exercise 11 Subqueries
01:21
Section 13: Views and Indexes
14:49
VIEWS
07:22
INDEX
06:39
Exercise 12 Views
00:48
Section 14: String Functions
33:23
LENGTH
03:32
UPPER LOWER
02:11
REPLACE
04:14
TRIM LTRIM RTRIM
06:57
CONCATENATION
02:57
SUBSTRING
06:02
LIST AGGREGATION
05:02
Exercise 13 String Functions
02:28
Section 15: Mathematical Functions
19:19
CEIL FLOOR
03:34
RANDOM
05:07
SETSEED
04:12
ROUND
02:27
POWER
02:25
Exercise 14 Mathematical Functions
01:34
Section 16: Date-Time Functions
18:04
CURRENT DATE TIME
04:32
AGE (Date Time)
03:50
EXTRACT
08:18
Exercise 15 Date-time functions
01:24
Section 17: PATTERN (STRING) MATCHING
24:49
PATTERN MATCHING BASICS
07:45
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
15:21
Exercise 16 Pattern Matching
01:43
Section 18: Data Type conversion functions
16:46
Converting Numbers/ Date to String
10:53
Converting String to Numbers Date
05:53
Section 19: User Access Control Functions
13:42
User Access Control
13:42
Section 20: Bonus Section: Nail that Interview!
20:45
Tablespace
05:44
PRIMARY KEY FOREIGN KEY
05:10
ACID compliance
05:57
Truncate
03:54
Section 21: Performance tuning tips
27:02
TIP 1 (EXPLAIN)
11:27
TIP #2
01:18
TIP #3
02:33
TIP 4 (VACCUM)
00:35
TIP #5
02:00
TIP 6 (STRING FUNCTIONS)
02:20
TIP 7 (JOINS)
01:58
TIP 8 (SCHEMAS)
04:51
Section 22: Bonus Section : Database Basics
12:22
What is SQL
01:57
Tables and DBMS
03:10
Types of SQL commands
04:44
PostgreSQL
02:31

Description

Requirements

  • Just a PC with any web browser

About the Instructor

Reviews 3
Students 152
Courses 5

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.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo