Learn SQL With MySQL & Microsoft SQL Server for Beginners

Focused View

Data Science Guide

4:43:41

168 View

1. Introduction to Relational Databases

1. Introduction to the Course.mp4

02:07

2. What is the Relational Database.mp4

03:25

3. What is the relational database.html

4. Why a relational database.html

5. Primary and Foreign Keys in the Relational Database.mp4

04:52

6. Why primary keys and foreign keys are used to link tables.html

7. Normalization.mp4

05:08

8. Apply Normalization on Tables in the Relational Database.mp4

05:11

9. Introduction to Data Modeling and ER Diagram.mp4

07:34

10. The Attributes of an Entity and Relationships types between Entities.mp4

05:16

11. Fix Many to Many Relationship.mp4

01:50

12. The Conceptual ERD.mp4

03:25

13. The Logical ERD.mp4

01:54

14. The Physical ERD.mp4

01:56

15. Create Conceptual ERD for DSG Database.mp4

02:04

16. Create Logical ERD for DSG Database.mp4

06:27

17. Create Physical ERD for DSG Database.mp4

03:34

2. Introduction to Database Management Systems

1. What is a Relational Database Management System.mp4

02:41

2. Install Microsoft SQL Server and Management Studio on Windows.mp4

02:39

3. Introduction to SQL Server Management Studio.mp4

02:44

4. Install MySQL on Windows.mp4

06:34

5. Introduction to Workbench.mp4

04:33

3. Introduction to SQL - Data Definition Language (DDL)

1. What is SQL.mp4

03:54

2. Database and Schema.mp4

00:35

3. Create a Schema (Database) in MySQL.mp4

03:00

4. Drop a Database in MySQL.mp4

02:29

5. Create a Database in Microsoft SQL Server.mp4

02:57

6. Drop a Database in Microsoft SQL Server.mp4

01:18

7. Data Types in MySQL and Microsoft SQL Server.mp4

04:17

8. What are Constraints.mp4

04:16

9. Create a Table in MySQL using SQL Code.mp4

04:57

10. Create a Table in MySQL using GUI.mp4

03:09

11. Drop a Table in MySQL.mp4

02:20

12. Create a Table in Microsoft SQL Server.mp4

03:53

13. Create a Table in Microsoft SQL Server using GUI.mp4

05:38

14. Drop a Table in Microsoft SQL Server.mp4

03:35

15.1 create dsg database in mysql.zip

15. Create DSG Database in MySQL Part-1.mp4

06:43

16. Create DSG Database in MySQL Part-2.mp4

06:46

17. Create DSG Database in MySQL Part-3.mp4

03:20

18. Create DSG Database in Microsoft SQL Server Part-1.mp4

06:29

19.1 create dsg database in ms sql server.zip

19. Create DSG Database in Microsoft SQL Server Part-2.mp4

04:20

20. Create DSG Database in Microsoft SQL Server Part-3.mp4

04:01

21. Add and Drop Columns in MySQL.mp4

02:50

22. Add and Drop Columns in Microsoft SQL Server.mp4

04:20

23. Add a New Table to DSG Database.mp4

01:57

24. Add a New Table in MySQL.mp4

03:39

25. Add a New Table in Microsoft SQL Server.mp4

02:44

4. Introduction to SQL - Data Manipulation Language (DML)

1. Introduction to Insert Data in Tables.mp4

03:42

2. Insert Data in MySQL-Part 1.mp4

04:09

3. Insert Data in MySQL-Part 2.mp4

03:11

4. Insert Data in MySQL-Part 3.mp4

01:56

5. Homework - Insert Data in Microsoft SQL Server.html

6. Delete Data From a Table in Microsoft SQL Server Part-1.mp4

02:40

7. Delete Data From a Table in Microsoft SQL Server Part-2.mp4

01:12

8. Delete Data From a Table in MySQL.mp4

02:30

9. Homework- Delete Data From a Table in MS SQL Server.html

10. Homework- Solution.mp4

02:18

11. Update Tables in SQL.mp4

02:50

12. Homework- Update a Table.mp4

00:18

13. Homework Solution - Update a Table.mp4

01:08

