Advanced SQL

SQL is a used to communicate with a database by firing queries.  Advance sql contains all the sql functions.
These are the topics covered:
   
Basics:

1.     SELECTing columns from a table
2.     Aggregates Part 1: COUNT, SUM, MAX/MIN
3.     Aggregates Part 2: DISTINCT, GROUP BY, HAVING

Intermediate:

1.     JOINs, syntax
2.     UNION vs UNION ALL
3.     Subqueries: IN, EXISTS, and inline views
4.     Subqueries: Correlated
5.     WITH syntax: Subquery Factoring/CTE
6.     Views

Advanced Topics:

1.  Controlling User Access.
2.  Using SET operators.
3.  DateTime Functions.
4.  Enhancements to Group by clause(cube, Rollup and Grouping).
5.  Advanced Subqueries (Multiple column subqueries, Subqueries in FROM clause, Scalar and correlated subqueries).
6.  WITH Clause.
7.  Hierarchical retrieval.

References/Books:
Murach’s Oracle SQL and PLSQL by Joel Murach, Murach and Associates.
Oracle Database 11g PL/SQL Programming Workbook, ISBN: 9780070702264, By: Michael McLaughlin,John Harper, TATAMCGRAW-HILL .
Oracle PL/SQL Programming, Fifth Edition By Steven Feuerstein.
Oracle database 11g: hands on SQL/PL SQL by Satish Asnani (PHI) EEE edition.

Notes Download:
Advance SQL (Sem-III) Complete Notes -Here

Advanced SQL All Programs Available - Here

Modern Operating Systems

Modern Operating Systems (mostly known as MOS) it includes the fundamentals of an operating system with small amounts of code written in autonomous C language.MOS describes many scheduling algorithms and also how the operating systems works..

References/Books:

1. Modern Operating Systems, Andrew Tanenbaum,
2. Operating Systems, --K. A.Sumitra Devi and N.P Banashree, SPD
3. Operating System Concepts --Abraham Silberschatz, Peter B.Galvin, Greg Gagne
4. Operating Systems- A concept based approached --D.M. Dhamdhere, McGrawHill publications
5. Operating Systems, ---Godbole and Kahate, McGrawHill publications.

Notes Download:

All Modern Operating System Notes -Here

Case Studies:

a) MS-DOS

b) Windows NT

c) Windows 2008 Server

d) Windows 7

e) Unix

f) Linux

g) OS/2

h) MAC OS

i) Symbian

j) Chrome

k) Android

Notepadd++ - A PowerFull Text Editor

Notepad++ is a versatile and powerful source code editor that also serves as an excellent replacement for the default Notepad text editor in Windows.It is the best code editor for Programmers.Html and Css Codes Can also be written , edited in This Tool..

DOWNLOAD HERE     

Features of Notepad++

• Open Source: I suppose nothing beats having a notepad replacement that is completely free. In addition, its open nature means that changes can be made in order to facilitate one's development efforts.

• Line Numbering: I'm not sure why this was left out of the default Notepad application in Windows. Well Notepad++ has line numbering, which is always useful to have when editing source code or configuration files.

• Zoom in and Out: Ever had to squint at text that is too small? Rather than having to change the size of the font just so that you can see them better, zooming in and out is trivial with Notepad++

• Detection of Modified Files: Like most advanced text editors on the market, Notepad++ knows when files have been modified in the background. When detected, the software will prompt whether the user would like to reload the source file, or overwrite the changes.

• Search and Replace: The value of this feature is often overlooked. I've personally found it to be very useful when editing configuration files, which required a search and replace of multiple items.

• Syntax Highlighting: Syntax highlighting is always a useful feature to have, whether doing a quick edit or viewing of source code.

• Many Languages Support: Supports Writing Code In Many Languages like php,C++,C,Javascript,Java ,etc

MicoProcessor 8085 Simulator Kit

