SQL Data Analyst - SQL , Microsoft SQL, PostgreSQL, MySQL
WEBRip | English | MP4 | 1280 x 720 | AVC ~553 Kbps | 30 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~10.5 hours | 3.32 GB
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~10.5 hours | 3.32 GB
Genre: eLearning Video / Business Analytics & Intelligence, SQL
Hands-On Data Analysis with SQLWhat you'll learn
Analyse and manipulate data
Create Database and Tables
Analyse data using aggregate functions
Analyse data using analytic functions
Analyse data using ranking functions
Analyse data using various operators
Analyse data using sub queries
Analyse data using views
Description
A SQL data analyst is a data scientist that uses the SQL language to interpret data.
This analysis is used to improve business information and provide new insights to managers.
SQL data analysts design scripts and programs to perform specific database functions and to analyse and maintain data.
Some SQL Data Analyst Duties and Responsibilities
Duties vary for SQL data analysts based on the specific needs of the hiring company and the amount of data being analysed. However, these core tasks are commonly associated with this job:
Integrate Data
SQL data analysts integrate data from multiple data sets into o:ne database system to streamline information.
Create Database Functions
SQL data analysts program specific database functions to create database triggers and design data tables.
Design Reports
After reviewing and analysing data, SQL data analysts design reports to show statistics and other information about specific database topics.
Clean Database
SQL data analysts remove dead data files and other irrelevant information to free up database space.
Write Scripts
SQL data analysts write scripts to analyse data and perform specific data queries.
Resolve Data Issues
SQL data analysts isolate and resolve issues with data and databases.
Add Data
SQL data analysts collect data from multiple sources and add it to the database.
We will be performing data analysis using SQL on relational databases like: MySQL, PostgreSQL and MS SQL Server.
A relational database is a type of database. It uses a structure that allows us to identify and access data in relation to another piece of data in the database. Often, data in a relational database is organized into tables. A relational database includes tables containing rows and columns. For example, a typical business order entry database would include a table that describes a customer with columns for name, address, phone number and so forth.
SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences. Millions of data points are being generated every minute. And raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.
Who this course is for:
Beginner Data Analyst
Beginner Data Scientist
also You can find my other useful: Development-posts
General
Complete name : 001 MySQL INNER Join.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 59.0 MiB
Duration : 11 min 57 s
Overall bit rate : 689 kb/s
Writing application : Lavf58.12.100
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, RefFrames : 4 frames
Format settings, GOP : M=4, N=60
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 11 min 57 s
Bit rate : 553 kb/s
Nominal bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.020
Stream size : 47.3 MiB (80%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=22 / lookahead_threads=3 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : mp4a-40-2
Duration : 11 min 57 s
Bit rate mode : Constant
Bit rate : 128 kb/s
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 kHz
Frame rate : 43.066 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 10.9 MiB (19%)
Default : Yes
Alternate group : 1
Complete name : 001 MySQL INNER Join.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 59.0 MiB
Duration : 11 min 57 s
Overall bit rate : 689 kb/s
Writing application : Lavf58.12.100
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, RefFrames : 4 frames
Format settings, GOP : M=4, N=60
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 11 min 57 s
Bit rate : 553 kb/s
Nominal bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.020
Stream size : 47.3 MiB (80%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=22 / lookahead_threads=3 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : mp4a-40-2
Duration : 11 min 57 s
Bit rate mode : Constant
Bit rate : 128 kb/s
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 kHz
Frame rate : 43.066 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 10.9 MiB (19%)
Default : Yes
Alternate group : 1
Screenshots
Exclusive eLearning Videos ParRus-blog ← add to bookmarks