SQL – MySQL for Data Analytics and Business Intelligence

سرفصل های دوره

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management

01 - Introduction to databases, SQL, and MySQL

001 What does the course cover

002 SQL-FAQ.pdf

002 Why SQL

003 Why MySQL

004 Introduction to databases

02 - SQL theory

001 SQL as a declarative language

002 DDL.pdf

002 Data definition language (DDL)

003 SQL keywords

003 SQL-Keywords.pdf

004 DML.pdf

004 Data manipulation language (DML)

005 DCL.pdf

005 Data control language (DCL)

006 TCL.pdf

006 Transaction control language (TCL)

external-links.txt

03 - Basic database terminology

001 Relational database essentials

002 Databases vs spreadsheets

003 Database terminology

004 Relational schemas - Primary key

004 Relational-Schemas-Primary-Key.pdf

005 Relational schemas - Foreign key

005 Relational-Schemas-Foreign-Key.pdf

006 Relational schemas - Unique key and null values

006 Relational-Schemas-Unique-Key-and-Null-Values.pdf

007 Relationships

007 Relationships.pdf

04 - Installing MySQL and getting acquainted with the interface

001 Installing MySQL

002 Additional note Installing Visual C.html

003 Installing MySQL on macOS and Unix systems.html

004 The Client-Server Model.html

004 The-Client-Server-Model.pdf

005 Setting up a connection

006 Read me!!!.html

007 New Authentication Plugin - Creating a New User

008 Introduction to the MySQL interface

05 - First steps in SQL

001 Creating a Database - Part I

001 Creating-a-Database-Part-I.pdf

002 SQL files.html

002 SQL-FAQ.pdf

002 mysql-for-data-analytics-and-bi-lecture-code.zip

002 mysql-for-data-analytics-and-bi-lecture-code-and-tasks-solutions.zip

003 Creating a Database - Part I - exercise.html

004 Creating a Database - Part I - solution.html

005 Creating a Database - Part II

006 Creating a Database - Part II - exercise.html

007 Creating a Database - Part II - solution.html

008 Introduction to data types

008 Introduction-to-Data-Types.pdf

009 String data types

009 String-Data-Types.pdf

010 Integers

010 Integers.pdf

011 Fixed and floating-point data types

011 Fixed-and-Floating-Point-Data-Types.pdf

012 Other useful data types

012 Other-Useful-Data-Types.pdf

013 Creating a table

013 Creating-a-Table.pdf

014 Creating a table - exercise.html

015 Creating a table - solution.html

016 Using databases and tables

016 Using-Databases-and-Tables.pdf

017 Using databases and tables - exercise.html

018 Using databases and tables - solution.html

019 Additional notes on using tables

019 Additional-Notes-on-Using-Tables.pdf

020 Additional notes on using tables - exercise.html

06 - MySQL constraints

001 PRIMARY KEY constraint

001 PRIMARY-KEY-Constraint.pdf

001 sales-db.pdf

002 PRIMARY KEY constraint - exercise.html

003 PRIMARY KEY constraint - solution.html

004 FOREIGN KEY constraint - Part I

004 FOREIGN-KEY-Constraint.pdf

005 FOREIGN KEY constraint - Part II

006 FOREIGN KEY constraint - Part II - exercise.html

007 FOREIGN KEY constraint - Part II - solution.html

008 UNIQUE Constraint

008 UNIQUE-Constraint.pdf

009 UNIQUE Constraint - exercise.html

010 DEFAULT Constraint

010 DEFAULT-Constraint.pdf

011 DEFAULT Constraint - exercise.html

012 DEFAULT Constraint - solution.html

013 NOT NULL Constraint - Part I

013 NOT-NULL-Constraint.pdf

014 NOT NULL Constraint - Part I - exercise.html

015 NOT NULL Constraint - Part I - solution.html

016 NOT NULL Constraint - Part II

07 - SQL best practices

001 Coding techniques and best practices - Part I

001 Coding-Techniques-and-Best-Practices.pdf

001 MySQL-Workbench-Shortcuts.pdf

002 Coding techniques and best practices - Part II

08 - Loading the employees database

001 Loading the employees database

002 Loading the employees database.html

external-links.txt

09 - SQL SELECT statement

001 SELECT - FROM

001 SELECT-FROM.pdf

001 employees-db.pdf

002 SELECT - FROM - exercise.html

003 SELECT - FROM - solution.html

004 WHERE

004 WHERE.pdf

005 WHERE - exercise.html

006 WHERE - solution.html

007 AND

007 AND.pdf

008 AND - exercise.html

009 AND - solution.html

010 OR

010 OR.pdf

011 OR - exercise.html

012 OR - solution.html

013 Operator precedence

013 Operator-Precedence.pdf

014 Operator precedence - exercise.html

015 Operator precedence - solution.html

016 IN - NOT IN

