Showing posts with label TCCI online computer class. Show all posts
Showing posts with label TCCI online computer class. Show all posts
Sunday, June 14, 2020
Thursday, June 11, 2020
Structured Query Language-tccicomputercoaching.com
SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands
for Structured Query Language.
SQL- Structured Query Language is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.
SQL was one of the first commercial languages for Code’s relational model, as described in his influential 1970 paper, “A Relational Model of Data for Large Shared Data Banks.”. Despite not entirely adhering to the relational model as described by Codd, it became the most widely used database language.
The standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.
A database most often contains one or more tables. Each table is identified by a name (e.g. “Customers” or “Orders”). Tables contain records (rows) with data.
In this tutorial we will use the well-known North wind sample database (included in MS Access and MS SQL Server).
For example, to display data from database, select command is used,
SELECT * FROM Customers;
The most common operation in SQL, the query, makes use of the declarative SELECT statement. SELECT retrieves data from one or more tables, or expressions. Standard SELECT statements have no persistent effects on the database. Some non-standard implementations of SELECT can have persistent effects, such as the SELECT INTO syntax provided in some databases.
SQL keywords are NOT case sensitive like any other c language: select is the same as SELECT
Some of the Most Important SQL Commands:
SELECT – extracts data from a database
UPDATE – updates data in a database
DELETE – deletes data from a database
INSERT INTO – inserts new data into a database
CREATE DATABASE – creates a new database
ALTER DATABASE – modifies a database
CREATE TABLE – creates a new table
ALTER TABLE – modifies a table
DROP TABLE – deletes a table
CREATE INDEX – creates an index (search key)
DROP INDEX – deletes an index
If you like this post then please like this post and share this post.
To learn more about SQL at TCCI
Visit us @ www.tccicomputercoahcing.com
Call us @ 98256 18292.
SQL- Structured Query Language is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.
SQL was one of the first commercial languages for Code’s relational model, as described in his influential 1970 paper, “A Relational Model of Data for Large Shared Data Banks.”. Despite not entirely adhering to the relational model as described by Codd, it became the most widely used database language.
The standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.
A database most often contains one or more tables. Each table is identified by a name (e.g. “Customers” or “Orders”). Tables contain records (rows) with data.
In this tutorial we will use the well-known North wind sample database (included in MS Access and MS SQL Server).
For example, to display data from database, select command is used,
SELECT * FROM Customers;
The most common operation in SQL, the query, makes use of the declarative SELECT statement. SELECT retrieves data from one or more tables, or expressions. Standard SELECT statements have no persistent effects on the database. Some non-standard implementations of SELECT can have persistent effects, such as the SELECT INTO syntax provided in some databases.
SQL keywords are NOT case sensitive like any other c language: select is the same as SELECT
Some of the Most Important SQL Commands:
SELECT – extracts data from a database
UPDATE – updates data in a database
DELETE – deletes data from a database
INSERT INTO – inserts new data into a database
CREATE DATABASE – creates a new database
ALTER DATABASE – modifies a database
CREATE TABLE – creates a new table
ALTER TABLE – modifies a table
DROP TABLE – deletes a table
CREATE INDEX – creates an index (search key)
DROP INDEX – deletes an index
If you like this post then please like this post and share this post.
To learn more about SQL at TCCI
Visit us @ www.tccicomputercoahcing.com
Call us @ 98256 18292.
Tuesday, April 28, 2020
Thursday, April 23, 2020
Learn Online Microsoft Excel - tccicomputercoaching.com
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS
X, Android and iOS. It structures calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications, which makes work easy for
employees in companies.
Microsoft Excel is in form of grid, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.
In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It also contains different formula function like maths, logical, text, date-Time, Financial etc…….
Short cut keys for Excel:
Ribbon:
Alt key press:
To display a tab on the Ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab’s buttons appear. Then, press the key for the button you want.
To get to the Ribbon, press Alt, and then, to move between tabs, use the Right Arrow and Left Arrow keys.
To hide the Ribbon so you have more room to work, press Ctrl+F1. Repeat to display the Ribbon again.
Go to the access keys for the Ribbon
To go directly to a tab on the Ribbon, press one of the following access keys:
If you like this post then please share and like this post.
To Learn More about Computer Course
Visit us @ tccicomputercoaching.com
Call us @ 98256 18292.
Microsoft Excel is in form of grid, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.
In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It also contains different formula function like maths, logical, text, date-Time, Financial etc…….
Short cut keys for Excel:
Ribbon:
Alt key press:
To display a tab on the Ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab’s buttons appear. Then, press the key for the button you want.
To get to the Ribbon, press Alt, and then, to move between tabs, use the Right Arrow and Left Arrow keys.
To hide the Ribbon so you have more room to work, press Ctrl+F1. Repeat to display the Ribbon again.
Go to the access keys for the Ribbon
To go directly to a tab on the Ribbon, press one of the following access keys:
| To do this | Press |
| Open the Tell me box on the Ribbon and type a search term for assistance or Help content. | Alt+Q, and then enter the search term. |
| Open the File page and use Backstage view. | Alt+F |
| Open the Home tab and format text and numbers and use the Find tool. | Alt+H |
| Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. | Alt+N |
| Open the Page Layout tab and work with themes, page setup, scale, and alignment. | Alt+P |
| Open the Formulas tab and insert, trace, and customize functions and calculations. | Alt+M |
| Open the Data tab and connect to, sort, filter, analyze, and work with data. | Alt+A |
| Open the Review tab and check spelling, add comments, and protect sheets and workbooks. | Alt+R |
| Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros. | Alt+W |
If you like this post then please share and like this post.
To Learn More about Computer Course
Visit us @ tccicomputercoaching.com
Call us @ 98256 18292.
Wednesday, April 22, 2020
Online Learn C Language - tccicomputercoaching.com
We teach following topics in c course:
- Introduction to C
- Basic Syntax
- Token
- Data Types and Variables
- Constants, Literals
- Storage class
- Operators
- Loop Controls
- For Loop
- While Loop
- Do-While Loop
- Decision Making
- Arrays
- String
- Function
- Pointer
- Inheritance
- Structure
- Union
- Type Casting
- Recursion
- Files
- Command Line Argument
Class Mode : Theory with Practicals.
Lecture Timing : At student’s convenience.
To know more about c language course in Ahmedabad , C language course
Call us @ 9825618292
Visit us @ www.tccicomputercoaching.com
Friday, April 17, 2020
Friday, April 10, 2020
Is C High Level Programming Languages -tccicomputercoaching.com
A high-level language (HLL) is a programming language such as C, FORTRAN, or Pascal that enables a programmer to write programs that are more or less independent of a particular type of computer. Such languages are considered high-level because they are closer to human languages and further from machine languages.
C is a high level procedure oriented language used in almost all technologies being developed. High level means it is written in such a way that user can easily read and understand it. You won't see any complex binary or Hexadecimal numbers in its code.Even associations like NASA and ISRO use this language to write codes for their projects.
sometimes c called as high-level language but sometimes called as middle-level language because OS such as WINDOWS,UNIX and LINUX are developed by this language.
C language is belonging to middle level language. C language behaves as a bridge between machine level (low level) languages and high level languages. C language is more user friendly than machine level languages.
To learn more about C Programming Language at TCCI.
TCCI Computer Coaching is located in Bopal and Satellite in Ahmedabad.
Call us@ 98256 18292
Visit us@ http://tccicomputercoaching.com/
Subscribe to:
Posts (Atom)