SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

Focused View

John Thompson • 470,000+ Enrollments Worldwide

11:19:29

0 View

01 - SQL Beginner to Guru MySQL Edition Introduction

001 GettingTheMostOutOfYourCourse.pdf

001 Getting the Most out of Your SQL Course.mp4

04:04

002 Slack Group for SQL Beginner to Guru MySQL Edition.html

003 GitHub Workflow.mp4

12:20

004 AssignmentCreatePersonTable.pdf

004 SQL - Lets write our first SQL!.mp4

07:46

005 SQL Fiddle Assignment Review.mp4

03:17

005 example.zip

02 - Introduction to SQL

001 Introduction to SQL.mp4

01:03

002 WhatIsADatabase.pdf

002 What is a Database.mp4

08:35

003 RelationalDatabasePrinciples.pdf

003 Relational Database Principles.mp4

13:08

004 2.4AssnCreateTablesInsertData.pdf

004 Assignment Create Tables and Insert Data.mp4

02:33

005 Assignment Review Create Tables and Insert Data.mp4

03:27

005 example.zip

006 HistoryOfSQL.pdf

006 History of SQL.mp4

13:31

007 WhatIsaRDBMS.pdf

007 What is a Relational Database Management System.mp4

11:19

008 HIstoryOfMySQL.pdf

008 History of MySQL.mp4

10:41

009 RDBMSDeploymentArchtectures.pdf

009 RDBMS Deployment Architectures.mp4

09:25

010 Flashcards.mp4

04:52

010 MySQL-Flashcard.pdf

011 Conclusion.mp4

00:35

external-links.txt

03 - Installation of MySQL

001 Introduction.mp4

01:45

002 MySQLInstallationOptions.pdf

002 Review of MySQL Installation Options.mp4

03:26

003 MySQL Windows 10 Installation Quick Start.html

004 MySQL Windows 10 Installation.mp4

06:07

005 MySQL OSX Installation Quick Start.html

006 MySQL OSX Installation.mp4

06:05

007 MySQL Linux Installation Quick Start.html

008 MySQL Linux Installation Ubuntu.mp4

03:21

009 MySQL Linux Installation CentOS.mp4

04:51

external-links.txt

04 - Connecting to MySQL

001 Introduction.mp4

01:17

002 ConnectingToMySQLOverview.pdf

002 Connecting to MySQL Overview.mp4

07:45

003 MySQL Command Line for OSX and Linux.mp4

05:06

004 MySQL Command Line for Docker.mp4

07:47

005 MySQL Workbench Windows Installation Quick Start.html

006 MySQL Workbench OSX Installation Quick Start.html

007 MySQL Workbench OSX Installation.mp4

07:14

008 MySQL Workbench Linux Installation Quick Start.html

009 MySQL Workbench Linux Installation.html

05 - Selecting Data from a Single Table

001 Introduction.mp4

02:51

002 Importing the MySQL Employee Database.mp4

06:44

003 AssignmentGetRowCounts.pdf

003 Assignment use SQL to get Row Counts.mp4

00:47

005 Assignment Review - Use SQL to get Row Counts.mp4

02:22

006 Review of the SQL Select Statement.mp4

05:13

007 Selecting Specific Columns from Tables.mp4

01:56

008 Using Aliases to Name Columns.mp4

02:54

009 Using the SQL CONCAT Function to Join Columns.mp4

02:26

010 SQLArithemticOperators.pdf

010 SQL Arithmetic Operators.mp4

02:26

011 Using SQL Arithmetic Operators in Selecting Data.mp4

07:14

012 MySQLDataTypes.pdf

012 SQL Data Types.mp4

16:24

013 Formatting Date Values with MySQL.mp4

06:45

013 MySQLFormatingDates.pdf

014 Using the LEFT and RIGHT MySQL Functions.mp4

04:02

016 IntroductionToWhereClause.pdf

016 Introduction to the SQL WHERE Clause.mp4

08:44

017 SQL WHERE Clause with Equals and Not Equals.mp4

03:19

018 Using AND and OR with SQL WHERE Clause.mp4

03:52

019 Using IN and NOT IN with with SQL WHERE Clause.mp4

05:03

020 Dealing with NULL Values in SQL WHERE Clause.mp4

03:27

021 Using Greater Than and Less Than with SQL WHERE Clause.mp4

