Ultimate SQL Bootcamp: Enter The World Of Data Science → Earning and Career Opportunity

Course Content

Total learning: 167 lessons

Road to Database, SQL and MySQL
- 1.1
  
  What We Will Cover in This Course Preview
- 1.2
  
  Why Study SQL? Preview
- 1.3
  
  Reason for learning MySQL Preview
- 1.4
  
  Earning and Career Opportunity Preview
- 1.5
  
  Introduction to Database Preview
- 1.6
  
  Important Message for Students

SQL Philosophy
- 2.1
  
  SQL as a declarative language
- 2.2
  
  Data Definition Language (DDL)
- 2.3
  
  SQL Keyword
- 2.4
  
  Data Manipulation Language (DML)
- 2.5
  
  Data Control Language (DCL)
- 2.6
  
  Transaction Control Language (TCL)

Fundamentals of Database Terminology
- 3.1
  
  Relational Database Essentials
- 3.2
  
  Databases VS Spreadsheets
- 3.3
  
  Database Terminology
- 3.4
  
  Relational Schemas: Primary Key
- 3.5
  
  Relational Schemas: Foreign Key
- 3.6
  
  Unique Key and Null Values
- 3.7
  
  Relationship

Install MySQL and Getting Acquainted with the Interface
- 4.1
  
  Installing MySQL
- 4.2
  
  Additional Note- Installing VISUAL C
- 4.3
  
  Installing MySQL on MacOS and UniX Systems
- 4.4
  
  Setting Up a Connection
- 4.5
  
  New Authentication Plugin- Creating a New User
- 4.6
  
  Introduction to The MySQL Interface

Practically Learn SQL with Confidence
- 5.1
  
  Creating a Database – Part 1
- 5.2
  
  Creating a Database – Part 1 (Exercise)
- 5.3
  
  Creating a Database – Part 2
- 5.4
  
  Creating a Database – Part 2 (Exercise)
- 5.5
  
  Introduction to Data Types
- 5.6
  
  String Data Types
- 5.7
  
  Integers
- 5.8
  
  Fixed and Floating-Point Data Types
- 5.9
  
  Other Useful Data Types
- 5.10
  
  Creating a Table
- 5.11
  
  Creating a Table (Exercise)
- 5.12
  
  Using Databases and Tables
- 5.13
  
  Using Databases and Tables (Exercise)
- 5.14
  
  Additional Notes on Using Table
- 5.15
  
  Additional Notes on Using Tables (Exercise)

Understanding MySQL Constraints
- 6.1
  
  Primary Key Constraint
- 6.2
  
  PRIMARY KEY Constraint (Exercise)
- 6.3
  
  Foreign Key Constraint
- 6.4
  
  FOREIGN KEY Constraint (Exercise)
- 6.5
  
  Unique Constraint
- 6.6
  
  UNIQUE KEY Constraint (Exercise)
- 6.7
  
  Default Constraint
- 6.8
  
  DEFAULT Constraint (Exercise)
- 6.9
  
  NOT NULL Constraint
- 6.10
  
  NOT NULL Constraint (Exercise)

How Professionals Deal with Codes
- 7.1
  
  Coding Techniques and Best Practices

Loading The 'Employees' Database
- 8.1
  
  Loading “Employees” Database
- 8.2
  
  Loading The ’employees’ Database

SQL Select Statement (Very Important)
- 9.1
  
  SELECT….FORM…..
- 9.2
  
  SELECT – FROM (Exercise)
- 9.3
  
  WHERE
- 9.4
  
  WHERE (Exercise)
- 9.5
  
  AND
- 9.6
  
  AND (Exercise)
- 9.7
  
  OR
- 9.8
  
  OR (Exercise)
- 9.9
  
  Operation Precedence
- 9.10
  
  Operator precedence (Exercise)
- 9.11
  
  IN – NOT IN
- 9.12
  
  IN – NOT IN (Exercise)
