Mastering SQL (Using MySQL, Java, and Go) (Udemy.com)

A practical course to master SQL advanced queries using MySQL, and to connect Java & Golang to MySQL & PostgreSQL

( 6 Reviews )

Created by: Kam Hojati

Produced in 2021

What you will learn

Write complex queries to address organizations business queries
Perform data analysis using SQL
Design and implement your own database (mainly using MySQL and partially using PostgreSQL)
Create tables, views, triggers, stored programs, and cursors
Design and implement four sample databases
Connect MySQL / PostgreSQL to Java and Go (Google Golang)

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 86 / 100

Course Description

Learning SQL (Structured Query Language), as the most commonly used database language, can be one of the greatest career decisions you make.
SQL is one of the most sought-after skills by hiring employers.
SQL that is the primary language responsible for managing data within a relational database management system (RDBMS) can be easily connected to any programming language.
SQL is a natural language for data analysis that is the center of every decision making process.
SQL is a productive language for writing queries and for performing CRUD (Create, Read, Update, Delete) operations on data.
SQL can be used by data scientists, data analysts, front- and back-end developers, business and systems analysts and in short anyone who's willing to analyze data.

In this practical course, you will:

Learn CRUD (Create, Read, Update, Delete) operations
Create complex queries across multiple tables
Analyze data and create reports accordingly
Write complex joins (inner, outer, full)
Write summary queries using aggregate functions
Write sub-queries
Utilize String/Numeric/Datetime functions
Analyze data, group the related data into separate entities (tables), establish relationships (1-1, 1-m, m-m) between tables, and apply referential integrity on tables
Write views, triggers, stored procedures, cursors, and stored functions
Four Comprehensive Assignments: Create four sample databases from scratch, as well as to write advanced queries for each assignment
Assignments: Learn how views, triggers, stored procedures, cursors, and stored functions can interact
Connect MySQL and PostgreSQL to Java
Connect MySQL and PostgreSQL to Go (Google Golang)

Who this course is for:

Developers, systems analysts, business analysts, or anyone willing to comfortably write SQL queries to analyze data and to address business needs
Anyone willing to create databases, tables, views, triggers, and stored programs
Anyone who wants to learn how use SQL (mainly MySQL and partially PostgreSQL) in Java and Go (Google Golang)

Time: 21h

Instructor Details

Kam Hojati

4.3 Rating
6 Reviews

Kam has been in the IT industry since 1992, filling in roles such as programmer, systems analyst, architect, and development manager.
He has professionally used programming languages such as Go, C, C++, Java, Spring Framework, SQL, JavaScript, react, and several others.
His mission is to simplify complex topics and to help others to understand and to apply those topics. He is invested in continuous learning and sharing.
Kam has a Bachelor of Science in Computer and Mathematics and also a Master of Science in Management of Technology.

Reviews

4.3

6 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Ven1980 p

videos are not clear for half of the time

By Arial Penn

Great course! Practical, organized, and easy to understand, even on challenging subjects. I felt that every lesson was important. In addition to SQL, I enjoyed the Java and Golang sections.

By Cyrus Haroon

What a great course! 100% practical based course. Very well explained, easy to understand, informative, very well organized. The Instructor implements each and every topic practically. Thank you Kam Hojati for such a great course.

By Josh Madsen

This course is well-planned and comprehensive. Theory and practice go and in hand in hand. There’s a load of examples, exercises, and a couple of comprehensive assignments to design databases from scratch. Thank you!

By William Chan

Extremely informative and very engaging. There are many examples and exercises that allow you to learn and apply basic and advanced topics.

The final inclusive assignments are also very helpful.

I also liked the programming part of the course, both using MySQL stored programs and also using Java and Golang.

By Dan Taylor

I took the course to see how to connect to mysql using golang which this course covered. I didn't realize most of the course was mostly about mysql but that is ok. I skipped that part and was able to install mysql, view and execute his example go code which provided what I was looking for.