017 IN - NOT IN - exercise 1.html

018 IN - NOT IN - solution 1.html

019 IN - NOT IN - exercise 2.html

020 IN - NOT IN - solution 2.html

021 LIKE - NOT LIKE

022 LIKE - NOT LIKE - exercise.html

023 LIKE - NOT LIKE - solution.html

024 Wildcard characters

024 Wildcard-Characters.pdf

025 Wildcard characters - exercise.html

026 Wildcard characters - solution.html

027 BETWEEN - AND

027 BETWEEN-AND.pdf

028 BETWEEN - AND - exercise.html

029 BETWEEN - AND- solution.html

030 IS NOT NULL - IS NULL

030 IS-NOT-NULL-IS-NULL.pdf

031 IS NOT NULL - IS NULL - exercise.html

032 IS NOT NULL - IS NULL - solution.html

033 Other comparison operators

033 Other-Comparison-Operators.pdf

034 Other comparison operators - exercise.html

035 Other comparison operators - solution.html

036 SELECT DISTINCT

036 SELECT-DISTINCT.pdf

037 SELECT DISTINCT - exercise.html

038 SELECT DISTINCT - solution.html

039 Introduction to aggregate functions

039 Introduction-to-Aggregate-Functions.pdf

040 Introduction to aggregate functions - exercise.html

041 Introduction to aggregate functions - solution.html

042 ORDER BY

043 ORDER BY - exercise.html

044 ORDER BY - solution.html

045 GROUP BY

045 GROUP-BY.pdf

046 Using Aliases (AS)

047 Using Aliases (AS) - exercise.html

048 Using Aliases (AS) - solution.html

049 HAVING

049 HAVING.pdf

050 HAVING - exercise.html

051 HAVING - solution.html

052 WHERE vs HAVING- Part I

052 WHERE-vs-HAVING.pdf

053 WHERE vs HAVING- Part II

054 WHERE vs HAVING - Part II - exercise.html

055 WHERE vs HAVING - Part II - solution.html

056 LIMIT

056 LIMIT.pdf

057 LIMIT - exercise.html

058 LIMIT - solution.html

10 - SQL INSERT statement

001 The INSERT statement - Part I

001 The-INSERT-Statement.pdf

002 The INSERT statement - Part II

003 The INSERT statement - exercise 1.html

004 The INSERT statement - solution 1.html

005 The INSERT statement - exercise 2.html

006 The INSERT statement - solution 2.html

007 Inserting data INTO a new table

007 Inserting-Data-INTO-a-New-Table.pdf

008 Inserting Data INTO a New Table - exercise.html

009 Inserting Data INTO a New Table - solution.html

11 - SQL UPDATE Statement

001 TCLs COMMIT and ROLLBACK

001 TCLs-COMMIT-and-ROLLBACK.pdf

002 The UPDATE Statement - Part I

002 The-UPDATE-Statement.pdf

003 ROLLBACK; ARTICLE.html

004 The UPDATE Statement - Part II

005 The UPDATE Statement Part II - exercise.html

006 The UPDATE Statement Part II - solution.html

12 - SQL DELETE Statement

001 The DELETE Statement - Part I

001 The-DELETE-Statement.pdf

002 The DELETE Statement - Part II

003 The DELETE Statement Part II - exercise.html

004 The DELETE Statement Part II - solution.html

005 DROP vs TRUNCATE vs DELETE

005 DROP-vs-TRUNCATE-vs-DELETE.pdf

13 - MySQL - Aggregate functions

001 COUNT.pdf

001 COUNT()

002 COUNT() - exercise.html

003 COUNT() - solution.html

004 SUM.pdf

004 SUM()

005 SUM() - exercise.html

006 SUM() - solution.html

007 MIN() and MAX()

007 MIN-and-MAX.pdf

008 MIN() and MAX() - exercise.html

009 MIN() and MAX() - solution.html

010 AVG.pdf

010 AVG()

011 AVG() - exercise.html

012 AVG() - solution.html

013 ROUND.pdf

013 ROUND()

014 ROUND() - exercise.html

015 ROUND() - solution.html

016 COALESCE() - Preamble.html

016 COALESCE-Preamble.pdf

017 IFNULL() and COALESCE()

017 IFNULL-and-COALESCE.pdf

018 Another Example of Using COALESCE()

019 Another example of using COALESCE() - exercise 1.html

020 Another example of using COALESCE() - solution 1.html

021 Another example of using COALESCE() - exercise 2.html

022 Another example of using COALESCE() - solution 2.html

14 - SQL Joins

001 Introduction to JOINs

001 Introduction-to-Joins.pdf

002 Intro to JOINs - exercise 1.html

003 Intro to JOINs - solution 1.html

004 Intro to JOINs - exercise 2.html

005 INNER JOIN - Part I

005 INNER-JOIN.pdf

