In Partnership with Simplilearn
This is an ONLINE course. Participants are able to access to the online course upon completion of registration.
Once activated, the licenses will be valid for ONE YEAR from the date of activation.
Course include 3 hours of learning.
This SQL certification course gives you all of the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn how to correctly structure your database, author efficient SQL statements, and clauses, and manage your SQL database for scalable growth.
This online SQL certification course is ideal for freshers, programmers, software developers, and testing professionals who want to learn SQL. It’s also ideal for marketing professionals and salespeople who want to better understand their company’s data.
Lesson 01 – Introduction
Lesson 02 – Installation and getting started
Lesson 03 – Case Study Demo
Lesson 04 – Fundamental SQL statements
Lesson 05 – Restore and Back-up
Lesson 06 – Selection commands Filtering
Lesson 07 – Selection commands Ordering
Lesson 08 – Alias
Lesson 09 – Aggregate Commands
Lesson 10 – Group by Commands
Lesson 11 – Conditional Statement
Lesson 12 – JOINS
Lesson 13 – Subqueries
Lesson 14 – Views and Indexes
Lesson 15 – String Functions
Lesson 16 – Mathematical Functions
Lesson 17 – Date-Time Functions
Lesson 18 – PATTERN (STRING) MATCHING
Lesson 19 -Data Type conversion functions
Lesson 20 – User Access Control Functions
Lesson 21 – Bonus Section Nail that Interview
Lesson 22 – Performance tuning tips
Lesson 23 – Bonus Section Database Basics