2023 Complete SQL Bootcamp from Zero to Hero in SQL

Become an expert in SQL by learning through concept & Hands-on coding :)
2023 Complete SQL Bootcamp from Zero to Hero in SQL
File Size :
1.31 GB
Total length :
4h 16m

Category

Instructor

Surendra Varma Pericherla

Language

Last update

10/2023

Ratings

4.5/5

2023 Complete SQL Bootcamp from Zero to Hero in SQL

What you’ll learn

Use SQL to query a database
Be comfortable putting SQL on their resume
Replicate real-world situations and query reports
Use SQL to perform data analysis
Learn to perform GROUP BY statements
Model real-world data and generate reports using SQL
Learn Oracle SQL by Professionally Designed Content Step by Step!
Solve any SQL-related Problems by Yourself Creating Analytical Solutions!
Write, Read and Analyze Any SQL Queries Easily and Learn How to Play with Data!
Become a Job-Ready SQL Developer by Learning All the Skills You will Need!
Write complex SQL statements to query the database and gain critical insight on data
Transition from the Very Basics to a Point Where You can Effortlessly Work with Large SQL Queries
Learn Advanced Querying Techniques
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
Complete SQL statements that use aggregate functions
Using joins, return columns from multiple tables in the same query

2023 Complete SQL Bootcamp from Zero to Hero in SQL

Requirements

No Programming Experience Needed

Description

Learn how to use SQL quickly and effectively with this course!You’ll learn how to read and write complex queries in SQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you’ll 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! Including:Get started with DBeaver , one of the world’s most popular SQL toolLearn he basics of SQL syntaxAnalyzing data using aggregate functions with GROUP BY commandsRunning advanced queries with string operations and comparison operationsLearn to use logical operators to add logic flow to your SQL queriesLearn to create tables and databases with constraints on data entriesLearn common SQL JOIN commandsLearn how to convert ER Diagram into a SQL Table.Who this course is for:Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today’s most in-demand skills.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 understanding company data better.Developers who are looking to build applications (e.g. social network, ecommerce site) using SQL.SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!I’ll see you inside the course!Check out the free preview videos for more information!

Overview

Section 1: Introduction to SQL

Lecture 1 Instructor’s Note

Lecture 2 Working with online IDE to run SQL Queries

Lecture 3 DBeaver Installation

Lecture 4 Getting Started with DBeaver Tool

Lecture 5 Connecting with Database in DBeaver Tool

Lecture 6 Why SQL ?

Section 2: DDL Commands

Lecture 7 Creating Tables

Lecture 8 Solving Tasks in Creating Tables

Lecture 9 Dropping, Truncating & Altering Tables

Section 3: DML Commands

Lecture 10 INSERT Command

Lecture 11 UPDATE Command

Lecture 12 DELETE Command

Section 4: Constraints in SQL

Lecture 13 Not NULL and Unique Constraints in SQL

Lecture 14 Primary Key Constraints

Lecture 15 Auto Increment

Lecture 16 Super Key

Lecture 17 Candidate Key

Lecture 18 Composite Key

Lecture 19 Foreign Key

Section 5: Data Querying

Lecture 20 SELECT Command

Lecture 21 WHERE Clause

Lecture 22 LIKE Condition

Lecture 23 Simple Queries : BETWEEN/ NOT BETWEEN

Lecture 24 Simple Queries : IN/ NOT IN

Lecture 25 Simple Queries : ORDER BY clause

Lecture 26 Simple Queries : Aggregation

Lecture 27 Simple Queries : GROUP BY clause

Lecture 28 Simple Queries : HAVING clause

Lecture 29 Hands-on working with Customer table

Section 6: Set Operations & Views in SQL

Lecture 30 Set Operations with Examples

Lecture 31 Union Operation

Lecture 32 Intersect Operation

Lecture 33 Creating a View

Lecture 34 Updating a View

Lecture 35 Deleting rows from Views

Lecture 36 Dropping a view

Section 7: Working with Sub-Queries

Lecture 37 Subquery with the SELECT Statement

Lecture 38 Subquery with the UPDATE Statement

Lecture 39 Subquery with the DELETE Statement

Lecture 40 CASE Statement in SQL

Lecture 41 Subquery Example

Section 8: Joins in SQL

Lecture 42 Cross Join

Lecture 43 Inner Join

Lecture 44 Left Outer Join

Lecture 45 Left Join Excluding Inner Join

Lecture 46 Right Outer Join

Lecture 47 Right Join Excluding Inner Join

Lecture 48 Full Outer Join

Lecture 49 Full Outer Excluding Inner Join

Lecture 50 Solved Example Query #1

Lecture 51 Solved Example Query #2

Section 9: Working with sailors database

Lecture 52 Find sailor name whose rating is morethan 8

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

Lecture 54 Find young sailor with rating as 10

Lecture 55 Find the sids of sailors who have reserved a red boat.

Lecture 56 Find the names of sailors who have reserved a red boat.

Lecture 57 Find the colors of boats reserved by Lubber.

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

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

Section 10: Solved Examples in SQL Queries

Lecture 60 Query-1

Lecture 61 Query-2

Lecture 62 Query-3

Lecture 63 Query-4

Lecture 64 Query-5

Section 11: Generating SQL Table structure from E-R Diagrams

Lecture 65 E-R Diagrams

Lecture 66 Types of Attributes

Lecture 67 Cardinality Types

Lecture 68 E-R Diagram to SQL table structure

Lecture 69 Representing composite and multi-valued attributes in SQL Tables

Section 12: Assignments

Lecture 70 Working with Real-Estate Database

Section 13: Final Test in SQL

Section 14: Bonus Lecture

Lecture 71 Bonus Lecture

Anyone interested in learning SQL to help with their current job or to find a new role.,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 understanding company data better.,Developers who are looking to build applications (e.g. social network, ecommerce site) using SQL.

Course Information:

Udemy | English | 4h 16m | 1.31 GB
Created by: Surendra Varma Pericherla

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top