006 INNER JOIN - Part II

007 INNER JOIN - Part II - exercise.html

008 INNER JOIN - Part II - solution.html

009 A Note on Using Joins

010 Duplicate Records

010 Duplicate-Records.pdf

011 LEFT JOIN - Part I

011 LEFT-JOIN.pdf

012 LEFT JOIN - Part II

013 LEFT JOIN - Part II - exercise.html

014 LEFT JOIN - Part II - solution.html

015 RIGHT JOIN

015 RIGHT-JOIN.pdf

016 The new and the old join syntax

016 The-New-and-the-Old-Join-Syntax.pdf

017 The new and the old join syntax - exercise.html

018 The new and the old join syntax - solution.html

019 JOIN and WHERE Used Together

019 JOIN-and-WHERE-Used-Together.pdf

020 Important Prevent Error Code 1055!.html

021 JOIN and WHERE Used Together - exercise.html

022 JOIN and WHERE Used Together - solution.html

023 CROSS JOIN

023 CROSS-JOIN.pdf

024 CROSS JOIN - exercise 1.html

025 CROSS JOIN - solution 1.html

026 CROSS JOIN - exercise 2.html

027 CROSS JOIN - solution 2.html

028 Using Aggregate Functions with Joins

029 JOIN more than two tables in SQL

029 JOIN-More-Than-Two-Tables-in-SQL.pdf

030 Join more than two tables in SQL - exercise.html

031 Join more than two tables in SQL - solution.html

032 Tips and tricks for joins

032 Tips-and-Tricks-for-Joins.pdf

033 Tips and tricks for joins - exercise.html

034 Tips and tricks for joins - solution.html

035 UNION vs UNION ALL

035 UNION-vs-UNION-ALL.pdf

036 UNION vs UNION ALL - exercise.html

037 UNION vs UNION ALL - solution.html

15 - SQL Subqueries

001 SQL Subqueries with IN nested inside WHERE

001 Subqueries-IN-WHERE.pdf

002 SQL Subqueries with IN nested inside WHERE - exercise.html

003 SQL Subqueries with IN nested inside WHERE - solution.html

004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE

004 Subqueries-EXISTS-WHERE.pdf

005 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html

006 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html

007 SQL Subqueries nested in SELECT and FROM

007 Subqueries-SELECT-FROM.pdf

008 SQL Subqueries nested in SELECT and FROM - exercise 1.html

009 SQL Subqueries nested in SELECT and FROM - solution 1.html

010 SQL Subqueries nested in SELECT and FROM - exercise 2.html

011 SQL Subqueries nested in SELECT and FROM - solution 2.html

011 subqueries-select-from-solution.zip

16 - SQL Self Join

001 SQL-Self-Join.pdf

001 Self Join

17 - SQL Views

001 SQL-Views.pdf

001 Views

002 Views - exercise.html

003 Views - solution.html

18 - Stored routines

001 Introduction to stored routines

001 Introduction-to-Stored-Routines.pdf

002 The MySQL syntax for stored procedures

002 The-MySQL-Syntax-for-Stored-Procedures.pdf

003 Stored procedures - Example - Part I

004 Stored procedures - Example - Part II

005 Stored procedures - Example - Part II - exercise.html

006 Stored procedures - Example - Part II - solution.html

007 Another way to create a procedure

008 Stored procedures with an input parameter

008 Stored-Procedures-with-an-Input-Parameter.pdf

009 Stored procedures with an output parameter

009 Stored-Procedures-with-an-Output-Parameter.pdf

010 Stored procedures with an output parameter - exercise.html

011 Stored procedures with an output parameter - solution.html

012 Variables

012 Variables.pdf

013 Variables - exercise.html

014 Variables - solution.html

015 User-Defined-Functions-in-MySQL.pdf

015 User-defined functions in MySQL

016 Error Code 1418.html

017 User-defined functions in MySQL - exercise.html

018 User-defined functions in MySQL - solution.html

019 Stored routines - conclusion

019 Stored-Routines-Conclusion.pdf

19 - Advanced SQL Topics

001 Types of MySQL Variables - Local Variables

001 Types-of-MySQL-Variables-Local-Variables.pdf

002 Session Variables

002 Session-Variables.pdf

003 Global Variables

003 Global-Variables.pdf

004 User-Defined vs System Variables

004 User-Defined-vs-System-Variables.pdf

005 MySQL Triggers.html

005 MySQL-Triggers.pdf

005 mysql-triggers.zip

006 MySQL Triggers

007 MySQL Triggers - exercise.html

008 MySQL Triggers - solution.html

009 MySQL Indexes

009 MySQL-Indexes.pdf

010 MySQL Indexes - exercise 1.html

011 MySQL Indexes - solution 1.html

012 MySQL Indexes - exercise 2.html

013 MySQL Indexes - solution 2.html

