SQL Course for Beginner
- No programming knowledge required
I created this course to help freshers start day career as Oracle DBA. SQL and Unix is really important to start career as Oracle DBA.
In this course I have explain about the basic concept of SQL. this course will help you to get the knowledge about structured query language.
whenever you go for an interview as a fresher Oracle DBA there is a chances that interviewer can expect that you have a knowledge about SQL.
What is SQL?
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
What Can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
RDBMS stands for Relational Database Management System.
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.
Who this course is for:
- Beginner for Oracle DBA and anyone who want to work on databases
I am oracle certified DBA and having experience working with Bank,finance,Healthcare,Retail domain.I have knowledge on RAC,ASM,Golden gate,Core DBA,Shell scripting. I have also working experince as Web Developer.
I have tried to cover all important topic by providing the real time example.
I have trained many students and keep going the same. I am working with multinational company and got exposure to work on many technology.