|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-beginners-t/
课程评论：没有评论
课程名称：SQL基础入门 概述：欢迎参加我的SQL基础入门课程。本课程将帮助您理解数据库系统在现实世界中的重要性及其实施。随着各种数据库管理系统（DBMS）软件的出现，SQL成为了最受欢迎的语言。SQL代表结构化查询语言，它将数据以表格结构的形式进行解释。这个短期课程将使您对以下内容有良好的理解：1. 关系数据库管理系统的基本概念；2. 针对特定案例研究编写SQL语句的步骤。完成本课程后，您将能够进行案例研究、建立数据库并为其编写SQL查询。 课程内容包括：1. DDL语句；2. DML语句；3. SQL中的约束类型；4. Oracle SQL中的数据类型；5. 主键与外键；6. 选择语句；7. 选择唯一值；8. WHERE子句；9. GROUP BY子句；10. ORDER BY子句；11. HAVING子句；12. 聚合函数；13. SQL中的不同类型连接 - 内连接、左连接、右连接、全连接；14. 子查询等。 我将采用循序渐进的教学方法，帮助您快速完成课程。此外，技术面试中将不乏SQL的考察，因此您学到的概念将不仅提升您的知识水平，也将增强您的自信心。
Welcome to my course on SQL For Beginners. It is very essential to know and understand the importance and implementation of database systems in the real world. To interact with a lot of DBMS Softwares available out there, SQL becomes the most wanted language. SQL stands for Structured Query Language which interprets the data in forms of tabular structures. This short term course will give you a good understanding on 1. Fundamentals of Relational Database Management Systems. 2. Procedure to write SQL Statements for any given case study. After completing this course, you'll be able to perform case studies, form the database and write SQL Queries for the same. The topics that will be covered in this course are:1. DDL Statements2. DML Statements3. Types of Constraints in SQL4. Datatypes in Oracle SQL5. Primary, Foreign Keys6. Select Statement7. Select Distinct8. Where clause9. Group By clause10. Order By clause11. Having clause12. Aggregate functions13. Different types of joins in SQL - Inner, Left, Right, Full14. Sub Queries And so on. I will follow a step by step procedure in my pedagogy which will greatly gain you the momentum which accelerates your pace to complete this course at the earliest. Furthermore, None of the Technical Interviews will go without SQL. So, The concepts you learn will gain not only the knowledge but also boosts your confidence levels.
