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

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

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

01 - SQL Beginner to Guru MySQL Edition Introduction

001 GettingTheMostOutOfYourCourse.pdf

001 Getting the Most out of Your SQL Course

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

003 GitHub Workflow

004 AssignmentCreatePersonTable.pdf

004 SQL - Lets write our first SQL!

005 SQL Fiddle Assignment Review

005 example.zip

02 - Introduction to SQL

001 Introduction to SQL

002 WhatIsADatabase.pdf

002 What is a Database

003 RelationalDatabasePrinciples.pdf

003 Relational Database Principles

004 2.4AssnCreateTablesInsertData.pdf

004 Assignment Create Tables and Insert Data

005 Assignment Review Create Tables and Insert Data

005 example.zip

006 HistoryOfSQL.pdf

006 History of SQL

007 WhatIsaRDBMS.pdf

007 What is a Relational Database Management System

008 HIstoryOfMySQL.pdf

008 History of MySQL

009 RDBMSDeploymentArchtectures.pdf

009 RDBMS Deployment Architectures

010 Flashcards

010 MySQL-Flashcard.pdf

011 Conclusion

external-links.txt

03 - Installation of MySQL

001 Introduction

002 MySQLInstallationOptions.pdf

002 Review of MySQL Installation Options

003 MySQL Windows 10 Installation Quick Start.html

004 MySQL Windows 10 Installation

005 MySQL OSX Installation Quick Start.html

006 MySQL OSX Installation

007 MySQL Linux Installation Quick Start.html

008 MySQL Linux Installation Ubuntu

009 MySQL Linux Installation CentOS

external-links.txt

04 - Connecting to MySQL

001 Introduction

002 ConnectingToMySQLOverview.pdf

002 Connecting to MySQL Overview

003 MySQL Command Line for OSX and Linux

004 MySQL Command Line for Docker

005 MySQL Workbench Windows Installation Quick Start.html

006 MySQL Workbench OSX Installation Quick Start.html

007 MySQL Workbench OSX Installation

008 MySQL Workbench Linux Installation Quick Start.html

009 MySQL Workbench Linux Installation.html

05 - Selecting Data from a Single Table

001 Introduction

002 Importing the MySQL Employee Database

003 AssignmentGetRowCounts.pdf

003 Assignment use SQL to get Row Counts

005 Assignment Review - Use SQL to get Row Counts

006 Review of the SQL Select Statement

007 Selecting Specific Columns from Tables

008 Using Aliases to Name Columns

009 Using the SQL CONCAT Function to Join Columns

010 SQLArithemticOperators.pdf

010 SQL Arithmetic Operators

011 Using SQL Arithmetic Operators in Selecting Data

012 MySQLDataTypes.pdf

012 SQL Data Types

013 Formatting Date Values with MySQL

013 MySQLFormatingDates.pdf

014 Using the LEFT and RIGHT MySQL Functions

016 IntroductionToWhereClause.pdf

016 Introduction to the SQL WHERE Clause

017 SQL WHERE Clause with Equals and Not Equals

018 Using AND and OR with SQL WHERE Clause

019 Using IN and NOT IN with with SQL WHERE Clause

020 Dealing with NULL Values in SQL WHERE Clause

021 Using Greater Than and Less Than with SQL WHERE Clause

022 Using LIKE and NOT LIKE with SQL WHERE Clause

023 Using BETWEEN and NOT BETWEEN with SQL WHERE Clause

024 Ordering Results with SQL ORDER BY

025 Limit Results with SQL LIMIT Clause

026 Using SQL to Select DISTINCT Values

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

028 Assignment - Fix SQL Statements

029 Assignment Review

030 Conclusion

Files.zip

external-links.txt

06 - Grouping and Summarizing Data with SQL

001 Introduction

002 Using the SQL GROUP By clause

003 MySQLAggreateFunctiosn.pdf

003 MySQL Aggregate Functions

004 Using the SQL HAVING Clause

005 Using the SQL SUM Function

006 Using the SQL Min and Max Functions

007 Using the SQL AVG Function

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

008 SQLAssignemtnSalReportExcludingManagers.pdf

010 Assignment Review

011 Conclusion

Files.zip

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

001 Introduction

002 OverviewOfSQLJoins.pdf

002 Overview of SQL Table Joins

003 Introduction to SQL Inner Joins

004 Using Table Aliases with SQL Inner Joins

005 Limiting Columns Displayed with SQL Inner Joins

006 Using a WHERE Clause with SQL Inner Joins

007 Assignment - Create Department Employee Report

007 SQLAssignemtnEmployeeReport.pdf

008 Assignment Review - Create Department Employee Report

009 Using SQL Natural Joins

010 Using SQL Equi-Joins

