Introduction to Data Extraction Using SQL

Introduction to Data Extraction Using SQL, available at $39.99, has an average rating of 4, with 42 lectures, based on 39 reviews, and has 7734 subscribers.

You will learn about Install Database Server Query all data in a table Query data from specific table Query DISTINCT Data Query data with various types of operators Filter data Sort Data Query data using aggregate function Query data using table joins Query data with subqueries This course is ideal for individuals who are Beginner SQL Developers or Beginners to SQL or Beginner Database Administrator It is particularly useful for Beginner SQL Developers or Beginners to SQL or Beginner Database Administrator.

Enroll now: Introduction to Data Extraction Using SQL

Summary

Title: Introduction to Data Extraction Using SQL

Price: $39.99

Average Rating: 4

Number of Lectures: 42

Number of Published Lectures: 42

Number of Curriculum Items: 42

Number of Published Curriculum Objects: 42

Original Price: $94.99

Quality Status: approved

Status: Live

What You Will Learn

Install Database Server
Query all data in a table
Query data from specific table
Query DISTINCT Data
Query data with various types of operators
Filter data
Sort Data
Query data using aggregate function
Query data using table joins
Query data with subqueries

Who Should Attend

Beginner SQL Developers
Beginners to SQL
Beginner Database Administrator

Target Audiences

Beginner SQL Developers
Beginners to SQL
Beginner Database Administrator

This introductory beginners course will help you master the basics of using SQL to query and retrieve data from databases.

You will learn how to filter & sort data, customize output, & how you can query aggregated data from a database.

In this course, we will focus on ANSI(American National Standards Institute) SQL that works on

every database like Oracle, MySQL, Microsoft SQL Server, PostgreSQL etc.

SQL has become a requirement for most database related jobs that include:

Database Administrator -DBA , Data analyst, BI (Business Intelligence) developer, programmer, database programmer.

SQL will let you communicate with the database and work with your data.

What You will learn include:

Writing SQL SELECT Statements
Eliminating duplicate rows using DISTINCT
Restricting and Sorting Data
WHERE clause, wildcard like IN, LIKE
Analysing data using various SQL Operators
Sorting data using ORDER BY clause
Using LIMIT Operator
Querying Aggregated Data Using the Group Functions
AVG, COUNT, MIN, MAX…
Using GROUP BY and HAVING Clauses
Displaying Data From Multiple Tables
Analysing data Using Subqueries
Filtering data

Course Curriculum

Chapter 1: Database Setup

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is PostgreSQL

Lecture 4: Installation Requirements

Lecture 5: Download PostgreSQL

Lecture 6: Install PostgreSQL for Windows

Lecture 7: Verify Installation

Lecture 8: Connect to Database

Lecture 9: Install PostgreSQL on Macs

Lecture 10: Some notable companies using PostgreSQL

Lecture 11: Loading Sample Database

Lecture 12: Basic Database Concepts

Chapter 2: Querying Columns

Lecture 1: Querying all columns in a table

Lecture 2: Querying specific columns

Lecture 3: Querying DISTINCT

Lecture 4: Querying data with INTERSECT Operator

Lecture 5: Querying data with UNION Operator

Lecture 6: Querying data with UNION ALL Operator

Chapter 3: Filtering Data

Lecture 1: Filtering with WHERE

Lecture 2: Filtering with WHERE AND

Lecture 3: Filtering with WHERE AND OR

Lecture 4: Filtering with BETWEEN

Lecture 5: Filtering with IN

Lecture 6: Filtering with NOT

Lecture 7: Filtering with LIKE

Lecture 8: Filtering with LIMIT

Lecture 9: Using Subqueries

Chapter 4: Summarize data with Aggregate Functions

Lecture 1: What are Aggregate Functions

Lecture 2: AVG Aggregate Function

Lecture 3: COUNT Aggregate Function

Lecture 4: SUM Aggregate Function

Lecture 5: MIN Aggregate Function

Lecture 6: MAX Aggregate Function

Chapter 5: Sorting and Grouping Query Results

Lecture 1: Sorting Columns

Lecture 2: Grouping Data with GROUP BY clause

Lecture 3: Filter groups with HAVING clause

Chapter 6: Query Multiple Tables using Joins

Lecture 1: Query with INNER Join

Lecture 2: Query with LEFT Join

Lecture 3: Query with Full Outer Join

Lecture 4: Query with CROSS Join

Lecture 5: Query with Natural Join

Lecture 6: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 10 votes
4 stars: 11 votes
5 stars: 16 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