LinkedIn Learning - Intermediate SQL Data Reporting and Analysis
Language: English | Size:428.12 MB
Genre:eLearning

Files Included :

01 - Learn hands-on to extract, manipulate, edit, and delete real data.mp4 (3.36 MB)
MP4
02 - Who this course is for.mp4 (1.29 MB)
MP4
03 - What can you do with intermediate SQL.mp4 (2.77 MB)
MP4
01 - Get familiar with phpMyAdmin.mp4 (9.06 MB)
MP4
02 - Understand the demo database.mp4 (8.99 MB)
MP4
01 - The basic SELECT query.mp4 (6.64 MB)
MP4
02 - Aggregated results with GROUP BY.mp4 (6.86 MB)
MP4
03 - Wildcards and aliases.mp4 (22.82 MB)
MP4
04 - Merging tables with JOIN.mp4 (8.54 MB)
MP4
05 - Use string functions.mp4 (26.32 MB)
MP4
06 - Use number functions with grouped data.mp4 (22.91 MB)
MP4
07 - Use date functions.mp4 (15.56 MB)
MP4
08 - Challenge Report average cost by staff.mp4 (1.65 MB)
MP4
09 - Solution Report average cost by staff.mp4 (6.37 MB)
MP4
01 - UPDATE fields in a table.mp4 (20.78 MB)
MP4
02 - Common issues with the UPDATE command.mp4 (28.51 MB)
MP4
03 - Automating your query creation.mp4 (10.24 MB)
MP4
04 - Updating a field using JOIN.mp4 (6.1 MB)
MP4
05 - Updating dynamically.mp4 (28.09 MB)
MP4
06 - Challenge Update the film table using JOIN.mp4 (1.27 MB)
MP4
07 - Solution Update the film table using JOIN.mp4 (10.52 MB)
MP4
01 - INSERT rows into a table.mp4 (21.96 MB)
MP4
02 - Common issues with the INSERT command.mp4 (28.93 MB)
MP4
03 - Using MERGE instead of UPDATEINSERT.mp4 (23.7 MB)
MP4
04 - Duplicate table with SELECT.mp4 (19.64 MB)
MP4
05 - Challenge Insert a row into the film table.mp4 (1.1 MB)
MP4
06 - Solution Insert a row into the film table.mp4 (6.44 MB)
MP4
01 - DELETE rows from a table.mp4 (17.88 MB)
MP4
02 - DROP an entire table.mp4 (8.92 MB)
MP4
03 - ALTER TABLE for modifying fields.mp4 (11.87 MB)
MP4
04 - Problems with foreign key constraints.mp4 (8.46 MB)
MP4
05 - Challenge Delete from the country table.mp4 (1.68 MB)
MP4
06 - Solution Delete from the country table.mp4 (28.21 MB)
MP4
01 - Next steps.mp4 (686.14 KB)
MP4




[Only registered and activated users can see links. ]

[Only registered and activated users can see links. ]