Watch 2023 Complete SQL Bootcamp from Zero to Hero in SQL Free Online - Full Video Classroom | MJ Accedemy

Udemy – 2023 Complete SQL Bootcamp from Zero to Hero in SQL 2023-8

Download Course (Free)

Lecture 8/71

00:00/00:00

Lecture 8 of 71

Solving Tasks in Creating Tables

Download Course (Free)

Course Content

0 / 71 completed

Section 1: Introduction to SQL6 videos

Instructor's Note

38m

Working with online IDE to run SQL Queries

12m

DBeaver Installation

Getting Started with DBeaver Tool

19m

Connecting with Database in DBeaver Tool

Why SQL

Section 2: DDL Commands3 videos

Creating Tables

11m

Solving Tasks in Creating Tables

7mNow Playing

Dropping, Truncating & Altering Tables

Section 3: DML Commands3 videos

INSERT Command

UPDATE Command

DELETE Command

Section 4: Constraints in SQL7 videos

Not NULL and Unique Constraints in SQL

Primary Key Constraints

10m

Auto Increment

Super Key

Candidate Key

Composite Key

Foreign Key

Section 5: Data Querying10 videos

SELECT Command

WHERE Clause

LIKE Condition

Simple Queries BETWEEN NOT BETWEEN

Simple Queries IN NOT IN

Simple Queries ORDER BY clause

Simple Queries Aggregation

Simple Queries GROUP BY clause

Simple Queries HAVING clause

Hands-on working with Customer table

1h 30m

Section 6: Set Operations & Views in SQL7 videos

Set Operations with Examples

10m

Union Operation

11m

Intersect Operation

Creating a View

Updating a View

Deleting rows from Views

Dropping a view

Section 7: Working with Sub-Queries5 videos

Subquery with the SELECT Statement

Subquery with the UPDATE Statement

Subquery with the DELETE Statement

CASE Statement in SQL

Subquery Example

Section 8: Joins in SQL10 videos

Cross Join

Inner Join

11m

Left Outer Join

Left Join Excluding Inner Join

Right Outer Join

Right Join Excluding Inner Join

Full Outer Join

Full Outer Excluding Inner Join

Solved Example Query #1

Solved Example Query #2

Section 9: Working with sailors database8 videos

Find sailor name whose rating is morethan 8

Find sailor name and age whose age is in the range of 35 to 45

Find young sailor with rating as 10

Find the sids of sailors who have reserved a red boat

Find the names of sailors who have reserved a red boat

Find the colors of boats reserved by Lubber

Find the names of sailors who have reserved at least one boat

Find sid’s of all sailors who have a rating of 10 or reserved boat 104

Section 10: Solved Examples in SQL Queries5 videos

Query-1

23m

Query-2

12m

Query-3

Query-4

Query-5

Section 11: Generating SQL Table structure from E-R Diagrams5 videos

E-R Diagrams

Types of Attributes

Cardinality Types

E-R Diagram to SQL table structure

Representing composite and multi-valued attributes in SQL Tables

Section 12: Assignments1 videos

Working with Real-Estate Database

15m

Section 13: Bonus Lecture1 videos

Bonus Lecture

About this Lecture

Section: DDL Commands • Size: 15.47 MB • Duration: 7m

Course Summary

Course 2023 Complete SQL Bootcamp from Zero to Hero in SQL. Complete 2023 SQL Bootcamp Course from Zero to Champion in SQL. Learn how to use SQL quickly and effectively with this course! You will learn how to read and write complex queries in SQL. These skills are also applicable to any major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and more. Learning SQL is one of the fastest ways to improve your career prospects because it’s one of the most sought-after technical skills! In this course you will learn quickly and receive challenges and tests along the way to improve your understanding! In this course you will learn everything you need to become a SQL Pro! Contains: Get started with DBeaver, one of the world’s most popular SQL tools Learn the basics of SQL syntax Analyze data using aggregate functions with GROUP BY statements Run advanced queries with string operations and comparison operations Learn to use logical operators to add logical flow to your SQL queries Learn to create tables and databases with restrictions on data entry Learn common SQL JOIN commands Learn how to convert an ER chart to a SQL table. Who is this course for: Anyone interested in learning SQL to help their current job or find a new role. SQL is one of the most in-demand skills today. Anyone looking to answer complex business problems and generate reports using data. Business owners, people in sales, or people in marketing roles who are interested in better understanding company data. Developers looking to build applications (such as social networks, e-commerce sites) using SQL. SQL is an in-demand skill for business analysts, data scientists, and anyone who finds themselves working with data! Quickly upgrade your skill set and add SQL to your resume by signing up today!

Course Content

0 / 71 completed

Section 1: Introduction to SQL6 videos

Instructor's Note

38m

Working with online IDE to run SQL Queries

12m

DBeaver Installation

Getting Started with DBeaver Tool

19m

Connecting with Database in DBeaver Tool

Why SQL

Section 2: DDL Commands3 videos

Creating Tables

11m

Solving Tasks in Creating Tables

7mNow Playing

Dropping, Truncating & Altering Tables

Section 3: DML Commands3 videos

INSERT Command

UPDATE Command

DELETE Command

Section 4: Constraints in SQL7 videos

Not NULL and Unique Constraints in SQL

Primary Key Constraints

10m

Auto Increment

Super Key

Candidate Key

Composite Key

Foreign Key

Section 5: Data Querying10 videos

SELECT Command

WHERE Clause

LIKE Condition

Simple Queries BETWEEN NOT BETWEEN

Simple Queries IN NOT IN

Simple Queries ORDER BY clause

Simple Queries Aggregation

Simple Queries GROUP BY clause

Simple Queries HAVING clause

Hands-on working with Customer table

1h 30m

Section 6: Set Operations & Views in SQL7 videos

Set Operations with Examples

10m

Union Operation

11m

Intersect Operation

Creating a View

Updating a View

Deleting rows from Views

Dropping a view

Section 7: Working with Sub-Queries5 videos

Subquery with the SELECT Statement

Subquery with the UPDATE Statement

Subquery with the DELETE Statement

CASE Statement in SQL

Subquery Example

Section 8: Joins in SQL10 videos

Cross Join

Inner Join

11m

Left Outer Join

Left Join Excluding Inner Join

Right Outer Join

Right Join Excluding Inner Join

Full Outer Join

Full Outer Excluding Inner Join

Solved Example Query #1

Solved Example Query #2

Section 9: Working with sailors database8 videos

Find sailor name whose rating is morethan 8

Find sailor name and age whose age is in the range of 35 to 45

Find young sailor with rating as 10

Find the sids of sailors who have reserved a red boat

Find the names of sailors who have reserved a red boat

Find the colors of boats reserved by Lubber

Find the names of sailors who have reserved at least one boat

Find sid’s of all sailors who have a rating of 10 or reserved boat 104

Section 10: Solved Examples in SQL Queries5 videos

Query-1

23m

Query-2

12m

Query-3

Query-4

Query-5

Section 11: Generating SQL Table structure from E-R Diagrams5 videos

E-R Diagrams

Types of Attributes

Cardinality Types

E-R Diagram to SQL table structure

Representing composite and multi-valued attributes in SQL Tables

Section 12: Assignments1 videos

Working with Real-Estate Database

15m

Section 13: Bonus Lecture1 videos

Bonus Lecture