- 9.13
  
  LIKE – NOT LIKE
- 9.14
  
  LIKE – NOT LIKE (Exercise)
- 9.15
  
  Wildcard Characters
- 9.16
  
  Wildcard Characters (Exercise)
- 9.17
  
  BETWEEN….. AND
- 9.18
  
  BETWEEN – AND (Exercise)
- 9.19
  
  IS NOT NULL – IS NULL
- 9.20
  
  IS NOT NULL – IS NULL (Exercise)
- 9.21
  
  Other Comparison Operations
- 9.22
  
  Other comparison operators (Exercise)
- 9.23
  
  SELECT DISTINCT
- 9.24
  
  SELECT DISTINCT (Exercise)
- 9.25
  
  Introduction to Aggregate Function
- 9.26
  
  Introduction to Aggregate Functions (Exercise)
- 9.27
  
  ORDER BY
- 9.28
  
  ORDER BY (Exercise)
- 9.29
  
  GROUP BY
- 9.30
  
  Using Aliases
- 9.31
  
  Using Aliases (AS) (Exercise)
- 9.32
  
  HAVING
- 9.33
  
  HAVING (Exercise)
- 9.34
  
  WHERE vs HAVING
- 9.35
  
  WHERE vs HAVING (Exercise)
- 9.36
  
  LIMIT
- 9.37
  
  LIMIT (Exercise)

SQL INSERT Statement
- 10.1
  
  The INSERT Statement
- 10.2
  
  The INSERT statement (Exercise)
- 10.3
  
  Inserting Data INTO a new Table
- 10.4
  
  Inserting Data INTO a New Table (Exercise)

SQL UPDATE Statement
- 11.1
  
  TCL’s COMMIT and ROLLBACK
- 11.2
  
  The UPDATE Statement
- 11.3
  
  The UPDATE Statement (Exercise)
- 11.4
  
  The Important Note

SQL DELETE Statement
- 12.1
  
  The SQL DELETE Statement
- 12.2
  
  The DELETE Statement (Exercise)
- 12.3
  
  DROP vs TRUNCATE vs DELETE

SQL Aggregate Functions
- 13.1
  
  COUNT()
- 13.2
  
  COUNT() (Exercise)
- 13.3
  
  SUM()
- 13.4
  
  SUM() (Exercise)
- 13.5
  
  MIN() and MAX()
- 13.6
  
  MIN() and MAX() (Exercise)
- 13.7
  
  AVG()
- 13.8
  
  AVG() (Exercise)
- 13.9
  
  ROUND()
- 13.10
  
  ROUND() (Exercise)
- 13.11
  
  IFNULL and COALESCE()
- 13.12
  
  IFNULL and COALESCE() (Exercise)

Deep Dive into SQL Joins
- 14.1
  
  Introduction to JOINs
- 14.2
  
  Introduction to JOINs (Exercise)
- 14.3
  
  INNER JOIN Part-I
- 14.4
  
  INNER JOIN Part-II
- 14.5
  
  INNER JOIN – Part II (Exercise)
- 14.6
  
  A Note on Using Joins
- 14.7
  
  Duplicate Records
- 14.8
  
  LEFT JOIN Part-I
- 14.9
  
  LEFT JOIN Part-II
- 14.10
  
  LEFT JOIN Part-II (Exercise)
- 14.11
  
  RIGHT JOIN
- 14.12
  
  The New and The Older Join Syntax
- 14.13
  
  The New and The Older Join Syntax (Exercise)
- 14.14
  
  JOIN and WHERE Used Together
- 14.15
  
  JOIN and WHERE Used Together (Exercise)
- 14.16
  
  Important – Prevent Error Code 1055!

SQL Subqueries
- 15.1
  
  SQL Subqueries with IN nested inside WHERE
- 15.2
  
  SQL Subqueries with IN nested inside WHERE (Exercise)
