What you'll learn
- How to write SQL queries with confidence
- Design and optimize relational databases
- How to secure databases
- How to use indexing for performance, and more
Who is this course for
- Individuals who want to learn how to design and query relational databases
- Students in computer science who wish to learn more about SQL
- People interested in careers in back-end programming, database administration, or data science
- SQL developers that desire to improve their SQL knowledge
After completing this course, you will uncover the mystery of SQL, Database Management, and Database Design.
With this, you can get free access to
- Course Materials for Life
- Expertise in SQL, Database Management, and Database Design
About Us
Over 100,000 students have received instruction from this online academy in topics including Lift Style, Fitness Training, Cyber Security, Ethical Hacking, Facebook Ads, SEO, Email Marketing, eCommerce, Business Investing, Social Media Marketing, Launching Your Own Business, and Marketing/Ad Agency!
We provide a wide variety of top-notch online courses that educate through real-world examples from subject matter experts and tried-and-true research, all supported by top-notch, studio vocally narrated videos! Teaching practical life skills, which are crucial in today's environment, is the focus.
Every course offered by this online learning academy is instructed by subject-matter specialists who genuinely love what they do and want to share it with others.
Course Curriculum
- 1- The SELECT Statement (5:50)
- 2- The SELECT Clause (8:48)
- 3- The WHERE Clause (5:17)
- 4- The AND, OR and NOT Operators (6:52)
- 5- The IN Operator (3:03)
- 6- The BETWEEN Operator (2:12)
- 7- The LIKE Operator (5:37)
- 8- The REGEXP Operator (9:21)
- 9- The IS NULL Operator (2:26)
- 10- The ORDER BY Clause (7:06)
- 11- The LIMIT Clause (3:26)
- 1- Inner Joins (8:27)
- 2- Joining Across Databases (2:47)
- 3- Self Joins (4:14)
- 4- Joining Multiple Tables (6:46)
- 5- Compound Join Conditions (3:41)
- 6- Implicit Join Syntax (2:20)
- 7- Outer Joins (6:27)
- 8- Outer Join Between Multiple Tables (6:19)
- 9- Self Outer Joins (2:12)
- 10- The USING Clause (5:23)
- 11- Natural Joins (1:21)
- 12- Cross Joins (3:14)
- 13- Unions (8:29)
- 1- Column Attributes (3:25)
- 2- Inserting a Row (5:46)
- 3- Inserting Multiple Rows (3:18)
- 4- Inserting Hierarchical Rows (5:53)
- 5- Creating a Copy of a Table (8:47)
- 6- Updating a Single Row (3:55)
- 7- Updating Multiple Rows (3:14)
- 8- Using Subqueries in Updates (5:37)
- 9- Deleting Rows (1:24)
- 10- Restoring the Databases (1:06)
- 1- What are Stored Procedures (2:18)
- 2- Creating a Stored Procedure (5:34)
- 3- Creating Procedures Using MySQLWorkbench (1:21)
- 4- Dropping Stored Procedures (2:09)
- 5- Parameters (5:26)
- 6- Parameters with Default Value (8:18)
- 7- Parameter Validation (6:40)
- 8- Output Parameters (3:55)
- 9- Variables (4:34)
- 10- Functions (6:29)
- 11- Other Conventions (1:52)
- 1- Transactions (2:44)
- 2- Creating Transactions (5:11)
- 3- Concurrency and Locking (4:07)
- 4- Concurrency Problems (7:25)
- 5- Transaction Isolation Levels (5:43)
- 6- READ UNCOMMITTED Isolation Level (3:27)
- 7- READ COMMITTED Isolation Level (3:02)
- 8- REPEATABLE READ Isolation Level (3:30)
- 9- SERIALIZABLE Isolation Level (2:18)
- 10- Deadlocks (6:11)
- 1- Introduction (1:25)
- 2- Data Modelling (2:26)
- 3- Conceptual Models (4:34)
- 4- Logical Models (7:24)
- 5- Physical Models (6:28)
- 6- Primary Keys (3:23)
- 7- Foreign Keys (5:48)
- 8- Foreign Key Constraints (5:22)
- 9- Normalization (1:24)
- 10- 1NF- First Normal Form (2:42)
- 11- Link Tables (4:02)
- 12- 2NF- Second Normal Form (6:33)
- 13- 3NF- Third Normal Form (1:44)
- 14- My Pragmatic Advice (2:55)
- 15- Don't Model the Universe (4:24)
- 16- Forward Engineering a Model (2:35)
- 17- Synchronizing a Model with a Database (4:49)
- 18- Reverse Engineering a Database (3:11)
- 19- Project- Flight Booking System (0:23)
- 20- Solution- Conceptual Model (8:00)
- 21- Solution- Logical Model (9:04)
- 22- Project - Video Rental Application (1:05)
- 23- Solution- Conceptual Model (7:00)
- 24- Solution- Logical Model (8:30)
- 25- Creating and Dropping Databases (1:41)
- 26- Creating Tables (3:13)
- 27- Altering Tables (2:56)
- 28- Creating Relationships (4:47)
- 29- Altering Primary and Foreign Key Constraints (2:11)
- 30- Character Sets and Collations (6:29)
- 31- Storage Engines (2:27)
- 1- Introduction (0:41)
- 2- Indexes (2:49)
- 3- Creating Indexes (5:01)
- 4- Viewing Indexes (3:19)
- 5- Prefix Indexes (3:40)
- 6- Full-text Indexes (7:50)
- 7- Composite Indexes (5:12)
- 8- Order of Columns in Composite Indexes (9:17)
- 9- When Indexes are Ignored (5:03)
- 10- Using Indexes for Sorting (7:02)
- 11- Covering Indexese (1:59)
- 12- Index Maintenance (1:25)
- 13- Performance Best Practices
Frequently Asked Questions
When does the course start and finish?
The course has begun and will never stop! You set the start and end dates for this entirely self-paced online course.
How long do I have access to the course?
Lifetime access—how does that sound? You receive unrestricted access to this course after registering for as long as you like, on any device you own.
Do I get a certificate?
Yes, when you complete the course, you will receive a certificate of completion which you can happily add to your resume or LinkedIn profile.
Can I cancel my subscription?
Yes you can. You have a 15-days money-back guarantee.
