準備 156 個流行的真實世界 SQL 面試問題,並自信地走進面試,對於你會被問的各類型問題胸有成竹。 給面試官留下深刻的印象
測驗包含以下資料庫和 SQL 主題的問題:
Databases Core Concepts
Normalization (First Normal Form, Second Normal Form, Third Normal Form)
Relationships
SQL Queries Basics
SELECT statement and syntax
SQL Data Types
WHERE operators: comparison operators, LIKE, BETWEEN, IN
Scalar Functions
Aggregate Functions (SUM, COUNT, MIN, MAX, AVG)
GROUP BY
ORDER BY
JOINS (INNER JOIN, RIGHT and LEFT JOIN, OUTER JOIN, CROSS JOIN)
Set Theory (INTERSECT, UNION, MINUS)
Subqueries
INSERT, UPDATE, DELETE
DML vs DDL vs DCL
DDL: CREATE, DROP, ALTER
Constraints
Indexes
DCL privileges: GRANT, REVOKE
Transactions
Views
Triggers
Cursors
https://softnshare.com/2018/06/09/sql-interview-questions/
「triggers in sql」的推薦目錄:
triggers in sql 在 sql-docs/create-trigger-transact-sql.md at live - GitHub 的推薦與評價
Transact-SQL reference for the CREATE TRIGGER statement, which is used to create a DML, DDL, or logon trigger. ... database-scoped triggers [SQL Server] ... ... <看更多>
triggers in sql 在 SQL Triggers and when or when not to use them. - Software ... 的推薦與評價
Non-Trigger Stored procedures can reference any type of object, however, to reference a view, you must use INSTEAD OF triggers. In SQLServer, you can have any ... ... <看更多>
triggers in sql 在 In SQL Server Management Studio 2014, the New Trigger ... 的推薦與評價
... <看更多>