🎁 Airdrop Season 7 is LIVE - Answer Fun Questions to Earn $30K Prize Pool Rewards. JOIN NOW!
watching now
16 Students

Description

What Will You Learn?

  • Create your own database or interact with existing databases
  • Build a web app using Python and MySQL
  • Write complex SQL queries across multiple tables
  • Learn JOINS, How to use in real-world data
  • Write complex SQL queries across multiple tables

Requirements

  • No SQL and No previous programming language experience required, but it won't hurt :)
  • No idea about Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome.
  • All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.
  • NFT Certificate
  • 56 Lessons
  • Beginner
  • English
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 7h 50min of content, in total.

Section 2: SQL Environment Setup
33:54
Section 3: SQL Statement Basics
1:50:12
Overview of Challenges
03:43
SQL Statement Basic
15:31
SELECT Statement
09:19
SELECT DISTINCT
04:51
Column AS Statement
11:43
COUNT
11:03
SELECT WHERE Clause – One
04:36
SELECT WHERE Clause – Two
10:41
ORDER BY
07:41
LIMIT
08:35
BETWEEN
11:18
LIKE and ILIKE
11:11
Section 4: GROUP BY Statements
46:05
Overview of GROUP BY
05:39
Aggregation Function SUM()
08:52
Aggregation MIN() and MAX()
05:30
GROUP BY - One
09:13
GROUP BY – Two
11:46
HAVING
05:05
Section 5: Assessment Test 1
01:59
Overview Assessment Test 1
01:59
Assessment
Solution for an Assessment
Section 6: JOINS
1:02:45
Overview of JOINS
03:36
Introduction to JOINS
04:01
AS Statement
03:04
INNER Joins
18:30
Full Outer Joins
11:11
Left Outer Join
07:54
Right Outer Join
07:45
Union
06:44
Section 7: Advanced SQL Commands
1:13:18
Basic of Advanced SQL Commands
03:38
Timestamps
12:22
Extract from Timestamp
09:59
Mathematical Functions
11:39
String Functions
22:15
SubQuery
13:25
Section 8: Creating Database and Tables
1:37:21
Basic of Database and Tables
06:09
Data Types
10:30
Primary Keys and Foreign Keys
05:33
Create Table in SQL Script
13:12
Insert
10:47
Update
07:09
Delete
04:08
Alter Table
09:30
Drop Table
05:21
Check Constraint
07:54
NOT NULL Constraint
07:54
UNIQUE Constraint
09:14
Section 9: Databases and Tables
24:21
Overview of Databases and Tables
04:50
Creating a Database backup
12:28
Restoring a Database from backup
07:03

About the Instructor

About me
Sekhar Metla is a software engineer with 20 years of professional experience. He is the author of several online-selling courses with more than 30,000+ students in many countries. He has a Master of Science in Computer Applications as Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.

See All Instructor Courses

BitDegree platform reviews