Preview Complete Mysql for beginners

Back

Getting Started

01 Introduction

02 - What is Relational Databases and MySQL

03 - Install MySQL Database

04 - MySQL Workbench

05 - MySQL Database on Microsoft Azure

06 - MySQL MySQL Database on AWS

07 - Summary

08 - Create and Drop Databases

09 - Create Users

10 - Exercise Create Database and User

11 - Summary

12 - Introduction to The Chapter

13 - Database Tables

14 - Data Types in MySQL

15 - Primary Keys

16 - Constraints

17 - Exercise Create Tables Employees and Jobs

18 - Foreign Keys

19 - Exercise Create Tables Previous Experience

20 - Exercise Import Data (Employees and Cities)

21 - Create table using Table Data Import Wizard

22 - Exercise Primary and Foreign Keys For Status Table

23 - Export Data out of Database

24 - Entity Relationship Diagram (ERD)

25 - Summary

26 - Introduction to The Chapter

27 - Select

28 - Exercise Select

29 - Where

30 - Exercise Where

31 - Order by

32 - Exercise Order By

33 - And, Or, Not, Is Null

34 - Like and Wildcards

35 - Exercise Like and Wildcards

36 - Summary

37 - Introduction to The Chapter

38 - Distinct

39 - In

40 - Between

41 - Exercise Between and in

42 - Union Operator

43 - Exercise Union Operator

44 - Case Statement

45 - Exercise Case Statement

46 - Exists

47 - Subquery

48 - Exercise Subquery

49 - Summary

50 - Introduction to The Chapter

51 - Aggregate Functions - Min and Max

52 - Aggregate Functions - Count

53 - Exercise Create Table Budget with Some Queries

54 - Aggregate Functions - Avg and Sum

55 - Group By

56 - Having

57 - Exercise Aggregate Functions

58 - Summary

59 - Introduction to The Chapter

60 - DML and DDL

61 - Insert Into Statement

62 - Exercise Insert Into Statement

63 - Cloning a Table

64 - Delete Statement

65 - Update Statement

66 - Exercise Update Statement

67 - Exercise Update Status of Employees

68 - Summary

69 - The Final Lecture

Preview - Complete Mysql for beginners