What is SQL ?
SQL stands for Structured Query Language. 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.
List of SQL Software :
This certification is primarily good for developer, application developers, PL/SQL developer, forms developer, system analysts, business analysts and data warehouse administrator. It is also recommended to the entry-level and junior programmers wishing to start and/or continue down the path of using SQL technologies and same time software developers and technical leads wishing to solidify their SQL-related skill sets.
SQL stands for Structured Query Language. 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.
List of SQL Software :
- Oracle
- MySQL
- Microsoft SQL Server
- PostgreSQL
- IBM DB2.
Syllabus of SQL :
Lesson 1: Introduction to SQL
Lesson 2: Retrieving Data
Lesson 3: Updating Data
Lesson 4: Inserting Data
Lesson 5: Deleting Data
Lesson 6: Sorting and Filtering Data
Lesson 7: Advanced Filtering
Lesson 8: Summarizing Data
Lesson 9: Grouping Data
Lesson 10: Using Sub queries
Lesson 11: Joining Tables
Lesson 12: Managing Tables
Lesson 13: Using Views
Lesson 14: Stored Procedures
Lesson 15: Using Cursors
Lesson 16: Using Transactions
SQL International Exam Details :
This certification is primarily good for developer, application developers, PL/SQL developer, forms developer, system analysts, business analysts and data warehouse administrator. It is also recommended to the entry-level and junior programmers wishing to start and/or continue down the path of using SQL technologies and same time software developers and technical leads wishing to solidify their SQL-related skill sets.
| Exam Number | 1Z0-051 |
|---|---|
| Exam Name | Oracle Database 11g: SQL Fundamentals |
| Certification Track | Oracle Certified Oracle Database 11g Administrator |
| Exam Product Version | SQL and PL/SQL |
| Exam Fees | US$ 125 |
| Number of Questions | 70 |
| Duration | 120 Minutes |
| Passing Score | 60% |
| Questions format | Multiple Choice |
Most Important questions :
1. What does SQL stand for?
2. Which SQL statement is used to extract data from a database?
3.Which SQL statement is used to update data in a database?
4. Which SQL statement is used to delete data from a database?
5. Which SQL statement is used to insert new data in a database?
6. With SQL, how do you select a column named "FirstName" from a table named "Persons"?
7. With SQL, how do you select all the columns from a table named "Persons"?
8.With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
9.With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
10. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
SQL Video Material:
Images :
3.Which SQL statement is used to update data in a database?
4. Which SQL statement is used to delete data from a database?
5. Which SQL statement is used to insert new data in a database?
6. With SQL, how do you select a column named "FirstName" from a table named "Persons"?
7. With SQL, how do you select all the columns from a table named "Persons"?
8.With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
9.With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
10. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
SQL Video Material:
Images :
No comments:
Post a Comment