SQL Certification Course: Basic to Advance by Geekster
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
SQL Certification Course: Basic to Advance
Related SQL Courses
Thank You!
Your review has been submitted successfully.