种子简介

种子名称： [GigaCourse.Com] Udemy - SQL - MySQL for Data Analytics and Business Intelligence
文件类型： 视频
文件数目： 151个文件
文件大小： 2.88 GB
收录时间： 2024-2-20 06:29
已经下载： 3次
资源热度： 70
最近下载： 2024-5-2 22:33

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

[GigaCourse.Com] Udemy - SQL - MySQL for Data Analytics and Business Intelligence.torrent

01 - Introduction to databases, SQL, and MySQL/001 What does the course cover.mp473.65MB

01 - Introduction to databases, SQL, and MySQL/002 Why SQL.mp458.06MB

01 - Introduction to databases, SQL, and MySQL/003 Why MySQL.mp423.71MB

01 - Introduction to databases, SQL, and MySQL/004 Introduction to databases.mp483.52MB

02 - SQL theory/001 SQL as a declarative language.mp47.08MB

02 - SQL theory/002 Data definition language (DDL).mp49.09MB

02 - SQL theory/003 SQL keywords.mp42.46MB

02 - SQL theory/004 Data manipulation language (DML).mp410.7MB

02 - SQL theory/005 Data control language (DCL).mp413.55MB

02 - SQL theory/006 Transaction control language (TCL).mp49.12MB

03 - Basic database terminology/001 Relational database essentials.mp491.73MB

03 - Basic database terminology/002 Databases vs spreadsheets.mp4141.25MB

03 - Basic database terminology/003 Database terminology.mp413.34MB

03 - Basic database terminology/004 Relational schemas - Primary key.mp414.38MB

03 - Basic database terminology/005 Relational schemas - Foreign key.mp411.85MB

03 - Basic database terminology/006 Relational schemas - Unique key and null values.mp47MB

03 - Basic database terminology/007 Relationships.mp413.22MB

04 - Installing MySQL and getting acquainted with the interface/001 Installing MySQL.mp460.22MB

04 - Installing MySQL and getting acquainted with the interface/005 Setting up a connection.mp46.43MB

04 - Installing MySQL and getting acquainted with the interface/007 New Authentication Plugin - Creating a New User.mp419.07MB

04 - Installing MySQL and getting acquainted with the interface/008 Introduction to the MySQL interface.mp414.08MB

05 - First steps in SQL/001 Creating a Database - Part I.mp420.27MB

05 - First steps in SQL/005 Creating a Database - Part II.mp46.03MB

05 - First steps in SQL/008 Introduction to data types.mp44.81MB

05 - First steps in SQL/009 String data types.mp411.15MB

05 - First steps in SQL/010 Integers.mp415.27MB

05 - First steps in SQL/011 Fixed and floating-point data types.mp418.64MB

05 - First steps in SQL/012 Other useful data types.mp413.96MB

05 - First steps in SQL/013 Creating a table.mp416.35MB

05 - First steps in SQL/016 Using databases and tables.mp49.15MB

05 - First steps in SQL/019 Additional notes on using tables.mp47.23MB

06 - MySQL constraints/001 PRIMARY KEY constraint.mp417.68MB

06 - MySQL constraints/004 FOREIGN KEY constraint - Part I.mp417.74MB

06 - MySQL constraints/005 FOREIGN KEY constraint - Part II.mp421.33MB

06 - MySQL constraints/008 UNIQUE Constraint.mp413.49MB

06 - MySQL constraints/010 DEFAULT Constraint.mp414.72MB

06 - MySQL constraints/013 NOT NULL Constraint - Part I.mp434.63MB

06 - MySQL constraints/016 NOT NULL Constraint - Part II.mp44.26MB

07 - SQL best practices/001 Coding techniques and best practices - Part I.mp413.78MB

07 - SQL best practices/002 Coding techniques and best practices - Part II.mp411.55MB

08 - Loading the 'employees' database/001 Loading the 'employees' database.mp48.06MB

09 - SQL SELECT statement/001 SELECT - FROM.mp415.15MB

09 - SQL SELECT statement/004 WHERE.mp416.98MB

09 - SQL SELECT statement/007 AND.mp45.67MB

09 - SQL SELECT statement/010 OR.mp410.59MB

09 - SQL SELECT statement/013 Operator precedence.mp410.22MB

09 - SQL SELECT statement/016 IN - NOT IN.mp49.85MB

09 - SQL SELECT statement/021 LIKE - NOT LIKE.mp410.89MB

09 - SQL SELECT statement/024 Wildcard characters.mp43.72MB

09 - SQL SELECT statement/027 BETWEEN - AND.mp45.48MB

