|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-beginner-to-guru-mysql-edition/
课程评论：没有评论
课程名称：SQL初学者到专家：MySQL版 - 精通SQL与MySQL 课程概述：SQL是用于管理数据库中数据的编程语言，关系型数据库在各类企业中广受欢迎。雇主正积极寻找具备SQL技能的人才。在各大求职网站上，搜索“SQL”关键词，将会看到成千上万的岗位空缺。现阶段，由于缺乏具备SQL技能的人选，这些职位无法得到填补。本课程将教授如何使用MySQL关系型数据库，这是全球最受欢迎的数据库，适合所有初学者，无需先前的SQL经验。 在本课程中，你将学习到： - 如何在电脑上安装MySQL - 如何在电脑上安装MySQL Workbench - 导入著名的MySQL员工数据库到你的MySQL数据库中 - 实际操作生成SQL报告 - 精通SQL连接语句 - 使用包含数百万条记录的数据库表进行表连接 - 轻松使用SQL更新数据库中的单条或多条记录 - 学习使用SQL子查询 - 针对电子商务数据库编写高级SQL报告 - 理解数据库事务及使用MySQL进行控制的工具 - 使用SQL在MySQL数据库中创建表 - 学习通过MySQL语法修改现有数据库表 - 处理具有挑战性的现实世界SQL报告和数据库维护任务 - 利用SQL视图处理常见报告 课程附加内容： - Slack社区：加入讲师、助教与其他同学，共同交流学习。 - GitHub源码访问：获取课程中使用的所有源代码（无需具备GitHub经验）。 - 可下载的讲义幻灯片：下载讲义以供学习和未来参考。 其他数据库？本课程专注于使用MySQL数据库的SQL。SQL是一个标准语言，受到许多其他数据库的支持。你在本课程中学到的SQL技能也可应用于其他数据库，如Postgres、Oracle和MS SQL Server。在美国，具有SQL技能的职位空缺超过10万个。 通过本课程，你将掌握SQL，开启全新机会，立即注册吧！
SQL is the programming language used to get data in and out of databases. Relational Databases are extremely popular with companies of all sizes.Employers are searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'. You will see 10's of THOUSANDS of job postings. Right now these positions are going unfilled - because companies cannot find enough people with SQL skills.In this course, you will learn how to use SQL using the MySQL relational database - the most popular database in the world. No previous SQL experience is needed. This course is perfect for beginners. In this course, you will:Learn how to install MySQL on your computer.Learn how to install MySQL Workbench on your computer.See how to import the famous MySQL employee database into your MySQL database.Get hands on experience generating SQL reports.Master SQL join statements.Create table joins using database tables with MILLIONS of records!See how easy it is to use SQL to update one record or many records in the database.Learn to use SQL Sub-Selects.Write advanced SQL reports against a ecommerce database.Understand what database transactions are, and the tools you have to control them with MySQL.Use SQL to create tables in your MySQL database.Learn the MySQL syntax to alter existing database tables.Tackle challenging real world like assignments for SQL reporting and database maintenance tasks. Leverage using SQL views for common reports.Course ExtrasSlack Community - Join the instructor, teacher's assistants, and other students in a Slack Community exclusive to this course!All Source Code in GitHub - Get access to all source code used in course via GitHub (no experience with GitHub necessary)All Lecture Slides Downloadable as PDFs - Download lecture slides for study and future reference!Other Databases?This course is focused on using SQL with the MySQL database. SQL is a standard, which which is supported by many other databases. The SQL skills you learn in this course can be applied to other databases such as Postgres, Oracle, and MS SQL Server. There is a ton of demand for people with SQL skills. In the US, there are over 100,000 job openings for people with SQL skills.Through this course, you will master SQL. Open the door to new opportunities and enroll today!