04:00

022 Using LIKE and NOT LIKE with SQL WHERE Clause.mp4

03:49

023 Using BETWEEN and NOT BETWEEN with SQL WHERE Clause.mp4

04:30

024 Ordering Results with SQL ORDER BY.mp4

04:30

025 Limit Results with SQL LIMIT Clause.mp4

06:19

026 Using SQL to Select DISTINCT Values.mp4

02:12

027 Using SQL Sub-selects with IN in SQL Where Clause.mp4

03:12

028 Assignment - Fix SQL Statements.mp4

02:05

029 Assignment Review.mp4

08:44

030 Conclusion.mp4

02:18

Files.zip

external-links.txt

06 - Grouping and Summarizing Data with SQL

001 Introduction.mp4

01:00

002 Using the SQL GROUP By clause.mp4

02:49

003 MySQLAggreateFunctiosn.pdf

003 MySQL Aggregate Functions.mp4

02:03

004 Using the SQL HAVING Clause.mp4

04:17

005 Using the SQL SUM Function.mp4

02:00

006 Using the SQL Min and Max Functions.mp4

05:50

007 Using the SQL AVG Function.mp4

03:55

008 Assignment - Write SQL Report for Salary Information by Year Excluding Managers.mp4

01:58

008 SQLAssignemtnSalReportExcludingManagers.pdf

010 Assignment Review.mp4

04:12

011 Conclusion.mp4

00:34

Files.zip

07 - Using SQL to Select Data from More Than One Table

001 Introduction.mp4

01:15

002 OverviewOfSQLJoins.pdf

002 Overview of SQL Table Joins.mp4

05:13

003 Introduction to SQL Inner Joins.mp4

03:34

004 Using Table Aliases with SQL Inner Joins.mp4

03:38

005 Limiting Columns Displayed with SQL Inner Joins.mp4

03:02

006 Using a WHERE Clause with SQL Inner Joins.mp4

04:33

007 Assignment - Create Department Employee Report.mp4

01:44

007 SQLAssignemtnEmployeeReport.pdf

008 Assignment Review - Create Department Employee Report.mp4

06:52

009 Using SQL Natural Joins.mp4

03:10

010 Using SQL Equi-Joins.mp4

04:48

011 Using SQL Union Joins.mp4

05:04

012 OtherMySQLFunctions.pdf

012 Other MySQL Functions.mp4

08:55

013 Using SQL LEFT OUTER JOINS.mp4

05:09

014 Assignment - Write SQL LEFT OUTER JOIN.mp4

01:32

014 AssnWriteOuterJoin.pdf

015 Assignment Review - Write SQL LEFT OUTER JOIN.mp4

06:13

016 Conclusion.mp4

01:31

Files.zip

08 - Using SQL to Insert Data

001 Introduction.mp4

00:44

002 Overview of the SQL Insert Statement.mp4

02:44

003 Example SQL Insert Statement.mp4

02:38

004 Specifying Columns in SQL Inserts.mp4

04:05

005 AssignmentInsertIntoDepartmentsTable.pdf

005 Assignment - Use SQL to create a record in DEPARTMENTS table.mp4

00:45

006 Assignment Review - Use SQL to create a record in DEPARTMENTS table.mp4

05:07

007 Using a SQL Sub-select with SQL Insert Statements.mp4

04:02

008 SQL Core Concept - Foreign Key Constraints.mp4

04:24

009 AssUseSQLInsertsCreateEmp.pdf

009 Assignment - Use SQL Inserts to create a new Employee.mp4

00:51

010 Assignment Review - Use SQL Inserts to create a new Employee.mp4

06:23

011 Conclusion.mp4

00:59

Files.zip

09 - Using SQL to Update Data

001 Introduction.mp4

01:23

002 Overview of the SQL Update Statement.mp4

03:55

003 Example SQL Update Statement.mp4

03:07

004 Assignment - Use SQL Update Statement to Change Employee Name.mp4

00:48

004 AssnUpdateEmployeeRecord.pdf

005 Assignment Review - Use SQL Update Statement to Change Employee Name.mp4

02:22

006 Assignment - Using SQL Update and Insert to Create a New Salary Record.mp4

01:40

006 AssnUpdateCreateSalaryRec.pdf