014 The CASE Statement

014 The-CASE-Statement.pdf

015 The CASE Statement - exercise 1.html

016 The CASE Statement - solution 1.html

017 The CASE Statement - exercise 2.html

018 The CASE Statement - solution 2.html

019 The CASE Statement - exercise 3.html

020 The CASE Statement - solution 3.html

20 - SQL Window Functions

001 Introduction to MySQL Window Functions

002 The ROW NUMBER() Ranking Window Function and the Relevant MySQL Syntax

003 The ROW NUMBER() Ranking Window Function - Exercises.html

004 The ROW NUMBER() Ranking Window Function - Solution.html

005 A Note on Using Several Window Functions in a Query

006 A Note on Using Several Window Functions - Exercise.html

007 A Note on Using Several Window Functions - Solution.html

008 MySQL Window Functions Syntax

009 MySQL Window Functions Syntax - Exercise.html

010 MySQL Window Functions Syntax - Solution.html

011 The PARTITION BY Clause VS the GROUP BY Clause

012 The PARTITION BY Clause VS the GROUP BY Clause - Exercise.html

013 The PARTITION BY Clause VS the GROUP BY Clause - Solution.html

014 The MySQL RANK() and DENSE RANK() Window Functions

015 The MySQL RANK() and DENSE RANK() Window Functions - Exercise.html

016 The MySQL RANK() and DENSE RANK() Window Functions - Solution.html

017 Working with MySQL Ranking Window Functions and Joins Together

018 Working with MySQL Ranking Window Functions and Joins Together - Exercise.html

019 Working with MySQL Ranking Window Functions and Joins Together - Solution.html

020 The LAG() and LEAD() Value Window Functions

021 The LAG() and LEAD() Value Window Functions - Exercise.html

022 The LAG() and LEAD() Value Window Functions - Solution.html

023 MySQL Aggregate Functions in the Context of Window Functions - Part I

024 MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise.html

025 MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution.html

026 MySQL Aggregate Functions in the Context of Window Functions - Part II

027 MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise.html

028 MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution.html

21 - SQL Common Table Expressions (CTEs)

001 MySQL Common Table Expressions - Introduction

002 An Alternative Solution to the Same Task

003 An Alternative Solution to the Same Task-Exercise.html

004 An Alternative Solution to the Same Task-Solution.html

005 Using Multiple Subclauses in a WITH Clause - Part I

006 Using Multiple Subclauses in a WITH Clause - Part II

007 Using Multiple Subclauses in a WITH Clause-Exercise.html

008 Using Multiple Subclauses in a WITH Clause-Solution.html

009 Referring to Common Table Expressions in a WITH Clause

22 - SQL Temporary Tables

001 MySQL Temporary Tables - Introduction

002 MySQL Temporary Tables in Action

003 MySQL Temporary Tables in Action-Exercise.html

004 MySQL Temporary Tables in Action-Solution.html

005 Other Features of MySQL Temporary Tables

006 Other Features of MySQL Temporary Tables-Exercise.html

007 Other Features of MySQL Temporary Tables-Solution.html

23 - Combining SQL and Tableau - Introduction

001 The Advantages of Software Integration

002 Why Combining SQL and Tableau is useful

003 Installing Tableau Public

004 Loading the employees mod Database

004 employees-mod-db.pdf

005 Loading the employees mod Database.html

005 employees-mod-db.pdf

external-links.txt

24 - Combining SQL and Tableau - Task 1

001 Task 1

002 Task 1 - Text.html

003 Important clarification!.html

004 Task 1 SQL Solution

005 Task 1 SQL Solution - Code.html

006 Transferring a Dataset from SQL to Tableau

007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I

008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II

25 - Combining SQL and Tableau - Task 2

001 Task 2

002 Task 2 - Text.html

003 Task 2 SQL Solution

004 Task 2 SQL Solution - Code.html

005 Chart 2 Visualizing and Analyzing the Solution in Tableau

26 - Combining SQL and Tableau - Task 3

001 Task 3

002 Task 3 - Text.html

003 Task 3 SQL Solution

004 Task 3 SQL Solution - Code.html

005 Chart 3 Visualizing and Analyzing the Solution in Tableau

27 - Combining SQL and Tableau - Task 4

001 Task 4

002 Task 4 - Text.html

003 Task 4 Solution in SQL

004 Task 4 Solution in SQL - Code.html

005 Chart 4 Visualizing and Analyzing the Solution in Tableau

28 - Combining SQL and Tableau - Task 5

001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau

29 - Practice SQL 10 Final Query Questions

001 10-Practice-SQL-Final-Query-Questions.pdf

001 10-practice-final-query-questions-solutions.zip

001 Practice SQL 10 Final Query Questions.html

30 - BONUS LECTURE

001 Bonus Lecture Next Steps.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy