SQL - MySQL for Data Analytics and Business Intelligence

Focused View

365 Careers

11:14:34

64 View

01 - Introduction to databases, SQL, and MySQL

001 What does the course cover.mp4

04:14

002 SQL-FAQ.pdf

002 Why SQL.mp4

03:17

003 Why MySQL.mp4

01:57

004 Introduction to databases.mp4

04:44

02 - SQL theory

001 SQL as a declarative language.mp4

02:11

002 DDL.pdf

002 Data definition language (DDL).mp4

04:13

003 SQL keywords.mp4

01:12

003 SQL-Keywords.pdf

004 DML.pdf

004 Data manipulation language (DML).mp4

04:55

005 DCL.pdf

005 Data control language (DCL).mp4

05:03

006 TCL.pdf

006 Transaction control language (TCL).mp4

03:02

external-links.txt

03 - Basic database terminology

001 Relational database essentials.mp4

04:51

002 Databases vs spreadsheets.mp4

08:06

003 Database terminology.mp4

04:17

004 Relational schemas - Primary key.mp4

04:55

004 Relational-Schemas-Primary-Key.pdf

005 Relational schemas - Foreign key.mp4

04:58

005 Relational-Schemas-Foreign-Key.pdf

006 Relational schemas - Unique key and null values.mp4

03:07

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

007 Relationships.mp4

04:39

007 Relationships.pdf

04 - Installing MySQL and getting acquainted with the interface

001 Installing MySQL.mp4

10:48

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.mp4

02:34

006 Read me!!!.html

007 New Authentication Plugin - Creating a New User.mp4

06:18

008 Introduction to the MySQL interface.mp4

05:09

05 - First steps in SQL

001 Creating a Database - Part I.mp4

05:12

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.mp4

02:22

006 Creating a Database - Part II - exercise.html

007 Creating a Database - Part II - solution.html

008 Introduction to data types.mp4

02:16

008 Introduction-to-Data-Types.pdf

009 String data types.mp4

05:01

009 String-Data-Types.pdf

010 Integers.mp4

04:10

010 Integers.pdf

011 Fixed and floating-point data types.mp4

05:43

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

012 Other useful data types.mp4

06:12

012 Other-Useful-Data-Types.pdf

013 Creating a table.mp4

05:17

013 Creating-a-Table.pdf

014 Creating a table - exercise.html

015 Creating a table - solution.html

016 Using databases and tables.mp4

03:03

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.mp4

02:12

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

020 Additional notes on using tables - exercise.html

06 - MySQL constraints

001 PRIMARY KEY constraint.mp4

05:23

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.mp4

05:25

004 FOREIGN-KEY-Constraint.pdf

005 FOREIGN KEY constraint - Part II.mp4

05:26

006 FOREIGN KEY constraint - Part II - exercise.html

007 FOREIGN KEY constraint - Part II - solution.html

008 UNIQUE Constraint.mp4

05:00

008 UNIQUE-Constraint.pdf

009 UNIQUE Constraint - exercise.html

010 DEFAULT Constraint.mp4

05:24

010 DEFAULT-Constraint.pdf

011 DEFAULT Constraint - exercise.html

012 DEFAULT Constraint - solution.html

013 NOT NULL Constraint - Part I.mp4

05:53

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.mp4

01:59

07 - SQL best practices

001 Coding techniques and best practices - Part I.mp4

05:34

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

001 MySQL-Workbench-Shortcuts.pdf

002 Coding techniques and best practices - Part II.mp4

04:11

08 - Loading the employees database

001 Loading the employees database.mp4

02:19

002 Loading the employees database.html

external-links.txt

09 - SQL SELECT statement

001 SELECT - FROM.mp4

04:57

001 SELECT-FROM.pdf

001 employees-db.pdf

002 SELECT - FROM - exercise.html

003 SELECT - FROM - solution.html

004 WHERE.mp4

02:30

004 WHERE.pdf

005 WHERE - exercise.html

006 WHERE - solution.html

007 AND.mp4

02:14

007 AND.pdf

008 AND - exercise.html

009 AND - solution.html

010 OR.mp4

03:35

010 OR.pdf

011 OR - exercise.html

012 OR - solution.html

013 Operator precedence.mp4

03:34

013 Operator-Precedence.pdf

