Learn SQL by Writing Queries

Learn SQL by Writing Queries, available at $44.99, has an average rating of 4.7, with 32 lectures, 3 quizzes, based on 61 reviews, and has 290 subscribers.

You will learn about Be able to write simple and complex SQL queries Be able to create a real working DB Be able to answer exam questions regarding SQL This course is ideal for individuals who are Students in DBMS Courses or People who are curious about querying a data base or Programmers who want to incorporate DB in their systems It is particularly useful for Students in DBMS Courses or People who are curious about querying a data base or Programmers who want to incorporate DB in their systems.

Enroll now: Learn SQL by Writing Queries

Summary

Title: Learn SQL by Writing Queries

Price: $44.99

Average Rating: 4.7

Number of Lectures: 32

Number of Quizzes: 3

Number of Published Lectures: 32

Number of Published Quizzes: 3

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will Learn

Be able to write simple and complex SQL queries
Be able to create a real working DB
Be able to answer exam questions regarding SQL

Who Should Attend

Students in DBMS Courses
People who are curious about querying a data base
Programmers who want to incorporate DB in their systems

Target Audiences

Students in DBMS Courses
People who are curious about querying a data base
Programmers who want to incorporate DB in their systems

SQL stands for Structured Query Language. It is used to retrieve data that is located in tables in a relational data-base.

SQL abilities are enormous, and the better you know it, the better your abilities to gain data and insights about it would be.

In this course I’ll teach you all the elements of SQL, and I’ll do it by writing queries. A lot of queries. I believe that the best way to learn SQL is to practice it with all kind of possible queries and manipulations, and that’s what I’ll do in this course.

Every lesson in this course contains example queries, exercise and all of them are available for you as source code to download.

In addition, I supply to you a full and functioning DB, with a lot of data, so you can try by your own your SQL skills.

Who should take this course?

If you learn an academic course on data bases, you probably have SQL part. This course can give you all the needed knowledge for answering SQL questions in University and colleges exams on SQL.

If you are a developer who wants to integrate data base in your application – this course is for you.

If you plane to design a system and you uncertain of how would you access the data and make use of it – this course is for you.

What you get from this course?

After completing the course you’ll be able to write any SQL query in order to retrieve any data you want from a data base.�

This course contains dozens of queries, from all levels and all topics.

This course also contains a real DB to make trials on.

This course contains a quiz for each section, quiz that would help you asses your advancement. �

An important note:

The course is still under construction so I’ll add the next sections in the next two weeks. You’ll get an announcement whenever a new section is added.�

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Where to Start?

Lecture 3: What is a DB

Lecture 4: Relational DB

Lecture 5: Foreign Keys

Chapter 2: Installations

Lecture 1: Install PostgerSQL

Lecture 2: Create a New Data-Base

Chapter 3: Loading the data for this Course

Lecture 1: Youtube Trending DB Overview

Lecture 2: Creating the Tables from Script

Lecture 3: Filling Data with Script

Chapter 4: Basic SQL

Lecture 1: SQL Introduction

Lecture 2: Select Query

Lecture 3: Running Queries on the Shell

Lecture 4: Where Clause

Lecture 5: Comparing Strings with 'like'

Lecture 6: Working with Dates and Time

Chapter 5: Joins

Lecture 1: Cartesian Product

Lecture 2: Cartesian Product in Select Query

Lecture 3: Join

Lecture 4: More Joins

Chapter 6: Aggregate Functions

Lecture 1: Aggregate Functions

Lecture 2: Aggregate Functions and Where clause

Chapter 7: Sets Operations

Lecture 1: Sets Operations

Lecture 2: Sets Operations with SQL Queries

Chapter 8: Nested Queries

Lecture 1: What is a Nested Query

Lecture 2: In and Not In Operators

Lecture 3: All and Any Operators

Lecture 4: Dependent Queries

Lecture 5: Exists and Not Exists Operators

Chapter 9: Group By

Lecture 1: Group By Introduction

Lecture 2: Group By

Lecture 3: Group By and Where Clause

Instructors

Shay Tavor
Software Engineer

Rating Distribution

1 stars: 2 votes
2 stars: 2 votes
3 stars: 7 votes
4 stars: 13 votes
5 stars: 37 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu