COURSE INTRODUCTION
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.
KEY FEATURES
COURSE OBJECTIVES
After completing this course, students will have knowledge and skills about:
AUDIENCE
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.
PREREQUISITE
There are no prerequisites for this database training course. This course can be taken up by anyone who wants to learn SQL.
COURSE CONTENT
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