Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
IT & Software
Other IT & Software
MySQL
Mastering SQL (Using MySQL, Java, and Go)

Mastering SQL (Using MySQL, Java, and Go)

Loại khoá học: Other IT & Software

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

image
50.000 VND
999.000 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

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)




Bạn sẽ học được gì

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)

Yêu cầu

  • 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

Nội dung khoá học

20 sections

Introduction & Installation

7 lectures
Welcome to The Mastering SQL (Using MySQL, Java, and Go)
02:48
Sample Course Lectures (Only For Prospective Students)
16:26
A Brief History of SQL and MySQL
02:17
Database Concepts - Part 1 (Data and Tables)
02:31
Database Concepts - Part 2 (Columns, Rows, Tables, and Databases)
03:20
Database Concepts - Part 3 (DBMS, RDBMS, CRUD, and an Example) - Exercise
05:51
MySQL Installation on Windows
08:05

Your First Database

7 lectures
Section Introduction
00:26
First Data Types (INT and VARCHAR)
01:37
Creating & Managing Your First Database
06:57
Creating & Managing Your First Tables
09:02
Inserting Data into Tables
12:35
Querying Data using the SELECT Statement
04:02
Exercise - Working with Databases and Tables
08:35

Retrieving Data - Part 1 (Basics)

12 lectures
Section Introduction
01:02
NULL Values, Testing for NULL Values, Columns Alias, and Equality Operators
06:10
Primary Key, WHERE Clause, and AUTO_INCREMENT
17:26
The DEFAULT Keyword, Logical Operators, and Exercises
11:52
Creating Primary Keys (2nd approach), Simple & Composite Primary Keys - Exercise
14:09
Data Types (DECIMAL, DATE, and ENUM) - Mathematical Operators
05:05
Exercise [DECIMAL, DATE, and ENUM, Mathematical Operators, CONCAT() and LEFT() ]
16:54
Managing Duplicate Rows - DISTINCT and ALL Keywords - Comparison Operators
05:47
Writing Subqueries Using the IN Keyword - The BETWEEN Keyword
07:02
The ORDER BY Clause, and the LIMIT Keyword - Exercise
08:58
Pattern Matching using the LIKE Operator
08:00
Complex Pattern Matching using the REGEXP Operator
07:32

Retrieving Data - Part 2 (Joins)

10 lectures
Section Introduction
00:34
Table Joins, Concepts (Inner and Outer Joins)
06:50
Table Joins, Examples
16:31
Inner Joins, Exercise 1,2
14:24
Implicit Inner Joins
01:56
Left Outer Joins, Exercise 4,5
04:30
Right Outer Joins, Exercise 6,7
03:52
Implicit and Explicit Self Joins - Equijoins - The USING Keyword - Exercise
09:05
Cross Joins, UNION, and Full Outer Joins - Exercise 1,2
14:35
Joining Multiple Tables - Exercise 1-3
13:30

Tables & Databases - Part 1 (CRUD Operations)

6 lectures
Section Introduction
00:34
Creating and Dropping Databases and Tables - CRUD Operations - Exercise 1
06:35
Creating Tables using the 'SELECT AS' and 'LIKE' keywords - Exercise 1,2
09:34
Modifying Structure of Tables using the 'Alter Table' Command - Exercise
15:28
Updating Data using the UPDATE statement - Exercise 1,2
16:24
Removing Data using the DELETE statement - Exercise
13:07

Retrieving Data - Part 3 (More Advanced Queries)

