100 SQL Problem Scenario and Solutions – Volume 1

100 SQL Problem Scenario and Solutions – Volume 1, available at $19.99, has an average rating of 4.05, with 105 lectures, based on 31 reviews, and has 2670 subscribers.

You will learn about Perfect understanding on how to build and read simple to complex queries Be able to analyze business logic using queries This course is ideal for individuals who are Beginner to intermediate SQL developer It is particularly useful for Beginner to intermediate SQL developer.

Enroll now: 100 SQL Problem Scenario and Solutions – Volume 1

Summary

Title: 100 SQL Problem Scenario and Solutions – Volume 1

Price: $19.99

Average Rating: 4.05

Number of Lectures: 105

Number of Published Lectures: 105

Number of Curriculum Items: 105

Number of Published Curriculum Objects: 105

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

Perfect understanding on how to build and read simple to complex queries
Be able to analyze business logic using queries

Who Should Attend

Beginner to intermediate SQL developer

Target Audiences

Beginner to intermediate SQL developer

This course provides hands-on experience to enable participants to thrive in a working environment that benefits from SQL developer knowledge and skills.

Job scenarios are included to expose students to practical SQL developer experience. These lessons serve to increase confidence and experience to prepare students as an SQL developer.

Divided into several logical segments for easy learning, 100 SQL Problem Scenario and Solutions provides a platform for those who want to understand how to apply SQL to business logic. This course is designed to accelerate your SQL writing skills and shorten the learning curve.

I will continue to enhance this course with the objective being a comprehensive training and learning reference for aspiring SQL developers world-wide.

Thank you for making the decision to take 100 SQL Problem Scenario and Solutions.

What you’ll learn

Deep understanding on how to build and read simple to complex queries

Ability to analyze business logic using queries

Are there any course requirements or prerequisites?

Must have basic understanding of SQL

Be able to understand a select statement

Who this course is for:

Beginner to intermediate SQL developers

Course Curriculum

Chapter 1: COURSE SCHEMAS AND TABLES

Lecture 1: COURSE SCHEMAS AND TABLES

Chapter 2: COURSE REQUIREMENTS

Lecture 1: COURSE REQUIREMENTS

Chapter 3: ORACLE INSTALLATION

Lecture 1: ORACLE INSTALLATION

Chapter 4: SQL DEVELOPER

Lecture 1: SQL DEVELOPER

Chapter 5: POPULATING DATA FOR ZARA'S GROCERIES TASK

Lecture 1: ZARA'S GROCERIES DATA

Chapter 6: SELECT STATEMENT

Lecture 1: SELECT STATEMENT

Lecture 2: TABLE FAMILIARIZATION

Lecture 3: Where Clause

Lecture 4: STATEMENT STAGE ONE

Lecture 5: MAX, MIN AND AVG FUNCTIONS

Lecture 6: ALIAS

Lecture 7: CONCATENATION

Lecture 8: IN OPERATOR

Lecture 9: BETWEEN

Lecture 10: SUM

Lecture 11: ROUND FUNCTION

Lecture 12: NOT EQUALS

Lecture 13: FLOOR FUNCTION

Lecture 14: ORDER BY

Lecture 15: LENGTH FUNCTION

Lecture 16: LEFT AND RIGHT PAD

Lecture 17: SUBSTRING

Lecture 18: ADD_MONTH FUNCTION

Lecture 19: MONTHS_BETWEEN

Lecture 20: TO_CHAR

Lecture 21: NEXT_DAY

Lecture 22: NESTED SQL FUNCTIN

Lecture 23: AMPERSAND OPERATOR

Lecture 24: GROUP BY

Lecture 25: HAVING

Lecture 26: CASE

Lecture 27: JOIN

Lecture 28: SUBQUERY

Chapter 7: ZARA'S GROCERIES TASK 1 – 20

Lecture 1: ZARA'S GROCERIES TASK 1

Lecture 2: ZARA'S GROCERIES TASK 2

Lecture 3: ZARA'S GROCERIES TASK 3

Lecture 4: ZARA'S GROCERIES TASK 4

Lecture 5: ZARA'S GROCERIES TASK 5

Lecture 6: ZARA'S GROCERIES TASK 6

Lecture 7: ZARA'S GROCERIES TASK 7

Lecture 8: ZARA'S GROCERIES TASK 8

Lecture 9: ZARA'S GROCERIES TASK 9

Lecture 10: ZARA'S GROCERIES TASK 10

Lecture 11: ZARA'S GROCERIES TASK 11

Lecture 12: ZARA'S GROCERIES TASK 12

Lecture 13: ZARA'S GROCERIES TASK 13

Lecture 14: ZARA'S GROCERIES TASK 14

Lecture 15: ZARA'S GROCERIES TASK 15

Lecture 16: ZARA'S GROCERIES TASK 16

Lecture 17: ZARA'S GROCERIES TASK 17

Lecture 18: ZARA'S GROCERIES TASK 18

Lecture 19: ZARA'S GROCERIES TASK 19

Lecture 20: ZARA'S GROCERIES TASK 20

Chapter 8: UNLOCKING HR SCHEMA

Lecture 1: UNLOCKING HR SCHEMA

Chapter 9: HR SCHEMA TASK 1-30

Lecture 1: HR SCHEMA TASK 1

Lecture 2: HR SCHEMA TASK2

Lecture 3: HR SCHEMA TASK 3

Lecture 4: HR SCHEMA TASK 4

Lecture 5: HR SCHEMA TASK 5

Lecture 6: HR SCHEMA TASK 6

Lecture 7: HR SCHEMA TASK 7

Lecture 8: HR SCHEMA TASK 8

Lecture 9: HR SCHEMA TASK 9

Lecture 10: HR SCHEMA TASK 10

Lecture 11: HR SCHEMA TASK 11

Lecture 12: HR SCHEMA TASK 12

Lecture 13: HR SCHEMA TASK 13

Lecture 14: HR SCHEMA TASK 14

Lecture 15: HR SCHEMA TASK 15

Lecture 16: HR SCHEMA TASK 16

Lecture 17: HR SCHEMA TASK 17

Lecture 18: HR SCHEMA TASK 18

Lecture 19: HR SCHEMA TASK 19

Lecture 20: HR SCHEMA TASK 20

Lecture 21: HR SCHEMA TASK 21

Lecture 22: HR SCHEMA TASK 22

Lecture 23: HR SCHEMA TASK 23

Lecture 24: HR SCHEMA TASK 24

Lecture 25: HR SCHEMA TASK 25

Lecture 26: HR SCHEMA TASK 26

Lecture 27: HR SCHEMA TASK 27

Lecture 28: HR SCHEMA TASK 28

Lecture 29: HR SCHEMA TASK 29

Lecture 30: HR SCHEMA TASK 30

Chapter 10: POPULATING DATA FOR JOB SELECTION TASK

Lecture 1: DATA FOR JOB SELECTION TASK

Chapter 11: JOB SELECTION PROCESS TASK 1- 20

Lecture 1: JOB SELECTION PROCESS TASK 1

Lecture 2: JOB SELECTION PROCESS TASK 2

Lecture 3: JOB SELECTION PROCESS TASK 3

Lecture 4: JOB SELECTION PROCESS TASK 4

Instructors

Olalekan David-Banjo
IT Consultant at BookwormIT

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 4 votes
4 stars: 7 votes
5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu