| Udvikler: | G Sanghani (47) | ||
| Pris: | Gratis | ||
| Rangeringer: | 0 | ||
| Anmeldelser: | 0 Skriv en anmeldelse | ||
| Lister: | 0 + 0 | ||
| Point: | 0 + 14 (3.2) ¡ | ||
| App Store | |||
Beskrivelse
Topics covered in the app are:
> Basic Terms of SQL
- Basic Terms
- Table & Column Naming Rules
> Tools of SQL
- Microsoft SQL Server,
- MySQL
- Oracle
- Postgre SQL
- SQLite
- MongoDB
> Components of SQL
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
> Data Types
- SQL data types
- Comparison between TinyInt, SmallInt, Int, BigInt
- Comparison between Char, NChar, Varchar, NVarchar
- The disadvantage of text datatype
> Basic Topics
- SQL CREATE Database
- SQL DROP Database
- SQL CREATE Table
- SQL CREATE Table from an Existing Table
- SQL INSERT INTO SELECT
- SQL SELECT
- SQL WHERE Clause
- SQL SELECT DISTINCT
- SQL TOP Clause
- SQL UPDATE
- SQL DELETE
- SQL TRUNCATE
- SQL DELETE vs TRUNCATE
- SQL ALTER
- Rules of ALTER Statement
- SQL RENAME (Table)
- SQL RENAME (Column)
- SQL DROP
- DROP vs TRUNCATE
> Advance Topics
- SQL AND, OR, NOT
- SQL Combined AND, OR, NOT
- SQL BETWEEN
- SQL ORDER BY
- SQL IN
- SQL NOT IN
- SQL LIKE
- SQL NULL
- SQL CASE WHEN
- SQL EXISTS Operator
- SQL ALL & ANY Operator
- SQL COMMANDS
- SQL AGGREGATE Functions
- SQL GROUP BY
- SQL HAVING
- SQL WHERE vs HAVING
- SQL NUMERIC Functions
- SQL STRING Functions
- SQL DATE Functions
- SQL ADVANCED Functions
- SQL SET Operators
- SQL AUTO INCREMENT
- SQL IDENTITY INSERT ON/OFF
- SQL ALIAS
- SQL JOINS
- SQL CARTESIAN JOIN
- SQL INNER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL JOIN
- SQL SELF JOIN
- SQL JOIN vs UNION
- SQL UNIQUE KEY
- SQL PRIMARY KEY
- SQL FOREIGN KEY
- Primary Key vs Unique Key vs Foreign Key
- SQL CHECK Constraint
- SQL DEFAULT Constraint
- SQL SUBQUERY
- SQL CORRELATED SUBQUERY
- SQL SUBQUERY vs CORRELATED
- SQL COMMIT/ROLLBACK
- SQL GRANT/REVOKE
Key features of the app are:
> 50+ topics of Structured Query Language (SQL)
> 50+ sample query for your referral
> Learn SQL language for free
> Easy to use User Interface
> You can share the app with your friends and family members.
----------------------------------------------------------------------------------------------------------------------------------------------
This App is developed at ASWDC by Ayushi Ghoniya (160540107048), 6th-semester CE Student. ASWDC is Apps, Software, and Website Development Center @ Darshan Institute of Engineering & Technology, Rajkot run by Students & Staff of Computer Engineering Department
Call us: +91-9727747317
Write to us: aswdc@darshan.ac.in
Visit: http://www.darshan.ac.in http://www.darshan.ac.in/aswdc
Follow us on Facebook: https://www.facebook.com/DarshanInstitute.Official
Follows us on Twitter: https://twitter.com/darshan_inst
Skærmbilleder
Nyheder
- Version: 2.1
- Opdateret:
- - Interview Questions introduced.
- More SQL questions added in the topics.
- Improved stabilit and Bug fixes.
Pris
- I dag: Gratis
- Minimum: Gratis
- Maksimalt: Gratis
Overvåg priser
Udvikler
- G Sanghani
- Platforme: iOS Apps (47)
- Lister: 1 + 0
- Point: 1 + 62 ¡
- Rangeringer: 0
- Anmeldelser: 0
- Rabatter: 0
- Videoer: 0
- RSS: Abonner
Point
0☹️
Rangeringer
0☹️
Lister
0☹️
Anmeldelser
Vær den første til at gennemgå 🌟
Yderligere oplysninger
Kontaktpersoner
- X: darshan_inst
- Facebook: DarshanInstitute.Official
- Websted:
http://www.darshan.ac.in
Du vil måske også kunne lide
-
- Learn SQL Programming [PRO]
- iOS Apps: Læring Ved: Muhammad Mubeen
- $1.99
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 0 Version: 1.0 "Learn SQL Programming" is your ultimate guide to mastering SQL, the foundational language for managing and manipulating relational databases. Whether you're a beginner or an ... ⥯
-
- Learn JavaScript Programming
- iOS Apps: Læring Ved: Shahbaz Khan
- Gratis
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 1 + 349 (4.6) Version: 1.8.0 Learn JavaScript Programming and start your career. This app will give you all the basics to advanced knowledge you need to start developing your own web apps & websites with ... ⥯
-
- Learn Java Programming
- iOS Apps: Læring Ved: Ahmad Masood
- $1.99
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 0 Version: 1.0.4 Build your programming skills in the Java Programming language. Become a Java programming master with this programming learning app. Learn the basics of Java Programming or become an ... ⥯
-
- Learn Fortran Programming
- iOS Apps: Læring Ved: Saqib Masood
- $1.99
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 0 Version: 1.0 This comprehensive app is designed for students, engineers, researchers... to be able to use Fortran language from scratch to program in a simple and practical way. Never mind if you ... ⥯
-
- Learn R Programming
- iOS Apps: Læring Ved: Jayotsanaben Hadiya
- Gratis
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 13 (4.8) Version: 1.2 If you are searching for an application to learn R basic to advance without any programming knowledge. You are at right place. Whether you are an experienced programmer or not, this ... ⥯
-
- Learn HTML Programming
- iOS Apps: Læring Ved: Ghumman Tech LLC
- * Gratis
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 0 Version: 3.8 This app is a great resource to learn about HTML Programming Language. The app is engineered to make users perfect understanding common HTML Programming Language questions by studying ... ⥯
-
- SQL Programming Pro
- iOS Apps: Læring Ved: ALG Software Lab
- $3.99
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 0 Version: 2.1 Learn SQL Quickly and Easily! SQL Programming Pro is the ultimate learning tool for mastering SQL and core database concepts from the ground up. Designed for beginners, this app ... ⥯
-
- Learn C Programming: Programiz
- iOS Apps: Læring Ved: Parewa Labs PVT. LTD.
- Gratis
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 72 (4.7) Version: 2.5.140052 Learn C: Programiz is a free iOS app that makes it easy to learn C programming. You can use the app to follow through C tutorials, write and run C code in each lesson, take quizzes and ⥯
-
- Learn SQL For Beginners 2024
- iOS Apps: Læring Ved: MOHAMMAD H JAFARI
- Gratis
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 0 Version: 1.0 Learn SQL quickly and efficiently with our comprehensive SQL learning app. Featuring 60 in-depth, text-based lessons, this app covers everything from beginner concepts to advanced SQL ... ⥯
-
- Learn C Programming Pro
- iOS Apps: Læring Ved: ARJUN ADHIKARI
- $0.99
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 4 + 0 Version: 1.0 Welcome to C Programming App A free, comprehensive platform to learn C programming from beginner to advanced levels. Description Master C programming with step-by-step tutorials, ... ⥯
-
- Learn C Programming Tutorials
- iOS Apps: Læring Ved: Muhammad Umair
- $1.99
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 0 Version: 1.4 If you want to learn complete C programming. just install this app and start learning. In this app we will teach you all about C Programming. C Programming is a procedural programming ... ⥯
-
- Learn & Play children center
- iOS Apps: Læring Ved: Learn & Play s.a.r.l
- Gratis
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 0 + 0 Version: 3.2.817 Learn & Play Children s Center is dedicated to providing each child with loving care in a safe and healthy environment that provides learning opportunities and promotes social, ... ⥯
-
- Learn English Easily - iStoria
- iOS Apps: Læring Ved: Learn English Easily - iStoria
- Gratis
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 4 + 1,625 (4.6) Version: 5.0.0 Learn English easily with iStoria The first app in the world for English language enhancement through captivating storytelling. It tracks your Progress from basic to professional ... ⥯
-
- Learn Drums - Drum Kit Beats
- iOS Apps: Læring Ved: Learn To Master Ltd
- Gratis
- Lister: 0 + 0 Rangeringer: 0 Anmeldelser: 0
- Point: 1 + 140 (4.5) Version: 18.4 * Learn how to drum your favourite grooves from the greatest songs and from all genres. * Choose 1000s of drum rhythms from the best bands and bring in rolls and fills to your ... ⥯