14 lectures
Section Introduction
00:40
Summary Queries / Aggregate Functions, Part 1 - AVG, MIN, MAX, SUM, COUNT
09:21
Summary Queries / Aggregate Functions, Part 2 - Exercise 1,2
09:37
Summary Queries / Aggregate Functions, Part 3 - Exercise 3,4
04:52
The Group By Clause, Part 1 - Exercise 1-3
09:16
Running MySQL Scripts
04:50
The Group By Clause, Part 2 - Exercise 1,2
06:03
The Group By Clause, Part 3-1 - Exercise 1,2
06:09
The Group By Clause, Part 3-2 - The HAVING Clause - Exercise 3-5
05:29
The Group By Clause, Part 3-3 - Exercise 6
10:33
The Group By Clause, Part 3-4 - Exercise 7,8
03:05
Replacing Inner Joins with Implicit Joins - Exercise 1-5
05:50
Using Subqueries in Different Parts of Queries - Exercise 1-4
12:09
Subqueries - ALL, ANY, and SOME Operators
11:47

Data Types

5 lectures
Section Introduction
00:40
Data Types - CHAR, and VARCHAR
08:33
Data Types - Texts, Binary Large Objects, ENUM, and SET
09:06
Data Types-INT, BIGINT, …, BOOLEAN, DECIMAL, FLOAT, DOUBLE, DATE, TIME, DATETIME
09:03
Implicit and Explicit Data Conversion - CAST(), CONVERT(), FORMAT(), CHAR()
14:20

String & Numeric Functions

10 lectures
Section Introduction
00:53
String Functions - Part 1 (Lower, Upper, Lcase, Ucase)
01:50
String Functions - Part 2 (Concat, Concat_WS, LTrim, RTrim, Trim)
04:30
String Functions - Part 3 (Length, Char_Length, Lpad, Rpad)
05:57
String Functions - Part 4 (Left, Right, Reverse, Repeat, Space)
05:01
String Functions - Part 5 (Replace, Locate, Insert)
09:05
String Functions - Part 6 (Strcmp, Substring)
04:50
String Functions - Exercise 1,2
13:25
Numeric Functions - Part 1 (Mod, Sign, Abs, Ceiling, Floor)
04:45
Numeric Functions - Part 2 (Power, Sqrt, Truncate, Rand) - Exercise
05:52

Date-Time & Miscellaneous Functions

12 lectures
Section Introduction
01:05
Datetime Functions - Part 1 (Now, Sysdate, Curdate, Curtime, UTC_Date, …)
04:29
Datetime Functions - Part 2 (Year, Quarter, Month, MonthName, Week)
02:22
Datetime Functions - Part 3 (Day, Hour, Minute, Second, DayOfWeek, ...)
04:13
Datetime Functions - Part 4 (Extract)
04:37
Datetime Functions - Part 5 (Date_Format, Time_Format, Get_Format)
08:04
Datetime Functions - Part 6 (Format Specifiers)
07:41
Datetime Functions - Part 7 (Date_add, Date_Sub, DateDiff, TimeDiff, ...)
06:54
Datetime Functions - Part 8 - Searching for date/time values - Exercise 1,2
04:25
The Case() Function - Exercise
04:21
The IF() Function
02:22
The IfNull() and Coalesce() Functions
03:47

Tables & Databases - Part 2 (Relationships & Constraints)

12 lectures
Section Introduction
00:53
One-to-One Relationships / Primary and Foreign Keys
05:47
One-to-Many Relationships
02:42
Many-to-Many Relationships
05:04
One-to-One Relationships - Practice
09:05
One-to-Many Relationships - Practice
03:52
Many-to-Many Relationships - Practice (Including an ERD)
10:11
Attributes & Constraints (NOT NULL, UNIQUE, DEFAULT, AUTO_INCREMENT, ...)
07:31
Referential Integrity & Foreign Key Constraint - Exercise
17:25
Altering Table Constraints (Add/Drop/Change Column) - Exercise 1-3
05:50
Altering Table Constraints (Add/Drop Primary or Foreign Key, ...) - Exercise 4-8
09:09
Renaming, Truncating and Dropping Tables
02:30

Working with Views

6 lectures
Section Introduction
00:27
What is a View?
02:30
Views, Examples
11:41
Views, Nested Views - Exercise 1-3
07:44
Read-Only and Updatable Views - Part 1
06:34
Read-Only and Updatable Views - Part 2
10:00