007 Assignment Review - Using SQL Update and Insert to Create a New Salary Record.mp4

03:35

008 Using SQL to drop the employee database.mp4

02:49

009 Assignment - Re-import the employee database.mp4

00:43

009 AssnReImportEmpDatabase.pdf

010 Assignment - Review re-import employee database.mp4

03:26

011 Conclusion.mp4

00:40

Files.zip

external-links.txt

10 - Using SQL to Delete Data

001 Introduction.mp4

01:00

002 Overview of the SQL DELETE statement.mp4

02:33

003 Example of the SQL DELETE Statement.mp4

09:42

004 Assignment - Create, Update, and Delete an Employee record.mp4

01:20

004 AssnCRUDEmployeeRec.pdf

005 Assignment Review - Create, Update, and Delete an Employee Record.mp4

04:05

006 Conclusion.mp4

00:36

Files.zip

11 - Using SQL Transactions

001 Introduction.mp4

01:32

002 Introduction to SQL Transactions.mp4

10:15

002 OverviewOfSQLTransactions.pdf

003 Demonstration of Database Transactions.mp4

06:10

004 Assignment - Create Employee Using SQL Transactions.mp4

01:20

004 AssnCreateEmpWithTrans.pdf

005 Assignment Review - Create Employee Using SQL Transactions.mp4

04:41

006 Demonstration of Database Locks.mp4

05:16

007 User Defined Variables in MySQL.mp4

05:25

008 Demonstration of Lost SQL Updates.mp4

05:18

009 Using SQL Select for Update.mp4

04:58

010 Conclusion.mp4

01:57

Files.zip

external-links.txt

12 - Advanced SQL Reporting

001 Introduction to Advanced SQL Reporting.mp4

02:56

002 OverviewOfNorthwind.pdf

002 Overview of the Northwind Database.mp4

03:00

003 Assignment - Import the Northwind Database.mp4

03:40

004 Assignment Review - Import the Northwind Database.mp4

04:00

005 Assignment - Create Orders Report.mp4

02:11

005 AssnCreateOrdersReport.pdf

006 Assignment Review - Create Orders Report.mp4

10:01

007 Assignment - Monthly Sales Report by State.mp4

00:58

007 AssnCreateMonthlySalesRptByState.pdf

008 Assignment Review - Monthly Sales Report by State.mp4

07:23

009 Assignment - Create Monthly Profit Report by Item.mp4

01:06

009 AssnCreateMonthlyProfitReportByItem.pdf

010 Assignment Review - Create Monthly Profit Report by Item.mp4

10:37

011 Assignment - Create a Weekly Sales Report by Employee.mp4

02:07

011 AssnCreateWeeklySalesReportByEmployee.pdf

012 Assignment Review - Create a Weekly Sales Report by Employee.mp4

11:09

013 Weekly Sales Report by Employee Revisted.mp4

04:14

014 Conclusion.mp4

01:28

Files.zip

external-links.txt

13 - Introduction to DDL Statements - Creating SQL Views

001 Introduction to Views.mp4

00:50

002 Demonstration using SQL DDL Creating a Database View.mp4

02:53

003 Assignment - Create Orders View.mp4

01:53

003 AssnCreateOrdersView.pdf

004 Assignment Review - Create Orders View.mp4

04:48

004 examples.zip

005 MaterializedViews.pdf

005 Materialized Views in MySQL.mp4

02:33

14 - Using SQL to Create MySQL Database Tables

001 Overview of SQL Create Table Syntax.mp4

04:34

002 Creating a Table with SQL Select.mp4

02:35

003 SQL Truncate Table Command.mp4

02:50

003 TruncateTableComand.pdf

004 SQL Drop Table Command.mp4

03:27

005 SQL Create Table Example.mp4

04:47

006 SQL Create Table Example with Primary Key.mp4

03:43

007 SQL Create Table with Auto-Increment Primary Key.mp4

05:15

008 SQL Create Table with Foreign Keys.mp4

04:33

009 SQL Create Table with Indexes.mp4

03:57

010 SQL Create Table with Unique Indexes.mp4

04:31

011 Assignment - SQL Create Table.mp4

02:48

011 AssnCreateTable.pdf

012 Assignment Review - SQL Create Table.mp4

09:22

Files.zip

15 - Using SQL to Update Tables

001 Introduction to the SQL Alter Table Command.mp4

