SQL Programming
SQL Training course provides all the basic information you need to successfully start working with SQL databases and apply the SQL database to your applications. You will learn how to correctly structure your database and write efficient SQL statements and clauses and manage and scale your data base.
Benefits
Course Curriculum
There is no eligibility for SQL Training. This course is ideal for Freshers, programmers, software developers & Testing professionals.
There are no pre requisites for learning SQL.
Ch- 01 - Introduction
Ch- 02 - Installation and getting started
Ch- 03 - Case Study Demo
Ch- 04 - Fundamental SQL statements
Ch- 05 - Restore and Back-up
Ch- 06 - Selection commands Filtering
Ch- 07 - Selection commands Ordering
Ch- 08 - Alias
Ch- 09 - Aggregate Commands
Ch- 10 - Group by Commands
Ch- 11 - Conditional Statement
Ch- 12 - JOINS
Ch- 13 - Subqueries
Ch- 14 - Views and Indexes
Ch- 15 - String Functions
Ch- 16 - Mathematical Functions
Ch- 17 - Date-Time Functions
Ch- 18 - PATTERN (STRING) MATCHING
Ch- 19 -Data Type conversion functions
Ch- 20 - User Access Control Functions
Ch- 21 - Bonus Section Nail that Interview
Ch- 22 - Performance tuning tips
Ch- 23 - Bonus Section Database Basics