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.
39
views
Add the class to your calendar
About the Class
Design and implement the database for your customer
Deliver high-performing, scalable business applications
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.
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
Requirements
You should have good VBA programming skills.
Class Contents
One-time Fee
$87
List Price: $167
You save: $80
€74.63
List Price: €143.26
You save: €68.63
£64.88
List Price: £124.55
You save: £59.66
CA$120.04
List Price: CA$230.42
You save: CA$110.38
A$133.20
List Price: A$255.69
You save: A$122.48
S$112.08
List Price: S$215.15
You save: S$103.06
HK$678.78
List Price: HK$1,302.95
You save: HK$624.17
CHF 69.91
List Price: CHF 134.19
You save: CHF 64.28
NOK kr872.12
List Price: NOK kr1,674.08
You save: NOK kr801.95
DKK kr557.02
List Price: DKK kr1,069.22
You save: DKK kr512.20
NZ$148.35
List Price: NZ$284.76
You save: NZ$136.41
د.إ319.50
List Price: د.إ613.30
You save: د.إ293.80
৳10,581.80
List Price: ৳20,312.19
You save: ৳9,730.39
₹7,660.67
List Price: ₹14,704.97
You save: ₹7,044.30
RM367.79
List Price: RM705.99
You save: RM338.20
₦133,671.15
List Price: ₦256,587.15
You save: ₦122,916
₨24,618.18
List Price: ₨47,255.59
You save: ₨22,637.41
฿2,814.14
List Price: ฿5,401.86
You save: ฿2,587.72
₺3,580.27
List Price: ₺6,872.48
You save: ₺3,292.20
B$475.95
List Price: B$913.62
You save: B$437.66
R1,533.70
List Price: R2,944.01
You save: R1,410.30
Лв146.09
List Price: Лв280.44
You save: Лв134.34
₩120,894.47
List Price: ₩232,061.81
You save: ₩111,167.33
₪293.02
List Price: ₪562.46
You save: ₪269.44
₱4,985.05
List Price: ₱9,569.01
You save: ₱4,583.96
¥12,924.46
List Price: ¥24,809.02
You save: ¥11,884.56
MX$1,627.37
List Price: MX$3,123.81
You save: MX$1,496.43
QR316.99
List Price: QR608.48
You save: QR291.48
P1,172.67
List Price: P2,251
You save: P1,078.32
KSh11,236.05
List Price: KSh21,568.05
You save: KSh10,332
E£4,227.70
List Price: E£8,115.24
You save: E£3,887.54
ብር12,429.94
List Price: ብር23,859.78
You save: ብር11,429.83
Kz79,340.09
List Price: Kz152,296.50
You save: Kz72,956.40
CLP$84,706.68
List Price: CLP$162,597.88
You save: CLP$77,891.20
CN¥620.37
List Price: CN¥1,190.84
You save: CN¥570.46
RD$5,480.22
List Price: RD$10,519.50
You save: RD$5,039.28
DA11,303.35
List Price: DA21,697.24
You save: DA10,393.89
FJ$196.75
List Price: FJ$377.67
You save: FJ$180.92
Q666.76
List Price: Q1,279.88
You save: Q613.11
GY$18,191.80
List Price: GY$34,919.89
You save: GY$16,728.09
ISK kr10,719.27
List Price: ISK kr20,576.07
You save: ISK kr9,856.80
DH786.91
List Price: DH1,510.52
You save: DH723.60
L1,434.58
List Price: L2,753.74
You save: L1,319.16
ден4,601.24
List Price: ден8,832.26
You save: ден4,231.02
MOP$699.43
List Price: MOP$1,342.59
You save: MOP$643.15
N$1,541.34
List Price: N$2,958.67
You save: N$1,417.32
C$3,201.51
List Price: C$6,145.44
You save: C$2,943.92
रु12,278.93
List Price: रु23,569.90
You save: रु11,290.97
S/307.50
List Price: S/590.25
You save: S/282.75
K364.79
List Price: K700.24
You save: K335.44
SAR326.45
List Price: SAR626.64
You save: SAR300.18
ZK2,061.21
List Price: ZK3,956.58
You save: ZK1,895.37
L378.98
List Price: L727.48
You save: L348.49
Kč1,824.83
List Price: Kč3,502.84
You save: Kč1,678
Ft29,386.71
List Price: Ft56,408.98
You save: Ft27,022.27
SEK kr821.17
List Price: SEK kr1,576.27
You save: SEK kr755.10
ARS$118,273.46
List Price: ARS$227,030.67
You save: ARS$108,757.20
Bs601.11
List Price: Bs1,153.86
You save: Bs552.74
COP$348,863.20
List Price: COP$669,656.95
You save: COP$320,793.75
₡43,980.85
List Price: ₡84,423.02
You save: ₡40,442.17
L2,292.98
List Price: L4,401.48
You save: L2,108.49
₲628,329.77
List Price: ₲1,206,104.28
You save: ₲577,774.50
$U3,481.92
List Price: $U6,683.70
You save: $U3,201.77
zł317.35
List Price: zł609.17
You save: zł291.81
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