菜鸟教程-Python速成Learn SQL 앱 분석 (10월 6일)

SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language. This tutorial will give you quick start with SQL. include:SQL Tutorial、Advanced SQL、SQL Interview Questions、SQL Online Quiz、Useful Functions 1.SQL - Overview 2.SQL - RDBMS Concepts 3.SQL - RDBMS Databases 4.SQL - Syntax 5.SQL - Data Types 6.SQL - Operators 7.SQL - Expressions 8.SQL - CREATE Database 9.SQL - DROP or DELETE Database 10.SQL - SELECT Database, USE Statement 11.SQL - CREATE Table 12.SQL - DROP or DELETE Table 13.SQL - INSERT Query 14.SQL - SELECT Query 15.SQL - WHERE Clause 16.SQL - AND and OR Conjunctive Operators 17.SQL - UPDATE Query 18.SQL - DELETE Query 19.SQL - LIKE Clause 20.SQL - TOP, LIMIT or ROWNUM Clause 21.SQL - ORDER BY Clause 22.SQL - Group By 23.SQL - Distinct Keyword 24.SQL - SORTING Results *****Advanced SQL 25.SQL - Constraints 26.SQL - Using Joins 27.SQL - UNIONS CLAUSE 28.SQL - NULL Values 29.SQL - Alias Syntax 30.SQL - Indexes 31.SQL - ALTER TABLE Command 32.SQL - TRUNCATE TABLE Command 33.SQL - Using Views 34.SQL - Having Clause 35.SQL - Transactions 36.SQL - Wildcard Operators 37.SQL - Date Functions 38.SQL - Temporary Tables 39.SQL - Clone Tables 40.SQL - Sub Queries 41.SQL - Using Sequences 42.SQL - Handling Duplicates 43.SQL - Injection 44.SQL COUNT Function 45.SQL MAX Function 46.SQL MIN Function 47.SQL AVG Function 48.SQL SUM Function 49.SQL SQRT Functions 50.SQL RAND Function 51.SQL CONCAT Function 52.SQL Numeric Functions 53.SQL String Functions