5. Introduction to SQL - Data Query Language (DQL)

1. SELECT- FROM Statement.mp4

03:54

2. Use WHERE Condition in SELECT Query.mp4

03:09

3. AND & OR Operators.mp4

03:58

4. Sort Data Using ORDER BY Operator.mp4

02:54

5. TOP and LIMIT Operators.mp4

02:32

6. BETWEEN-AND Operator.mp4

02:22

7. DISTINCT Operator.mp4

01:17

8. IN and NOT IN Operators.mp4

02:43

9. LIKE and NOT LIKE Operators.mp4

04:49

10. Wildcards.mp4

04:54

11. Introduction to Tables Join in SQL.mp4

05:45

12. Tables Join in Microsoft SQL Server.mp4

04:07

13. Tables Join in MySQL.mp4

04:23

14. Introduction to SQL Aggregate Functions.mp4

10:23

15. GROUP BY Statement.mp4

03:35

16. Use HAVING Clause in MySQL.mp4

03:40

17. Homework-HAVING Clause.mp4

00:27

18. Homework Solution.mp4

00:35

19. Introduction to Date Functions.mp4

02:12

20. DATEDIFF & TIMESTAMP Functions.mp4

01:59

21. DATEADD in Microsoft SQL Server.mp4

02:35

22. DATEADD in MySQL.mp4

01:57

23. Data Types Conversion Functions.mp4

05:37

24. CONCAT Function.mp4

02:01

25. A View in SQL.mp4

02:26

26. Create a view in MS SQL Server.mp4

02:03

6. Introduction to SQL - Data Transaction Language (DTL)

1. Introduction to COMMIT-ROLLBACK Statements.mp4

04:09

Description

Learn Data Modeling, Relational Databases and SQL from Scratch in both MySQL and Microsoft SQL Server

What You'll Learn?

Learn Data Modeling
Understand Relational database Terminology
Install and Use MS SQL Server and MySQL
Learn create and drop databases and their objects
Learn insert, update and delete data

Who is this for?

Those who need to learn SQL and relational databases from scratch in MySQL and MS SQL Server

More details

Description
As most of the business data stored in relational databases, learning SQL is essential for anyone wants to be a SQL developer, database administrator, data analyst or data scientist. Since SQL is the main tool used to create and manipulate relational databases and their stored data, mastering SQL is necessary to maintain them. You will learn in the beginning of this course, data modeling including how to create conceptual, logical, and physical ERD's (Entity Relationship Diagram). After that you will learn how to install MySQL and Microsoft SQL Server and be acquainted in their work environments. You will learn SQL from scratch in both two database management systems. You will learn DDL, DML, and DTL SQL. This course starts with the basics of SQL like creating and managing a database. You will learn how to create and modify tables, views and other database objects. You will learn how to insert, update and delete data in tables. Also, you will learn retrieving data from tables using SELECT statement in both MySQL and Microsoft SQL Server. You will learn using the most important functions in SELECT quires, such as: aggregate, conversion, and date functions. Furthermore, you will learn different types of SQL joins to retrieve data from multiple tables.

Who this course is for:
Those who need to learn SQL and relational databases from scratch in MySQL and MS SQL Server

User Reviews

Rating

average 0

Total votes0

Focused display

My name is Abraham Joudah I have worked in IT and Data Science for more than 15 years. After completed my bachelor’s in computer science, I worked as Database Administrator in one of the engineering companies. I have obtained several certificates from Microsoft like MCSE, MCDBA and MCSA. After several years of working in IT, I started focusing on Data Science field and learning SQL in depth to enhance my business data analysis skills. I also worked as Data Analyst in several companies. Over several years of working in this field I mastered several analytical tools, such as: R, SAS, SQL, Tableau, and Excel. As I enjoy working at data science field I pursued my study in this major and obtained my Master’s degree in Business Analytics from the University of North Texas.I love teaching Data Science, So I decided to create several courses in this field to share my knowledge with others. I tried to be more practical in my classes rather than repeating the same materials and curriculums in this field. I used materials based on real business scenarios to provide practical knowledge for students. I focused on examples from real business. In other words, I created shortcuts for learners to gain practical experience while studying my courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.