vizag Posted November 21, 2012 Report Posted November 21, 2012 Lets plan to discuss 1 topic every day. It helps novice members to learn SQL and for those who already know, it would be like a subject refresh. Expert members can chip in their knowledge. Do you guys think it would work?
ChampakDas Posted November 21, 2012 Report Posted November 21, 2012 already ekada okati undhi jump into that http://www.andhrafriends.com/topic/343735-sql-server-technology-vallu-entamandi-vunaru/
vizag Posted November 21, 2012 Author Report Posted November 21, 2012 [quote name='GatisKandis' timestamp='1353524896' post='1302837033'] already ekada okati undhi jump into that [/quote] I haven't gone through all the pages but idhi SQL Server meedha disco anukunta kada Nenu cheppindhi SQL basics meedha Eg: [list] [*][font=arial,helvetica,sans-serif]DDL, DML, DRL, TCL & DCL commands[/font] [*][font=arial,helvetica,sans-serif]Constraints(Unique, Notnull, Check, Primary Key, Foreign Key)[/font] [*][font=arial,helvetica,sans-serif]Joins(Inner join, nonequi join, outer join, Natural join, cartesian join, self join)[/font] [*][font=arial,helvetica,sans-serif]Sub queries[/font] [*][font=arial,helvetica,sans-serif]Synonyms[/font] [*][font=arial,helvetica,sans-serif]Views[/font] [*][font=arial,helvetica,sans-serif]Indexes[/font] [*][font=arial,helvetica,sans-serif]SQL Functions(Number, Character, Date, Conversion, NVL functions)[/font] [*][font=arial,helvetica,sans-serif]Group functions, Group By, Having & Order By clauses[/font] [/list] This looks more like a question and answer session. I am thinking on this as more like a training thing Lets chalk out the list of topics and discuss them one after another each day
calmandquiet Posted November 21, 2012 Report Posted November 21, 2012 [quote name='vizag' timestamp='1353525463' post='1302837073'] I haven't gone through all the pages but idhi SQL Server meedha disco anukunta kada Nenu cheppindhi SQL basics meedha Eg:[list] [*][font=arial,helvetica,sans-serif]DDL, DML, DRL, TCL & DCL commands[/font] [*][font=arial,helvetica,sans-serif]Constraints(Unique, Notnull, Check, Primary Key, Foreign Key)[/font] [*][font=arial,helvetica,sans-serif]Joins(Inner join, nonequi join, outer join, Natural join, cartesian join, self join)[/font] [*][font=arial,helvetica,sans-serif]Sub queries[/font] [*][font=arial,helvetica,sans-serif]Synonyms[/font] [*][font=arial,helvetica,sans-serif]Views[/font] [*][font=arial,helvetica,sans-serif]Indexes[/font] [*][font=arial,helvetica,sans-serif]SQL Functions(Number, Character, Date, Conversion, NVL functions)[/font] [*][font=arial,helvetica,sans-serif]Group functions, Group By, Having & Order By clauses[/font] [/list] This looks more like a question and answer session. I am thinking on this as more like a training thing Lets chalk out the list of topics and discuss them one after another each day [/quote]
vissu Posted November 21, 2012 Report Posted November 21, 2012 [quote name='vizag' timestamp='1353525463' post='1302837073'] I haven't gone through all the pages but idhi SQL Server meedha disco anukunta kada Nenu cheppindhi SQL basics meedha Eg: [list] [*][font=arial,helvetica,sans-serif]DDL, DML, DRL, TCL & DCL commands[/font] [*][font=arial,helvetica,sans-serif]Constraints(Unique, Notnull, Check, Primary Key, Foreign Key)[/font] [*][font=arial,helvetica,sans-serif]Joins(Inner join, nonequi join, outer join, Natural join, cartesian join, self join)[/font] [*][font=arial,helvetica,sans-serif]Sub queries[/font] [*][font=arial,helvetica,sans-serif]Synonyms[/font] [*][font=arial,helvetica,sans-serif]Views[/font] [*][font=arial,helvetica,sans-serif]Indexes[/font] [*][font=arial,helvetica,sans-serif]SQL Functions(Number, Character, Date, Conversion, NVL functions)[/font] [*][font=arial,helvetica,sans-serif]Group functions, Group By, Having & Order By clauses[/font] [/list] This looks more like a question and answer session. I am thinking on this as more like a training thing Lets chalk out the list of topics and discuss them one after another each day [/quote] Okay nice Shall we start first one?
vizag Posted November 21, 2012 Author Report Posted November 21, 2012 [quote name='vissu' timestamp='1353526749' post='1302837201'] Okay nice Shall we start first one? [/quote] Thanksgiving holidays tharuwatha start chedham Ee lopu list of topics thayaruchdham...what say?
vizag Posted November 21, 2012 Author Report Posted November 21, 2012 List of topics - [list] [*]What is SQL? Database? [*][font=arial, helvetica, sans-serif]SELECT / DELETE / UPDATE / ALTER[/font] [*][font=arial, helvetica, sans-serif]Functions[/font] [*][font=arial, helvetica, sans-serif]Order by / Group by / Having[/font] [*][font=arial, helvetica, sans-serif]Joins / Unions[/font] [*]Sub-queries [*][color=#282828]Schema / Primary Key / Foreign Key / Constraints / Views / Synonyms[/color] [*]Normal Forms [*]DDL / DML / TCL [/list] [color=#282828]Have I missed anything? Please feel free to chip in[/color]
vikuba Posted November 21, 2012 Report Posted November 21, 2012 yes.,.. grp by order by meedha command vastey baagundu. but as long as one understands how the tables are architectured...i think playin wit them is kool and easy enough
vikuba Posted November 21, 2012 Report Posted November 21, 2012 I would suggest you to start wit why tables...what are tables...how tables are touched to get relevant/required info.
vizag Posted November 21, 2012 Author Report Posted November 21, 2012 [quote name='Aamphat' timestamp='1353529268' post='1302837402'] yes.,.. grp by order by meedha command vastey baagundu. but as long as one understands how the tables are architectured...i think playin wit them is kool and easy enough [/quote] Ee topics anni ayyaka architecture touch chesthe better emo kada
vikuba Posted November 21, 2012 Report Posted November 21, 2012 [quote name='vizag' timestamp='1353529529' post='1302837419'] Ee topics anni ayyaka architecture touch chesthe better emo kada [/quote] ok ur wish our wish
vizag Posted November 21, 2012 Author Report Posted November 21, 2012 [quote name='Aamphat' timestamp='1353529319' post='1302837406'] I would suggest you to start wit why tables...what are tables...how tables are touched to get relevant/required info. [/quote] To start with....what are tables / database and why SQL is used tho start chedhamani
vikuba Posted November 21, 2012 Report Posted November 21, 2012 [quote name='vizag' timestamp='1353529660' post='1302837431'] To start with....what are tables / database and why SQL is used tho start chedhamani [/quote] kool...challaga...kool
Recommended Posts