|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-bootcamp-for-beginners/
课程评论：没有评论
课程名称：使用微软免费工具的SQL入门培训 课程概述：数据在当今企业世界中扮演着至关重要的角色，随着应用程序和物联网设备的普及，数据的增长速度十分惊人。SQL作为与数据库交互的通用语言，成为了技术行业中最受欢迎的技能之一，特别是在数据库管理员和商业分析师的职位上十分紧俏。学习SQL不仅可以帮助分析数据并获取可行见解，还能够为您带来高于80K美元的起薪。 本课程将通过使用微软的WideWorldImporters和AdventureWorks事务性及数据仓库数据库，让您在模拟真实世界的场景中逐步学习SQL。课程内容设计详尽且实用，适合零基础学员，所有所需的工具均为微软提供的免费工具。在此课程中，您将完成3600多行代码的编写，独特的内容和丰富的练习将帮助您掌握SQL技能。此外，课程还附送微软的“Dashboard-in-a-Day”课程，您可以在家或办公室自行学习如何识别趋势、模式并从数据中提取可行见解。 课程包括： 1. SQL Server安装及数据库连接 2. 数据库基础及数据仓库架构 3. 数据的CRUD操作（创建、读取、更新、删除） 4. SQL查询数据以获取所需信息 5. 数据过滤、排序和聚合 6. 数据组合与联接技术 7. 子查询、排名函数和分析函数 8. 逻辑、数学、字符串、系统和日期函数 9. 存储过程的创建与执行 10. BONUS课程：Dashboard-in-a-Day包含数据可视化及报告发布等内容 课程提供终身访问权限，以及个性化笔记、作业练习、检查表和模板，完成课程后可获得证书以增强简历或LinkedIn简历的吸引力。无论您是希望改善职业发展的现有员工，还是希望转行的新手，本课程都为您提供了理想的学习平台。今天就报名，开启您的SQL学习之旅吧！
We all know how data is growing by leaps and bounds. Data coming from application, data coming from iot devices, structured data and unstructured data. Basically data is the lifeblood of today's corporate world. and data is company's most valueable asset The data can be stored in data lakes and hundreds of different databases. All database speaks same language called SQL. That is why, SQL is the most in-demand and hottest skill in the tech industry for roles like DBA and Business Analyst. You can use it to analyse data and get actionable insights from data. Starting salaries for DBA are over 80K and with couple of years of experience it goes over 100K. In this course I am teaching you SQL the most in demand skill used to interact and manuplate databases.This is very comprehensive course because. We are using Microsoft WideWorldimporters and Adventureworks Transactional and data warehouse databases to mimic real world scenarios. I am going to start from beginning and teach you SQL step by step. No prior experience is necessary and no need to buy anything as we are using all the free tools from Microsoft in this course. I am explaining each concept very slowly and clearly with tons of exercises so you can master these skills.You will write over 3600 lines of code that you won't find in ANY other course. You will also learn Microsoft's Popular Course DASHBOARD-IN-A-DAY at your own pace at home or at your office AS A BONUS. I am going to teach you how to find the trends, patterns and get actionable insights from that data in that course. All of the exercises are designed by keeping the practical aspects of SQL in mind. All exercises are 100% hands-on.Please sign up today and get life time access to all the contents. This course also comes with Custom Notes, homework excercises, Checklists, Templates to help get you results faster. You will also receive your certification of completion that you can post in your resume or your linkedin account to show your newly skill to new potential employers. Check the next lecture for full overivew of this course.#microsoft #SQL #SQL Server i #data #business #intelligence #analysis #analyticsWhy should you consider a career as a Business Data Analyst?· Salary. A Business Data Analyst is a well-paid career· Stable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst.· Everyone who wants to learn how to code SQL and apply their skills in practice· Anyone willing to step into the software development career· Anyone dreaming to get a well-paid SQL Development Job· Anyone who wants to get you a better job or improve the one you have· Anyone who wants to become Business Analyst, Data Analyst and Business Intelligence Professional· Anyone who works with data, tables, or databases· Anyone who is working in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects informationCourse contentSection 1: Introduction· Introduction· Course Overview· Welcome to this course and how to get support ( must watch )Section 2: SQL Server Installation· SQL Server Installation· Connecting to Database· Download and install sample databases· Check Databases· SQL HelpSection 3: Database Basics· Data warehouse architecture· Databases basics· Database Objects· Database Schema· Data Types and Constraints· Database Views and Store Procedures· How to do Exercise ChallengesSection 4: CRUD Premier· Physical and Logical query processing order· CRUD - What is CRUD· Creating Databases and Tables· CRUD-Insert Data in Tables· CRUD-Delete Databases and Tables· Exercise Challenge CRUD· Exercise Solution CRUDSection 5: SQL Server Management Premier· How to use SSMS· What is GO Statement and ALIASSection 6: Reading Data· Repeat: Physical and Logical query processing order· Reading Data - SELECT· Exercise Solution SELECT· Reading Data - DISTINCT· Exercise Solution DISTINCT· Reading Data - TOP· Exercise Solution TOPSection 7: Filtering Data· Predicates and Operators· Filtering Data - Where Clause· Exercise Solution - Where Clause· Filtering Data - Where - AND· Exercise Solution - Where - AND· Filtering Data - Where - OR· Exercise Solution - Where - OR· Filtering Data - Where - IN· Exercise Solution - Where - IN· Filtering Data - Where - BETWEEN· Exercise Solution - Where - BETWEEN· Filtering Data - Where - LIKE· Exercise Solution - Where - LIKE· Filtering Data - Where - NOT· Exercise Solution - Where - NOTSection 8: Sorting Data· Sorting Data - ORDER BY· Exercise Solution - ORDER BY· Sorting Data - ORDER BY - OFFSET and FETCH· Exercise Solution - ORDER BY - OFFSET and FETCHSection 9: Aggregating Data· AGGREGATE - COUNT· Exercise Solution AGGREGATE - COUNT· AGGREGATE - SUM· Exercise Solution AGGREGATE - SUM· AGGREGATE - AVG· Exercise Solution - AGGREGATE - AVG· AGGREGATE - MIN or MAX· Exercise Solution - AGGREGATE - MIN or MAXSection 10: Grouping Data· Grouping Data - GROUP BY· Exercise Solution - Grouping Data - GROUP BY· Grouping Data - GROUP BY - HAVING· Exercise Solution - Grouping Data - GROUP BY - HAVINGSection 11: Combining data with JOINS· JOINS - INNER JOIN· Exercise Solution - INNER JOIN-0· Exercise Solution - INNER JOIN-1· JOINS - LEFT JOIN· JOINS - RIGHT JOIN· Exercise Solution - JOINS -LEFT RIGHT JOIN-0· Exercise Solution - JOINS -LEFT RIGHT JOIN-1· JOINS - FULL JOIN· Exercise Solution - JOINS -FULL CROSS JOIN· Exercise Challenges for Aggregation with Joins - Download· resources here· Exercise Solution - AGGREGATIONS - JOINSSection 12: Combining Data with UNION· UNION· UNION - and UNION ALL· UNION - Rules· Exercise Solution - UNION-0· Exercise Solution - UNION-1Section 13: Magic of SUBQUARIES· Subqueries· Subqueries - IN· Subqueries - NOT IN· Subqueries - Expression· Subqueries - Correlated· Subqueries - NULL· Exercise Solution SUBQUERIES-0· Exercise Solution SUBQUERIES-1· Exercise Solution SUBQUERIES-2· Exercise Solution SUBQUERIES-3· Exercise Solution SUBQUERIES-4Section 14: RANKING Functions· RANKING - ROW_NUMBER· Exercise Solution RANKING - ROW_NUMBER· RANKING - NTILE· RANKING - RANK· RANKING - DENSE_RANK· Exercise Solutions NTILE RANK - DENSE_RANK-0· Exercise Solutions NTILE RANK - DENSE_RANK-1Section 15: ANALYTICS Functions· ANALYTIC - LEAD· ANALYTIC - LAG· ANALYTIC - FIRST_VALUE· ANALYTIC - LAST_VALUESection 16: LOGICAL Functions· LOGICAL FUNCTIONS-0· LOGICAL FUNCTIONS-1· LOGICAL FUNCTIONS-2· LOGICAL FUNCTIONS-3· LOGICAL FUNCTIONS-4· LOGICAL FUNCTIONS-5Section 17: MATH Functions· MATHIMATICAL FUNCTIONS-0· MATHEMATICAL FUNCTIONS-1Section 18: STRING Functions· STRING FUNCTIONS-0· STRING FUNCTIONS-1Section 19: SYSTEM Functions· SYSTEM FUNCTIONSSection 20: DATE Functions· Date FunctionsSection 21: Store Procedures· Stored Procedures· Stored Procedures - Create and Execute· Stored Procedures - Delete· Exercise Solution Stored ProceduresSection 22: BONUS!!! Dashboard-in-a-day· DIAD - Introduction· DIAD - Accessing Data· DIAD - Data Preparation-0· DIAD - Data Preparation-1· DIAD -Data Modeling and Exploration-0· DIAD -Data Modeling and Exploration-1· DIAD -Data Modeling and Exploration-2· DIAD -Data Modeling and Exploration-3· DIAD -Data Modeling and Exploration-4· DIAD - Data Visualization-0· DIAD - Data Visualization-1· DIAD - Publishing Report· DIAD - Creating Dashboards· DIAD - Creating Dashboards-0· DIAD - Creating Dashboards-1
