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

The complete Database and MYSQL course

Wilky S.

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
49 Videos (5h 12m)
    • Installation

      13:54
    • SQL BASICS

      6:42
    • Tables

      1:45
    • Sql Commands

      3:11
    • Field and row

      2:11
    • Data Integrity

      2:14
    • MYSQL

      1:51
    • Create Database

      3:28
    • Drop the database

      3:32
    • Create a table

      9:34
    • Dropping a table

      4:23
    • Insert and Select

      12:24
    • Populate one table using other table

      5:55
    • Where clause

      8:13
    • Or Operator

      2:10
    • Update

      8:39
    • Delete

      8:16
    • Like

      8:11
    • LIMIT

      3:36
    • Order By

      5:27
    • Distinct

      7:58
    • Group By

      7:49
    • Group By with where and order by

      3:22
    • Join

      9:01
    • Inner Join

      13:13
    • Left Join

      6:35
    • Right Join

      4:37
    • Self Join

      8:36
    • Cross Join

      3:10
    • Union

      7:13
    • Null and Not Null

      8:34
    • Alias

      4:39
    • Alter table

      5:38
    • Truncate

      3:59
    • Sub Queries

      10:09
    • Sub queries 2

      15:50
    • Views

      6:52
    • View

      9:18
    • Transactions

      2:58
    • Date Functions

      12:53
    • Having

      8:36
    • case

      8:31
    • Auto Increment

      6:10
    • AVG

      3:34
    • Max

      2:46
    • Min

      2:22
    • Sum

      2:38
    • NULLIF

      3:44
    • Coalesce

      5:53

About This Class

If you want to explore databases but don't  know where to start, then this course is for you. This course is a basic but has a comprehensive introduction to MySQL, And without doubt it is one of the  highly in-demand skills in the business sector today.  

If you work in IT,sales or marketing,  or you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. By getting a good grasp over the MYSQL you can open an unlimited opportunities to your way.As these days data is the big issue and everybody is running after data as it is becoming very crucial so to stand in the race ahead and be competitive you should learn it.

In this course, you will learn:

  • Basic SQL syntax
  • Analyze data using Aggregate Functions
  • Run complex queries using MySQL logical operators and string functions
  • Solve some critical and complex interview tricky questions
  • Use all the common SQL joins with confidence
  • Date functions in MYSQL
  • Various String Functions
  • Interview Questions
  • You will solve various MCQ's 

This course  also contains huge number of exercises, challenges  and opportunities for you to practice . For an example to find the highest paid person in the MNCs, the highest rated actor,Some critical information regarding the GDP's and sales and marketing and total revenue generation in the required area in a particular year.

Upon completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.

MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. 

More than 90% of the learning in this course is common in MYSQL,Oracle and POSTgre.

 You’ll also be able to integrate MySQL into complete applications and can generate some important data related to organisation performance country wise

Best of luck guys!!

Happy Coding!!

2

Students

--

Projects

0

Reviews (0)

Technology Data Science