|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-bootcamp-for-beginners-g/
课程评论：没有评论
课程名称：学习SQL概念 课程概述：在本课程中，您将学习SQL语法的方方面面，生成基于销售和用户数据的报告，通过聚合函数分析数据，使用MySQL逻辑运算符和字符串函数运行复杂查询，撰写常见的SQL连接，处理包含数千条目大数据集，构建使用MySQL和NodeJS的Web应用程序，设计并实现复杂的数据库架构，掌握存储日期和时间的技巧，克隆一个照片分享社交网络的数据库结构，以及编写JavaScript代码生成假数据集等等！ 本课程包含大量练习、挑战、项目，以及您可以实践所学内容的机会。课程一开始就让您动手设置和恢复数据库，而不是观看他人编写代码。每个章节都有新鲜的挑战问题和任务，模拟真实世界的任务和情境。 作为一名在财富500强公司在线和面对面授课多年的讲师，我的目标是将两者的优势结合，允许您在互动环境中按照自己的节奏学习。课程从基础开始，很快您就会发现自己能够使用高级命令，处理时间戳数据和变量字符信息，像专业人士一样工作。 SQL是商业分析师、数据科学家以及任何与数据打交道的人最需要的技能之一。通过加入本课程，快速提升您的技能，将SQL添加到您的简历中！ 期待在课程中见到您！
In this course, you will:Learn the ins and outs of SQL syntaxGenerate reports using sales and user dataAnalyze data using Aggregate FunctionsRun complex queries using MySQL logical operators and string functionsWrite all the common SQL joinsWork with large datasets containing thousands of entriesBuild a web app using MySQL and NodeJSDesign and implement complex database schemasLearn to navigate the treacherous world of storing dates and timesClone the database structure of a photo sharing social networkWrite Javascript code to generate fake data setsAnd more!This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you're learning.This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!I'll see you inside the course!
