Introduction to Data Extraction Using SQL

[mitsumi]

Introduction to Data Extraction Using SQL
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.71 GB
Genre: eLearning Video | Duration: 41 lectures (4 hour, 53 mins) | Language: English

 Master the basics of querying databases using SQL - The World's most popular database language

What you'll 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

Requirements

    You should have access to internet
    You should access to a computer ,Laptop or mac

Description

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

Who this course is for:

    Beginner SQL Developers
    Beginners to SQL
    Beginner Database Administrator

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction