2023 Complete SQL Bootcamp from Zero to Hero in SQL

Focused View

Surendra Varma Pericherla

4:15:22

80 View

01 - Introduction to SQL

001 Instructors Note.mp4

06:01

002 Working with online IDE to run SQL Queries.mp4

02:46

003 DBeaver Installation.mp4

01:05

004 Getting Started with DBeaver Tool.mp4

03:45

005 Connecting with Database in DBeaver Tool.mp4

01:57

006 Why SQL.mp4

02:36

02 - DDL Commands

001 Creating Tables.mp4

03:34

002 Solving Tasks in Creating Tables.mp4

02:08

003 Dropping, Truncating & Altering Tables.mp4

03:35

03 - DML Commands

001 INSERT Command.mp4

03:04

002 UPDATE Command.mp4

03:12

003 DELETE Command.mp4

03:28

04 - Constraints in SQL

001 Not NULL and Unique Constraints in SQL.mp4

05:45

002 Primary Key Constraints.mp4

07:59

003 Auto Increment.mp4

03:02

004 Super Key.mp4

02:28

005 Candidate Key.mp4

01:21

006 Composite Key.mp4

02:10

007 Foreign Key.mp4

03:07

05 - Data Querying

001 SELECT Command.mp4

04:25

002 WHERE Clause.mp4

02:15

003 LIKE Condition.mp4

01:54

004 Simple Queries BETWEEN NOT BETWEEN.mp4

02:53

005 Simple Queries IN NOT IN.mp4

02:01

006 Simple Queries ORDER BY clause.mp4

02:36

007 Simple Queries Aggregation.mp4

07:06

008 Simple Queries GROUP BY clause.mp4

04:41

009 Simple Queries HAVING clause.mp4

02:55

010 Hands-on working with Customer table.mp4

23:12

06 - Set Operations & Views in SQL

001 Set Operations with Examples.mp4

10:05

002 Union Operation.mp4

03:15

003 Intersect Operation.mp4

01:44

004 Creating a View.mp4

02:48

005 Updating a View.mp4

00:50

006 Deleting rows from Views.mp4

00:49

007 Dropping a view.mp4

00:34

07 - Working with Sub-Queries

001 Subquery with the SELECT Statement.mp4

02:35

002 Subquery with the UPDATE Statement.mp4

03:01

003 Subquery with the DELETE Statement.mp4

02:12

004 CASE Statement in SQL.mp4

02:43

005 Subquery Example.mp4

07:17

08 - Joins in SQL

001 Cross Join.mp4

02:14

002 Inner Join.mp4

03:01

003 Left Outer Join.mp4

02:17

004 Left Join Excluding Inner Join.mp4

01:31

005 Right Outer Join.mp4

01:26

006 Right Join Excluding Inner Join.mp4

01:40

007 Full Outer Join.mp4

01:56

008 Full Outer Excluding Inner Join.mp4

02:08

009 Solved Example Query #1.mp4

03:40

010 Solved Example Query #2.mp4

02:35

09 - Working with sailors database

001 Find sailor name whose rating is morethan 8.mp4

02:11

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

01:43

003 Find young sailor with rating as 10.mp4

01:18

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

03:38

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

05:03

006 Find the colors of boats reserved by Lubber.mp4

04:24

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

02:53

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

04:06

10 - Solved Examples in SQL Queries

001 Query-1.mp4

09:19

002 Query-2.mp4

02:27

003 Query-3.mp4

02:26

004 Query-4.mp4

01:58

005 Query-5.mp4

02:38

11 - Generating SQL Table structure from E-R Diagrams

001 E-R Diagrams.mp4

06:16

002 Types of Attributes.mp4

02:35

003 Cardinality Types.mp4

03:12

004 E-R Diagram to SQL table structure.mp4

07:03

005 Representing composite and multi-valued attributes in SQL Tables.mp4

06:07

12 - Assignments

001 Working with Real-Estate Database.mp4

07:27

13 - Final Test in SQL

14 - Bonus Lecture

001 Bonus Lecture.mp4

01:16

Description

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

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

Who is this for?

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.

What You Need to Know?

No Programming Experience Needed

More details

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 tool
Learn he basics of SQL syntax
Analyzing data using aggregate functions with GROUP BY commands
Running advanced queries with string operations and comparison operations
Learn to use logical operators to add logic flow to your SQL queries
Learn to create tables and databases with constraints on data entries
Learn common SQL JOIN commands
Learn 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!
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Surendra Varma Pericherla

Instructor's Courses

The name of the instructor is Surendra varma.He is a winner of BEST TEACHER award.He is a winner of Young Achiever award.He holds Bachelors degree in Computer Science & Masters degree in Computer science. He cracked toughest exams in computer science such as GATE & UGC-NET with flying colors. Also, he is a university topper during masters.He is currently Pursuing PhD from world's most reputed university Indian Institute of Sciences(IISC), Bangalore.He worked with various EdTech companies in India including Great Learning. He always received best feedback from his students. He has 14+ Years of experience in Teaching/research/Industry. He worked in various roles like Software Engineer, Associate professor, Researcher, Technical Trainer, Senior Technical Trainer, Technical head & Academic head. He has trained over 1,00,000 students in his career. His former students are currently working in MNC's such as Amazon, Infosys, Wipro, TCS, CTS, Accenture etc.He has given Guest lectures in top Universities/ colleges in India like IIIT’s, SRM University, VIT etc.He has given online training to students of various countries such as India, USA, Canada, UAE, Australia, UK, Germany etc.He ranked in Top 5% in Cracking the Amazon Coding Assessment.In Udemy, his students are scattered in 161 different countries."He loves education and educating others. His goal is to Provide quality of education to the students across the world."

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.