Udemy - SQL Masterclass Become MySQL Data Analyst Expert in 16 Days

[AD-TEAM]

Download Free Download : Udemy - SQL Masterclass Become MySQL Data Analyst Expert in 16 Days
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:1.72 GB

Files Included :

1 IS NULL filtering the actual values out.mp4 (22.93 MB)
MP4
3 IS NOT NULL filtering the missing values out.mp4 (16.13 MB)
MP4
1 AND combining two or more conditions.mp4 (23.4 MB)
MP4
11 IN precise logic for multiple conditions.mp4 (17.03 MB)
MP4
13 LIMIT filtering with limited data.mp4 (15.77 MB)
MP4
3 OR flexible logical operator.mp4 (25.15 MB)
MP4
5 NOT excluding values from filteration.mp4 (19.47 MB)
MP4
7 BETWEEN AND filtering ranges of values.mp4 (22.69 MB)
MP4
9 LIKE filtering based on pattern.mp4 (36.09 MB)
MP4
1 CHAR LENGTH finding the length of text.mp4 (24.54 MB)
MP4
11 REPLACE replacing old value by new value.mp4 (19.69 MB)
MP4
3 CONCAT adding different strings together.mp4 (25.37 MB)
MP4
5 LOWER converting into lowercase.mp4 (15.35 MB)
MP4
7 UPPER converting into uppercase.mp4 (11.25 MB)
MP4
9 TRIM removing unnecessary gaps.mp4 (16.57 MB)
MP4
1 ABS negative to positive value.mp4 (21.99 MB)
MP4
11 MIN finding the lowest value.mp4 (10.15 MB)
MP4
13 MAX finding the highest value.mp4 (9.78 MB)
MP4
3 SUM calculating the total value.mp4 (13.49 MB)
MP4
5 AVG calculating the average value.mp4 (12.1 MB)
MP4
7 COUNT counting total items.mp4 (14.94 MB)
MP4
9 DIV dividing numeric data.mp4 (23.21 MB)
MP4
1 POWER multiple multiplications.mp4 (23.08 MB)
MP4
3 ROUND decreasing the decimals.mp4 (25.34 MB)
MP4
5 SQRT and LOG transformation functions.mp4 (19.12 MB)
MP4
1 DATEFORMAT formatting the date shape.mp4 (29.06 MB)
MP4
3 DATEDIFF finding the date difference.mp4 (14.42 MB)
MP4
5 DAYMONTHYEAR extracting parts of dates.mp4 (14.07 MB)
MP4
1 ORDER BY sorting data based on a column.mp4 (27.13 MB)
MP4
3 GROUP BY group data analysis with functions.mp4 (48.67 MB)
MP4
1 Understanding different JOINS methods.mp4 (55.95 MB)
MP4
2 INNER JOIN joining on common values.mp4 (38.37 MB)
MP4
4 LEFT JOIN joining on left table values.mp4 (24.7 MB)
MP4
6 RIGHT JOIN joining on right table values.mp4 (20.79 MB)
MP4
8 CROSS JOIN joining all values from tables.mp4 (20.78 MB)
MP4
1 HAVING advanced conditional format.mp4 (45.54 MB)
MP4
3 EXISTS nested filtering between tables.mp4 (34.87 MB)
MP4
5 ANY nested filtering between tables.mp4 (30.06 MB)
MP4
7 CASE finding the conditional outcomes.mp4 (28.84 MB)
MP4
1 SQL comments systems.mp4 (15.37 MB)
MP4
2 Storing and executing procedures.mp4 (25.58 MB)
MP4
1 RDBMS example and importance.mp4 (36.99 MB)
MP4
2 Key features of RDBMS.mp4 (33.59 MB)
MP4
3 Primary key vs Foreign key.mp4 (22.18 MB)
MP4
4 Types of relationship in RDBMS.mp4 (24.22 MB)
MP4
5 Data types in RDBMS.mp4 (36.31 MB)
MP4
1 Introduction to SQL language.mp4 (20.74 MB)
MP4
2 Various platforms of SQL.mp4 (19.1 MB)
MP4
2 Loading CSV dataset in MySQL.mp4 (56.6 MB)
MP4
1 Creating database.mp4 (10.65 MB)
MP4
2 Selecting database.mp4 (7.54 MB)
MP4
3 Modifying database.mp4 (30.96 MB)
MP4
4 Deleting database.mp4 (18.45 MB)
MP4
1 SELECT FROM select data from table.mp4 (19.48 MB)
MP4
3 DISTINCT selecting unique values for column.mp4 (20.42 MB)
MP4
5 AS selecting columns based on aliases.mp4 (40.45 MB)
MP4
7 WHERE selecting data based on condition.mp4 (21.86 MB)
MP4
1 CREATE creating table.mp4 (24.88 MB)
MP4
11 DELETE deleting values based on condition.mp4 (16.24 MB)
MP4
13 TRUNCATE deleting all the values except table.mp4 (10.02 MB)
MP4
15 DROP removing entire table.mp4 (8.97 MB)
MP4
17 CHECK limiting specific values in columns.mp4 (32.42 MB)
MP4
3 NOT NULL limiting null values.mp4 (21.67 MB)
MP4
5 UNIQUE limiting duplicates.mp4 (23.52 MB)
MP4
7 INSERT INTO adding values in columns.mp4 (22.33 MB)
MP4
9 UPDATE updating values based on condition.mp4 (21.38 MB)
MP4
1 ADD COLUMN adding new column.mp4 (15.71 MB)
MP4
11 ADD CONSTRAINT. REFERENCES adding foreign key.mp4 (40.65 MB)
MP4
13 DROP CONSTRAINT deleting keys.mp4 (9.18 MB)
MP4
3 MODIFY COLUMN replacing data types.mp4 (14.52 MB)
MP4
5 RENAME COLUMN changing column names.mp4 (19.95 MB)
MP4
7 DROP COLUMN deleting columns.mp4 (10.85 MB)
MP4
9 ADD CONSTRAINT adding primary key.mp4 (29.5 MB)
MP4
1 CREATE INDEX creating new index.mp4 (18.35 MB)
MP4
3 CREATE UNIQUE INDEX creating index without duplicates.mp4 (16.26 MB)
MP4
5 DROP INDEX deleting existing index.mp4 (10.47 MB)
MP4

[To see links please register or login]

[To see links please register or login]

[To see links please register or login]

[To see links please register or login]