【2024年】十大資料庫程式設計課程熱門排行推薦與優惠精選!
本文章推薦「Python + SQL + Tableau: Integrating Python, SQL, and Tableau」、「Database programming for intermediates」、「C# Database Driven WinForm Apps (step by step projects)」等相關LinkedIn線上課程,讓您滿足學習的慾望。
你是否想透過線上學習得到更多的技能,增加自己的技能樹?現在是學生的您,透過線上學習可以將更多專業知識用在課業學習上更加強所學。還是您是朝九晚五的上班族,尋找可以為工作上帶來更上一層樓的技能?或您是因為興趣或想培養其他興趣?
線上課程不受地理位置影響,不受時間早晚影響,老師來自世界各地,也不受學習程度影響的特色,讓您無時無刻想學都可以,想多看幾次增加熟悉度也可以。不同領域的老師將針對不同主題滿足您的學習目的,推薦的課程項目會陸續更新,絕對提供您最熱門人氣高的線上課程。
目錄
- Python + SQL + Tableau: Integrating Python, SQL, and Tableau
- Database programming for intermediates
- C# Database Driven WinForm Apps (step by step projects)
- PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
- Clean Code for SQL
- Database programming for beginners
- SQL for Beginners: Crash Course to Become Database Expert
- C# with WinForms and SQL Create Database Driven Desktop App
- Essential SQL Server Development Tips for SQL Developers
資料庫程式設計課程總覽
課程資訊 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
---|---|---|---|---|---|---|---|---|---|
評價 | 4.5 分 (3,141 個評分) | 4.7 分 (29 個評分) | 4.8 分 (255 個評分) | 4.5 分 (320 個評分) | 4.3 分 (20 個評分) | 4.5 分 (39 個評分) | 4.2 分 (70 個評分) | 4.5 分 (34 個評分) | 4.5 分 (18 個評分) |
學生 | 28,697 人人 | 4,794 人人 | 3,566 人人 | 3,081 人人 | 1,773 人人 | 1,466 人人 | 304 人人 | 302 人人 | 92 人人 |
課程描述 | See the full picture: Learn how to combine the three most important tools in data science: Python, SQL, and Tableau | From DBMS mechanism (Transaction, Rollback, Index, View) to Database design (Design process, Normalization) | Project-based Learning: how to use C# Windows Forms and Microsoft Access Database to create small database driven apps | Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions… | Developing readable, maintainable and easy to upgrade SQL code | MySQL & PHP | Database Primer to learn SQL for Oracle, Microsoft SQL Server, PostgreSQL, MySQL, MS Access, etc. by IT Professionals | Learn how to program mid-size project with Create, Read, Update and Delete functionality with C#, Windows Forms, and SQL | Sharpen your SQL Server T-SQL programming skills and learn useful database programming techniques |
資料庫程式設計課程列表
Python + SQL + Tableau: Integrating Python, SQL, and Tableau
課程老師 | 365 Careers |
---|---|
課程評價 | 4.5 分(3,141 個評分) |
學生人數 | 28,697 人 |
課程介紹
Python, SQL, and Tableau are three of the most widely used tools in the world of data science.
Python is the leading programming language;
SQL is the most widely used means for communication with database systems;
Tableau is the preferred solution
哪些人適合這堂課?
- Intermediate and advanced students
- Students eager to differentiate their resume
- Individuals interested in a career in Business Intelligence and Data Science
學習目標
- How to use Python, SQL, and Tableau together
- Software integration
- Data preprocessing techniques
- Apply machine learning
- Create a module for later use of the ML model
- Connect Python and SQL to transfer data from Jupyter to Workbench
- Visualize data in Tableau
- Analysis and interpretation of the exercise outputs in Jupyter and Tableau
Database programming for intermediates
課程老師 | Shota Fukuda |
---|---|
課程評價 | 4.7 分(29 個評分) |
學生人數 | 4,794 人 |
課程介紹
This course’s target and goal is as follows
■ Target
● IT engineer already have basic SQL skill related to data manipulation,
and want to get more knowledge on DBMS itself (such as transaction, DDL, performance, design)
● IT engineer want to know
哪些人適合這堂課?
- IT engineer already have basic SQL skill related to data manipulation, and want to get more knowledge on DBMS itself (such as transaction, DDL, performance, design)
- IT engineer want to know advanced function to enhance performance and safety
學習目標
- DBMS’s function to keep safety and accuracy (Keywords: Transaction, rollback, lock, etc.)
- How to create table, and mechanism to keep reliability (Keywords: DDL, constraint, referential integrity, etc.)
- How to enhance performance, safety, convenience (Keywords: Index, view, sequence, backup, etc.)
- Procedure to design table based on requirement (Keywords: Conceptual design, logical design, physical design, normalization, etc.)
C# Database Driven WinForm Apps (step by step projects)
課程老師 | Pavol Almasi |
---|---|
課程評價 | 4.8 分(255 個評分) |
學生人數 | 3,566 人 |
課程介紹
WARNING! Some students reported that the MS Access database used in this course will not work with the current version MS Office 365, even with legacy MS Access database redistributable engine. In majority of cases the issue is solved by installing
哪些人適合這堂課?
- Beginner C# developer who wants to create small database driven Windows Forms apps
- Selft Taught programmers or students interested in C# and databases
- Anyone seeking to get entry level position or internship,
- Students who like to learn by hands-on examples.
學習目標
- Students will understand the basics of database programming using C# and MS Access database.
- Students will become familiar with database programming concepts.
- Students will be able to create small database-driven desktop apps.
- Students will understand basics of database concepts.
- Students will be able to create and modify Windows Forms and bind form objects with database objects.
- Students will be ready to tackle more complex projects.
PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
課程老師 | Adnan Waheed |
---|---|
課程評價 | 4.5 分(320 個評分) |
學生人數 | 3,081 人 |
課程介紹
Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more…
I’ve design this course from step-by-step move from basic to advanced topics. Here is a partial lis
哪些人適合這堂課?
- Complete beginners to database world
- Anyone wanting to learn SQL or PostgreSQL
- Anyone wanting to learn advanced query expressions
- Application engineers seeking to expand their backend skillset
- Anyone wants to learn from basic to advanced functionality of PostgreSQL
學習目標
- Learn with 60+ hours of hands-on practical exercises
- Step-by-step walkthrough to perform simple to complex SQL queries
- Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions, and much more
- How to create a database from scratch
- Creating and using various Data types
- Creating User-defined data types
- Table and Column constraints
- Understanding, Using, and creating custom Sequences
- String Functions
- Aggregate Functions
- Date/Time Functions with query analysis
- Grouping data with group sets
- Schemas creations and privileges
- Table Partitioning techniques
- Exploring Array Functions
- In-depth JSON data types and queries
- Subqueries
- Common Table Expressions (CTEs)
- Recursive Common Table Expressions
- Advanced Window Functions
- Server Programming
- Functions with SQL Language
- Functions with PL/pgSQL Language
- Exploring Stored Procedures
- Indexes and queries performance optimizations
- Multiple Data Views types and Security
- Using Regular Expressions for Text Patterns
- Power Text Searches with special data types and indexes
- Crosstab Reports with crosstab extensions
- Making our database for global languages – Internationalization
- psql Utility Commands
- Understanding PostgreSQL Internals
- Triggers
- Using Cursors
- Data integrity with Transactions and Savepoints
- Managing PostgreSQL security
- Extended PostgreSQL echosystem
- Analyze sample HR, Stocks, Northwind, Global Trades databases
- Practice with huge number of queries
- Use SQL to perform data analysis
- Confident putting SQL and PostgreSQL on your resume
課程老師 | Matei Dogeanu |
---|---|
課程評價 | 4.3 分(20 個評分) |
學生人數 | 1,773 人 |
課程介紹
In this course, you will learn how to write clean SQL code. Clean Code is about writing code which is not only understandable to the developer him/herself but to the others as well. Also, it makes it easier to understand your own code after an extend
哪些人適合這堂課?
- SQL Developers who want to learn to write clean code
- Web/Desktop/Mobile Developers who want to learn some clean code principles for developing code for their databases
- Anyone with SQL knowledge who wants to take their skill to the next level
學習目標
- The most important clean code concepts that can be applied to SQL code
- A list of principles to apply in your day to day SQL programming activity
- How to write SQL code that is easily readable by other developers
- How to develop SQL code that can be comfortably upgraded in the future
課程老師 | Shota Fukuda |
---|---|
課程評價 | 4.5 分(39 個評分) |
學生人數 | 1,466 人 |
課程介紹
This course includes how to use basic SQL statement, how to develop easy web app by PHP and MySQL.
After you finished this course, you will fully understand the relationship between web app and database.
And also, you will have skills of database p
哪些人適合這堂課?
- IT engineer want to acquire basic database programming skill
學習目標
- Understand basic SQL statement and get used to DB programming
SQL for Beginners: Crash Course to Become Database Expert
課程老師 | ASquared LLC |
---|---|
課程評價 | 4.2 分(70 個評分) |
學生人數 | 304 人 |
課程介紹
Are you
A College grad looking to learn SQL?
Someone who wants to get into IT as a profession?
An experienced IT professional but want to upgrade your ‘query’ writing ability?
Look no further!
A-Squared’s Database Primer course is the one stop s
哪些人適合這堂課?
- Anyone who wants to learn database
- College graduates, entry level IT professionals, anyone who wants to get into IT, QA professionals wanting to learn SQL
學習目標
- Database concepts
- What is SQL
- Writing SQL Queries
C# with WinForms and SQL Create Database Driven Desktop App
課程老師 | Pavol Almasi |
---|---|
課程評價 | 4.5 分(34 個評分) |
學生人數 | 302 人 |
課程介紹
So what is the course all about? It’s about showing you how to set up mid-size project with Create, Read, Update and Delete functionality, C#, Windows Forms, and SQL. I don’t go over any theory, so it is advised you have a at least few months of expe
哪些人適合這堂課?
- Beginner C# programmers
- Programmers who prefer hands on programming
- Students who prefer single project over mutliple small examples
學習目標
- Working with multiple forms
- CRUD operation
- OOP C#
- Passing data between forms
- Connecting Windows Forms to database
- Windows Forms
- Working with Windows Forms Events
- SQL
Essential SQL Server Development Tips for SQL Developers
課程老師 | Artemakis Artemiou |
---|---|
課程評價 | 4.5 分(18 個評分) |
學生人數 | 92 人 |
課程介紹
In this course, via a combination of lectures, downloadable resources and over than 30 live demos/hands-on guides, you will learn many useful SQL Server database programming hands-on tips, that will help you efficiently develop data processes for you
哪些人適合這堂課?
- SQL Developers who want to strengthen their SQL Server database programming skills
- SQL Server DBAs and Computer Programmers who want to learn more about developing in SQL Server
- IT Architects who want to learn more about SQL Server database development
- Technology enthusiasts who want to learn more about SQL Server database development
學習目標
- How to efficiently perform essential database development tasks in SQL Server, using a variety of techniques and methodologies
- How to work with unstructured data in SQL Server using all the available techniques
- How to implement specialized development-related tasks in SQL Server
- Useful tips for easily resolving SQL Server database development issues
從老師查找更多資料庫程式設計課程
還是您有熱衷某個老師或某個品牌開的課程呢?嘗試從老師或品牌頁挑選吧!
參考其他資料庫設計與開發線上課程
除了本文介紹的課程種類以外,想要瞭解資料庫設計與開發領域還有哪些不同類型的課程值得一探究竟嗎?讓您可以從不同面向更紮實的學習,點擊參考以下其他熱門主題文章。絕對提供您最優惠人氣滿檔的課程,歡迎繼續延伸閱讀。
- 【2024年】十大Oracle Database課程熱門排行推薦與優惠精選!
- 【2024年】十大Pl/SQL課程熱門排行推薦與優惠精選!
- 【2024年】十大資料庫管理課程熱門排行推薦與優惠精選!
- 【2024年】十大資料庫設計課程熱門排行推薦與優惠精選!
- 【2024年】十大PostgreSQL課程熱門排行推薦與優惠精選!