Course Highlights
  • Sql basics
  • CRUD
  • Functions
  • String functions
  • Selection Refining
  • Aggregate Functions
  • Revisiting Data Type
  • Logical Operator
Skills you will learn!
Curriculum

4 Topics
Roadmap Of Our Sql Course
Glimpse of SQL
Introduction To SQL
Introduction To SQL NOTES

7 Topics
Overview of Goorm IDE (Complete Tour)
Creating And Dropping Database
Creating And Dropping Table
Inserting Data into Tables
Insertion Challenge Solution
Null / Not Null Default Primary Key
SQL Basics

6 Topics
CRUD PART 1 (CREATE)
CRUD PART 2 (READ)
CRUD PART 3 (UPDATE)
CRUD PART 4 (DELETE)
CRUD CHALLENGES WITH SOLUTION
CRUD

10 Topics
INTRO TO STRING FUNCTION
STRING FUNCTION - CONCAT
STRING FUNCTION - CONCAT_WS
STRING FUNCTION - SUBSTRING
STRING FUNCTION - REPLACE
STRING FUNCTION - REVERSE
STRING FUNCTION - CHAR_LENGTH
STRING FUNCTION - UPPER / LOWER
STRING FUNCTION CHALLENGES WITH SOLUTION
STRING FUNCTION IN SQL

6 Topics
SELECTION REFINING - DISTINCT
SELECTION REFINING - ORDER BY
SELECTION REFINING - LIMIT
SELECTION REFINING - LIKE
SELECTION REFINING CHALLENGES WITH SOLUTION
SELECTION REFINING

8 Topics
AGGREGATE FUNCTION - COUNT
AGGREGATE FUNCTION - MIN/MAX
AGGREGATE FUNCTION - SUBQUERY
AGGREGATE FUNCTION - MIN/MAX WITH GROUP BY
AGGREGATE FUNCTION - SUM AND SUM WITH GROUP BY
AGGREGATE FUNCTION - AVG AND AVG WITH GROUP BY
AGGREGATE FUNCTION - CHALLENGES WITH SOLUTION
AGGREGATE FUNCTION

9 Topics
REVISITING DATA TYPES - CHAR VS VARCHAR
REVISITING DATATYPES - DECIMAL(MD)
REVISITING DATATYPES - FLOAT AND DOUBLE
REVISITING DATATYPES - DATE TIME
REVISITING DATATYPES - FORMATTING DATES
REVISITING DATATYPES - DATE MATH
REVISITING DATATYPES - TIMESTAMP
REVISITING DATATYPES CHALLENGES
REVISITING DATA TYPES NOTES

12 Topics
INTRO TO LOGICAL OPERATORS
LOGICAL OPERATORS - NOT EQUAL
LOGICAL OPERATORS - NOT LIKE
LOGICAL OPERATORS - GREATER THAN
LOGICAL OPERATORS - LESS THAN
LOGICAL OPERATORS-'AND &&'
LOGICAL OPERATORS - 'OR II'
LOGICAL OPERATORS - BETWEEN
LOGICAL OPERATORS - IN / NOT IN
LOGICAL OPERATORS - CASE
LOGICAL OPERATORS CHALLENGES
LOGICAL OPERATORS NOTES

8 Topics
INTRO TO RELATIONSHIP
1:M RELATIONSHIP - (FOREIGN KEYS)
1:M RELATIONSHIP - INNER JOIN
1:M RELATIONSHIP - LEFT JOIN
1:M RELATIONSHIP - RIGHT JOIN
1:M RELATIONSHIP CHALLENGES (PART 1)
1:M RELATIONSHIP CHALLENGES (PART 2)
INTRO TO RELATIONSHIP NOTES

10 Topics
INTRO TO MANY TO MANY RELATIONSHIP
M:M RELATIONSHIP - INSERTING DATA
M:M RELATIONSHIP - CHALLENGE 1
M:M RELATIONSHIP - CHALLENGE 2
M:M RELATIONSHIP - CHALLENGE 3
M:M RELATIONSHIP - CHALLENGE 4
M:M RELATIONSHIP - CHALLENGE 5
M:M RELATIONSHIP - CHALLENGE 6
M:M RELATIONSHIP - CHALLENGE 7
MANY TO MANY RELATIONSHIP

  Write a Review

SQL Certification Course: Basic to Advance

Go to Free Course