2024 Complete SQL Bootcamp from Zero to Hero in SQL
- Offered byUDEMY
2024 Complete SQL Bootcamp from Zero to Hero in SQL at UDEMY Overview
Duration | 5 hours |
Total fee | ₹399 |
Mode of learning | Online |
Credential | Certificate |
2024 Complete SQL Bootcamp from Zero to Hero in SQL at UDEMY Highlights
- 30-Day Money-Back Guarantee
- Certificate of completion
- Full lifetime access
- Learn from 1 practise test and 2 coding exercisess
2024 Complete SQL Bootcamp from Zero to Hero in SQL at UDEMY Course details
- 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
- 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!
2024 Complete SQL Bootcamp from Zero to Hero in SQL at UDEMY Curriculum
Introduction to SQL
Instructor's Note
Working with online IDE to run SQL Queries
DBeaver Installation
Getting Started with DBeaver Tool
Connecting with Database in DBeaver Tool
Why SQL ?
DDL Commands
Creating Tables
Solving Tasks in Creating Tables
Dropping, Truncating & Altering Tables
Quiz on DDL Commands
DML Commands
INSERT Command
UPDATE Command
DELETE Command
Quiz on DML Commands
Assignment on DML Commands
Constraints in SQL
Not NULL and Unique Constraints in SQL
Primary Key Constraints
Auto Increment
Super Key
Candidate Key
Composite Key
Foreign Key
Create Students table with Constraints
Data Querying
SELECT Command
WHERE Clause
Working with Bakery items table
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
Quiz on Data Querying Language
Practice Task-1 on Data Querying
Practice Task-2 on Data Querying
Practice Task-3 on Data Querying
Set Operations & Views in SQL
Set Operations with Examples
Union Operation
Intersect Operation
Creating a View
Updating a View
Deleting rows from Views
Dropping a view
Practice Task-1 on Set-Operations
Working with Sub-Queries
Subquery with the SELECT Statement
Subquery with the UPDATE Statement
Subquery with the DELETE Statement
CASE Statement in SQL
Subquery Example
Joins in SQL
Cross Join
Inner Join
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
Quiz on Join Operations
Practice task-1 on Joins in SQL
Practice task-2 on Joins in SQL
Working with sailors database
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
Practice Task-1 on Sailors Database
Solved Examples in SQL Queries
Query-1
Query-2
Query-3
Query-4
Query-5
Generating SQL Table structure from E-R Diagrams
E-R Diagrams
Types of Attributes
Cardinality Types
E-R Diagram to SQL table structure
Representing composite and multi-valued attributes in SQL Tables
Assignments
Working with Real-Estate Database
Assignment : Teacher Database
Assignment : Airline Flight Information Database
Assignment : Employee Works in Department
Assignment : Works On Database
Final Assignment
Final Test in SQL
Exam in SQL
Bonus Lecture
Bonus Lecture
2024 Complete SQL Bootcamp from Zero to Hero in SQL at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?