Microprocessor 8085 Simulator Software Kit is aimed to be a proper substitute of Microprocessor 8085 Simulator Hardware Kit. A microprocessor communicates and operates in the binary 0s and 1s, called bits. Each microprocessor has a fixed set of instructions in the binary patterns called a machine language. However it is difficult to remember for human to communicate in the language of 0s and 1s. Microprocessor 8085 Hardware Kit accepts hexadecimal codes from users and executes to give the output which is much easier to remember and implement. Later assembly language is introduced in this purpose. The binary instructions are given abbreviated names, called mnemonics, which form the assembly language for a given microprocessor. Our software accepts codes written in hexadecimal codes as well as it supports assembly language code in a user friendly interface.

DOWNLOAD HERE

Functionality Of The Program

1. The software have a Code Editing interface, where user can have following facilities to enter code:

• User can enter code through mnemonics.
• User can enter code through Hexadecimal codes.
• User can also put comments on the program.
• There will be a sub-section where user can enter data according to the memory locations.

2. The software have a two way code Conversion section, where user can have following facilities: code:

• User can convert the mnemonics to Hexadecimal code, which is originally accepted by 8085 simulator kit.
• User can convert the Hexadecimal codes to corresponding Mnemonics.

 3. The software have a Execution section, where user can have following facilities:

• User can execute all codes at a time.
• User can execute codes one by one to debug the program.

4. The software have a Output interface, where user will find:

• T-states, Machine-cycles, Total time of execution.
• A display which will show the status of the flag registers.
• Data stored in the general purpose registers.

5.The software have a Output Port Interface, where user will find the following:

• There will be at most three ports to investigate the output of the port.
• User can see the output of the port through several visual displays.
• There will be also Seven-Segment-Display associated with a port, which will help user to examine the programs related to Seven-Segment-Display.

6. The software have an option to set the Clock frequency where user can execute the code at real time and also it will show the time needed for the execution at the output screen.

7. The software has a user-friendly interface which will consist of a click-n-generate code. This interface will help users who have less knowledge about the mnemonics for 8085.

8. The software can save the codes so that user can open the codes at a later time.

MicorProcessor 8085 Programs For Bsc-IT - Download

Open The Zip and Load All Programs From The MicorProcessor Simulator Kit Software

Learning Web Designing and Programming

HTML AND CSS

Html Includes Various Html Tags-standalone and container tags..Frames,Forms,Table ,Image ,Image mapping and Other Concepts and Css Includes Inline,Internal and External Css and also Class and Id selectors of Css..

Sites For Learning HTML and CSS :

• W3Schools - HTML AND CSS
• http://www.codecademy.com/en/tracks/web
• http://learn.shayhowe.com/html-css/
• http://html.net/tutorials/html5/
• http://html.net/tutorials/css/
• http://www.htmldog.com
• http://teamtreehouse.com/
• http://www.tutorialspoint.com/css/index.htm
• http://www.tutorialspoint.com/html5/index.htm
• http://www.cssbasics.com/
• Youtube - Html5 and Css3 Tutorials
• Youtube - Html5 By thenewboston

Html Programs For Bsc-IT - Download [ Open Nav.html To See All Files] 

JAVASCRIPT 

Javascript is a Scripting Language ..It is a client side scripting language.It is Used with Web browsers to interact with the users,control the browser,communicate Asynchronously.Javascript is the Most Popular Scripting language for website developing..

Sites For Learning Javascript:

• http://www.w3schools.com/js/
• https://www.codeschool.com/paths/javascript
• http://www.codeavengers.com/
• Youtube - Javascript Beginner Tutorials
• Youtube - Thenewboston

Javascript Programs For Bsc-IT - Download  

XML

XML (extensible Markup Language) is a meta-language; that is, it is a language in which other languages are created.It a language used to store data.. In XML, data is "marked up" with tags, similar to HTML tags..XML was designed to describe data. XML is used to store data or information..Xml includes DTD ,Schemas ,etc

Sites For Learning XML:

• http://www.w3schools.com/xml/
• Youtube - Xml Tutorials
• Youtube - Xml Beginner Tutorials
• Youtube - Xml Advance Tutorials

XML Programs For Bsc-IT - Download [ Open Nav.html To See All Files]

PHP AND MYSQL

