Top 28 Apps Similar to SQL &PL-SQL Tutorial
SQL Course 1.00
With this course you will learn everything necessary to becomeanexpert programmer in Databases. You will find courses of ansiSQL(standard language for accessing databases), courses of designofdatabases, language courses to specific databases such asSQLServer, PL-SQL, and MySQL. You will learn how to normalizearelational database, perform queries, inserts and updatesoftables.(Select, Insert, update, delete,...) This coursehassections for all levels. Tutorials for the beginner andconceptsthat are more advanced for those who have experiencewithrelational databases.
SQL Offline Tutorial & Interview Questions 5.8
Learn SQL - offline tutorial. Read SQL concepts and Easytounderstand This App enables reading concepts Offline (withouttheinternet). Download our App and read it whenever you feel like.Nointernet connection is required. This App lets developers orCSstudents or Engineering students or anyone who is interestedinlearning SQL from theory, implementation. If you are aprogrammerlooking for your first programming job and preparing forcodinginterviews, or a student who is preparing for exams aboutDatabaserelated or SQL cases, this app could be a right fit for youAll theconcepts are explained easily. There is a favorite optiontobookmark your favorites. Also, you can track which concept youreadand which are unread Currently, we are covering followingtopics:SQL Basics SQL Functions SQL Advanced concepts SQL BasicQuestionsSQL Interview Questions Under SQL Basics section followingconceptsare covered : SQL Intro SQL Syntax SQL SELECT SQL DISTINCTSQLWHERE SQL AND & OR SQL ORDER BY SQL INSERT SQL UPDATESQLDELETE Under SQL Advanced following concepts are covered: SQLTopSQL LIKE SQL WILDCARDS SQL IN SQL BETWEEN SQL ALIAS SQL JOINSQLINNER JOIN SQL LEFT JOIN SQL RIGHT JOIN SQL UNION SQL SELECTINTOSQL CONSTRAINTS SQL NOT NULL CONSTRAINT SQL UNIQUE CONSTRAINTSQLPRIMARY KEY CONSTRAINT SQL FOREIGN KEY CONSTRAINT SQL CHECKSQLDEFAULT SQL CREATE INDEX SQL DROP SQL ALTER SQL INCREMENT SQLVIEWSSQL DATES SQL NULL SQL ISNULL SQL DATA TYPES Under SQLFunctionssection following concepts are covered: SQL avg() SQLcount() SQLfirst() SQL last() SQL max() SQL min() SQL sum() SQLGroup By SQLHaving SQL ucase() SQL lcase() SQL mid() SQL len() SQLround() SQLnow() SQL format() SQL Quick Reference SQL Hosting SQLBasicInterview Questions Section: At present we have added the22interview questions. 1 What is a primary key? 2 What is aforeignkey? 3 What is view in SQL? 4 What is an Index in SQL? 5What isClustered Index in SQl? 6 What is NonClustered Index in SQL?7 Whatis the difference between clustered and non clustered indexin SQL?8 Is it possible to sort a column using a column alias? 9What isthe difference between BETWEEN and IN condition operators?10 Whatis the difference between DELETE and TRUNCATE statement inSQL? 11What is the difference among NULL value, zero and blankspace? 12What is subquery? 13 What are the types of subquery? 14What is astored procedure? 15 What is Auto Increment? 16 What isSelf-Join?17 What is user defined functions? 18 What are all typesof userdefined functions? 19 What is collation? 20 AdvantagesandDisadvantages of Stored Procedure? 21 What is Union, minusandInteract commands? 22 What are the types of join and explaineach?SQL Interview Questions Section: At present we have added the38interview questions. For these questions please check in our appIfyou want us to add any new topics please Write to Us usingthe"Feedback/Suggestions" option in our App. Learn SQL concepts inavery easy way without connecting to the internet is themainobjective. We will also add the SQL interview questions in ournextupdate. Please stay tuned for the next update
Database Notes
Database Notes provides you a wide rangeofknowledge with practical approach that can be asked duringaInterview. Application answers most commonly askedinterviewquestions and has been categories for ease.This application is unique as it gives you an overview towardtheDatabase, instilling you with the confidence that you needtoendure the most difficult of interviews.Features:1. List of common database table with practical approach2. Notes has been categorised for ease of use.3. The Application covers a wide range of questions relatedtoDatabase. You may not be interested in all of them so pleaseselectthe Categories in which you are interested.Categories:Application cover questions from the following sevenbroadcategories.1. Database Administration2. Database Architecture3. Basic4. Data Access5. DBA6. PL-SQL7. SQL PlusThis is the first version, I will keep updatingtheapplicationHope this application helps you!
Learn SQL 1.0.1
This app provides the best wayandbetterunderstanding of SQL.This is provide all Things given below:► Basics► SQL Keywords► Select, Insert, Update, Delete, Alter, Create, Drop► Joins - Inner, Outer, Left, Right► SQL Date Functions► SQL Time Functions► SQL Aggregate Functions - AVG(), COUNT(), FIRST(),FORMAT(),SUM(),ROUND(), UCASE(), SPACE(),REPLACE(), NOW(), MIN(), MAX(), LAST(), LCASE(), etc.► Group By - Having► SQL Indexes► SQL Constraints - UNIQUE, NOT NULL► Between► Switch Case in SQL► Data Types► Dates► PK and FK► SQL Functions► LIKE► UNION► SQL Views► Wild Cards► Advanced SQL Topics
SQL Queries 1.0
1.This is basic app for learning SQL queries whicharefrequentlyasked in SQL exams or interview. 2.In this app usercannavigatequeries using "Next" or "Prev" button. Also he candirectlygo toany query by selecting "Go to" Button. 3.Currently Ihaveaddedonly 63 queries. As soon as I get new query definitelyi'lladd inapp.User can also send me query or any source ofqueryThanksPately
Belajar SQL 1.0
Aplikasi Belajar SQL adalahAplikasiyangdigunakan agar memahami query SQL, pada aplikasiinidisediakanmateri-materi yang mudah dimengerti, pengenalanfungsiInsert,Select dan lain-lain. diharapkan aplikasi ini dapatmembantubagipemula dalam pembuatan databases dengan QuerySQL.Learning SQLapplicationisan application that is used to understand the SQLquery, inthisapplication are provided materials that are easy tounderstand,theintroduction of the function Insert, Select, andothers.Thisapplication is expected to be helpful to the beginnerinmakingdatabases with SQL Query.
Sql Queries 1.0
A collection of Sql Queries thatareusedfrequently in job interviews.You can use this application to if you want to getreadyforinterviews, or just to refresh your basicSqlQueriesknowledge.If you are an interviewer you can also use this applicationtogetideas for questions.Key features:* Auto reading of the Questions And Answers* Share your notes via e-mail, SMS, and etc.;
SQL Tutorials Fulllversion 1.0
---SQL Tutorials Fulllversion---SQL is a standard language for accessing databases.What is SQL?SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL is an ANSI (American National StandardsInstitute)standardOur SQL tutorial will teach you how to use SQL toaccessandmanipulate data in: MySQL, SQL Server, Access, Oracle,Sybase,DB2,and other database systems.---SQLtutorialsFulllversion ---SQL is a standard language for Accessing databases.What is SQL?SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL is an ANSI (American National StandardsInstitute)standardOur SQL tutorial will teach you how to use SQL toaccessandmanipulate data in MySQL, SQL Server, Access, Oracle,Sybase,DB2,and other database systems.
DBMS Interview Questions 1.0.3
This app is designed for computer science engineering,b.tech,mca,bca,ms student & software professionals to learnDatabasequestiones mostly asked during interview. Allmost allquestion fromtopics given below are covered in the app.Introduction andapplications of DBMS, Purpose of data base, Data,Independence,Database System,architecture- levels, Mappings,Database, users andDBA,Structure of relational databases,Domains,Relations,,Relational algebra – fundamental operatorsandsyntax,,relational algebra queries, tuplerelationalcalculus,Entity-Relationship model :Basic concepts,Design process,constraints, Keys,Design issues, E-R diagrams, weakentitysets,extended E-R features–generalization,specialization,aggregation, reduction toE-Rdatabase schema,Relational Database design :FunctionalDependency –definition, trivial and non-trivial FD, closure of FDset, closureof attributes, irreducible setof FD, Normalization –1Nf, 2NF, 3NF,Decomposition,using FD- dependency preservation,BCNF, Multivalueddependency, 4NF, Join dependency and 5NF,QueryProcessing &Query Optimization :Overview, measures of querycost, selectionoperation,sorting, join, evaluation ofexpressions,transformationof relational expressions,estimating,statistics of expressionresults, evaluationplans,materialized views,Transaction Management: Transactionconcepts, properties of transactions,serializabilityoftransactions, testing for serializability,System recovery,Two-Phase Commit protocol,Recovery and Atomicity, Log-basedrecovery,concurrent,executions of transactions and relatedproblems,Lockingmechanism, solution to concurrencyrelated,problems, deadlock, ,two-phase locking protocol,Isolation,Intentlocking,Security:introduction, Discretionary accesscontrol,MandatoryAccess Control, Data Encryption,SQL Concepts:Basics ofSQL, DDL,DML,DCL, structure – creation,alteration,definingconstraints – Primary key, foreign key,unique, not null,check, INoperator,Functions - aggregate,functions,Built-infunctions,numeric, date, string functions, setoperations,sub-queries,correlated sub-queries, Use of group by,having, orderby,join and its types, Exist, Any, All , view anditstypes,transaction control commands –Commit,Rollback,Savepoint,PL/SQL Concepts :Cursors, StoredProcedures,Stored Function,Database,Triggers