09 - SQL SELECT statement/030 IS NOT NULL - IS NULL.mp44.54MB

09 - SQL SELECT statement/033 Other comparison operators.mp416.33MB

09 - SQL SELECT statement/036 SELECT DISTINCT.mp47.65MB

09 - SQL SELECT statement/039 Introduction to aggregate functions.mp414.59MB

09 - SQL SELECT statement/042 ORDER BY.mp412.05MB

09 - SQL SELECT statement/045 GROUP BY.mp424.3MB

09 - SQL SELECT statement/046 Using Aliases (AS).mp46.76MB

09 - SQL SELECT statement/049 HAVING.mp412.66MB

09 - SQL SELECT statement/052 WHERE vs HAVING- Part I.mp427.24MB

09 - SQL SELECT statement/053 WHERE vs HAVING- Part II.mp417.84MB

09 - SQL SELECT statement/056 LIMIT.mp418.67MB

10 - SQL INSERT statement/001 The INSERT statement - Part I.mp421.41MB

10 - SQL INSERT statement/002 The INSERT statement - Part II.mp47.32MB

10 - SQL INSERT statement/007 Inserting data INTO a new table.mp411.72MB

11 - SQL UPDATE Statement/001 TCL's COMMIT and ROLLBACK.mp49.59MB

11 - SQL UPDATE Statement/002 The UPDATE Statement - Part I.mp49.72MB

11 - SQL UPDATE Statement/004 The UPDATE Statement - Part II.mp48.74MB

12 - SQL DELETE Statement/001 The DELETE Statement - Part I.mp412.75MB

12 - SQL DELETE Statement/002 The DELETE Statement - Part II.mp45.58MB

12 - SQL DELETE Statement/005 DROP vs TRUNCATE vs DELETE.mp47.63MB

13 - MySQL - Aggregate functions/001 COUNT().mp419.12MB

13 - MySQL - Aggregate functions/004 SUM().mp43.81MB

13 - MySQL - Aggregate functions/007 MIN() and MAX().mp43.52MB

13 - MySQL - Aggregate functions/010 AVG().mp46.6MB

13 - MySQL - Aggregate functions/013 ROUND().mp46.01MB

13 - MySQL - Aggregate functions/017 IFNULL() and COALESCE().mp428.08MB

13 - MySQL - Aggregate functions/018 Another Example of Using COALESCE().mp44.13MB

14 - SQL Joins/001 Introduction to JOINs.mp421.64MB

14 - SQL Joins/005 INNER JOIN - Part I.mp413.8MB

14 - SQL Joins/006 INNER JOIN - Part II.mp426.2MB

14 - SQL Joins/009 A Note on Using Joins.mp413.32MB

14 - SQL Joins/010 Duplicate Records.mp416.78MB

14 - SQL Joins/011 LEFT JOIN - Part I.mp420.44MB

14 - SQL Joins/012 LEFT JOIN - Part II.mp420.78MB

14 - SQL Joins/015 RIGHT JOIN.mp424.52MB

14 - SQL Joins/016 The new and the old join syntax.mp414.49MB

14 - SQL Joins/019 JOIN and WHERE Used Together.mp418.88MB

14 - SQL Joins/023 CROSS JOIN.mp431.13MB

14 - SQL Joins/028 Using Aggregate Functions with Joins.mp48.62MB

14 - SQL Joins/029 JOIN more than two tables in SQL.mp412.65MB

14 - SQL Joins/032 Tips and tricks for joins.mp436.77MB

14 - SQL Joins/035 UNION vs UNION ALL.mp415.25MB

15 - SQL Subqueries/001 SQL Subqueries with IN nested inside WHERE.mp412.18MB

15 - SQL Subqueries/004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp49.76MB

15 - SQL Subqueries/007 SQL Subqueries nested in SELECT and FROM.mp432.84MB

16 - SQL Self Join/001 Self Join.mp447.25MB

17 - SQL Views/001 Views.mp420.65MB

18 - Stored routines/001 Introduction to stored routines.mp48.12MB

18 - Stored routines/002 The MySQL syntax for stored procedures.mp425.16MB

18 - Stored routines/003 Stored procedures - Example - Part I.mp47.68MB

18 - Stored routines/004 Stored procedures - Example - Part II.mp414.41MB

18 - Stored routines/007 Another way to create a procedure.mp410.13MB

18 - Stored routines/008 Stored procedures with an input parameter.mp419.4MB

18 - Stored routines/009 Stored procedures with an output parameter.mp412.54MB

18 - Stored routines/012 Variables.mp422.46MB