PHP stands for PHP Preprocessor HyPertext. It is a server-side scripting language, like ASP. All PHP scripts are executed on the server. It supports many databases (MySQL, Informix, Oracle, Sybase, Solid,

PostgreSQL, Generic ODBC, etc.). It is open source software ..PHP runs on different platforms (i.e., Windows, LINUX, UNIX,etc.) and is compatible with almost all servers used today including APACHE, IIS, etc. MySQL is a free to download and use database server that is ideal for both small and large applications. It supports standard SQL and compiles on a number of platforms.

Sites For Learning PHP and MYSQL:

• http://www.tutorialspoint.com/php/index.htm
• http://www.tutorialspoint.com/mysql/index.htm
• http://www.w3schools.com/php/php_mysql_intro.asp
• http://php.about.com/
• http://www.phpeasystep.com/
• www.phpacademy.com
• http://www.homeandlearn.co.uk/php/php.html
• http://www.phpgang.com/
• http://php4allu.blogspot.in/
• http://www.codecademy.com/tracks/php
• http://tutorialsjackpot.blogspot.in/p/beginning-of-php.html
• www.php.net
• Youtube- Php Academy

For Any Program Or Topic Help You can Contact us at bscit.cracked999@gmail.com

Turbo C++ For WIndows 7 And 8

Turbo C++ is a C++ compiler and integrated development environment and computer language originally from Borland..Turbo C++ Doesn't Runs On Dos Based System. It Only Runs On Windows 93,95,98 & xp which run on Different Technology -NT..So To Make It Compatible With Windows 7 and 8 Some People Have Modded Turbo C++ To Work With Windows 7 and 8.

Download Turbo C++ 

First Install Turbo C++ Then Download The Beta Update of Turbo C++:
Beta-4 Update

If you want all your drives/Partitions to mount automatically .Download and install the patch Drive_automounter..

Some Controls Of Turbo C++:

1. To create a new file: File -> new.
2. To open an existing source file: File -> open OR F3-> select your file -> Open
3. To save your source file: File -> save / SaveAs OR F2-> give an name to your source file with .CPP extension -> OK. **Note your primary file name should not be longer than 8 characters
4. To rename or change the location of save source file: File -> SaveAs->write new file location (if required) and new file name -> OK Example - "D:\SAMPLE.CPP"
5. To print the program source code: File -> Print
6. Undo the last operation: Edit -> Undo OR Alt + Bksp
7. Redo the last operation: Edit -> Redo OR Shift + Alt + Bksp
8. Copy: Edit -> Copy OR Ctrl + Ins
9. Cut: Edit -> Cut OR Shift + Del
10. Paste: Edit -> Paste OR Shift + Ins
11. To find a specific word in your source (program): Search -> Find
12. To search for a word and to replace with some other: Search -> Replace
13. To Search again with previously mentioned word: Search -> Search again OR Ctrl + L
14. Go to specific line number: Search -> Go to line number
15. To run your program: Run -> Run OR Ctrl + F9
16. Menu options helpful for tracing the flow of program control:
17. Trace into: Run -> Trace into OR F7
18. Trace over: Run -> Trace over OR F8
19. To compile your program: Compile -> Compile OR Alt + F9

Features and Info About TurboC++ By NeuTroN:

• During re-installation please un-install it properly back-up all the source code files from "C:\turboc++\disk\" folder and delete the folder  "C:\turboc++", reboot your computer and then you can proceed to re-installing it.
• If mouse hangs after running a program you can re-enable it by selecting repaint desktop option from main menu. For that first press F10 use arrow keys to goto main menu(left of FILE menu) and select Repaint Desktop.
• For the convenience of the users some example programs have been given.
• Un-installing won't delete the source files you created, you can find them in "C:\TurboC++\Disk" folder.
• For Graphics programming please use "C:\\Turboc3\\BGI" instead of "C:\\Tc\\BGI" as BGI path.
• Problem regarding inserting special symbols please use the key-mapper to suite your needs, it can  be opened by pressing "Ctrl+alt+F1" and change the mapping according to your needs, please don't toggle it if you don't know what you are doing.
• This Version Works For Both C and C++
• This Version Works On Both Windows 7,8 64 Bit also ...So For Any Problems U can Contact the developer at striker.dbz@hotmail.com

Source- http://nvstech.weebly.com/