011 Using SQL Union Joins

012 OtherMySQLFunctions.pdf

012 Other MySQL Functions

013 Using SQL LEFT OUTER JOINS

014 Assignment - Write SQL LEFT OUTER JOIN

014 AssnWriteOuterJoin.pdf

015 Assignment Review - Write SQL LEFT OUTER JOIN

016 Conclusion

Files.zip

08 - Using SQL to Insert Data

001 Introduction

002 Overview of the SQL Insert Statement

003 Example SQL Insert Statement

004 Specifying Columns in SQL Inserts

005 AssignmentInsertIntoDepartmentsTable.pdf

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

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

007 Using a SQL Sub-select with SQL Insert Statements

008 SQL Core Concept - Foreign Key Constraints

009 AssUseSQLInsertsCreateEmp.pdf

009 Assignment - Use SQL Inserts to create a new Employee

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

011 Conclusion

Files.zip

09 - Using SQL to Update Data

001 Introduction

002 Overview of the SQL Update Statement

003 Example SQL Update Statement

004 Assignment - Use SQL Update Statement to Change Employee Name

004 AssnUpdateEmployeeRecord.pdf

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

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

006 AssnUpdateCreateSalaryRec.pdf

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

008 Using SQL to drop the employee database

009 Assignment - Re-import the employee database

009 AssnReImportEmpDatabase.pdf

010 Assignment - Review re-import employee database

011 Conclusion

Files.zip

external-links.txt

10 - Using SQL to Delete Data

001 Introduction

002 Overview of the SQL DELETE statement

003 Example of the SQL DELETE Statement

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

004 AssnCRUDEmployeeRec.pdf

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

006 Conclusion

Files.zip

11 - Using SQL Transactions

001 Introduction

002 Introduction to SQL Transactions

002 OverviewOfSQLTransactions.pdf

003 Demonstration of Database Transactions

004 Assignment - Create Employee Using SQL Transactions

004 AssnCreateEmpWithTrans.pdf

005 Assignment Review - Create Employee Using SQL Transactions

006 Demonstration of Database Locks

007 User Defined Variables in MySQL

008 Demonstration of Lost SQL Updates

009 Using SQL Select for Update

010 Conclusion

Files.zip

external-links.txt

12 - Advanced SQL Reporting

001 Introduction to Advanced SQL Reporting

002 OverviewOfNorthwind.pdf

002 Overview of the Northwind Database

003 Assignment - Import the Northwind Database

004 Assignment Review - Import the Northwind Database

005 Assignment - Create Orders Report

005 AssnCreateOrdersReport.pdf

006 Assignment Review - Create Orders Report

007 Assignment - Monthly Sales Report by State

007 AssnCreateMonthlySalesRptByState.pdf

008 Assignment Review - Monthly Sales Report by State

009 Assignment - Create Monthly Profit Report by Item

009 AssnCreateMonthlyProfitReportByItem.pdf

010 Assignment Review - Create Monthly Profit Report by Item

011 Assignment - Create a Weekly Sales Report by Employee

011 AssnCreateWeeklySalesReportByEmployee.pdf

012 Assignment Review - Create a Weekly Sales Report by Employee

013 Weekly Sales Report by Employee Revisted

014 Conclusion

Files.zip

external-links.txt

13 - Introduction to DDL Statements - Creating SQL Views

001 Introduction to Views

002 Demonstration using SQL DDL Creating a Database View

003 Assignment - Create Orders View

003 AssnCreateOrdersView.pdf

004 Assignment Review - Create Orders View

004 examples.zip

005 MaterializedViews.pdf

005 Materialized Views in MySQL

14 - Using SQL to Create MySQL Database Tables

001 Overview of SQL Create Table Syntax

002 Creating a Table with SQL Select

003 SQL Truncate Table Command

003 TruncateTableComand.pdf

004 SQL Drop Table Command

005 SQL Create Table Example

006 SQL Create Table Example with Primary Key

007 SQL Create Table with Auto-Increment Primary Key

008 SQL Create Table with Foreign Keys

009 SQL Create Table with Indexes

010 SQL Create Table with Unique Indexes

011 Assignment - SQL Create Table

011 AssnCreateTable.pdf

012 Assignment Review - SQL Create Table

Files.zip

15 - Using SQL to Update Tables

001 Introduction to the SQL Alter Table Command

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

003 Using SQL Alter Table to Reorder Columns

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

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

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

006 AssnAddASINandUPC.pdf

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

008 Using SQL Alter Table for MySQL Generated Columns

Files.zip

16 - Appendix A

001 Udemy Interface Explained - For new Udemy Users.html

002 GitHub Basics.html

003 GitHub Workflow

189,000 تومان

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

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

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

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