| Προγραμματιστής: | G Sanghani (47) | ||
| Τιμή: | Δωρεάν | ||
| Κατατάξεις: | 0 | ||
| Κριτικές: | 0 Γράψτε μια κριτική | ||
| Λίστες: | 0 + 0 | ||
| Βαθμοί: | 0 + 14 (3.2) ¡ | ||
| App Store | |||
Περιγραφή
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
Στιγμιότυπα οθόνης
Τι νέο υπάρχει
- Εκδοχή: 2.1
- Ενημερώθηκε:
- - Interview Questions introduced.
- More SQL questions added in the topics.
- Improved stabilit and Bug fixes.
Τιμή
- Σήμερα: Δωρεάν
- Ελάχιστο: Δωρεάν
- Μέγιστο: Δωρεάν
Παρακολούθηση τιμών
Προγραμματιστής
- G Sanghani
- Πλατφόρμες: iOS Εφαρμογές (47)
- Λίστες: 1 + 0
- Βαθμοί: 1 + 62 ¡
- Κατατάξεις: 0
- Κριτικές: 0
- Εκπτώσεις: 0
- Βίντεο: 0
- RSS: Εγγραφή
Βαθμοί
0☹️
Κατατάξεις
0☹️
Λίστες
0☹️
Κριτικές
Γίνε ο πρώτος που θα αξιολογήσει 🌟
Πρόσθετες πληροφορίες
- Εκδοχή: 2.1
- ID: com.aswdc.learnsql
- Κατηγορία:
iOS Εφαρμογές›Εκπαίδευση - Λειτουργικό σύστημα:
iPad,iPhone,iOS 10.0 και νεότερες εκδόσεις - Μέγεθος:
25 Mb - Υποστηριζόμενη γλώσσα:
English - Αξιολόγηση περιεχομένου:
4+ - App Store Εκτίμηση:
3.2(14) - Ενημερώθηκε:
- Ημερομηνία έκδοσης:
Επαφές
- X: darshan_inst
- Facebook: DarshanInstitute.Official
- Ιστοσελίδα:
http://www.darshan.ac.in
Μπορεί επίσης να σας αρέσει
-
- Learn SQL Programming [PRO]
- iOS Εφαρμογές: Εκπαίδευση Με: Muhammad Mubeen
- $1.99
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Shahbaz Khan
- Δωρεάν
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 1 + 349 (4.6) Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Ahmad Masood
- $1.99
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Saqib Masood
- $1.99
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Jayotsanaben Hadiya
- Δωρεάν
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 13 (4.8) Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Ghumman Tech LLC
- * Δωρεάν
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: ALG Software Lab
- $3.99
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Parewa Labs PVT. LTD.
- Δωρεάν
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 72 (4.7) Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: MOHAMMAD H JAFARI
- Δωρεάν
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: ARJUN ADHIKARI
- $0.99
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 4 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Muhammad Umair
- $1.99
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Learn & Play s.a.r.l
- Δωρεάν
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 0 + 0 Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Learn English Easily - iStoria
- Δωρεάν
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 4 + 1,626 (4.6) Εκδοχή: 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 Εφαρμογές: Εκπαίδευση Με: Learn To Master Ltd
- Δωρεάν
- Λίστες: 0 + 0 Κατατάξεις: 0 Κριτικές: 0
- Βαθμοί: 1 + 140 (4.5) Εκδοχή: 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 ... ⥯