Database Design (Conceptual, Logical & Physical) / Assignment 1 – ‘World’ DB

11 lectures
Section Introduction
01:01
Steps to Design a Database
04:10
Example of Designing a Database - Part 1
02:09
Example of Designing a Database - Part 2
03:36
Example of Designing a Database - Part 3
02:34
Assignment 1 (The World DB) - Assignment Explained
03:29
Assignment 1 - Creating the Database and Tables / Assignment Resources
07:11
Assignment 1 - Solution to Queries #1-4
06:22
Assignment 1 - Solution to Queries #5-7
05:31
Assignment 1 - Solution to Queries #8,9
05:40
Assignment 1 - Solution to Queries #10,11
04:11

Assignment 2 – 'Soccer League' Database

11 lectures
Section Introduction
00:49
Assignment 2 Explained
06:01
Assignment 2 - Solution, Entity Relationship Diagram / Assignment Resources
08:50
Assignment 2 - Creating the Database and Tables
18:42
Assignment 2 - Solution to Query #1
08:18
Assignment 2 - Solution to Query #2
03:54
Assignment 2 - Solution to Query #3
07:52
Assignment 2 - Solution to Query #4
04:03
Assignment 2 - Solution to Query #5
04:09
Assignment 2 - Solution to Query #6
03:29
Assignment 2 - Solution to Query #7
05:42

Assignment 3 – 'Artists' Database

10 lectures
Section Introduction
01:08
Assignment 3 Explained
04:22
Assignment 3 - Solution, Entity Relationship Diagram / Assignment Resources
12:56
Assignment 3 - Creating the Database and Tables
09:50
Assignment 3 - Solution to Query #1
03:13
Assignment 3 - Solution to Query #2-4
04:00
Assignment 3 - Solution to Query #5
04:12
Assignment 3 - Solution to Query #6,7
02:30
Assignment 3 - Solution to Query #8
02:15
Assignment 3 - Solution to Query #9
02:50

Assignment 4 – 'Online Banking' Database

11 lectures
Section Introduction
00:55
Assignment 4 Explained
01:16
Assignment 4 - Solution, Entity Relationship Diagram - Part 1
05:18
Assignment 4 - Solution, Entity Relationship Diagram - Part 2
03:45
Assignment 4 - Solution, Entity Relationship Diagram - Part 3
08:28
Assignment 4 - Creating the Database and Tables
17:33
Assignment 4 - Queries
01:20
Assignment 4 - Solution to Query #1,2
03:46
Assignment 4 - Solution to Query #3,4
05:41
Assignment 4 - Solution to Query #5
06:13
Assignment 4 - Solution to Query #6
04:53

Stored Procedures & Program Control Structures

10 lectures
Section Introduction
00:37
Stored Procedures / Concepts - Example 1
09:53
Stored Procedures - Examples 2,3
12:32
Stored Procedures / Input Parameters - Examples 4,5 / Exercise
08:06
Stored Procedures - Example 6 / Exercise
05:50
Stored Procedures / Output Parameters / User-Defined Variables - Example 7
08:54
Stored Procedures / INOUT Parameters - Examples 8,9
08:33
IF Statement - Examples 1,2
11:46
CASE Statement - Examples 1-3
10:49
WHILE Loop - Examples 1,2
07:01

Cursors, Stored Functions, Triggers & Assignment 5 (Loan App)

10 lectures
Section Introduction
00:58
Cursors, Definition and Example
13:11
Stored Functions, Definition - Example 1
09:35
Stored Functions - Examples 2-4
07:07
Stored Functions - Examples 5-6
07:27
Triggers, Definition - Example 1
08:09
Triggers - Example 2
03:58
Triggers - Example 3
07:02
Assignment 5 (Processing Loan Applications) Explained
03:04
Assignment 5, Solution (Using Procedures, Cursors, Functions & Triggers)
15:45

Installation - JDK, Go, PostgreSQL, Eclipse, Visual Studio Code, & Git Bash

6 lectures
Section Introduction
00:48
Installation of the Java Development Kit ( JDK) on Windows
02:57
Installation of the Eclipse IDE on Windows
02:42
Installation of the Go Compiler, Visual Studio Code, and Git Bash on Windows
11:13
Installation of the PostgreSQL on Windows
02:25
Creating Some Tables in PostgreSQL
03:12

Connecting Java to MySQL & PostgreSQL

15 lectures
Section Introduction
00:52
Java Database Connectivity (JDBC), Concepts & Architecture
04:06
Setting up the Development Environment - Connecting to MySQL
07:29
JDBC / Select Statement
08:20
JDBC / Insert, Update, and Delete Statements
06:20
JDBC / Prepared Statements
05:50
JDBC / Views - Exercise
02:46
JDBC / Writing Large Objects to Database
08:10
JDBC / Reading Large Objects from Database
04:39
JDBC / Stored Procedures - IN Parameters
04:07
JDBC / Stored Procedures - INOUT Parameters
04:29
JDBC / Stored Procedures - IN, OUT, and INOUT Parameters
03:53
JDBC / Transaction Management
13:43
JDBC / PostgreSQL and Basic Operations
04:35
JDBC / PostgreSQL - Working with Large Objects and Transactions
03:31

Connecting Go (Google Golang) to MySQL & PostgreSQL

3 lectures
Connecting Go to MySQL
17:28
Go & CRUD Statements in MySQL
18:50
Go & CRUD Statements in PostgreSQL
10:40

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

The Complete UML Course (2024): Learn to Design UML Diagrams

The Complete UML Course (2024): Learn to Design UML Diagrams

25 VND
50.000 VND
Master Network Automation with Python for Network Engineers

Master Network Automation with Python for Network Engineers

1.699.000 VND
50.000 VND
Unity Mobile Game Development - Exterminator

Unity Mobile Game Development - Exterminator

1.499.000 VND
50.000 VND
Mastering CSS Grid 2023 - With 3 cool projects

Mastering CSS Grid 2023 - With 3 cool projects

99 VND
50.000 VND
Django 3 - Full Stack Websites with Python Web Development

Django 3 - Full Stack Websites with Python Web Development

1.699.000 VND
50.000 VND
Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

95 VND
50.000 VND
Appium - Mobile Testing with Latest 2.0 and Live Projects

Appium - Mobile Testing with Latest 2.0 and Live Projects

70 VND
50.000 VND
Deep Learning for Object Detection with Python and PyTorch

Deep Learning for Object Detection with Python and PyTorch

899.000 VND
50.000 VND
Full Android Development Masterclass | 14 Real Apps-46 Hours

Full Android Development Masterclass | 14 Real Apps-46 Hours

1.699.000 VND
50.000 VND
Go Java Full Stack with Spring Boot and Angular

Go Java Full Stack with Spring Boot and Angular

90 VND
50.000 VND
Machine Learning Practical Workout | 8 Real-World Projects

Machine Learning Practical Workout | 8 Real-World Projects

79 VND
50.000 VND
WordPress 2024: The Complete WordPress Website Course

WordPress 2024: The Complete WordPress Website Course

90 VND
50.000 VND
Android App Development Master Course with Java | Android

Android App Development Master Course with Java | Android

99 VND
50.000 VND
Unreal Engine 5: Soulslike Melee Combat System

Unreal Engine 5: Soulslike Melee Combat System

1.399.000 VND
50.000 VND
ASP.NET Core Web Application Using Razor Pages

ASP.NET Core Web Application Using Razor Pages

1.699.000 VND
50.000 VND
Build Undetectable Malware Using C Language: Ethical Hacking

Build Undetectable Malware Using C Language: Ethical Hacking

75 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi