Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • Last Modified:

interesting topic about sql

Hi,
can you advise me some interesting topic about sql, I could speak about 30 minutes. I'm looking for rather actual topic and not too advanced (easy to understand for normal sql users).

thanks
0
xLeon1
Asked:
xLeon1
4 Solutions
 
sudheeshthegreatCommented:
something that 'normal' sql users will be interested in:
1. views
2. triggers
3. cursors
4. stored procedures
5. indexes

a bit advanced topic might be 'query optimization'.
0
 
Ryan ChongCommented:
There are so many different native sql languages in the market, like Jet-SQL, T-SQL, PL/SQL etc, here are some of their references:

http://www.w3schools.com/sql/default.asp
http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html
http://www.mssqlcity.com/
http://www.sqlcourse.com/
http://www.orafaq.com/
http://technet.oracle.com/

0
 
bochgochCommented:
How about a restatement of the principles of SQL (i.e. set theory / boolean algebra...) and some worked examples, you could provide examples of implementations in different 'flavours' (i.e. Oracle SQL, SQL Server) if that would be of interest to your audience.

Alternatively, depending on the environment you use, look at some of the new directions that SQL is taking (in its broadest sense), for example Oracle PLSQL Pages, SQL's application to OLAP databases etc....
0
 
Ted BouskillSenior Software DeveloperCommented:
How about the rules of data normalization?  If I had a million dollars for every bad database table layout I have seen that broke every or most of the first 3 rules of normalization I would be richer than Bill Gates.  Well maybe not Bill Gates, but at least I would be rich! ;)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now