03:48

002 Using SQL Alter Table Command to Add and Remove a Column.mp4

02:57

003 Using SQL Alter Table to Reorder Columns.mp4

03:30

004 Using SQL Alter Table Command to Add or Remove an Index.mp4

04:12

005 Using SQL Alter Table Command to Add or Remove a Foreign Key Constraint.mp4

04:04

006 Assignment - Add ASIN, UPC, and EAN to Book Table using SQL Alter Table Command.mp4

02:17

006 AssnAddASINandUPC.pdf

007 Assignment Review - Add ASIN, UPC, EAN to Book Table using SQL Alter Table Cmd.mp4

03:11

008 Using SQL Alter Table for MySQL Generated Columns.mp4

05:24

Files.zip

16 - Appendix A

001 Udemy Interface Explained - For new Udemy Users.html

002 GitHub Basics.html

003 GitHub Workflow.mp4

12:20

Description

SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!

What You'll Learn?

Become a SQL Guru! Be that 'go-to' person!
Master SQL to create reports from realistic MySQL databases
See how to aggregate and analyze data using SQL functions
Create your own database through the power of SQL
Understand How to Leverage Database Transactions
Tune SQL statements for optimum performance
Avoid common mistakes with SQL

Who is this for?

Anyone wishing to learn how to use SQL!

What You Need to Know?

Just a computer - Any modern PC, Mac or Linux system will work!

Fundamental computer skills are helpful (you understand what files and directories are)

More details

Description
SQLÂ is the programming language used to get data in and out of databases.Â Relational Databases are extremely popular with companies of all sizes.
Employers are searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'. You will see 10's of THOUSANDSÂ of job postings.
Right now these positions are going unfilled - because companies cannot find enough people with SQLÂ skills.
In this course, you will learn how to use SQLÂ using the MySQLÂ relational database - the most popular database in the world.
No previous SQLÂ experience is needed. This course is perfect for beginners.Â
In this course, you will:
Learn how to install MySQL on your computer.
Learn how to install MySQL Workbench on your computer.
See how to import the famous MySQL employee database into your MySQL database.
Get hands on experience generating SQLÂ reports.
Master SQL join statements.
Create table joins using database tables with MILLIONS of records!
See how easy it is to use SQL to update one record or many records in the database.
Learn to use SQLÂ Sub-Selects.
Write advanced SQL reports against a ecommerce database.
Understand what database transactions are, and the tools you have to control them with MySQL.
Use SQL to createÂ tables in your MySQL database.
Learn the MySQL syntax to alter existing database tables.
TackleÂ challenging real world like assignments for SQLÂ reporting and database maintenance tasks.Â
Leverage using SQLÂ views for common reports.
Course Extras
Slack Community - Join the instructor, teacher's assistants, and other students in a Slack Community exclusive to this course!
All Source Code in GitHub - Get access to all source code used in course via GitHub (no experience with GitHub necessary)
All Lecture Slides Downloadable as PDFs - Download lecture slides for study and future reference!
Other Databases?
This course is focused on using SQLÂ with the MySQL database.Â
SQLÂ is a standard, which which is supported by many other databases. The SQLÂ skills you learn in this course can be applied to other databases such as Postgres, Oracle, and MSÂ SQL Server.
There is a ton of demand for people with SQL skills. In the US, there are over 100,000 job openings for people with SQLÂ skills.
Through this course, you will master SQL.Â
Open the door toÂ new opportunities and enroll today!
Who this course is for:
Anyone wishing to learn how to use SQL!

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

John Thompson • 470,000+ Enrollments Worldwide

Instructor's Courses

Hi. I'm John.I've been in the IT industry for over 25 years. Today, I specialize mainly in Java, the most successful and widely known programming language in use today. I also specialize with the Spring Framework, which the most popular open source application framework for building enterprise class applications on the Java platform. Just some of the organizations I've worked with include Visa, Kohls, Federal Home Loan Bank, and Belk Department Stores.Through the courses I'm providing, I hope to leverage my years of experience to accelerate your learning of the Spring Framework. I'm not going to lie to you. The Spring Framework is a big framework. The environment for enterprise Java is even bigger. If you're new to Java, you have a lot to learn. I hope through the content on this web site I can accelerate your education of the Java and Spring landscape.

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.