SQL Programming: From Beginner to Ultimate

(0 Reviews)

Duration 8 h 55 m 56 s

Price

R 119 ~~R 350~~ Buy now

SQL Programming: From Beginner to Ultimate

About Course

Embark on a transformative journey into the world of databases with our comprehensive online course, "SQL Programming: Beginner to Ultimate." Whether you're a complete novice or aspiring to become a SQL maestro, this course is your roadmap to mastering the art of database management and unleashing the full potential of SQL.

Course content

Introduction19 s Start

What is SQL3 m 24 s Start

Installing MySQL on MAC4 m 59 s Start

Installing MySQL on Windows5 m 21 s Start

Creating the Database8 m 32 s Start

What you will learn2 m 32 s Start

The Select Statement1 m 38 s Start

The Select Clause7 m Start

The Where Clause2 m 14 s Start

The AND, OR and NOT Operators6 m 52 s Start

The IN Operator1 m 42 s Start

The Between Operator1 m 59 s Start

The Like Operator1 m 55 s Start

The REGEXP Operator7 m Start

The IS NULL Operator1 m 50 s Start

The ORDER BY Clause7 m Start

Inner Joins8 m 27 s Start

Joining Across Database2 m 47 s Start

Self Joins4 m 14 s Start

Joining Multiple Tables6 m 47 s Start

Compound Join Conditions3 m 41 s Start

Implicit Join Syntax2 m 21 s Start

Outer Joins6 m 27 s Start

Self Outer Joins2 m 13 s Start

The USING Clause5 m 23 s Start

Natural Joins1 m 21 s Start

Cross Joins3 m 15 s Start

Unions8 m 29 s Start

Column Attributes3 m 25 s Start

Inserting a Row5 m 47 s Start

Inserting Multiple Rows3 m 18 s Start

Inserting Hierarchical Rows5 m 53 s Start

Creating a Copy of a Table8 m 48 s Start

Updating a Single Row3 m 55 s Start

Updating Multiple Rows3 m 15 s Start

Using Subqueries in Updates5 m 37 s Start

Deleting Rows1 m 24 s Start

Restoring the Database1 m 6 s Start

Aggregate Functions9 m 20 s Start

The Group by Clause7 m 21 s Start

The Having Clause8 m 51 s Start

The Rollup Operator5 m 6 s Start

Introduction1 m 29 s Start

The IN Operator3 m 40 s Start

Subqueries vs Joins5 m 8 s Start

The ALL Keyword4 m 52 s Start

The ANY Keyword2 m 37 s Start

Correlated Subqueries5 m 37 s Start

The EXISTS Operator5 m 40 s Start

Subqueries in the SELECT Clause4 m 29 s Start

Subqueries in the FROM Clause2 m 59 s Start

Numeric Functions2 m 54 s Start

String Functions5 m 48 s Start

Date Functions in MySQL4 m 8 s Start

Formatting Dates and Time2 m 14 s Start

Calculating Dates and Times3 m 8 s Start

The IFNULL and COALESCE Functions3 m 29 s Start

The IF Function4 m 55 s Start

The CASE Operator5 m 23 s Start

Creating Views5 m 37 s Start

Altering or Dropping Views2 m 52 s Start

Updatable Views5 m 12 s Start

Other Benefits of Views2 m 38 s Start

The WITH OPTION CHECK Clause.2 m 18 s Start

What is Stored Procedures2 m 19 s Start

Creating Stored Procedures1 m 18 s Start

Creating Procedures Using MySQLWorkbench1 m 21 s Start

Dropping Stored Procedures2 m 10 s Start

Parameters3 m 12 s Start

Parameters with Default Value7 m Start

Parameter Validation7 m Start

Output Parameters2 m 42 s Start

Variables1 m 30 s Start

Functions2 m 52 s Start

Other Conventions1 m 52 s Start

Transactions2 m 44 s Start

Creating Transactions5 m 11 s Start

Concurrency and Locking4 m 7 s Start

Concurrency Problems7 m 25 s Start

Transaction Isolation Levels5 m 43 s Start

Read Uncommitted Isolation Level3 m 27 s Start

REPEATABLE READ Isolation Level3 m 30 s Start

SERIALIZABLE Isolation Level2 m 18 s Start

Deadlocks6 m 12 s Start

Introduction44 s Start

String Types2 m 26 s Start

Integer Types2 m 52 s Start

Logical Model7 m 25 s Start

Physical Models6 m 28 s Start

Primary Keys3 m 23 s Start

Foreign Keys5 m 49 s Start

Foreign Key Constraints5 m 22 s Start

JSON Type10 m 24 s Start

Fixed-point and Floating-point Types1 m 43 s Start

Boolean Types47 s Start

Date and Time Types45 s Start

Blob Types1 m 18 s Start

Conceptual Model4 m 34 s Start

Logical Models7 m 25 s Start

Physical Models6 m 28 s Start

First Normal Form2 m 43 s Start

Second Normal Form6 m 33 s Start

Third Normal Form1 m 44 s Start

My Pragmatic Advice2 m 56 s Start

Forward Engineering a Model2 m 35 s Start

Synchronizing a Model with a Database4 m 49 s Start

Reverse Engineering a Database3 m 11 s Start

Solution- Conceptual Model8 m Start

Creating and Dropping Databases1 m 41 s Start

Creating Tables3 m 13 s Start

Altering Tables2 m 56 s Start

Creating Relationships4 m 47 s Start

Introduction41 s Start

Indexes2 m 50 s Start

Creating Indexes5 m 1 s Start

Viewing Indexes3 m 20 s Start

Prefix Indexes3 m 41 s Start

Full Text Indexes7 m 51 s Start

Composite Indexes5 m 12 s Start

Order of Columns in Composite Indexes9 m 17 s Start

When Indexes are Ignored5 m 4 s Start

Using Indexes for Sorting7 m 2 s Start

Covering Indexes1 m 59 s Start

Index Maintenance1 m 25 s Start

Introduction33 s Start

Creating a User3 m 13 s Start

Viewing Users1 m 30 s Start

Dropping Users48 s Start

Changing Passwords1 m 6 s Start

Granting Privilege4 m 54 s Start

Viewing Privilege1 m 35 s Start

Revoking Privileges1 m 21 s Start

Wrap Up44 s Start

Buy now

Course Instructor

Director and Owner

Reviews

(0 Reviews)

SQL Programming: From Beginner to Ultimate

About Course

Power Education

Course Instructor