Mastering SQL (Using MySQL, Java, and Go)
- 4.9
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
A practical course to master SQL advanced queries using MySQL, and to connect Java & Golang to MySQL & PostgreSQLDescription
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)
Requirements
- Requirements
- To learn SQL, all you need is some general computer knowledge, and time and patience to learn the topics and to work on exercises and assignments
- To connect MySQL and PostgreSQL to Java, you'll need prior Java experience, but code will be explained in detail
- To connect MySQL and PostgreSQL to Go (Google Golang), you'll need prior Go experience, but code will be explained in detail
Kam Hojati
4.9 Raiting
Java In-Depth: Become a Complete Java Engineer!
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Comprehensive Java programming course integrated with design principles, best practices & instructor-led Java EE project Here is what some of the students had to say:...
Mastering Data Analysis in Excel
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Unlock the power of Excel to utilize its analytical tools from Vlookup to Pivot Table - no matter your experience level...
Become a Blockchain Expert (BE I) | Bitcoin & Cryptocurrency
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn Blockchain, Cryptocurrency, Bitcoin, Mining, Altcoin, Wallet, Exchange from the Best Course for Crypto Beginners ★★★★★ "Cem is a well renowned figure in the blockchain and crypto industry....
Power BI: From Zero to Hero
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Start from scratch and in a short time become an advanced user of Power BI for analysing and visualizing data Become an expert of Power BI in a short period....
