Free software and educational resource. With a little searching, you can download what you need for free without spending any money. Our site -
"DDLFREE" offers free software downloads including antivirus software, office suites and video editing software. Here you can find software reviews and ratings so you can understand which apps are worth downloading. If you're looking for free educational programs or materials in the US and Canada, we'll help you find what you need for students and learners.
LinkedIn Learning - Intermediate SQL Data Reporting and Analysis
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