014 Operator precedence - exercise.html

015 Operator precedence - solution.html

016 IN - NOT IN.mp4

03:12

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.mp4

03:36

022 LIKE - NOT LIKE - exercise.html

023 LIKE - NOT LIKE - solution.html

024 Wildcard characters.mp4

01:45

024 Wildcard-Characters.pdf

025 Wildcard characters - exercise.html

026 Wildcard characters - solution.html

027 BETWEEN - AND.mp4

02:19

027 BETWEEN-AND.pdf

028 BETWEEN - AND - exercise.html

029 BETWEEN - AND- solution.html

030 IS NOT NULL - IS NULL.mp4

01:37

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.mp4

04:30

033 Other-Comparison-Operators.pdf

034 Other comparison operators - exercise.html

035 Other comparison operators - solution.html

036 SELECT DISTINCT.mp4

02:06

036 SELECT-DISTINCT.pdf

037 SELECT DISTINCT - exercise.html

038 SELECT DISTINCT - solution.html

039 Introduction to aggregate functions.mp4

05:24

039 Introduction-to-Aggregate-Functions.pdf

040 Introduction to aggregate functions - exercise.html

041 Introduction to aggregate functions - solution.html

042 ORDER BY.mp4

03:46

043 ORDER BY - exercise.html

044 ORDER BY - solution.html

045 GROUP BY.mp4

06:00

045 GROUP-BY.pdf

046 Using Aliases (AS).mp4

02:08

047 Using Aliases (AS) - exercise.html

048 Using Aliases (AS) - solution.html

049 HAVING.mp4

03:26

049 HAVING.pdf

050 HAVING - exercise.html

051 HAVING - solution.html

052 WHERE vs HAVING- Part I.mp4

04:03

052 WHERE-vs-HAVING.pdf

053 WHERE vs HAVING- Part II.mp4

03:08

054 WHERE vs HAVING - Part II - exercise.html

055 WHERE vs HAVING - Part II - solution.html

056 LIMIT.mp4

04:52

056 LIMIT.pdf

057 LIMIT - exercise.html

058 LIMIT - solution.html

10 - SQL INSERT statement

001 The INSERT statement - Part I.mp4

06:04

001 The-INSERT-Statement.pdf

002 The INSERT statement - Part II.mp4

02:19

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.mp4

03:55

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.mp4

02:41

001 TCLs-COMMIT-and-ROLLBACK.pdf

002 The UPDATE Statement - Part I.mp4

03:17

002 The-UPDATE-Statement.pdf

003 ROLLBACK; ARTICLE.html

004 The UPDATE Statement - Part II.mp4

02:55

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.mp4

04:14

001 The-DELETE-Statement.pdf

002 The DELETE Statement - Part II.mp4

01:29

003 The DELETE Statement Part II - exercise.html

004 The DELETE Statement Part II - solution.html

005 DROP vs TRUNCATE vs DELETE.mp4

03:23

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

13 - MySQL - Aggregate functions

001 COUNT.pdf

001 COUNT().mp4

04:14

002 COUNT() - exercise.html

003 COUNT() - solution.html

004 SUM.pdf

004 SUM().mp4

01:30

005 SUM() - exercise.html

006 SUM() - solution.html

007 MIN() and MAX().mp4

01:15

007 MIN-and-MAX.pdf

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

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

010 AVG.pdf

010 AVG().mp4

01:58

011 AVG() - exercise.html

012 AVG() - solution.html

013 ROUND.pdf

013 ROUND().mp4

02:06

014 ROUND() - exercise.html

015 ROUND() - solution.html

016 COALESCE() - Preamble.html

016 COALESCE-Preamble.pdf

017 IFNULL() and COALESCE().mp4

06:24

017 IFNULL-and-COALESCE.pdf

018 Another Example of Using COALESCE().mp4

01:36

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.mp4

04:23

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.mp4

06:03

005 INNER-JOIN.pdf

006 INNER JOIN - Part II.mp4

05:34

007 INNER JOIN - Part II - exercise.html

008 INNER JOIN - Part II - solution.html

009 A Note on Using Joins.mp4

04:09

010 Duplicate Records.mp4

04:21

010 Duplicate-Records.pdf

011 LEFT JOIN - Part I.mp4

04:31

