种子简介

种子名称： [FreeCourseLab.com] Udemy - SQL - MySQL for Data Analytics and Business Intelligence
文件类型： 视频
文件数目： 132个文件
文件大小： 2.28 GB
收录时间： 2019-6-1 14:53
已经下载： 3次
资源热度： 218
最近下载： 2024-11-20 05:05

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:03d1532a666220ea099b23a584a8bd24a789f2af&dn=[FreeCourseLab.com] Udemy - SQL - MySQL for Data Analytics and Business Intelligence 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseLab.com] Udemy - SQL - MySQL for Data Analytics and Business Intelligence.torrent

01 Introduction to databases SQL and MySQL/001 What does the course cover.mp424.25MB

01 Introduction to databases SQL and MySQL/002 Why SQL.mp414.74MB

01 Introduction to databases SQL and MySQL/003 Why MySQL.mp46.53MB

01 Introduction to databases SQL and MySQL/004 Introduction to databases.mp419.6MB

02 SQL theory/005 SQL as a declarative language.mp410.08MB

02 SQL theory/006 Data definition language (DDL).mp48.69MB

02 SQL theory/007 SQL keywords.mp42.47MB

02 SQL theory/008 Data manipulation language (DML).mp49.99MB

02 SQL theory/009 Data control language (DCL).mp48.06MB

02 SQL theory/010 Transaction control language (TCL).mp46.86MB

03 Basic database terminology/011 Relational database essentials.mp422.97MB

03 Basic database terminology/012 Databases vs spreadsheets.mp4169.95MB

03 Basic database terminology/013 Database terminology.mp418.96MB

03 Basic database terminology/014 Relational schemas - Primary key.mp410.41MB

03 Basic database terminology/015 Relational schemas - Foreign key.mp410.35MB

03 Basic database terminology/016 Relational schemas - Unique key and null values.mp46.34MB

03 Basic database terminology/017 Relationships.mp49.74MB

04 Installing MySQL and getting acquainted with the interface/018 Installing MySQL.mp489.8MB

04 Installing MySQL and getting acquainted with the interface/021 Setting up a connection.mp46.14MB

04 Installing MySQL and getting acquainted with the interface/022 New Authentication Plugin - Creating a New User.mp447.71MB

04 Installing MySQL and getting acquainted with the interface/023 Introduction to the MySQL interface.mp411.9MB

05 First steps in SQL/024 Creating a Database - Part I.mp410.36MB

05 First steps in SQL/028 Creating a Database - Part II.mp44.87MB

05 First steps in SQL/031 Introduction to data types.mp43.09MB

05 First steps in SQL/032 String data types.mp49.14MB

05 First steps in SQL/033 Integers.mp48.83MB

05 First steps in SQL/034 Fixed and floating-point data types.mp411.77MB

05 First steps in SQL/035 Other useful data types.mp411.8MB

05 First steps in SQL/036 Creating a table.mp410.66MB

05 First steps in SQL/039 Using databases and tables.mp46.52MB

05 First steps in SQL/042 Additional notes on using tables.mp45.07MB

06 MySQL constraints/044 PRIMARY KEY constraint.mp411.98MB

06 MySQL constraints/047 FOREIGN KEY constraint - Part I.mp411.06MB

06 MySQL constraints/048 FOREIGN KEY constraint - Part II.mp414.54MB

06 MySQL constraints/051 UNIQUE Constraint.mp411.75MB

06 MySQL constraints/053 DEFAULT Constraint.mp413.12MB

06 MySQL constraints/056 NOT NULL Constraint - Part I.mp414.91MB

06 MySQL constraints/059 NOT NULL Constraint - Part II.mp43.68MB

07 SQL best practices/060 Coding techniques and best practices - Part I.mp411.56MB

07 SQL best practices/061 Coding techniques and best practices - Part II.mp49.27MB

08 Loading the employees database/062 Loading the employees database.mp48.14MB

09 SQL SELECT statement/064 SELECT - FROM.mp410.96MB

09 SQL SELECT statement/067 WHERE.mp46.03MB

09 SQL SELECT statement/070 AND.mp44.82MB

09 SQL SELECT statement/073 OR.mp48.47MB

09 SQL SELECT statement/076 Operator precedence.mp48.49MB

09 SQL SELECT statement/079 IN - NOT IN.mp48.25MB

09 SQL SELECT statement/084 LIKE - NOT LIKE.mp49.6MB

09 SQL SELECT statement/087 Wildcard characters.mp43.34MB

09 SQL SELECT statement/090 BETWEEN - AND.mp45.18MB

09 SQL SELECT statement/093 IS NOT NULL - IS NULL.mp43.82MB

09 SQL SELECT statement/096 Other comparison operators.mp411.05MB

09 SQL SELECT statement/099 SELECT DISTINCT.mp44.58MB

09 SQL SELECT statement/102 Introduction to aggregate functions.mp412.66MB

09 SQL SELECT statement/105 ORDER BY.mp410.77MB

09 SQL SELECT statement/108 GROUP BY.mp414.82MB

09 SQL SELECT statement/109 Using Aliases (AS).mp45.26MB

09 SQL SELECT statement/112 HAVING.mp48.92MB

09 SQL SELECT statement/115 WHERE vs HAVING- Part I.mp49.99MB

09 SQL SELECT statement/116 WHERE vs HAVING- Part II.mp46.74MB

09 SQL SELECT statement/119 LIMIT.mp412.7MB

10 SQL INSERT statement/122 The INSERT statement - Part I.mp414.42MB

10 SQL INSERT statement/123 The INSERT statement - Part II.mp46.66MB

10 SQL INSERT statement/128 Inserting data INTO a new table.mp49.62MB