18 - Stored routines/015 User-defined functions in MySQL.mp443.93MB

18 - Stored routines/019 Stored routines - conclusion.mp411.37MB

19 - Advanced SQL Topics/001 Types of MySQL Variables - Local Variables.mp417.9MB

19 - Advanced SQL Topics/002 Session Variables.mp416.13MB

19 - Advanced SQL Topics/003 Global Variables.mp46.57MB

19 - Advanced SQL Topics/004 User-Defined vs System Variables.mp430.4MB

19 - Advanced SQL Topics/006 MySQL Triggers.mp443.46MB

19 - Advanced SQL Topics/009 MySQL Indexes.mp426.42MB

19 - Advanced SQL Topics/014 The CASE Statement.mp422.73MB

20 - SQL Window Functions/001 Introduction to MySQL Window Functions.mp44.65MB

20 - SQL Window Functions/002 The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax.mp459.47MB

20 - SQL Window Functions/005 A Note on Using Several Window Functions in a Query.mp410.31MB

20 - SQL Window Functions/008 MySQL Window Functions Syntax.mp412.88MB

20 - SQL Window Functions/011 The PARTITION BY Clause VS the GROUP BY Clause.mp418.53MB

20 - SQL Window Functions/014 The MySQL RANK() and DENSE_RANK() Window Functions.mp427.87MB

20 - SQL Window Functions/017 Working with MySQL Ranking Window Functions and Joins Together.mp435.48MB

20 - SQL Window Functions/020 The LAG() and LEAD() Value Window Functions.mp435.34MB

20 - SQL Window Functions/023 MySQL Aggregate Functions in the Context of Window Functions - Part I.mp434.18MB

20 - SQL Window Functions/026 MySQL Aggregate Functions in the Context of Window Functions - Part II.mp443.52MB

21 - SQL Common Table Expressions (CTEs)/001 MySQL Common Table Expressions - Introduction.mp449.22MB

21 - SQL Common Table Expressions (CTEs)/002 An Alternative Solution to the Same Task.mp48.45MB

21 - SQL Common Table Expressions (CTEs)/005 Using Multiple Subclauses in a WITH Clause - Part I.mp424.55MB

21 - SQL Common Table Expressions (CTEs)/006 Using Multiple Subclauses in a WITH Clause - Part II.mp421.19MB

21 - SQL Common Table Expressions (CTEs)/009 Referring to Common Table Expressions in a WITH Clause.mp416.68MB

22 - SQL Temporary Tables/001 MySQL Temporary Tables - Introduction.mp410.69MB

22 - SQL Temporary Tables/002 MySQL Temporary Tables in Action.mp429.65MB

22 - SQL Temporary Tables/005 Other Features of MySQL Temporary Tables.mp433.16MB

23 - Combining SQL and Tableau - Introduction/001 The Advantages of Software Integration.mp456.38MB

23 - Combining SQL and Tableau - Introduction/002 Why Combining SQL and Tableau is useful.mp414.71MB

23 - Combining SQL and Tableau - Introduction/003 Installing Tableau Public.mp47.1MB

23 - Combining SQL and Tableau - Introduction/004 Loading the 'employees_mod' Database.mp416.49MB

24 - Combining SQL and Tableau - Task 1/001 Task 1.mp413.81MB

24 - Combining SQL and Tableau - Task 1/004 Task 1 SQL Solution.mp420.11MB

24 - Combining SQL and Tableau - Task 1/006 Transferring a Dataset from SQL to Tableau.mp412.74MB

24 - Combining SQL and Tableau - Task 1/007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp415.87MB

24 - Combining SQL and Tableau - Task 1/008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp419.84MB

25 - Combining SQL and Tableau - Task 2/001 Task 2.mp48.8MB

25 - Combining SQL and Tableau - Task 2/003 Task 2 SQL Solution.mp411.46MB

25 - Combining SQL and Tableau - Task 2/005 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp430.02MB

26 - Combining SQL and Tableau - Task 3/001 Task 3.mp45MB

26 - Combining SQL and Tableau - Task 3/003 Task 3 SQL Solution.mp414.3MB

26 - Combining SQL and Tableau - Task 3/005 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp418.79MB

27 - Combining SQL and Tableau - Task 4/001 Task 4.mp48.67MB

27 - Combining SQL and Tableau - Task 4/003 Task 4 Solution in SQL.mp412.98MB

27 - Combining SQL and Tableau - Task 4/005 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp48.67MB

28 - Combining SQL and Tableau - Task 5/001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp441.73MB