Tutorialspoint
Freedom Sales | Secure your Future with Latest Skills | Get 10% OFF on checkout, Use CODE "FREEDOM"
Sales End on 17th August

MySQL Technologies Pack

Get a Hands-On experience of MySQL with 6 Courses & an E-Book

Tutorialspoint

    • Video
      Relational Database Design Essentials
      • Introduction about the course
      • Oracle SQL Data Modeler
        • Oracle SQL Data Modeler 02:58
      • Data Modeling and Data Base Design
        • Importance of Data Modeling and Data base Design 04:24
        • Introduction to Data Modeling and Data base design 10:09
        • Navigation Overview of Oracle SQL Data Modeler 04:51
      • Process Model - Data Flow diagram using Oracle SQL Modeler
        • Dataflow Diagram - Overview Presentation 07:20 Preview
        • Process Model - Data flow diagram - Demonstration 1 12:26
        • Process Model - Dataflow Diagram - Demonstration 2 05:34
        • Case lite - Process model - Data flow diagram 02:35
        • Case lite - Process model - Data flow diagram - Solution 08:57
      • Logical Model - ERD using Oracle SQL Modeler
        • What is Entity Relationalship Diagram - Overview - Part 1 07:01
        • Whats Entity Relation Diagram - Overview Part 2 06:34
        • Logical Model - Navigation Overview : SQL Modeler 04:43
        • Logical Model - ERD using Oracle SQL Modeler - Part 1 13:04
        • Logical Model - ERD using Oracle SQL Modeler - Part 2 06:12
        • SQL Modeler - Subview ERD 06:14
      • Relational Database - Normalization Process
        • Database Design through Normalization - An overview 10:00
        • Normalization - First Form 04:16
        • Normalization - Second Form 06:13
        • Normalization - Third form 08:01
      • Logical to Relational Model with DDL scripts using Oracle SQL modeler
        • Engineer Logical to Relational Model through SQL Modeler 07:58
        • DDL script creation & script execution 04:11
        • Importing Database Datamodel structure 05:33
      • Other Important features of SQL modeler
        • Business Information 05:01
        • Design rules - validation 05:07
        • Other features in SQL Modeler 02:32
    • Video
      Learn MySQL - For Beginners
      • MySQL Database Integration
        • Introduction to MySQL Databases 02:40 Preview
        • Introduction PhpMyAdmin 02:35 Preview
        • PhpMyAdmin Interface Overview 01:12 Preview
        • MySQL Security and Root Superuser 05:02
        • MySQL Creating a Database and Table 05:24
        • MySQL Creating a New User 05:33
        • MySQL Database and Table Specific Privileges 03:05
        • MySQL Modifying and Deleting a Table 04:30
        • MySQL Modifying and Deleting a Database 04:07
        • Introduction to SQL 01:35
        • SQL Statements in PhpMyAdmin 04:05
        • Connect to MySQL Database using PHP 05:02
        • MySQL Database - Import Data 01:43
        • SQL Select 02:27
        • SQL Distinct Keyword 01:45
        • SQL Where Clause 01:40
        • SQL And Operator 01:42
        • SQL Or Operator 01:01
        • SQL Order By 01:36
        • MySQL Insert Into 06:28
        • MySQL Get Last ID 01:27
        • MySQL Insert Multiple Records 01:44
        • MySQL Prepared Statements 02:45
        • MySQL Delete Records 07:49
        • PHP Header Function 01:17
        • PHP Isset 02:34
        • MySQL Update Records 07:06
    • Video
      Basic Concepts of MySQL Database
      • Introduction on MySQL Database
        • Introduction on MySQL Database 59:39 Preview
        • Course Resources
        • Data Types 51:11 Preview
        • Select Statements 59:19 Preview
        • Backticks 14:35 Preview
        • Usage of NULL 18:16
        • Limit and OffSet 13:20
        • Creating Databases 17:52
        • Using Variables 24:44
        • Commenting in MySQL 13:31
        • Inserting Data in MySQL 28:45
        • Deleting Data in MySQL 20:36
        • Updating in MySQL 19:59
        • Order by Clause in MySQL 07:54 Preview
        • Group by Statements 17:42
        • Errors in MySQL 10:18
        • Joins 37:15
        • Joins continued 10:39
        • Union 18:22
        • Arithmetic 19:38
        • String Operations 32:53
        • Date and Time Operations 07:48
        • Handling Time Zones 07:02
        • Regular Expressions 19:21
        • Views 19:31
        • Table Creation 22:50
        • Altering a Table 22:41
        • Dropping a Table 05:29
        • MySQL Lock Table 09:38
        • Error Codes 07:48
        • Stored Routines 29:08
        • Indexes and Keys 24:07
        • Full Text Search 17:55
        • Prepare Statements 09:09
        • JSON Introduction 10:38
        • Extract values from JSON types 05:15
        • MySQL Admin 08:00
        • Triggers 12:15
        • Configuration and Tuning 07:19
        • Events 08:12
        • ENUM 09:12
        • Collations, Transactions, Log files, Replication, Backup 40:42
    • Video
      Learn Database Design with MySQL
      • Introduction
      • Getting Started With MySQL
        • Windows Installation 10:37
        • Linux Installation 04:10
        • Environment Setup With Xampp 07:11
        • PHPMyAdmin 13:14
        • MySQL Workbench Setup 10:38
      • Planning & Design
        • Principles & Normalization 10:58
        • Database Design Process 05:17
        • Map Out Structure 14:58
      • Creating A Database
        • Create Tables & Columns 12:23
        • Importing & Exporting 05:16
        • Relations & Foriegn Keys 13:15
        • Junction Tables 04:46
      • SQL Fundamentals
        • Command Line & Inserting Data 28:58
        • Basic Select Queries 14:45
        • Updating & Deleting Data 09:06
        • Aliases & Joins 18:38
      • Advanced SQL
        • Union, Concat & Count 11:18
        • Using The IN Clause 09:11
        • Math & Subqueries 09:43
        • Using Group By 07:29
      • PHP & MySQL
        • PHP Fundamentals 20:59
        • Template & MySQL Connect 19:03
        • Select & Display With PHP 16:55
        • Insert Data With PHP 29:20
        • Update & Delete With PHP 22:58
        • Wrap up 03:49
    • Video
      Database Management Systems - MySQL
      • Database Management Systems - MySQL
        • Introduction to DBMS 50:22
        • Structured Query Language, MySQL Installation & Normalization 41:35
        • Data Definition Language Commands 02:24
        • Data Manipulation Language Commands 47:29
        • Sub Queries & Constraints 16:07
        • Aggregate Functions, Clauses & Views 07:21
    • Video
      MySQL Database Development Mastery
      • Introduction
        • Introduction to MySQL Server and Databases 06:33 Preview
        • Download and Install MySQL Server and MySQL Workbench 12:23
      • Manipulating Tables and Data - CRUD Operations
        • Connect and Create a Database 12:50 Preview
        • Drop or Remove Database 03:40
        • Create an SQL Database Table 22:59
        • Insert Data into the Table with SQL Script 08:49
        • Insert Data into the Table with Workbench 09:04
        • Select Data from the Table with SQL Script 08:09
        • Select Data with Filters 19:53
        • Update Data in the Table 08:33
        • Delete Data from the Table 10:20
        • Reverse Engineer Database into Model 06:54
        • Forward Engineer Data Model into Database 11:44
      • Relationships and Foreign Keys
        • What are Relationships, Foreign Keys and Normalization 10:49 Preview
        • Create Relationships with Data Modelling 15:28
        • Create Relationships with Workbench Table Design Tool 20:24
        • Insert Records in Related Tables 08:55
        • Run Queries on Related Tables (Inner Joins) 15:21
        • Left, Right and Cross Joins 07:07
      • Aggregate Functions
        • Grouping Data using SQL GROUP BY Clause 09:52
        • SQL AVG Aggregate Function 09:00
        • SQL COUNT Aggregate Function 07:44
        • SQL MIN & MAX Aggregate Functions 02:53
        • SQL SUM Aggregate Function 05:18
        • Splitting Groups using HAVING Clause 04:33
    • eBook
      MySQL Tutorial
  • Description

    Overview:

    Learn SQL from Basic MySQL Database Operations to Database Management Systems - MySQL, Fundamental Database Development Techniques with MySQL Server And Workbench, Oracle SQL Data Modeler, Data Modelling and Design, SQL Essentials.


    • 6 Modules
    • 158+ Lectures
    • 30+ Hrs HD Videos
    • Course Designed by Industry Experts
    • Up-to-Date Curriculum
    • 1 eBook
    • Full Lifetime Access
    • 30 Days Refund Policy
    • Certificate on Completion


    About Premium Pack:

    Welcome to our SQL Premium Pack. We have designed our courses in such a way that individuals can get the insights to turn raw data into actionable insights. Our Course is not only for  software engineers and system administrators and it also helps analysts to gain important insights into new marketplaces and make more informed strategic decisions.


    Scope of SQL:

    • SQL is a massive technology and it is not permitted in computer science and can be seen in  Retail, Finance, Healthcare, Science & Technology, Public Sector.
    • Average SQL Developer earns $88,334 per year.
    • SQL ( Structured Query Language ) is Needed for Data Scientists to get the data and to work with that data.

    Goals

    • Database Design Process, Normalization, Database Development using MySQL
    • Master SQL using PHP
    • Understand and develop business process models( data flow diagrams) through Oracle SQL modeler.
    • Basics of MySQL Database and Syntax
    • Effective creation of Process models, Logical data models and Relational data models
    • Database Normalization with Examples - 1st, 2nd and 3rd form of Normalization
    • MySQL Database Administration and PhpMyAdmin Fundamentals
    • MySQL Security and Root Superuser and Updating Data in MySQL DB
    • Fundamentals and Overview of DBMS course
    • Database Design - Beginner to Advance Level

    Prerequist

    • Basic Computer Skills
    • Basic Mathematics skills might be beneficial
    • Understanding of Basic web terminology
    • A Reliable Computer
MySQL Technologies Pack
This Prime Pack Includes :

31.5 hours

6 Video Courses

1 eBooks

Lifetime Access
Preview

Preview