課程介紹

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in

…[更多細節]

哪些人適合這堂課？

• Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today’s most in-demand skills
• Anyone looking to answer complex business problems and generate reports using data
• Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.
• Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL

學習目標

• Create your own database or interact with existing databases
• Write complex SQL queries across multiple tables
• Build a web app using NodeJS and MySQL
• Model real-world data and generate reports using SQL
• Answer company performance or sales questions using data

課程介紹

How important is database management in the age of big data and analytics?

It is really important.   

How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.  

How many pe

…[更多細節]

哪些人適合這堂課？

• People interested in SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
• Beginners to programming
• Everyone who wants to learn how to code and apply their skills in practice

學習目標

• Become an expert in SQL
• Learn how to code in SQL
• Boost your resume by learning an in-demand skill
• Create, design, and operate with SQL databases
• Start using MySQL – the #1 Database Management System
• Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
• Adopt professionally tested SQL best practices
• Gain theoretical insights about relational databases
• Work with a sophisticated real-life database throughout the course
• Get maximum preparation for real-life database management
• Add data analytical tools to your skillset
• Develop business intuition while solving tasks with big data
• Study relational database management theory that you will need in your workplace every day
• Learn how to create a database from scratch
• The ability to take control of your dataset – insert, update, and delete records from your database
• Be confident while working with constraints and relating data tables
• Become a proficient MySQL Workbench user
• Acquire top-notch coding techniques and best practices
• Know how to answer specific business questions by using SQL’s aggregate functions
• Handle complex SQL joins with ease
• Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
• Merge coding skills and business acumen to solve complex analytical problems
• Become a proficient SQL user by writing flawless and efficient queries
• Tons of exercises that will solidify your knowledge
• The freedom to query anything you like from a database

課程介紹

Database design is one of the most important aspects of Web programming. Successful implementation of any system with Data Storage will always need proper database design. In order to create great database design you will not only have to master the

…[更多細節]

哪些人適合這堂課？

• Web Developers and Database designers

學習目標

• To Learn Database design Process
• To Learn Database Normalization
• To Learn Database development using MySQL
• To Master SQL
• To Learn to use PHP with MySQL

課程介紹

See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:

“Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging

…[更多細節]

哪些人適合這堂課？

• Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems
• Excel users looking to shift into a broader business intelligence or database-focused role
• Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL)
• Students looking for a hands-on and highly engaging introduction to MySQL for data analysis
• Anyone looking to pursue a career in data analysis or business intelligence
• NOTE: This course is NOT for database administrators (we won’t cover tools to build or maintain databases in this course)

學習目標

• Write SQL queries to explore and analyze databases with MySQL Workbench
• Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently
• Analyze data across multiple tables with powerful MySQL JOIN statements
• Solve practical hands-on assignments and real-world business use cases
• Master unique tips, tools and case studies that you won’t find anywhere else
• Get LIFETIME access to resource files, quizzes, assignments, and expert support

課程介紹

This course will take you from beginner in SQL and MySQL to an advanced level. Whether you’re a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions

…[更多細節]

哪些人適合這堂課？

• This course teaches you MySQL from the very beginning.
• No prior knowledge is required, other than basic knowledge of your computer.
• By the end of the course you will be able to use MySQL to an advanced level.

學習目標

• Create, query and update databases
• Use triggers, views and stored procedures
• Understand transactions and database isolation levels.
• Understand database users and security.

課程介紹

Join over 5,000 students and be a part of this Udemy rated BEST SELLING course!

Do you want to become an expert in JavaScript, PHP and MySQL?

Do you want to build a social network just like Facebook?

If so, you’re in the right place! This course w

…[更多細節]

哪些人適合這堂課？

• In this course you will use HTML, CSS, PHP, MySQL, JavaScript and JQuery. Although we will use all of these skills, no prior experience with them is needed. Of course, you may pick things up a little faster if you have used them before, but at the start of the course, things are explained in ways that target people who have never used the skill before. Because this course appeals to beginners as well as as experienced users, it may seem a little slow paced at the start especially if you have prior programming experience. Bare with it though because it does pick up. If you are an experienced programmer, you may not learn much about the skills but you may learn how to structure a social media website. Some of the techniques and methods used are not the most efficient way to do things (e.g. we use procedural MySQLI statements), but in my opinion, they are the easiest to teach in a short amount of time and easiest to pick up having never used the skills before. Feel free to swap bits of code with your preferred methods.

學習目標

• Create a full scale social networking website like Facebook or Twitter, including features such as newsfeeds, profiles, friend system, chat system, trending posts and much more!
• Program proficiently in PHP, HTML and CSS
• Program using an OO (Object Oriented) approach
• Know how to easily use MySQL databases with your website
• Understand how to register domain names and put your new site on the web!

課程介紹

MySQL 是一种快速易用的 RDBMS，很多企业（不分规模大小）都在使用它来构建自己的数据库。MySQL 由一家瑞典公司 MySQL AB 开发、运营并予以支持。它之所以非常流行，原因在于具备以下这些优点：

