Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

SQL : The hitch hikers guide to writing SQL queries (2016)

Posted By: ParRus
SQL : The hitch hikers guide to writing SQL queries (2016)

SQL : The hitch hikers guide to writing SQL queries (2016)
WEBRip | English | MP4 | 1920 x 1080 | AVC ~1394 kbps | 29.970 fps
AAC | 126 Kbps | 44.1 KHz | 2 channels | 3h 30mn | 3.03 GB
Genre: eLearning Video / Business, Data & Analytics

Get a head start with writing basic SQL before tackling advanced queries
Hi there,
Welcome to "The hitch hikers guide to writing SQL queries", this is a course that I am sure you will complete and learn a lot.

The course is aimed at Beginners to Intermediate levels.

It covers all the bases for you to get up to speed with writing SQL before you progress on to more advanced SQL for transforming and analysing data.

I will explain everything step by step and in detail so you get to know SQL very well.

The course uses SQLServer 2014 express, and we all know the popularity of SQL Server and the thousands of enterprises that use it.

Enjoy this course, contact me in the Q & A pages if you have any questions , this is a free course, but you still get the same support as you would if you purchased any of my other courses.

See you in the course.
Paul
Data Analyst and SQL Developer

What are the requirements?

No prior knowledge required
A Windows PC or equivalent as you will want to code/modify the sample queries

What am I going to get from this course?

Understand the structure of a SQL query
Write aggregation based queries
Understand joining tables in a query
Ready to learn more advanced SQL query techniques for data analysis and discovery
How to do backups and restores
Import raw data ready for analysis

What is the target audience?

Anyone looking to start using SQL in their day to day work
Newbies to SQL and relational databases
Graduates
Technical users connecting to database backends
Looking to start with foundation skills before getting into advanced SQL

also You can watch my other last: Programming-posts

General
Complete name : 019 Counting stuff using the Count function.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom
File size : 124 MiB
Duration : 11mn 17s
Overall bit rate mode : Variable
Overall bit rate : 1 528 Kbps
Writing application : Lavf57.41.100

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3
Format settings, CABAC : Yes
Format settings, ReFrames : 4 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 11mn 17s
Bit rate : 1 394 Kbps
Nominal bit rate : 3 870 Kbps
Width : 1 920 pixels
Height : 1 080 pixels
Display aspect ratio : 16:9
Frame rate mode : Variable
Frame rate : 29.970 fps
Minimum frame rate : 29.960 fps
Maximum frame rate : 29.970 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.022
Stream size : 113 MiB (91%)
Writing library : x264 core 148 r236 a01e339
Encoding settings : cabac=1 / ref=1 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=2 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=0 / me_range=16 / chroma_me=1 / trellis=0 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=0 / threads=34 / lookahead_threads=8 / 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=1 / keyint=90 / keyint_min=9 / scenecut=0 / intra_refresh=0 / rc_lookahead=10 / rc=2pass / mbtree=1 / bitrate=3870 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / cplxblur=20.0 / qblur=0.5 / vbv_maxrate=3870 / vbv_bufsize=3870 / 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 : 40
Duration : 11mn 17s
Bit rate mode : Variable
Bit rate : 126 Kbps
Maximum bit rate : 131 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 10.1 MiB (8%)
Screenshots

SQL : The hitch hikers guide to writing SQL queries (2016)

SQL : The hitch hikers guide to writing SQL queries (2016)

SQL : The hitch hikers guide to writing SQL queries (2016)

SQL : The hitch hikers guide to writing SQL queries (2016)

SQL : The hitch hikers guide to writing SQL queries (2016)

Exclusive eLearning Videos ParRus-blogadd to bookmarks

SQL : The hitch hikers guide to writing SQL queries (2016)