Learn SQL concepts

Learn sql quickly from our course!

3.68 (131 reviews)
Udemy
platform
English
language
Databases
category
Learn SQL concepts
13,058
students
38 mins
content
Sep 2022
last update
$19.99
regular price

What you will learn

Become expert in sql

Master the fundamentals of relational databases

Design fast and efficient databases using the latest technologies

Learn and apply multiple database design patterns

Be comfortable putting SQL and PostgreSQL on their resume

Replicate real-world situations and query reports

Learn to analyse data

Description

In this course, you will:

  • Learn the ins and outs of SQL syntax

  • Generate reports using sales and user data

  • Analyze data using Aggregate Functions

  • Run complex queries using MySQL logical operators and string functions

  • Write all the common SQL joins

  • Work with large datasets containing thousands of entries

  • Build a web app using MySQL and NodeJS

  • Design and implement complex database schemas

  • Learn to navigate the treacherous world of storing dates and times

  • Clone the database structure of a photo sharing social network

  • Write Javascript code to generate fake data sets

  • And more!

This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning.This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.

I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.

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!

Content

Introduction

Introduction

Day 1

What is sql
Table basics
Selecting data
Creating tables

Day 2

Inserting values into a Table
Updating Records
Deleting Records
Drop a Table

Day 3

Aggregate Functions
GROUP BY clause
HAVING clause
ORDER BY clause

Day 4

Combining Conditions & Boolean Operators
IN & BETWEEN
Mathematical Functions
Joins

Reviews

Chirine
December 1, 2023
you said that in this course we will learn Work with large datasets containing thousands of entries Build a web app using MySQL and NodeJS Design and implement complex database schemas Learn to navigate the treacherous world of storing dates and times Clone the database structure of a photo sharing social network but no such thing was provided !!!
Gokuldas
June 21, 2023
This course is very basic information This course is just who want to get information about sql. This course you just get idea about sql.

Coupons

DateDiscountStatus
1/12/2023100% OFF
expired
3/2/2023100% OFF
expired
3/25/2023100% OFF
expired
4/5/2023100% OFF
expired
6/3/2023100% OFF
expired
7/7/2023100% OFF
expired
7/21/202350% OFF
expired
8/11/2023100% OFF
expired
9/2/2023100% OFF
expired
11/12/2023100% OFF
expired
3/19/2024100% OFF
expired
3/25/2024100% OFF
expired

Charts

Price

Learn SQL concepts - Price chart

Rating

Learn SQL concepts - Ratings chart

Enrollment distribution

Learn SQL concepts - Distribution chart
4808718
udemy ID
7/31/2022
course created date
9/29/2022
course indexed date
Bot
course submited by