MY SQL for Data Manipulation and Analysis with Real Life Practical Examples

Relational Database Theory and Introduction to SQL 10 lectures 45:38 1 Why Use SQL? 2 Why MYSQL? 3 Intro to Databases 4 Relational Database Fundamentals 5 Comparing Database and Spreadsheets 6 Importance of Database Terminology 7 The Concept of A Relational Schema (Primary Key) 8 The Concept of A Relational Schema (Foreign Key) 9 The Concept of Relational Schemas 10 The Concept of Relational Schemas (Relationships between Tables) Relational Database Theory and Introduction to SQL 10 lectures 45:38 1 Why Use SQL? 2 Why MYSQL? 3 Intro to Databases 4 Relational Database Fundamentals 5 Comparing Database and Spreadsheets 6 Importance of Database Terminology 7 The Concept of A Relational Schema (Primary Key) 8 The Concept of A Relational Schema (Foreign Key) 9 The Concept of Relational Schemas 10 The Concept of Relational Schemas (Relationships between Tables) 1 Why Use SQL? 1 Why Use SQL? 1 Why Use SQL? 1 Why Use SQL? 2 Why MYSQL? 2 Why MYSQL? 2 Why MYSQL? 2 Why MYSQL? 3 Intro to Databases 3 Intro to Databases 3 Intro to Databases 3 Intro to Databases 4 Relational Database Fundamentals 4 Relational Database Fundamentals 4 Relational Database Fundamentals 4 Relational Database Fundamentals 5 Comparing Database and Spreadsheets 5 Comparing Database and Spreadsheets 5 Comparing Database and Spreadsheets 5 Comparing Database and Spreadsheets 6 Importance of Database Terminology 6 Importance of Database Terminology 6 Importance of Database Terminology 6 Importance of Database Terminology 7 The Concept of A Relational Schema (Primary Key) 7 The Concept of A Relational Schema (Primary Key) 7 The Concept of A Relational Schema (Primary Key) 7 The Concept of A Relational Schema (Primary Key) 8 The Concept of A Relational Schema (Foreign Key) 8 The Concept of A Relational Schema (Foreign Key) 8 The Concept of A Relational Schema (Foreign Key) 8 The Concept of A Relational Schema (Foreign Key) 9 The Concept of Relational Schemas 9 The Concept of Relational Schemas 9 The Concept of Relational Schemas 9 The Concept of Relational Schemas 10 The Concept of Relational Schemas (Relationships between Tables) 10 The Concept of Relational Schemas (Relationships between Tables) 10 The Concept of Relational Schemas (Relationships between Tables) 10 The Concept of Relational Schemas (Relationships between Tables) Install and Get to Know MYSQL 3 lectures 15:12 1 Install MYSQL Workbench Server 2 Link GUI with MY SQL Server 3 Familiarise Yourself with MYSQL Interface Install and Get to Know MYSQL 3 lectures 15:12 1 Install MYSQL Workbench Server 2 Link GUI with MY SQL Server 3 Familiarise Yourself with MYSQL Interface 1 Install MYSQL Workbench Server 1 Install MYSQL Workbench Server 1 Install MYSQL Workbench Server 1 Install MYSQL Workbench Server 2 Link GUI with MY SQL Server 2 Link GUI with MY SQL Server 2 Link GUI with MY SQL Server 2 Link GUI with MY SQL Server 3 Familiarise Yourself with MYSQL Interface 3 Familiarise Yourself with MYSQL Interface 3 Familiarise Yourself with MYSQL Interface 3 Familiarise Yourself with MYSQL Interface Best SQL Practices 3 lectures 10:55 1 Coding Tips and Best Practice 1 2 Coding Tips and Best Practice 2 3 Loading the Employee Database Click on the link below to download the Employee Database. Best SQL Practices 3 lectures 10:55 1 Coding Tips and Best Practice 1 2 Coding Tips and Best Practice 2 3 Loading the Employee Database Click on the link below to download the Employee Database. 1 Coding Tips and Best Practice 1 1 Coding Tips and Best Practice 1 1 Coding Tips and Best Practice 1 1 Coding Tips and Best Practice 1 2 Coding Tips and Best Practice 2 2 Coding Tips and Best Practice 2 2 Coding Tips and Best Practice 2 2 Coding Tips and Best Practice 2 3 Loading the Employee Database Click on the link below to download the Employee Database. 3 Loading the Employee Database Click on the link below to download the Employee Database. 3 Loading the Employee Database Click on the link below to download the Employee Database. 3 Loading the Employee Database Click on the link below to download the Employee Database. on the link below to download the Employee Database. on the link below to download the Employee Database. Practical Application of the SELECT Statement. 19 lectures 01:01:30 1 Using SELECT from Exercise 1Select the information from the “dept_no” column of the “departments” table. Select all data from the “departments” table. 2 Using WHERE Exercise 2 Select all people from the “employees” table whose first name is “Elvis”. 3 Using AND Exercise 3 Retrieve a list with all female employees whose first name is Kellie. 4 Using OR Exercise 4 Retrieve a list with all employees whose first name is either Kellie or Aruna. 5 Operator Precedence and Logical Order Exercise 5 Retrieve a list with all female employees whose first name is either Kellie or Aruna. 6 Using IN NOT IN Exercise 6a Use the IN operator to select all individuals from the “employees” table, whose first name is either “Denis”, or “Elvis”.Exercise 6b Extract all records from the ‘employees’ table, aside from those with employees named John, Mark, or Jacob. 7 Using LIKE NOT LIKE Exercise 7Working with the “employees” table, use the LIKE operator to select the data about all individuals, whose first name starts with “Mark”; specify that the name can be succeeded by any sequence of characters. Retrieve a list with all employees who have been hired in the year 2000. Retrieve a list with all employees whose employee number is written with 5 characters, and starts with “1000”. 8 Using Wild Characters Exercise 8Extract all individuals from the ‘employees’ table whose first name contains “Jack”. Once you have done that, extract another list containing the names of employees that do not contain “Jack”. 9 Using Between AND Exercise 9Select all the information from the “salaries” table regarding contracts from 66,000 to 70,000 dollars per year. Retrieve a list with all individuals whose employee number is not between ‘10004’ and ‘10012’. Select the names of all departments with numbers between ‘d003’ and ‘d006’. 10 Using IS NOT NULL IS NULL Exercise 10 Select the names of all departments whose department number value is not null. 11 Using Other Comparison Operators Exercise 11:Retrieve a list with data about all female employees who were hired in the year 2000 or after. Hint: If you solve the task correctly, SQL should return 7 rows. Extract a list with all employees’ salaries higher than $150,000 per annum. 12 Using SELECT DISTINCT Exercise 12:Obtain a list with all different “hire dates” from the “employees” table. Expand this list and click on “Limit to 1000 rows”. This way you will set the limit of output rows displayed back to the default of 1000. In the next lectures, we will show you how to manipulate the limit rows count. 13 Getting to Know Aggregate Functions Exercise 13How many annual contracts with a value higher than or equal to $100,000 have been registered in the salaries table? How many managers do we have in the “employees” database? Use the star symbol (*) in your code to solve this exercise. 14 Using ORDER BY Exercise 14 Select all data from the “employees” table, ordering it by “hire date” in descending order. 15 Using GROUP BY 16 Using Aliases Exercise 16: This will be a slightly more sophisticated task. Write a query that obtains an output whose first column must contain annual salaries higher than 80,000 dollars Exercise 5 Retrieve a list with all female...