| Programista: | G Sanghani (47) | ||
| Cena: | Bezpłatny | ||
| Rankingi: | 0 | ||
| Opinie: | 0 Napisać recenzję | ||
| Listy: | 0 + 0 | ||
| Punkty: | 0 + 14 (3.2) ¡ | ||
| App Store | |||
Opis
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
Zrzuty ekranu
Nowości
- Wersja: 2.1
- Zaktualizowano:
- - Interview Questions introduced.
- More SQL questions added in the topics.
- Improved stabilit and Bug fixes.
Cena
- Dziś: Bezpłatny
- Minimalna: Bezpłatny
- Maksymalna: Bezpłatny
Monitoruj ceny
Programista
- G Sanghani
- Platformy: iOS Aplikacje (47)
- Listy: 1 + 0
- Punkty: 1 + 62 ¡
- Rankingi: 0
- Opinie: 0
- Zniżki: 0
- Filmy: 0
- RSS: Subskrybuj
Punkty
0☹️
Rankingi
0☹️
Listy
0☹️
Opinie
Bądź pierwszą osobą, która napisze recenzję 🌟
Dodatkowe informacje
- Wersja: 2.1
- ID: com.aswdc.learnsql
- Kategoria:
iOS Aplikacje›Edukacja - System operacyjny:
iPad,iPhone,iOS 10.0 i nowsze - Rozmiar:
25 Mb - Obsługiwany język:
English - Ocena treści:
4+ - App Store Ocena:
3.2(14) - Zaktualizowano:
- Data wydania:
Kontakty
- X: darshan_inst
- Facebook: DarshanInstitute.Official
- Witryna internetowa:
http://www.darshan.ac.in
Może ci się spodobać również
-
- Learn SQL Programming [PRO]
- iOS Aplikacje: Edukacja Przez: Muhammad Mubeen
- $1.99
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 0 Wersja: 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 Aplikacje: Edukacja Przez: Shahbaz Khan
- Bezpłatny
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 1 + 349 (4.6) Wersja: 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 Aplikacje: Edukacja Przez: Ahmad Masood
- $1.99
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 0 Wersja: 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 Aplikacje: Edukacja Przez: Saqib Masood
- $1.99
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 0 Wersja: 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 Aplikacje: Edukacja Przez: Jayotsanaben Hadiya
- Bezpłatny
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 13 (4.8) Wersja: 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 Aplikacje: Edukacja Przez: Ghumman Tech LLC
- * Bezpłatny
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 0 Wersja: 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 Aplikacje: Edukacja Przez: ALG Software Lab
- $3.99
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 0 Wersja: 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 Aplikacje: Edukacja Przez: Parewa Labs PVT. LTD.
- Bezpłatny
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 72 (4.7) Wersja: 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 Aplikacje: Edukacja Przez: MOHAMMAD H JAFARI
- Bezpłatny
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 0 Wersja: 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 Aplikacje: Edukacja Przez: ARJUN ADHIKARI
- $0.99
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 4 + 0 Wersja: 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 Aplikacje: Edukacja Przez: Muhammad Umair
- $1.99
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 0 Wersja: 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 Aplikacje: Edukacja Przez: Learn & Play s.a.r.l
- Bezpłatny
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 0 + 0 Wersja: 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 Aplikacje: Edukacja Przez: Learn English Easily - iStoria
- Bezpłatny
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 4 + 1,625 (4.6) Wersja: 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 Aplikacje: Edukacja Przez: Learn To Master Ltd
- Bezpłatny
- Listy: 0 + 0 Rankingi: 0 Opinie: 0
- Punkty: 1 + 140 (4.5) Wersja: 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 ... ⥯