011 LEFT-JOIN.pdf

012 LEFT JOIN - Part II.mp4

05:46

013 LEFT JOIN - Part II - exercise.html

014 LEFT JOIN - Part II - solution.html

015 RIGHT JOIN.mp4

04:31

015 RIGHT-JOIN.pdf

016 The new and the old join syntax.mp4

04:17

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.mp4

02:53

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.mp4

07:42

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.mp4

02:17

029 JOIN more than two tables in SQL.mp4

04:27

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.mp4

05:39

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.mp4

05:44

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.mp4

04:31

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.mp4

03:42

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.mp4

07:57

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.mp4

07:45

17 - SQL Views

001 SQL-Views.pdf

001 Views.mp4

07:12

002 Views - exercise.html

003 Views - solution.html

18 - Stored routines

001 Introduction to stored routines.mp4

03:26

001 Introduction-to-Stored-Routines.pdf

002 The MySQL syntax for stored procedures.mp4

04:32

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

003 Stored procedures - Example - Part I.mp4

02:45

004 Stored procedures - Example - Part II.mp4

04:49

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

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

007 Another way to create a procedure.mp4

03:19

008 Stored procedures with an input parameter.mp4

06:29

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

009 Stored procedures with an output parameter.mp4

03:19

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.mp4

06:50

012 Variables.pdf

013 Variables - exercise.html

014 Variables - solution.html

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

015 User-defined functions in MySQL.mp4

06:14

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.mp4

03:55

019 Stored-Routines-Conclusion.pdf

19 - Advanced SQL Topics

001 Types of MySQL Variables - Local Variables.mp4

04:56

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

002 Session Variables.mp4

05:21

002 Session-Variables.pdf

003 Global Variables.mp4

02:18

003 Global-Variables.pdf

004 User-Defined vs System Variables.mp4

04:12

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

005 MySQL Triggers.html

005 MySQL-Triggers.pdf

005 mysql-triggers.zip

006 MySQL Triggers.mp4

12:29

007 MySQL Triggers - exercise.html

008 MySQL Triggers - solution.html

009 MySQL Indexes.mp4

07:27

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.mp4

05:57

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.mp4

01:58

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

09:11

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.mp4

02:41

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.mp4

03:51

009 MySQL Window Functions Syntax - Exercise.html

010 MySQL Window Functions Syntax - Solution.html

011 The PARTITION BY Clause VS the GROUP BY Clause.mp4

06:28

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.mp4

07:54

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.mp4

08:26

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.mp4

08:35

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.mp4

06:14

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.mp4

06:47

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.mp4

07:00

002 An Alternative Solution to the Same Task.mp4

01:53

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.mp4

05:32

006 Using Multiple Subclauses in a WITH Clause - Part II.mp4

05:19

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.mp4

03:59

22 - SQL Temporary Tables

001 MySQL Temporary Tables - Introduction.mp4

03:08

002 MySQL Temporary Tables in Action.mp4

05:12

003 MySQL Temporary Tables in Action-Exercise.html

004 MySQL Temporary Tables in Action-Solution.html

005 Other Features of MySQL Temporary Tables.mp4

07:23

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.mp4

05:20

002 Why Combining SQL and Tableau is useful.mp4

04:54

003 Installing Tableau Public.mp4

01:51

004 Loading the employees mod Database.mp4

03:22

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.mp4

05:33

002 Task 1 - Text.html

003 Important clarification!.html

004 Task 1 SQL Solution.mp4

04:41

005 Task 1 SQL Solution - Code.html

006 Transferring a Dataset from SQL to Tableau.mp4

04:13

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

06:17

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

05:25

25 - Combining SQL and Tableau - Task 2

001 Task 2.mp4

03:50

002 Task 2 - Text.html

003 Task 2 SQL Solution.mp4

03:43

004 Task 2 SQL Solution - Code.html

005 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp4

06:09

26 - Combining SQL and Tableau - Task 3

001 Task 3.mp4

02:21

002 Task 3 - Text.html

003 Task 3 SQL Solution.mp4

03:14

004 Task 3 SQL Solution - Code.html

005 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp4

04:56

27 - Combining SQL and Tableau - Task 4

001 Task 4.mp4

02:45

002 Task 4 - Text.html

