Contact for queries :
banner1

 

What you’ll learn

  • Reading and writing data to databases
  • All about JOINs (inner, outer, cross, natural)
  • Grouping and summarizing data for reports
  • Writing complex queries using subqueries
  • Using views, stored procedures and functions to improve productivity
  • Using triggers and events to automate data maintenance
  • Using transactions to maintain data integrity
  • All about handling concurrency and transaction isolation levels
  • Designing databases – all about normalization rules
  • Various data types and when to use them
  • Indexing for high performance
  • Securing databases

 

Course Curriculum

Getting Started
1 – What is SQL 00:00:00
2 – Installing MySQL on Mac 00:00:00
3 – Installing MySQL on Windows 00:00:00
4 – Creating the Databases 00:00:00
Retrieving Data From a Single Table
5 – The SELECT Statement 00:00:00
6 – The SELECT Clause 00:00:00
7 – The WHERE Clause 00:00:00
8 – The AND, OR and NOT Operators 00:00:00
9 – The IN Operator – Title 00:00:00
10 – The BETWEEN Operator – Title 00:00:00
11 – The LIKE Operator – Title 00:00:00
12 – The REGEXP Operator 00:00:00
13 – The IS NULL Operator 00:00:00
14 – The ORDER BY Clause 00:00:00
15 – The LIMIT Clause 00:00:00
Retrieving Data From Multiple Tables
16 – Inner Joins 00:00:00
17 – Joining Across Databases 00:00:00
18 – Self Joins 00:00:00
19 – Joining Multiple Tables 00:00:00
20 – Compound Join Conditions 00:00:00
21 – Implicit Join Syntax 00:00:00
22 – Outer Joins 00:00:00
23 – Outer Join Between Multiple Tables 00:00:00
24 – Self Outer Joins 00:00:00
25 – The USING Clause 00:00:00
26 – Natural Joins 00:00:00
27 – Cross Joins 00:00:00
28 – Unions 00:00:00
Inserting, Updating, and Deleting Data
29 – Column Attributes 00:00:00
30 – Inserting a Row 00:00:00
31 – Inserting Multiple Rows 00:00:00
32 – Inserting Hierarchical Rows 00:00:00
33 – Creating a Copy of a Table 00:00:00
34 – Updating a Single Row 00:00:00
35 – Updating Multiple Rows 00:00:00
36 – Using Subqueries in Updates 00:00:00
37 – Deleting Rows 00:00:00
38 – Restoring the Databases 00:00:00
Summarizing Data
39 – Aggregate Functions 00:00:00
40 – The GROUP BY Clause – Title 00:00:00
41 – The HAVING Clause – Title 00:00:00
42 – The ROLLUP Operator – Title 00:00:00
Writing Complex Query
43 – Introduction 00:00:00
44 – Subqueries 00:00:00
45 – The IN Operator 00:00:00
46 – Subqueries vs Joins 00:00:00
47 – The ALL Keyword 00:00:00
48 – The ANY Keyword 00:00:00
49 – Correlated Subqueries 00:00:00
50 – The EXISTS Operator 00:00:00
51 – Subqueries in the SELECT Clause 00:00:00
52 – Subqueries in the FROM Clause 00:00:00
Essential MySQL Functions
53 – Numeric Functions 00:00:00
54 – String Functions 00:00:00
55 – Date Functions in MySQL 00:00:00
56 – Formatting Dates and Times 00:00:00
57 – Calculating Dates and Times 00:00:00
58 – The IFNULL and COALESCE Functions 00:00:00
59 – The IF Function 00:00:00
60 – The CASE Operator 00:00:00
Views
61 – Creating Views 00:00:00
62 – Altering or Dropping Views 00:00:00
63 – Updatable Views 00:00:00
64 – THE WITH OPTION CHECK Clause 00:00:00
65 – Other Benefits of Views 00:00:00
Stored Procedures
66 – What are Stored Procedures 00:00:00
67 – Creating a Stored Procedure 00:00:00
68 – Creating Procedures Using MySQLWorkbench 00:00:00
69 – Dropping Stored Procedures 00:00:00
70 – Parameters 00:00:00
71 – Parameters with Default Value 00:00:00
72 – Parameter Validation 00:00:00
73 – Output Parameters 00:00:00
74 – Variables 00:00:00
75 – Functions 00:00:00
76 – Other Conventions 00:00:00
Triggers and Events
77 – Triggers 00:00:00
78 – Viewing Triggers 00:00:00
79 – Dropping Triggers 00:00:00
80 – Using Triggers for Auditing 00:00:00
81 – Events 00:00:00
82 – Viewing, Dropping and Altering Events 00:00:00
Transactions and Concurrency
83 – Transactions 00:00:00
84 – Creating Transactions 00:00:00
85 – Concurrency and Lockign 00:00:00
86 – Concurrency Problems 00:00:00
87 – Transaction Isolation Levels 00:00:00
88 – READ UNCOMMITTED Isolation Level 00:00:00
89 – READ COMMITTED Isolation Level 00:00:00
90 – REPEATABLE READ Isolation Level 00:00:00
91 – SERIALIZABLE Isolation Level 00:00:00
92 – Deadlocks 00:00:00
Data Types
93 – Introduction 00:00:00
94 – String Types 00:00:00
95 – Integer Types 00:00:00
96 – Fixed-point and Floating-point Types 00:00:00
97 – Boolean Types 00:00:00
98 – Enum and Set Types 00:00:00
99 – Date and Time Types 00:00:00
100 – Blob Types 00:00:00
101 – JSON Type 00:00:00
Designing Databases
102 – Introduction 00:00:00
103 – Data Modelling 00:00:00
104 – Conceptual Models 00:00:00
105 – Logical Models 00:00:00
106 – Physical Models 00:00:00
107 – Primary Keys 00:00:00
108 – Foreign Keys 00:00:00
109 – Foreign Key Constraints 00:00:00
110 – Normalization 00:00:00
111 – NF- First Normal Form 00:00:00
112 – Link Tables 00:00:00
113 – NF- Second Normal Form 00:00:00
114 – NF- Third Normal Form 00:00:00
115 – My Pragmatic Advice 00:00:00
116 – Don’t Model the Universe 00:00:00
117 – Forward Engineering a Model 00:00:00
118 – Synchronizing a Model with a Database 00:00:00
119 – Reverse Engineering a Database 00:00:00
120 – Project- Flight Booking System 00:00:00
121 – Solution- Conceptual Model 00:00:00
122 – Solution- Logical Model 00:00:00
123 – Project – Video Rental Application 00:00:00
124 – Solution- Conceptual Model 00:00:00
125 – Solution- Logical Model 00:00:00
126 – Creating and Dropping Databases 00:00:00
127 – Creating Tables 00:00:00
128 – Altering Tables 00:00:00
129 – Creating Relationships 00:00:00
130 – Altering Primary and Foreign Key Constraints 00:00:00
131 – Character Sets and Collations 00:00:00
132 – Storage Engines 00:00:00
TAKE THIS COURSE
  • FREE
  • 10 Days
5 STUDENTS ENROLLED

About WPLMS

WPLMS is the most popular Education WordPress theme. With over 12000 customers and several startups successfully running their businesses on WPLMS, it is the most powerful solution for Education websites right now.

Popular Tags

Who’s Online

There are no users currently online
top
Template Design © VibeThemes. All rights reserved.