SQL Training
Course Overview
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 self-paced E learning course is done in partnership with SimpliLearn. It consists of a few videos that will take approximately 5 hours in total to finish the course. Upon successful completion of the SQL Training online course, you will receive an industry-recognized course completion certificate from SimpliLearn and Aventis that will be able to enhance your portfolio.
Eligibility
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.
Pre-requisites
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