003 Task 4 Solution in SQL.mp4

02:47

004 Task 4 Solution in SQL - Code.html

005 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp4

03:22

28 - Combining SQL and Tableau - Task 5

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

06:04

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

Description

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

What You'll Learn?

Become an expert in SQL
Learn how to code in SQL
Boost your resume by learning an in-demand skill
Create, design, and operate with SQL databases
Start using MySQL – the #1 Database Management System
Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
Adopt professionally tested SQL best practices
Gain theoretical insights about relational databases
Work with a sophisticated real-life database throughout the course
Get maximum preparation for real-life database management
Add data analytical tools to your skillset
Develop business intuition while solving tasks with big data
Study relational database management theory that you will need in your workplace every day
Learn how to create a database from scratch
The ability to take control of your dataset – insert, update, and delete records from your database
Be confident while working with constraints and relating data tables
Become a proficient MySQL Workbench user
Acquire top-notch coding techniques and best practices
Know how to answer specific business questions by using SQL’s aggregate functions
Handle complex SQL joins with ease
Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
Merge coding skills and business acumen to solve complex analytical problems
Become a proficient SQL user by writing flawless and efficient queries
Tons of exercises that will solidify your knowledge
The freedom to query anything you like from a database

Who is this for?

People interested in SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities

Beginners to programming

Everyone who wants to learn how to code and apply their skills in practice

What You Need to Know?

No prior experience is required. We will start from the very basics

More details

Description
How important is database management in the age of big data and analytics?
It is really important.Â Â
How many employers would be happy to hire employees who can use data for the purposes of business intelligence?Â Â
All of them. Â
How many people have these skills?
Not enough. Â
This is why now is the time to learn SQL and gain a competitive advantage in the job market. Remember, the average salary of a SQL developer is $103,400! Thatâ€™s a lucrative career.Â Â
How come?Â Â
Well, when you can work with SQL, it means you donâ€™t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making.Â Â
Worried that you have no previous experience?Â
Not an issue. We will start from the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.Â Â
Why take this course in particular? Isnâ€™t it like the rest of the SQL courses out there? Â
We would like to think it isnâ€™t. Our team worked hard to create a course that is: Â
Easy to understand Â
Time efficient and concise Â
Shows how SQL can be crucial for data analytics and business intelligenceÂ Â

Comprehensive â€“ it covers several topics not shown in other SQL coursesÂ Â

Practical â€“ it teaches you how to work with a real-life databaseÂ Â

Corresponds to professional best practices Â
Taught in MySQL â€“ The most popular SQL database management system Â
Contains plenty of downloadable exercises, course notes, and quiz questionsÂ Â
Some of these aspects have been covered in other courses. Others havenâ€™t. However, no one provides such a variety of topics in one place.Â Â Â
We firmly believe this course is the best training material out there. It is a truly interactive experience preparing you for a real-life working environment.Â Â
We love teachingÂ Â
So far, over 1,750,000 students have taken our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the most engaging content for you, our students. Our mission is to help you bridge the gap between theoretical knowledge taught at school and in universities and the practical application required at the workplace.Â Â
So, why do you need to enroll in this course and learn SQL? Â
Salary/Income. As we pointed out earlier, learning SQL is a great opportunity. There is a significant surge in demand for skills revolving around database management, database administration, and business analysis relying on data. Companies will pay top dollars for specialists who have such know-how Â
Profession of the future. In the years to come, data will only grow in importance and size. Therefore, it is great to pick up a skill that will likely increase in demand over the years to come Â
Analytical reasoning. Programming languages are a great way to train your mind. Furthermore, understanding a business task and looking for its solution through writing code can be really interesting and stimulating once you become familiar with the basics Â
What about certificates? Do you provide a certificate?
Upon completion of the course, you will be able to download a certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess. Â
Sounds awesome, right?Â Â
So, what are you waiting for? Click the â€œBuy nowâ€ button, and letâ€™s begin this journey together! Â
Who this course is for:
People interested in SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
Beginners to programming
Everyone who wants to learn how to code and apply their skills in practice

User Reviews

Rating

average 0

Total votes0

Focused display

365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 2,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, 365 focuses on the following topics on Udemy: 1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook5) Blockchain for BusinessAll of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur365 Careers’ courses are the perfect place to start.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.