Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

SQL Tutorial: Learn SQL with MySQL Database - Beginners to Expert

Pradnyankur Nikam, Freelancer PHP & WordPress developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
115 Videos (8h 50m)
    • Course Introduction

      1:13
    • What is SQL

      2:23
    • Who should learn SQL

      2:17
    • Install MySQL on Windows Operating System

      13:31
    • Install MySQL on Mac Operating System

      12:49
    • Install MySQL on Linux Operating System

      6:58
    • Add New Database User and Set Privileges

      10:04
    • MySQL shortcut for Windows users

      6:40
    • What is DBMS and RDBMS

      3:02
    • Database Engine Database Server and Database Software

      2:31
    • What is database How to create database

      5:53
    • What is database table How to create database table

      8:44
    • How to add the data rows to database table

      7:19
    • Understand Keywords Identifiers Constants and Clauses

      2:56
    • Learn about SQL Statements

      1:30
    • Data Definition Language and Data Manipulation Language

      2:34
    • Create example databases tables and data rows

      10:50
    • Learn about SQL SELECT Clause

      5:33
    • SQL SELECT DISTINCT Statement

      5:16
    • Learn about SQL FROM Clause

      3:10
    • Learn about SQL WHERE Clause

      4:56
    • SQL True Condition

      4:18
    • SQL False Condition

      4:42
    • SQL AND Operator

      5:59
    • SQL OR Operator

      6:58
    • SQL IN Operator

      5:09
    • SQL EXISTS Condition

      7:49
    • SQL NOT IN or NOT EXISTS Conditions

      4:48
    • SQL Comparison Operators

      4:17
    • SQL LIKE Operator

      5:40
    • SQL BETWEEN Operator

      4:35
    • SQL Numeric Operators

      4:14
    • SQL Concatenation Operator

      2:22
    • SQL Temporal Operator

      1:59
    • Learn about SQL GROUP BY Clause

      7:34
    • Learn about SQL HAVING Clause

      5:45
    • Learn about SQL ORDER BY Clause

      4:53
    • SQL LIMIT or TOP Clause

      2:55
    • SQL Wildcards

      4:56
    • SQL Aliases

      6:05
    • SQL Dates

      4:07
    • Add the data rows in a table using INSERT INTO Statement

      6:04
    • SQL INSERT INTO SELECT Statement

      6:10
    • Update data rows using UPDATE Statement

      7:10
    • Delete data rows using DELETE Statement

      3:38
    • What is SQL Injection and How to secure a database

      5:49
    • What are JOINS in SQL Types of SQL JOINS

      5:01
    • Learn about INNER JOIN in SQL

      10:32
    • Learn about LEFT OUTER JOIN in SQL

      7:31
    • Learn about RIGHT OUTER JOIN in SQL

      7:32
    • Learn about FULL OUTER JOIN in SQL

      3:52
    • Learn about CROSS JOIN in SQL

      4:29
    • SQL UNION Operator

      4:31
    • SQL VIEWS

      8:12
    • Derived Tables or Inline Views

      5:22
    • Functions in SQL and Types of SQL functions

      1:17
    • SQL COUNT Function

      5:44
    • SQL FIRST Function

      2:26
    • SQL LAST Function

      2:47
    • SQL SUM Function

      2:52
    • SQL MIN Function

      3:27
    • SQL MAX Function

      3:14
    • SQL AVG Function

      3:12
    • SQL UCASE Function

      2:27
    • SQL LCASE Function

      2:13
    • SQL MID Function

      2:51
    • SQL LEN Function

      2:25
    • SQL ROUND Function

      3:23
    • SQL FORMAT Function

      2:48
    • SQL SUBSTRING Function

      3:05
    • SQL COALESCE Function

      2:43
    • SQL CHAR LENGTH Function

      2:45
    • SQL CAST Function

      3:41
    • SQL CASE Function

      6:25
    • SQL NULLIF Function

      6:12
    • What is data type in SQL

      2:04
    • Integer Numbers in SQL Exact Values

      3:01
    • Fixed Point Numbers in SQL Exact Values

      3:30
    • Floating Point Numbers in SQL Approximate Values

      3:12
    • CHAR and VARCHAR in SQL String Values

      2:47
    • NCHAR and NVARCHAR in SQL String Values

      1:12
    • CLOB and BLOB in SQL String Values

      0:57
    • DATE TIME and TIMESTAMP in SQL Temporal Values

      1:33
    • Learn how to create and display databases

      4:11
    • Select and use existing database

      2:45
    • Remove or delete database from database management system

      2:57
    • Learn how to create the database table using right method

      3:41
    • Modify or update the database table details

      6:10
    • Remove or delete an existing table

      2:16
    • Understand Constraints in SQL

      1:00
    • NOT NULL Constraint in SQL

      8:05
    • UNIQUE Constraint in SQL

      6:45
    • PRIMARY KEY Constraint in SQL

      3:23
    • FOREIGN KEY Constraint in SQL

      10:32
    • CHECK Constraint in SQL

      0:55
    • DEFAULT Constraint in SQL

      4:19
    • AUTO INCREMENT or SEQUENCE in SQL

      4:03
    • Understand Database Relationship in SQL

      1:43
    • One to One 1 1 Relationship in SQL

      8:45
    • One to Many 1 M Relationship in SQL

      5:27
    • Many to Many M M Relationship in SQL

      7:08
    • What is Database Normalization in SQL

      2:32
    • First Normal Form 1NF in database normalization

      1:14
    • Second Normal Form 2NF in database normalization

      1:30
    • Third Normal Form 3NF in database normalization

      1:19
    • What is SQL Export and Import

      1:17
    • How to Export the database using SQL statement

      8:32
    • How to Import the database using SQL statement

      5:16
    • What is MySQL Workbench

      5:14
    • Create a new user and connect to database using MySQL Workbench

      4:20
    • Create Alter Drop database using MySQL Workbench

      3:38
    • Create Alter Drop table using MySQL Workbench

      7:34
    • Insert Read Update Delete data rows using MySQL Workbench

      4:19
    • Database Export and Import using MySQL Workbench

      8:07
    • SQL Tutorial Thank You

      1:20

About This Class

Learn SQL and Database Development: The class contains SQL tutorials for learning Structured Query Language using MySQL Database. You will understand how SQL works and learn effective database design for your applications. In this course we will learn SQL with practical example on every topic.

The course covers Database Installation and SQL fundamentals, Data Definition Language(DDL) and Data Manipulation Language(DML), SQL Joins, SQL functions and SQL data types, Database Relationships and Database Normalization, Database Export and Import, MySQL workbench etc.

Enroll to this class now and learn SQL today!!!

29

Students

--

Projects

0

Reviews (0)

Pradnyankur Nikam

Freelancer PHP & WordPress developer

Hello World! My name is Pradnyankur Nikam. A freelancer, PHP and WordPress developer from Pune, Maharashtra, India. I am a post graduate working as a freelancer since 2007.

I've 7+ years of practical experience in web designing & development, SEO (Search Engine Optimization), SMO (Social Media Optimization), SMM (Social Media Marketing), Online Marketing etc. I design websites and web applications for my clients using HTML5, CSS3, JavaScript, JQuery, Ajax, PHP, MySQL, WordPress. I'm al...

See full profile