11 SQL UPDATE Statement/131 TCLs COMMIT and ROLLBACK.mp47.81MB

11 SQL UPDATE Statement/132 The UPDATE Statement - Part I.mp47.91MB

11 SQL UPDATE Statement/133 The UPDATE Statement - Part II.mp47.39MB

12 SQL DELETE Statement/136 The DELETE Statement - Part I.mp410.31MB

12 SQL DELETE Statement/137 The DELETE Statement - Part II.mp43.68MB

12 SQL DELETE Statement/140 DROP vs TRUNCATE vs DELETE.mp47.48MB

13 MySQL - Aggregate functions/141 COUNT().mp49.24MB

13 MySQL - Aggregate functions/144 SUM().mp43.22MB

13 MySQL - Aggregate functions/147 MIN() and MAX().mp42.96MB

13 MySQL - Aggregate functions/150 AVG().mp44.16MB

13 MySQL - Aggregate functions/153 ROUND().mp44.74MB

13 MySQL - Aggregate functions/157 IFNULL() and COALESCE().mp415.75MB

13 MySQL - Aggregate functions/158 Another Example of Using COALESCE().mp43.7MB

14 SQL Joins/163 Introduction to JOINs.mp47.22MB

14 SQL Joins/167 INNER JOIN - Part I.mp412.42MB

14 SQL Joins/168 INNER JOIN - Part II.mp411.62MB

14 SQL Joins/171 A Note on Using Joins.mp410.76MB

14 SQL Joins/172 Duplicate Records.mp412.73MB

14 SQL Joins/173 LEFT JOIN - Part I.mp414.02MB

14 SQL Joins/174 LEFT JOIN - Part II.mp414.82MB

14 SQL Joins/177 RIGHT JOIN.mp432.09MB

14 SQL Joins/178 The new and the old join syntax.mp49.17MB

14 SQL Joins/181 JOIN and WHERE Used Together.mp46.55MB

14 SQL Joins/184 CROSS JOIN.mp489.99MB

14 SQL Joins/189 Using Aggregate Functions with Joins.mp46.21MB

14 SQL Joins/190 JOIN more than two tables in SQL.mp410.94MB

14 SQL Joins/193 Tips and tricks for joins.mp450.91MB

14 SQL Joins/196 UNION vs UNION ALL.mp48.54MB

15 SQL Subqueries/199 SQL Subqueries with IN nested inside WHERE.mp46.71MB

15 SQL Subqueries/202 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp48.64MB

15 SQL Subqueries/205 SQL Subqueries nested in SELECT and FROM.mp419.91MB

16 SQL Self Join/210 Self Join.mp420.83MB

17 SQL Views/211 Views.mp417.48MB

18 Stored routines/214 Introduction to stored routines.mp47.23MB

18 Stored routines/215 The MySQL syntax for stored procedures.mp45.96MB

18 Stored routines/216 Stored procedures - Example - Part I.mp47.23MB

18 Stored routines/217 Stored procedures - Example - Part II.mp411.17MB

18 Stored routines/220 Another way to create a procedure.mp45.43MB

18 Stored routines/221 Stored procedures with an input parameter.mp417.07MB

18 Stored routines/222 Stored procedures with an output parameter.mp48.52MB

18 Stored routines/225 Variables.mp415.97MB

18 Stored routines/228 User-defined functions in MySQL.mp48.03MB

18 Stored routines/231 Stored routines - conclusion.mp48.18MB

19 Advanced SQL Topics/232 Types of MySQL Variables - Local Variables.mp411.57MB

19 Advanced SQL Topics/233 Session Variables.mp411.96MB

19 Advanced SQL Topics/234 Global Variables.mp45.01MB

19 Advanced SQL Topics/235 User-Defined vs System Variables.mp410.96MB

19 Advanced SQL Topics/239 MySQL Indexes.mp418.21MB

19 Advanced SQL Topics/244 The CASE Statement.mp459.41MB

20 Combining SQL and Tableau - Introduction/251 The Advantages of Software Integration.mp492.4MB

20 Combining SQL and Tableau - Introduction/252 Why Combining SQL and Tableau is useful.mp485.35MB

20 Combining SQL and Tableau - Introduction/253 Installing Tableau Public.mp427.35MB

20 Combining SQL and Tableau - Introduction/254 Loading the employees_mod Database.mp428.53MB

21 Combining SQL and Tableau - Task 1/256 Task 1.mp433.52MB

21 Combining SQL and Tableau - Task 1/258 Task 1 SQL Solution.mp443.16MB

21 Combining SQL and Tableau - Task 1/260 Transferring a Dataset from SQL to Tableau.mp431.42MB

21 Combining SQL and Tableau - Task 1/261 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp440.54MB

21 Combining SQL and Tableau - Task 1/262 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp445.1MB

22 Combining SQL and Tableau - Task 2/263 Task 2.mp428.84MB

22 Combining SQL and Tableau - Task 2/265 Task 2 SQL Solution.mp439.28MB

22 Combining SQL and Tableau - Task 2/267 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp448.93MB

23 Combining SQL and Tableau - Task 3/268 Task 3.mp413.07MB

23 Combining SQL and Tableau - Task 3/270 Task 3 SQL Solution.mp433.12MB

23 Combining SQL and Tableau - Task 3/272 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp440.32MB

24 Combining SQL and Tableau - Task 4/273 Task 4.mp423.56MB

24 Combining SQL and Tableau - Task 4/275 Task 4 Solution in SQL.mp430.25MB

24 Combining SQL and Tableau - Task 4/277 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp422.28MB

25 Combining SQL and Tableau - Task 5/278 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp455.98MB