|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-query-lets-talk-sql-sql-server-sqlite-etc/
课程评论：没有评论
课程名称：数据库与查询 - 让我们谈谈SQL（SQL Server, SQLite等） 课程概述： 本课程旨在教授学员如何使用SQL创建和管理数据库，涵盖多种数据库对象和实体的创建与操作。课程内容包括简单及复杂查询的处理，以及对SQL Server、SQLite、PostgreSQL、MySQL等数据库进行各种查询操作。 主要内容包括： - 数据库及工具的基础知识 - 表与视图（数据类型、创建与修改、主键、约束条件、插入、更新、删除等） - 比较表达式（大于、小于、不等于等） - SQL语句基本操作（Between、IN、Order By、Select Where、Select Top等） - SQL聚合函数（SUM、Count、Group By、Having等） - 连接（内连接、左外连接、并集、全外连接等） - 内置函数（IsNumeric、isNULL、Left、Trim、Convert、CAST等） - 索引及其重要性（创建与优化索引） - 存储过程与函数（SQL事务、异常处理、标量值函数、表值函数、存储过程中的函数、存储过程中的存储过程、动态查询） 该课程教授的是市场上需求量极高的技能，学员将能够读取和创建复杂的数据库查询，使用Microsoft SQL Server以及其他主流SQL数据库（如MySQL、PostgreSQL、Amazon Redshift、Oracle等）。学习SQL是提升职业前景的快捷方式之一，课程将以稳定的节奏进行，使任何学习者都能轻松理解和实践。沿途中，学员将面临各种挑战和考核，以巩固理解和掌握技能。完成本课程后，学员将具备成为SQL专业人士所需的所有技能。
Use SQL to create and manage databasesCreate various database objects/entitiesManipulate with simple and complex queryPerform all various query operations applicable to SQL Server, SQLite, PostgreSQL, MySQL, etc. Database and ToolsTables and Views (Data Types, Create and alter, Primary Keys, Constraints, Insert, Update, Delete, etc)Comparison Expressions (Greater Than, Less Than, Not Equal to, etc)SQL Statements Fundamentals (Between, IN, Order By, Select Where, Select Top, etc)SQL Aggregate (SUM, Count, Group By, Having, etc)JOINS (Inner Join, Left Outer Join, Union, Full Outer Join, etc)In-Built Function (IsNumeric, isNULL, Left, Trim, Convert, CAST, etc)Index and the importance (Create and Optimize Index)Stored Procedure and functions ( SQL Transaction, Exception Handling, Scalar Value Function, Table-Valued Function, Function in Stored Procedure, Stored Procedure in Stored Procedure, Dynamic Query)and much, much moreOne of the most in-demand talents, knowing how to read and create sophisticated queries to a database using Microsoft SQL Server, will be taught to you. Any other significant SQL database, including MySQL, PostgreSQL, Amazon Redshift, Oracle, and many more, can be used with these abilities.Since SQL is one of the most in-demand tech skills, learning it is one of the fastest methods to improve your professional prospects! You'll pick up knowledge fast in this course, and along the way, you'll face obstacles and assessments to sharpen your comprehension! You will acquire all the skills required to become a SQL Pro in this course!The course runs at a steady pace for any learner to easily understand and practice alongside.
