The Ultimate SQL Bootcamp : from A to Z Quickly
4.0 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,937 students enrolled

The Ultimate SQL Bootcamp : from A to Z Quickly

Do you want to learn a skill that can help you extra income per year? If so, then this course is for you!
4.0 (15 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,937 students enrolled
Created by Emin Yardim
Published 11/2019
English
Current price: $11.99 Original price: $19.99 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 51 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 53 lectures 01:06:11
+ Introduction
6 lectures 06:09
Introduction to SQL Tutorial
02:41
Types of Databases
02:19
SQL vs MySQL: What's the Difference?
00:19
+ Creating Databases and Tables
4 lectures 00:50
Creating Database
00:17
Creating Table Commands
00:20
+ Deleting -Exiting Databases and Tables
4 lectures 00:33
DELETE Records
00:04
DROP Database
00:04
DROP Tables
00:07
EXISTS Operators
00:17
+ SQL Statements Fundamentals
14 lectures 05:25
SELECT
00:08
SELECT DISTINCT
00:13
WHERE
00:06
VIEW
00:18
AND, OR and NOT
00:17
NULL
00:09
SELECT TOP
00:15
LIKE
00:28
ALTER
00:27
UNIQUE
00:43
DATE
00:18
PRIMARY KEY
00:39
FOREIGN KEY
00:54
+ GROUP BY Statements
4 lectures 00:50
GROUP BY
00:12
MIN() and MAX()
00:08
HAVING
00:17
+ Advanced SQL Commands
17 lectures 05:58
Constraints
00:48
JOINS
00:35
UNION ALL
00:14
NULL
00:22
ALIAS
00:21
INDEX
00:15
EXISTS
00:06
ANY and ALL
00:16
SELECT INTO
00:05
CASE
00:15
TRUNCATE TABLE
00:13
CLONE
00:51
DEFAULT
00:37
Requirements
  • No prior technical experience is required! All you need a computer!
  • No Database, SQL, or MySQL experience needed!
Description

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!



Who this course is for:
  • Anyone interested in learning more about SQL
  • 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
  • Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.
  • You can build a career in SQL
  • You will master the most practical knowledge in the short time
  • You can find easily a job as a SQL Developer or Database Administrator