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

در حال حاضر محصولی در سبد خرید شما وجود ندارد.

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
خانه » فروشگاه » SQL Beginner to Guru: MySQL Edition – Master SQL with MySQL

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
    • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 41699
    حجم: 6134 مگابایت
    مدت زمان: 680 دقیقه
    تاریخ انتشار: ۱۸ آذر ۱۴۰۳
    دسته بندی محصول
    Udemy
    Udemy
    مشاهده دوره های Udemy
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید