If you are well aware with the basic SQL, then learning advanced SQL is not a rocket science. I am sharing the topics for advanced SQL with a little description, you can go through the links which are referred by me also for learning advanced SQL deeply . Advanced SQL Topics - a. Stored Procedures - Stored Procedures are stored as a group in RDBMS and it is a collection of SQL statements. We can reuse it whenever we require in programming. The major benefit of the Stored Procedure is that it provides a security layer between the user interface and database. You can learn this with the help of syntax and example. b. Indexes - Indexes used to speed up data retrieval in the database. It is a schema object. It slows down data input with insert and update statements, but speed up select queries and where clauses. Indexes are of following types - Normal Index Unique Index Clustered Index Non-Clustered Index Function-Based Index Composit...
“A year spent in artificial intelligence is enough to make one believe in God.”