基于开源许可发布，无需付费即可使用。

自身的功能非常强大，足以匹敌绝大多数功能强大但却价格昂贵的数据库软件。

使用业内所熟悉的标准SQL数据库语言。

可运行于多个操作系统，支持多种语言，包括 PHP、PERL、C、C++ 及 Java 等语言。

非常迅速，即使面对大型数据集也毫无

…[更多細節]

哪些人適合這堂課？

• Backend Developers
• Database Administrators
• DevOps

學習目標

• 掌握SQL语法
• 掌握MySQL的基本操作
• database和table的基本操作
• 数据的插入
• 数据的增删改查CRUD
• SQL中字符串的操作方法
• SELECT结果的再整理，排序，LIMIT
• 数据的分组和聚合
• MySQL数据类型精讲
• SQL语句的逻辑操作符
• MySQL内置函数
• 一对多，多对多关系表

課程介紹

采用 Java Spring Boot 框架 + MySQL数据库 + Semantic UI前端UI框架，从零开始，分析规划博客功能 > 设计前端页面 > 开发动态前端页面 > 集成使用的 Js 插件 > 构建后端服务框架 > 实现后端管理功能 > 实现前端展示功能。

在课程中我会一步一步的展示给你如何做，用实录代码的方式，全面展示和讲解各个细节给你，按照课程规划完整学习下来，你将有巨大的收获。瞬间拥有全栈开发的能力。

注意：课程中 Spring Boot 版本是1.5.7

…[更多細節]

哪些人適合這堂課？

• 想获得 Spring Boot框架实战使用经验的 Java 开发者
• 想动手打造属于自己的定制化漂亮博客系统的小伙伴
• 想学习如何开发网站应用系统的开发者

學習目標

• 从零开始分析规划，做一个网站应用的套路
• 使用 Semantic UI 框架构建漂亮现代化页面的技巧
• 寻找与集成各种使用 Js 插件的自己页面的心法
• 使用 thymeleaf 模板来渲染后端数据到前端页面的常用规则
• 使用 Java Spring Boot 框架 + MySQL 构建后端服务的完整套路

課程介紹

SQL和安全测试是每个软件工程师都需要具备的额外的、通用的技能，这与他们在项目中的角色无关。这门课程既详细的讲解了SQL相关的各种话题，又讲解了怎么对数据库进行测试，怎么安全的在代码中用SQL，详细的讲解了SQL注入如何发生，以及如何防御。通过教授这些，也让你比你工作中的其他工程师更有优势。当然，这也是每个软件工程师面试中都要考验的技能之一。

这门课对初学者来说有什么特别之处?

先解释概念后实例演示。用实际例子教授SQL中需要掌握的每一个主题。

此外，本课程还实际的展示了SQL注入怎么发生

…[更多細節]

哪些人適合這堂課？

• 任何对sql感兴趣的人
• 想要提高在数据库测试中的技能的QA测试人员
• 想要学习计算机科学基础的新生/毕业生

學習目標

• 您将获得设计任何复杂SQL来查询数据库的能力
• 深入理解GROUP BY、子查询、聚合函数、SQL Server函数、HAVING子句
• 理解内连接、左/右外连接和完全外连接之间的区别
• 深入理解高级SQL概念来测试数据库
• 深入理解数据约束，主键Primary key和外键Foreign Key
• JDBC ODBC 用Java编程连接到数据库，取到数据库中数据
• 你可以用面试问题那部分的课程，来解决任何有关SQL的面试
• 写SQL查询语句查找数据库、表以及敏感数据，比如使用SQL注入用户名、admin密码
• 采用SQL查询语句在更安全的页面中去发现和利用SQL注入
• 发现和开发盲SQL注入（blind SQL injections）
• 使用SQL注入获得对目标服务器的完全控制
• 使用SQL注入向服务器读取/写入文件
• 快速地给SQL注入打补丁
• 学习编写正确SQL语句的方法来以防止SQL注入

課程介紹

本课程是一门短小、精悍、专门介绍MySQL专题的课程。

理解和掌握SQL优化底层原理和方法，是技术人员内功修炼，提升技术功底的必修课，我们精心录制了SQL优化课程，为大家揭开SQL优化的迷雾，带领大家深刻理解SQL优化的底层原理和方法。在目前对性能要求极为苛求的情况下，对复杂的SQL语句，要设法对之进行优化，以获得更稳定的执行性能。

相信通过本课程的学习，大家可以对MySQL的性能优化有一定的理解和认识。为后续高性能系统的开发打下良好的基础和准备。

…[更多細節]

哪些人適合這堂課？

• 有java基础的人群
• IT相关从业人员
• 数据库管理人员
• 运维人员
• 想学习mysql的同学

學習目標

• 理解和掌握SQL优化底层原理和方法