SQL - The Query Writing Bootcamp [2019]
4.5 (90 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,565 students enrolled

SQL - The Query Writing Bootcamp [2019]

Master SQL and Become Job Ready as a SQL Developer by Working Hands-On Querying a Relational Database - [RDBMS]
4.5 (90 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,565 students enrolled
Created by Mark Stephenson
Last updated 6/2019
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 88 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • CREATE a Relational Database
  • Master SQL Programming Language
  • Write complex SQL statements to query a Relational Database
  • Prepare for Oracle SQL Certification Examination
  • Become Job Ready as a Database Designer / Developer
Course content
Expand all 63 lectures 09:41:07
+ Introduction
3 lectures 07:28

In this lecture we will review the outline of this course.

Preview 03:08

In this video we will go through the steps for registering for a free account on ORACLE Live SQL.

Preview 03:15
+ Creating Table & Relational Database in SQL
10 lectures 02:41:06

In this lesson we will CREATE our first sample Table in SQL.

Preview 32:08

In this lesson you will learn how to ALTER, UPDATE or DELTE a table.

ALTER, UPDATE, DELETE in SQL
11:44

CREATE Book Table Challange

CREATE TABLE: Book Challange
02:02

In this video we will CREATE the Book table, the first table of our relational database.

CREATE Book Table
30:25

CREATE Editor Table Challange

CREATE TABLE: Editor Challange
02:54

In this video we CREATE the Editor table. The second table in our relational database.

CREATE Editor Table
16:25

CREATE Rating Table Challange

CREATE TABLE: Rating Challange
04:57

In this video we create the Rating Table, the final table of our relational database. We connect the rating table to the Book and Editor table using the Primary Key and Foreign Key.

CREATE Rating Table
39:47

In this video, we learn how to load the database into the ORACLE Live SQL platform.

How To Load The Database in ORACLE Live SQL
11:06

In this video we review how to CREATE Tables in SQL and link them together using Primary and Foreign Keys.

Section 1 Review: CREATE Tables
09:38
+ SQL SELECT Statemet
16 lectures 02:32:47

Introduction to query writing and using the SELECT statment. 

SELECT Statement
02:54

In this lesson we begin writing queries using SELECT FROM WHERE. Pratice 1 included at the end.

SELECT FROM WHERE
14:30

Practice 1: Solutions

Practice 1: Solutions
08:58

In this lesson we will start using compariosn operators in the SELECT statement.

Comparison Operators
09:42

Practice 2: Comparison Operators Solution

Practice 2: Comparison Operators Solutions
05:26

In this lesson we begin writing queries using the AND operator.

AND Operator
14:14

Practice 3: AND Operator Soultions

Practice 3: AND Operator Soultions
15:43

In this lesson we will begin writing queries using the OR operator.

OR Condition
12:02

Practice 4: OR Operator Solutions

Practice 4: OR Condition Solutions
07:50

In this lesson we begin writing quesries using the NOT condition.

NOT Condition
10:56

Practice 5: NOT Operator Solutions

Practice 5: NOT Condition Solutions
06:15

In this lesson we begin writing queries using the BETWEEN condition.

BETWEEN Condition
07:20

Practice 6: BETWEEN Operator Solutions

Practice 6: BETWEEN Condition Solutions
10:58

In this lesson we begin writing queries using the LIKE condition.

LIKE Condition
12:32

Practice 7: LIKE Operator Solutions

Practice 7: LIKE Condition Solutions
12:12

Section 2: The SELECT Statement Conclusion

Section 2: The SELECT Statement Conclusion
01:15
+ Aggregate Functions Part 1
6 lectures 47:45

Introduction to Aggregate Functions.

Aggregate Functions Introduction
01:53

In this lesson we learn how to use AVG in SQL to find the average of a value.

AVERAGE
07:27

In this lesson we learn how to use COUNT to find the total of a value.

COUNT
05:58

In this lesson we will learn how to find the MAX & MIN of a value.

MAX & MIN
04:05

In this lesson we will learn how to find the SUM of a value.

SUM
07:57
Practice 8: Solutions
20:25
+ Aggregate Functions Part 2: GROUP BY and ORDER BY
5 lectures 49:31

In this lesson we will being writing aggregate functions including the GROUP BY statement.

GROUP BY: Aggregate Functions
13:16

GROUP BY: Practice 9 Solutions

Practice 9: Solutions
10:04

In this lesson we will being writing aggregate functions including the ORDER BY statement.

ORDER BY: Aggregate Functions
07:46

ORDER BY: Practice 10 Solutions

ORDER BY: Practice 10 Solutions
17:11
Aggregate Functions Conclusion
01:14
+ JOINS: Aggregate Functions
16 lectures 02:13:23

This video is an introduction to JOINS and the different types we can use to retrieve data from tow or more tables at a  time.

Introduction to JOIN's
12:13

In this video we begin writing queries using JOIN's.

JOIN Lesson One
15:59

Practice 11: JOIN's Lesson One Solution

Practice 11: JOIN's Lesson One Solution
08:05

JOIN's Lesson Two: Practice 12 and Solutions.

JOIN's Lesson Two: Practice 12
09:56

JOIN's Lesson Three: Practice 13

JOIN's Lesson Three: Practice 13
18:46

JOIN's Lesson Three: Practice 13 Solutions

JOIN's Lesson Three: Practice 13 Solutions
09:43

JOIN's Lesson Four: Practice 14

JOIN's Lesson Four: Practice 14
01:22

JOIN's Lesson Four: Practice 14 Solution - Query 1

JOIN's Lesson Four: Practice 14 Solution - Query 1
05:01

JOIN's Lesson Four: Practice 14 Solution - Query 2

JOIN's Lesson Four: Practice 14 Solution - Query 2
06:44

JOIN's Lesson Four: Practice 14 Solution - Query 3 and 4.

JOIN's Lesson Four: Practice 14 Solution - Query 3 & 4
09:42

JOIN's Lesson Six: Practice 15

JOIN's Lesson Six: Practice 15
01:56

JOIN's Lesson Six: Practice 15 Solution - Query 1

JOIN's Lesson Six: Practice 15 Solution - Query 1
04:19

JOIN's Lesson Six: Practice 15 Solution - Query 2

JOIN's Lesson Six: Practice 15 Solution - Query 2
06:41

JOIN's Lesson Six: Practice 15 Solution - Query 3

JOIN's Lesson Six: Practice 15 Solution - Query 3
06:32

JOIN's Lesson Six: Practice 15 Solution - Query 4

JOIN's Lesson Six: Practice 15 Solution - Query 4
08:30

JOIN's Lesson Six: Practice 15 Solution - Query 5

JOIN's Lesson Six: Practice 15 Solution - Query 5
07:54
+ Special Features in SQL
5 lectures 22:19

In this video we learn how to use alias in our queries.

Aliases
04:31

More practice using ALIASES.

Aliases 2
05:17

In this lesson we learn how to use the concatenate 2 strings.

Concatenate
04:19

In this lesson we learn how to use the LENGTH function.

LENGTH
05:19

In this lesson we learn how to use SYSDATE. Please read the article at the provided link.

SYSDATE
02:53
+ Course Conclusion
2 lectures 06:48

In this video, I provided you with information on how to access more sql and database practice provided by Oracle Live SQL.

Additional Practice
05:17

Thank you for enrolling and completing this intro course to SQL and Relational Databases with me.

Thank You!
01:31
Requirements
  • Internet access
  • No prerequisites needed for this course
Description

In this course you will learn SQL by working hands on with a Relational Database - [RDBMS]. At the end of this course you will know how to CREATE Tables in a Relational Database [RDBMS], using PRIMARY and FOREIGN Key’s. You will also know how to modify an existing database, to either ALTER or UPDATE the information.

This is a SQL programming course with extensive training and practice exercises. The objective of this course is to teach you SQL, so you are confident and prepared to become a skillful SQL Developer from day one!

  • CREATE a Relation Database Using: Tables, PRIMARY KEYS and FOREIGN KEYS

  • INSERT Data into Tables

  • UPDATE and ALTER Tables

  • RETRIEVE Data from a Relational Database using SQL

  • AGGREGATE Functions

  • JOINS

  • PRACTICE Questions in Every Lesson & Hands On Examples

  • MASTER The SQL Language

  • NO Software Download Required!

  • Become Job Ready as a SQL Developer!


Who this course is for:
  • Anyone looking to learn SQL and gain practice reading and writing queries within a relational database or pursuing a career as a: SQL Developer, Database Designer, Data Science, or Database Administrator.