2023 Complete SQL Bootcamp from Zero to Hero in SQL

سرفصل های دوره

Become an expert in SQL by learning through concept & Hands-on coding :)

01 - Introduction to SQL

001 Instructors Note

002 Working with online IDE to run SQL Queries

003 DBeaver Installation

004 Getting Started with DBeaver Tool

005 Connecting with Database in DBeaver Tool

006 Why SQL

02 - DDL Commands

001 Creating Tables

002 Solving Tasks in Creating Tables

003 Dropping, Truncating & Altering Tables

03 - DML Commands

001 INSERT Command

002 UPDATE Command

003 DELETE Command

04 - Constraints in SQL

001 Not NULL and Unique Constraints in SQL

002 Primary Key Constraints

003 Auto Increment

004 Super Key

005 Candidate Key

006 Composite Key

007 Foreign Key

05 - Data Querying

001 SELECT Command

002 WHERE Clause

003 LIKE Condition

004 Simple Queries BETWEEN NOT BETWEEN

005 Simple Queries IN NOT IN

006 Simple Queries ORDER BY clause

007 Simple Queries Aggregation

008 Simple Queries GROUP BY clause

009 Simple Queries HAVING clause

010 Hands-on working with Customer table

06 - Set Operations & Views in SQL

001 Set Operations with Examples

002 Union Operation

003 Intersect Operation

004 Creating a View

005 Updating a View

006 Deleting rows from Views

007 Dropping a view

07 - Working with Sub-Queries

001 Subquery with the SELECT Statement

002 Subquery with the UPDATE Statement

003 Subquery with the DELETE Statement

004 CASE Statement in SQL

005 Subquery Example

08 - Joins in SQL

001 Cross Join

002 Inner Join

003 Left Outer Join

004 Left Join Excluding Inner Join

005 Right Outer Join

006 Right Join Excluding Inner Join

007 Full Outer Join

008 Full Outer Excluding Inner Join

009 Solved Example Query #1

010 Solved Example Query #2

09 - Working with sailors database

001 Find sailor name whose rating is morethan 8

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

003 Find young sailor with rating as 10

004 Find the sids of sailors who have reserved a red boat

005 Find the names of sailors who have reserved a red boat

006 Find the colors of boats reserved by Lubber

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

008 Find sids of all sailors who have a rating of 10 or reserved boat 104

10 - Solved Examples in SQL Queries

001 Query-1

002 Query-2

003 Query-3

004 Query-4

005 Query-5

11 - Generating SQL Table structure from E-R Diagrams

001 E-R Diagrams

002 Types of Attributes

003 Cardinality Types

004 E-R Diagram to SQL table structure

005 Representing composite and multi-valued attributes in SQL Tables

12 - Assignments

001 Working with Real-Estate Database

13 - Final Test in SQL

14 - Bonus Lecture

001 Bonus Lecture

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy