Databases and SQL Mastery

Learn to understand, design and implement databases while mastering SQL at the highest level.

Databases and SQL Mastery

Learn to understand, design and implement databases while mastering SQL at the highest level.
22
views
Share the link to this page
Copied

About the Class

Design and implement the database for your customer

Deliver high-performing, scalable business applications

Excel VBA Course with Mor Sagmon

You thought you cannot master databases and SQL in a single course.

This course is a complete primer about databases and the SQL language, a skill that will serve you throughout your career as a business information systems specialist. I'm starting from zero and taking you to the most sophisticated use cases, including nested queries, locking, and transactions.

MySQL Database Course

What will you learn in this course?

  • Introduction to databases
  • Installing the MySQL DB server
  • MySQL server data types
  • The SQL language: concepts and structure
  • SQL data definition: creating the schema, tables
  • Assignment 8: Using SQL to create tables, indexes, and relationships
  • Populating DB tables from CSV files
  • The SQL select command: joins, scalar, aggregates, union, nested queries
  • MySQL views
  • Advanced insert and update: with subqueries and joins
  • Transactions, Locks, Isolation, and Variables
  • Assignment 9: Extend the ERD, serve complex business reports and monthly updates using SQL

Author

Mor Sagmon

Business Information Systems leader. Excel VBA Business Applications Expert
✔ World-class business software consultant ✔ Delivering Excel-based solutions for real life business challenges ✔ Serving customers such as Alstom, Tuttnauer, St. Croix Sensory, Hospitality Designs ✔ Developer of The Ultimate Excel Date Picker ✔ Author of the Computer Programming and Databases with Excel VBA and SQL online training program ✔...

School

Mor Sagmon's School

Requirements

You should have good VBA programming skills.

One-time Fee
$87
List Price:  $167
You save:  $80
€80.31
List Price:  €154.16
You save:  €73.84
£68.86
List Price:  £132.19
You save:  £63.32
CA$118.26
List Price:  CA$227.02
You save:  CA$108.75
A$133.27
List Price:  A$255.82
You save:  A$122.55
S$117.20
List Price:  S$224.98
You save:  S$107.77
HK$680.63
List Price:  HK$1,306.50
You save:  HK$625.87
CHF 78.79
List Price:  CHF 151.25
You save:  CHF 72.45
NOK kr936.51
List Price:  NOK kr1,797.67
You save:  NOK kr861.16
DKK kr599.03
List Price:  DKK kr1,149.86
You save:  DKK kr550.83
NZ$144.86
List Price:  NZ$278.07
You save:  NZ$133.20
د.إ319.49
List Price:  د.إ613.27
You save:  د.إ293.78
৳9,571.16
List Price:  ৳18,372.23
You save:  ৳8,801.06
₹7,252.21
List Price:  ₹13,920.92
You save:  ₹6,668.70
RM411.77
List Price:  RM790.41
You save:  RM378.64
₦121,512.90
List Price:  ₦233,248.90
You save:  ₦111,736
₨24,251.44
List Price:  ₨46,551.62
You save:  ₨22,300.18
฿3,165.14
List Price:  ฿6,075.62
You save:  ฿2,910.48
₺2,804.12
List Price:  ₺5,382.62
You save:  ₺2,578.50
B$433.01
List Price:  B$831.19
You save:  B$398.17
R1,643.04
List Price:  R3,153.89
You save:  R1,510.84
Лв157.20
List Price:  Лв301.75
You save:  Лв144.55
₩117,411.28
List Price:  ₩225,375.68
You save:  ₩107,964.40
₪318.51
List Price:  ₪611.39
You save:  ₪292.88
₱4,894.40
List Price:  ₱9,395
You save:  ₱4,500.59
¥13,154.66
List Price:  ¥25,250.90
You save:  ¥12,096.24
MX$1,447
List Price:  MX$2,777.58
You save:  MX$1,330.58
QR317.96
List Price:  QR610.34
You save:  QR292.38
P1,194.64
List Price:  P2,293.17
You save:  P1,098.52
KSh11,440.50
List Price:  KSh21,960.50
You save:  KSh10,520
E£4,109.88
List Price:  E£7,889.09
You save:  E£3,779.20
ብር4,954.73
List Price:  ብር9,510.81
You save:  ብር4,556.08
Kz72,750.35
List Price:  Kz139,647.23
You save:  Kz66,896.88
CLP$85,289.58
List Price:  CLP$163,716.78
You save:  CLP$78,427.20
CN¥628.63
List Price:  CN¥1,206.69
You save:  CN¥578.05
RD$5,157.90
List Price:  RD$9,900.80
You save:  RD$4,742.90
DA11,720.03
List Price:  DA22,497.07
You save:  DA10,777.04
FJ$195.99
List Price:  FJ$376.21
You save:  FJ$180.22
Q680.27
List Price:  Q1,305.81
You save:  Q625.54
GY$18,261.11
List Price:  GY$35,052.94
You save:  GY$16,791.83
ISK kr12,022.53
List Price:  ISK kr23,077.73
You save:  ISK kr11,055.20
DH879.28
List Price:  DH1,687.82
You save:  DH808.53
L1,534.67
List Price:  L2,945.86
You save:  L1,411.19
ден4,939.49
List Price:  ден9,481.56
You save:  ден4,542.06
MOP$702.73
List Price:  MOP$1,348.93
You save:  MOP$646.19
N$1,649.67
List Price:  N$3,166.60
You save:  N$1,516.93
C$3,209.93
List Price:  C$6,161.59
You save:  C$2,951.66
रु11,622.52
List Price:  रु22,309.89
You save:  रु10,687.37
S/322.82
List Price:  S/619.67
You save:  S/296.85
K333.76
List Price:  K640.67
You save:  K306.91
SAR326.30
List Price:  SAR626.35
You save:  SAR300.04
ZK2,217.39
List Price:  ZK4,256.37
You save:  ZK2,038.98
L399.22
List Price:  L766.32
You save:  L367.10
Kč2,031.11
List Price:  Kč3,898.80
You save:  Kč1,867.69
Ft31,693.37
List Price:  Ft60,836.70
You save:  Ft29,143.33
SEK kr921.86
List Price:  SEK kr1,769.55
You save:  SEK kr847.68
ARS$74,537.24
List Price:  ARS$143,077.24
You save:  ARS$68,539.99
Bs604.79
List Price:  Bs1,160.92
You save:  Bs556.13
COP$339,050.28
List Price:  COP$650,820.65
You save:  COP$311,770.37
₡43,947.79
List Price:  ₡84,359.56
You save:  ₡40,411.76
L2,152.88
List Price:  L4,132.55
You save:  L1,979.66
₲640,939.63
List Price:  ₲1,230,309.40
You save:  ₲589,369.77
$U3,289.80
List Price:  $U6,314.90
You save:  $U3,025.10
zł346.45
List Price:  zł665.02
You save:  zł318.57

What's Included

Language: English
Level: Intermediate
Skills: Master SQL, MySQL, Relational Databases, MySQL Command-Line, MySQL Workbench, Locking and Transactions
Duration: 6 hours 50 minutes
20 Videos
4 Documents
1 Quiz
0
Saves
22
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.