|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-interview-questions-all/
课程评论：没有评论
**课程名称：** 实践测试 SQL - 征服 SQL 面试 **课程概述：** 本课程旨在帮助您通过一系列 SQL 面试问题来巩固 SQL 概念。在准备面试时，我们常常只关注问题和答案，而忽略了对概念的真正理解。这些问题将帮助您检验实际知识，并判断您的概念是否清晰。如果概念不清，您可以通过 Google 或（更佳的）在 SQL Server 中练习这些查询来复习。 课程内容涵盖了所有基本的 SQL 概念，包括数据类型、连接（joins）、触发器（triggers）、函数（functions）和存储过程（stored procedures）。通过这些精心设计的面试问题，您可以理清它们之间的区别，以及在不同场景下如何最佳地运用它们。课程中的问题均为选择题，方便快速作答，让您轻松愉快地掌握多项 SQL 概念。您还可以尝试围绕这些问题构建小型程序来巩固理解。 **课程内容:** * 79 道选择题实践/测试题 **适合人群：** * 使用 SQL 的新手或有经验的开发者，正在为面试做准备。 **涵盖的 SQL 主题:** * **范式 (Normalization):** 1NF, 2NF, 3NF, BCNF, 4NF * **命令类型 (Command Types):** DDL, DCL, TCL, DML * **触发器 (Triggers) 和游标 (Cursors)** * **SQL 数据类型 (SQL Data Types)** * **SQL 连接 (SQL Joins):** Left, Right, Inner, Outer, Cross Join, Cartesian Product * **SQL 事务 (SQL Transactions)** * **键和约束 (Keys and Constraints):** Primary, Foreign, Unique, Default * **索引 (Indexes):** Clustered, Non-Clustered * **SQL 常用查询 (SQL common queries)** * **视图 (Views), 函数 (Functions), 和存储过程 (Stored Procedures)**
These SQL Interview Questions are prepared to help you revise your SQL Concepts. When we prepare for an interview, we are usually just looking at Questions and Answers without knowing whether we know the concepts or not. These questions will help you practice your real knowledge and see if your concepts are clear. If not, you can always revise using google or (better) by practicing these queries in SQL Server. These SQL Interview Questions are prepared to cover all your basic SQL Concepts - data types, joins, triggers, functions, stored procedures. Chances are that you have been using them in your daily life but are not sure what are the differences between them or which object is best used when. Our interview preparation questions try to clear your concepts by giving you multiple options and explaining why you chose was wrong. The questions in these preparation tests are all multiple choice, so these are quick are to answer and you will cover multiple concepts in a fun and easy way. You can also try creating small programs around these to confirm your understanding.What this course contains: 79 Multiple choice Practice/Test questionsWho should take this course:Recommended for: New or experienced developers using SQL and preparing for an interviewWhat Scrum Topics are covered:Normalization - 1NF, 2NF, 3NF, BCNF, 4NFCommand Types - DDL, DCL, TCL, DMLTriggers and CursorsSQL Data TypesSQL Joins - Left, Right, Inner, Outer, Cross Join, Cartesian ProductSQL Transactions Keys and Constraints - Primary, Foreign, Unique, DefaultIndexes - Clustered, Non-ClusteredSQL common queriesViews, Functions, and Stored Procedures
