Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

The Ultimate SQL Bootcamp 2023

via Udemy

Overview

Do you want to learn a skill that can help you extra income per year? If so, then this course is for you!

What you'll learn:
  • Learn how to code in SQL
  • The freedom to query anything you like from a database
  • Boost your resume by learning SQL an in-demand skill
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and Oracle and My SQL on their resume
  • Create your own database or interact with existing databases
  • Answer company performance or sales questions using data
  • Write complex SQL queries across multiple tables
  • Model real-world data and generate reports using SQL

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you.


SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL stands for Structured Query Language. This tutorial will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works.


This course is easy to understand

*********

We will start from the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.


In this course, you will:;

Section 1:

Lecture 1:Introduction to SQL Tutorial

Lecture 2:Relational Databases

Lecture 3:Types of Databases

Lecture 4:SQL vs MySQL: What's the Difference?

Lecture 5:Some of The Most Important SQL Commands

Lecture 6:Salaries for careers with SQL expertise

Section 2:Data Types and Operators

Lecture 7:SQL DATA TYPES

Lecture 8:OPERATORS IN SQL

Section 3:Installation DB

Lecture 9:Mysql Installation

Lecture 10:Oracle 18c Installation

Section 4:Creating Databases and Tables

Lecture 11:Creating Database

Lecture 12:Creating Table Commands

Lecture 13:INSERT INTO

Lecture 14:UPDATE

Section 5:Deleting -Exiting Databases and Tables

Lecture 15:DELETE Records

Lecture 16:DROP Database

Lecture 17:DROP Tables

Lecture 18:EXISTS Operators


Section 6:SQL Statements Fundamentals

Lecture 19:SELECT

Lecture 20:SELECT DISTINCT

Lecture 21:WHERE

Lecture 22:VIEW

Lecture 23:AND, OR and NOT

Lecture 24:NULL

Lecture 25:SELECT TOP

Lecture 26:LIKE

Lecture 27:ALTER

Lecture 28:UNIQUE

Lecture 29:PRIMARY KEY

Lecture 30:FOREIGN KEY

Lecture 31:CHECK

Section 7:GROUP BY Statements

Lecture 32:ORDER BY

Lecture 33:GROUP BY

Lecture 34:MIN() and MAX()

Lecture 35:HAVING

Section 8:Advanced SQL Commands

Lecture 36:DATES

Lecture 37:Constraints

Lecture 38:JOINS

Lecture 39:UNION

Lecture 40:UNION ALL

Lecture 41:NULL

Lecture 42:ALIAS

Lecture 43:INDEX

Lecture 44:EXISTS

Lecture 45:ANY and ALL

Lecture 46:SELECT INTO

Lecture 47:CASE

Lecture 48:SQL Comments

Lecture 49:TRUNCATE TABLE

Lecture 50:Wildcard

Lecture 51:CLONE

Lecture 52:DEFAULT


------------------------------------------------------------------------------------------------------

You'll Also Get:

✔ Lifetime Access to course updates

✔ Fast & Friendly Support in the Q&A section


Don't Miss Out!

Every second you wait is costing you valuable leads.

Go ahead and hit the "take Course" button to start your career today!


Thank you very much and have a wonderful day!



Taught by

Sure Academy

Reviews

3.4 rating at Udemy based on 27 ratings

Start your review of The Ultimate SQL Bootcamp 2023

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.