SQL – The Query Writing Bootcamp [2019]

SQL – The Query Writing Bootcamp [2019]
SQL – The Query Writing Bootcamp [2019]
English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 9.5 Hours | 5.63 GB

Master SQL and Become Job Ready as a SQL Developer by Working Hands-On Querying a Relational Database – [RDBMS]

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!
Table of Contents

Introduction
1 Introduction
2 ORACLE Live SQL – Registration
3 Lecture 3 Resources

Creating Table Relational Database in SQL
4 How to CREATE a Table in SQL
5 ALTER UPDATE DELETE in SQL
6 CREATE TABLE Book Challange
7 CREATE Book Table
8 CREATE TABLE Editor Challange
9 CREATE Editor Table
10 CREATE TABLE Rating Challange
11 CREATE Rating Table
12 How To Load The Database in ORACLE Live SQL
13 Section 1 Review CREATE Tables

SQL SELECT Statemet
14 SELECT Statement
15 SELECT FROM WHERE
16 Practice 1 Solutions
17 Comparison Operators
18 Practice 2 Comparison Operators Solutions
19 AND Operator
20 Practice 3 AND Operator Soultions
21 OR Condition
22 Practice 4 OR Condition Solutions
23 NOT Condition
24 Practice 5 NOT Condition Solutions
25 BETWEEN Condition
26 Practice 6 BETWEEN Condition Solutions
27 LIKE Condition
28 Practice 7 LIKE Condition Solutions
29 Section 2 The SELECT Statement Conclusion

Aggregate Functions Part 1
30 Aggregate Functions Introduction
31 AVERAGE
32 COUNT
33 MAX MIN
34 SUM
35 Practice 8 Solutions

Aggregate Functions Part 2 GROUP BY and ORDER BY
36 GROUP BY Aggregate Functions
37 Practice 9 Solutions
38 ORDER BY Aggregate Functions
39 ORDER BY Practice 10 Solutions
40 Aggregate Functions Conclusion

JOINS Aggregate Functions
41 Introduction to JOINs
42 JOIN Lesson One
43 Practice 11 JOINs Lesson One Solution
44 JOINs Lesson Two Practice 12
45 JOINs Lesson Three Practice 13
46 JOINs Lesson Three Practice 13 Solutions
47 JOINs Lesson Four Practice 14
48 JOINs Lesson Four Practice 14 Solution – Query 1
49 JOINs Lesson Four Practice 14 Solution – Query 2
50 JOINs Lesson Four Practice 14 Solution – Query 3 4
51 JOINs Lesson Six Practice 15
52 JOINs Lesson Six Practice 15 Solution – Query 1
53 JOINs Lesson Six Practice 15 Solution – Query 2
54 JOINs Lesson Six Practice 15 Solution – Query 3
55 JOINs Lesson Six Practice 15 Solution – Query 4
56 JOINs Lesson Six Practice 15 Solution – Query 5

Special Features in SQL
57 Aliases
58 Aliases 2
59 Concatenate
60 LENGTH
61 SYSDATE

Course Conclusion
62 Additional Practice
63 Thank You