- 15.3
  
  SQL Subqueries with EXISTS-NOT EXISTS
- 15.4
  
  SQL Subqueries with EXISTS-NOT EXISTS (Exercise)
- 15.5
  
  SQL Subqueries nested in SELECT and FROM
- 15.6
  
  SQL Subqueries nested in SELECT and FROM (Exercise 1)
- 15.7
  
  SQL Subqueries nested in SELECT and FROM (Exercise 2)

How to Establish SQL Self Join
- 16.1
  
  How to establish SQL self join

What is SQL Views & How It Works
- 17.1
  
  SQL views and How it works
- 17.2
  
  SQL views and How it works (Exercise)

How to Handle Stored Procedure
- 18.1
  
  Introduction to stored routines
- 18.2
  
  The MySQL syntax for stored procedures
- 18.3
  
  Stored procedures – Example – Part I
- 18.4
  
  Stored procedures – Example – Part II
- 18.5
  
  Stored procedures – Example – Part II (Exercise)
- 18.6
  
  Another way to create a procedure
- 18.7
  
  Stored procedures with an input parameter
- 18.8
  
  Stored Procedures with an Output Parameter
- 18.9
  
  Stored Procedures with an Output Parameter (Exercise)
- 18.10
  
  Variables
- 18.11
  
  Variables (Exercise)
- 18.12
  
  User-defined functions in MySQL
- 18.13
  
  Error Code 1418
- 18.14
  
  User-defined functions in MySQL (Exercise)
- 18.15
  
  Stored Routines – Conclusion

Understanding Advanced SQL Elements
- 19.1
  
  Types of MySQL Variables – Local Variable
- 19.2
  
  Session Variables
- 19.3
  
  Global Variables
- 19.4
  
  User-Defined vs System Variables
- 19.5
  
  MySQL Triggers
- 19.6
  
  MySQL Triggers (Exercise)
- 19.7
  
  MySQL Indexes
- 19.8
  
  MySQL Indexes (Exercise)
- 19.9
  
  The CASE Statement
- 19.10
  
  The CASE Statement (Exercise 1)
- 19.11
  
  The CASE Statement (Exercise 2)
- 19.12
  
  The CASE Statement (Exercise 3)

Conclusion + BONUS
- 20.1
  
  Get up-to 70% Discount

Ultimate SQL Bootcamp: Enter The World Of Data Science

Road to Database, SQL and MySQL

SQL Philosophy

Fundamentals of Database Terminology

Install MySQL and Getting Acquainted with the Interface

Practically Learn SQL with Confidence

Understanding MySQL Constraints

How Professionals Deal with Codes

Loading The 'Employees' Database

SQL Select Statement (Very Important)

SQL INSERT Statement

SQL UPDATE Statement

SQL DELETE Statement

SQL Aggregate Functions

Deep Dive into SQL Joins

SQL Subqueries

How to Establish SQL Self Join

What is SQL Views & How It Works

How to Handle Stored Procedure

Understanding Advanced SQL Elements

Conclusion + BONUS

COMMUNITY

HELP

ABOUT US

Hello!

We are happy to see you again!

Login to your account

Register to start learning

Ultimate SQL Bootcamp: Enter The World Of Data Science

Course Content

Road to Database, SQL and MySQL

SQL Philosophy

Fundamentals of Database Terminology

Install MySQL and Getting Acquainted with the Interface

Practically Learn SQL with Confidence

Understanding MySQL Constraints

How Professionals Deal with Codes

Loading The 'Employees' Database

SQL Select Statement (Very Important)

SQL INSERT Statement

SQL UPDATE Statement

SQL DELETE Statement

SQL Aggregate Functions

Deep Dive into SQL Joins

SQL Subqueries

How to Establish SQL Self Join

What is SQL Views & How It Works

How to Handle Stored Procedure

Understanding Advanced SQL Elements

Conclusion + BONUS

Earning and Career Opportunity

Modal title