Search
🔥學習資料庫的第一步
🔥快速活用 MySQL，精準設計關聯式資料庫
新課早鳥特惠 👉 https://bit.ly/2L9YTzn
💭你是否有過以下問題？
⚠資料太雜亂，找不到重點
⚠資訊量超出自身負荷，不知道該如何統整或分類
⚠總是花很多時間搜尋資料，卻還是一團混亂
⚠大量資訊擺在眼前，卻不懂該怎麼活用
💭10項課程目標帶你完整學會SQL
🎯運用 Workbench 工具
🎯運用 SQL 語法
🎯建立資料庫、表格、資料
🎯子查詢 - IN、ANY、ALL、EXISTS
🎯查詢資料 - SELECT、ORDER BY、WHERE 語法
🎯邏輯運算 - AND、OR、NOT、BETWEEN、IN 語法
🎯MySQL 不同函式種類與應用
🎯管理使用者帳號與如何授權
🎯關聯式資料庫觀念並進行設計
🎯MySQL 語法並進行實作
快速活用 MySQL，精準設計關聯式資料庫
早鳥特惠 👉 https://bit.ly/2L9YTzn
＃Windows與MacOS皆適用
＃課程中包含多個範例
＃不怕學不會 #只怕你不學
麻煩大家幫忙
留下優秀的一家人
他們來自波多黎各
父母親都是名校約翰霍普金大學的電腦碩士
(Master Degree in Computer Science - Johns Hopkins University at Laurel, MD)
他們著五個孩子，到全世界學習
Diego 17歲 Paula 13 歲 Alonzo 12 歲
Felizi 8 歲 Matteo 6 歲
八月，他們到了台灣
發覺這是一個非常適合的生活環境
有好的醫療、中文學習環境、電腦產業、和超好吃的水果
九月，Diego , Paula, Alonzo進入惠文高中寄讀
他們來了之後，學校形成一個很棒的英語學習情境
台灣學生都被迫用英文跟他們互動
星期五與台北歌德學院簽訂德國「PASCH夥伴學校」時
他們三個和學校弦樂社一起合奏卡農(見影片)
非常非常有教養的一家人
然而他們11月就必須離開台灣
因為他們來台灣的第五天
得到美國總公司的通知
他們收掉波多黎各的公司
爸爸Tommy失業了
所以這幾天，他在台中接一個英文家教
但經濟仍是問題
如果台中的朋友可以提供11月4日前的短期英文、西班牙文家教工作
或是提供長期電腦工程師的工作
麻煩和Tommy聯絡
以下是他的聯絡方式及完整資歷
(願意幫他們申請工作簽證更好)
他們很願意把台灣當成第二個家
PS
覺得政府說要把英文變成第二語言
最棒的方式是吸引國外的學生進入我們的校園
在人才即國力的年代
讓優秀的國際人才留在台灣
如果在台灣就有很好的英語學習環境
我們就不用一窩蜂跑到國外
聯絡TOMMY IRIZARRY-SIKES
Contact Information
Postal: Lane 400, Unit 11, Section 2, Nantun Road, Nantun District, Taichung City, Taiwan 408
Email: tirizar@gmail.com
Phone number: 0908 979 417
LinkedIn Profile: http://pr.linkedin.com/pub/tommy-irizarry/25/16/815
孩子的影片
Diego violin in a quartet:
https://youtu.be/ArkvU8Czmk8?t=37s
Diego violin Doble de Bach:
https://youtu.be/LYvnKwEueyA
Diego plays piano Clair de Lune:
https://youtu.be/CWCQMo5XJEY?t=14s
You can see some other videos in this YouTube channel:
https://www.youtube.com/user/tirizar/videos?reload=9
履歷
Summary of qualifications
Software developer for private industries and government agencies. Proficient web developer using classic ASP code, standard html, CSS and SQL Server for data storage. Web server administrator and SharePoint Power User.
Android developer
Certified Ethical Hacker
Programming / Markup languages: HTML, XML, ASP, PHP, CSS, JavaScript/AJAX/JQuery, experience with Java, C++ and C.
Mobile development: Java, Android, Android Studio.
Technologies / Tools: IIS 6.0/7.5, SQL Server, Dreamweaver, Fireworks, Microsoft SharePoint 2007/2010, Microsoft Office suite including InfoPath, Access, Excel, Google Analytics, Google AdSense, Facebook Advertising, Microsoft SharePoint Designer, Inquisite Surveys.
Experience
Since November 2016-current
Enterprise Iron
Principal consultant – Web Developer
Worked on the redesign efforts of the secure site for an international financial client. Applied responsive design principles using the Bootstrap framework while creating modular, reusable components of the code. Analyzed web page dependencies and identified legacy unused pages in the system.
Since November 2015-current
e-Nabler Corporation
Android developer – Professional Services Contract
Developed Java code for the eMobilePOS and Tupyx apps for their Android versions.
Since October 2013-November 2014 TEK Systems
Web Developer / Web Master for the Department of Veterans Affairs in DC
Continued supporting Veteran’s Affairs IT systems, including managing SharePoint 2010 systems and supporting databases. We identified issues with several databases including the management of IIS and SharePoint logs which were consuming many recourses and in a couple of occasions made the systems unavailable.
Enabled and configured space monitoring tools in the SharePoint server farms.
Since November 2011-September 2013 Centuria Corporation
Web Developer / Web Master for the Department of Veterans Affairs in DC
Developed a training registration web site that has been tweaked and used multiple times for different registration purposes, including new telephone system training, and scheduling software upgrades of encryption on laptops and upgrades to Apple Mac OS. The system uses a web front end and a SQL back end.
Performed a routine web server maintenance tasks including monitoring traffic logs, identifying and archiving sites no longer in use, evaluating tools to assist in the management of the web server.
Administered and migrated the FTP server from Windows 2003 Server / IIS 6 into Windows 2008 R2 Server / IIS 7.5. Configured new sites to support general operations within the VA Intranet.
Maintained and enhanced legacy sites, modifying forms and reports in needs to be updated. This includes modification and creation of site in the Enterprise Content Management System used at the VA.
Assisted other team members in various tasks including the creating or modification of surveys in the Inquisite system, and also the migration of some surveys into SharePoint, the modification of an Access application.
December 2001 – August 2011
Systems & System Software Solutions
Web Developer / Web Master for the Department of Veterans Affairs in DC
Mr. Irizarry developed a web based application for the State Home Per Diem Office, which manages millions of dollars in payments to the state homes, to replace an Access database. The Access database was converted to MS SQL Server database and all data was migrated successfully. He created a web based interface using the standard VA intranet look and feel. He also developed a custom interface for each of the 3 roles (CBO, VAMC and VISN). Tools were built for the administrator to view current reports, view missing reports lists, and configure many parameters in the application. The VAMC report form was heavily automated using jQuery to perform auto calculations, increasing data validation and saving time to the users. After the application was launched users commented frequently about how user friendly is the new interface and about the time savings. Tasks that will take 2 hours to be completed now take 15 minutes. We have close to 12,000 reports in the system.
There were various requests to the IT office for a web based training registration system of different types. Mr. Irizarry developed a registration system which was later used for the following projects: Take your child to work day, New Telephone system training registration, Laptop Hard Drive encryption software upgrade among others.
Developed an alternate cascading style sheet for SharePoint 2007, converting the out of the box look and feel to the Department of Veterans Affairs standard website look and feel.
After one of the VA’s laptops was stolen Mr. Irizarry worked to develop a Risk Assessment web based application. He created an Excel template which management will upload to an FTP server with information and details about remote employee access and the sensibility of the data accessed by those users. He also created VB Scripts to validate those Excel files an upload that information into an MS SQL database. Reports for upper management in Central Office were then created which prompted management to enforce stronger security measures, like hard drives encryption. In total more than 500,000 records were processed for the reports.
Administration of IIS 6.0 web server and MS SQL Server databases used in our websites.
Wrote migration scripts to move IIS 6.0 sites into a new IIS 7.5 server
Designed, developed and maintained multi-tier applications for the Veterans Health Administration. Most of the sites access a MS-SQL Server database, use cascade style sheets and ASP server side processing. The sites were developed using Adobe/Macromedia tools like Fireworks, and Dreamweaver.
Installed BlackBerry wireless email devices and trained users on the basic device usage.
Web developer for the Department of Veterans Affairs. Redesigned and modified web pages to make them compliant with the Section 508 guidelines. Tested validation tools that verify if web pages are “Section 508” compliant. Section 508 are guidelines that must be followed by all government agencies and points to which government resources must be make accessible to people with disabilities, i.e. blind, deaf, etc.
November 1999 - December 2001
Compaq Computer Corporation
Consulting Associate II
Design and develop the XOOB (Xevo out of the box) Web user interface. XOOB uses COM+, ASP, XML, XSL and JavaScript to provide a web user interface to the Xevo Workbench Platform based on the role associated with the user. Development was done using Visual Studio tools, IIS and XMLSpy.
Develop Active Server Pages for the Helpdesk solution for the PrimusASP project.
Design and code an ActiveX component that serves as the bridge between the Compaq ASP Framework and the Infranet billing system for Primus. Supported integration with other components of our framework.
Design, code and troubleshoot software for the Primus ASP (Application Service Provider) project. Software includes a DLL and various VB programs that run as NT Services, which are key components of the Compaq ASP framework.
June 1998 – October 1999
National Security Agency
Computer Scientist
Mr. Irizarry worked for as a software developer for the TOKENEER project. TOKENEER is a test platform for the integration of smart cards, biometrics (fingerprint, hand, iris and facial recognition) and a public key infrastructure. Development was done on Windows NT workstations using Visual C++ and Visual SourceSafe for source control. Mr. Irizarry used an SDK to capture and match fingerprints against a database of fingerprints. He also created software to created some statistics of “False Accepts and False Reject Rates” of the fingerprint. He also worked with other team members to identify which fingerprints characteristics could affect those rates. He then added error detection functions to the fingerprint recognition software to identify corrupted files of fingerprint images
Conducted research for methods to add security services to an off-the-shelf computer.
Developed C code to process fax data on an UltraSparc/SunOS station.
Wrote software to generate a daily report of traffic load in a telephone switch by analyzing the switch logs.
Education
Certifications:
Certified Ethical Hacker – 03/28/2014
Master Degree in Computer Science - May, 2001 Johns Hopkin
準備 156 個流行的真實世界 SQL 面試問題，並自信地走進面試，對於你會被問的各類型問題胸有成竹。 給面試官留下深刻的印象
測驗包含以下資料庫和 SQL 主題的問題：
Databases Core Concepts
Normalization (First Normal Form, Second Normal Form, Third Normal Form)
Relationships
SQL Queries Basics
SELECT statement and syntax
SQL Data Types
WHERE operators: comparison operators, LIKE, BETWEEN, IN
Scalar Functions
Aggregate Functions (SUM, COUNT, MIN, MAX, AVG)
GROUP BY
ORDER BY
JOINS (INNER JOIN, RIGHT and LEFT JOIN, OUTER JOIN, CROSS JOIN)
Set Theory (INTERSECT, UNION, MINUS)
Subqueries
INSERT, UPDATE, DELETE
DML vs DDL vs DCL
DDL: CREATE, DROP, ALTER
Constraints
Indexes
DCL privileges: GRANT, REVOKE
Transactions
Views
Triggers
Cursors
https://softnshare.com/2018/06/09/sql-interview-questions/
ดาวน์โหลด PostgreSQL script ไฟล์ที่ใช้ในคลิปได้ที่ ► http://bit.ly/30aRT8h
ดาวน์โหลด saturn database (saturn.tar) ได้ที่ ► http://bit.ly/2E2uY7a
เชิญสมัครเป็นสมาชิกของช่องนี้ได้ที่ ► https://www.youtube.com/subscription_center?add_user=prasertcbs
สอน PostgreSQL ► https://www.youtube.com/playlist?list=PLoTScYm9O0GGi_NqmIu43B-PsxA0wtnyH
สอน MySQL ► https://www.youtube.com/playlist?list=PLoTScYm9O0GFmJDsZipFCrY6L-0RrBYLT
สอน Microsoft SQL Server 2012, 2014, 2016, 2017 ► https://www.youtube.com/playlist?list=PLoTScYm9O0GH8gYuxpp-jqu5Blc7KbQVn
สอน SQLite ► https://www.youtube.com/playlist?list=PLoTScYm9O0GHjYJA4pfG38M5BcrWKf5s2
สอน SQL สำหรับ Data Science ► https://www.youtube.com/playlist?list=PLoTScYm9O0GGq8M6HO8xrpkaRhvEBsQhw
การเชื่อมต่อกับฐานข้อมูล (SQL Server, MySQL, SQLite) ด้วย Python ► https://www.youtube.com/playlist?list=PLoTScYm9O0GEdZtHwU3t9k3dBAlxYoq59
การใช้ Excel ในการทำงานร่วมกับกับฐานข้อมูล (SQL Server, MySQL, Access) ► https://www.youtube.com/playlist?list=PLoTScYm9O0GGA2sSqNRSXlw0OYuCfDwYk
#prasertcbs_SQL #prasertcbs #prasertcbs_PostgreSQL
ASP.NET數位影音資料庫第3天上課全程影音分享
今天早上3小時將以前要花56小時的SQL Server2008課程講完，
雖然只用了3小時，但該講的也沒少掉，查詢、新增、修改與刪除的功能都舉例說明了。
所以應該已經算是說的很透澈了！只是還是有幾個同學至不在此，
上課看的出來都沒在練習，甚至在上網做自己的事，感覺很浪費職訓資源。
下午進入ASP.NET的重頭戲，資料庫的進階應用，
利用ASP.NET所提供的控制項，幾乎沒想一行程式，就將查詢系統完成，
真的是很棒的設計工具，若與ASP、PHP等相比較，真的是簡單太多了，
利用工具箱的資料庫控制項，輕易的將資料庫的資料，快速的顯示在網頁上，
並可已查詢結果，最重要是沒想半行程式，真是了不起。
下星期剩6小時，思索與影音資料庫結合的範例，讓大家更清楚如何運用在影音上，
這部份還真的需要花一些時間備課的，不過是非常值得的，
可以自己做出 VOD系統或是線上影音教學平台，這一定會很有需求的。
吳老師 2010/09/08
上課影音：
01建立SQL_Server資料庫
02建立成語資料庫範例
03新增查詢&別名設定
04Where子句的查詢方式
05加入BETWEEN運算子
06查詢成語資料表中有虎的關鍵字
07查詢AND&OR運算子與排序
08新增資料流程說明
09更新資料庫流程說明
10刪除資料的流程
11建立資料來源並顯示在GRIDVIEW
12編輯GRIDVIEW的編輯&分頁&排序功能
13如何增加更新與刪除功能
14建立參數的SQL查詢使用TEXTBOX與DDL
15多個參數的查詢
16成語查詢系統建立流程
吳老師教學網：
http://3cc.cc/10g
部落格：
http://terry55wu.blogspot.com/
論壇：
http://groups.google.com/group/itctcaspnet?hl=zh-TW
YOUTUEB：
http://www.youtube.com/terry28853669
ASP.NET 3.5,吳清輝老師,文化大學,推廣部,職訓案,程式設計,WEB2.0,線上教學,TQC,Dreamweaver,Flash,影音資料庫
ASP.NET數位影音資料庫第3天上課全程影音分享
今天早上3小時將以前要花56小時的SQL Server2008課程講完，
雖然只用了3小時，但該講的也沒少掉，查詢、新增、修改與刪除的功能都舉例說明了。
所以應該已經算是說的很透澈了！只是還是有幾個同學至不在此，
上課看的出來都沒在練習，甚至在上網做自己的事，感覺很浪費職訓資源。
下午進入ASP.NET的重頭戲，資料庫的進階應用，
利用ASP.NET所提供的控制項，幾乎沒想一行程式，就將查詢系統完成，
真的是很棒的設計工具，若與ASP、PHP等相比較，真的是簡單太多了，
利用工具箱的資料庫控制項，輕易的將資料庫的資料，快速的顯示在網頁上，
並可已查詢結果，最重要是沒想半行程式，真是了不起。
下星期剩6小時，思索與影音資料庫結合的範例，讓大家更清楚如何運用在影音上，
這部份還真的需要花一些時間備課的，不過是非常值得的，
可以自己做出 VOD系統或是線上影音教學平台，這一定會很有需求的。
吳老師 2010/09/08
上課影音：
01建立SQL_Server資料庫
02建立成語資料庫範例
03新增查詢&別名設定
04Where子句的查詢方式
05加入BETWEEN運算子
06查詢成語資料表中有虎的關鍵字
07查詢AND&OR運算子與排序
08新增資料流程說明
09更新資料庫流程說明
10刪除資料的流程
11建立資料來源並顯示在GRIDVIEW
12編輯GRIDVIEW的編輯&分頁&排序功能
13如何增加更新與刪除功能
14建立參數的SQL查詢使用TEXTBOX與DDL
15多個參數的查詢
16成語查詢系統建立流程
吳老師教學網：
http://3cc.cc/10g
部落格：
http://terry55wu.blogspot.com/
論壇：
http://groups.google.com/group/itctcaspnet?hl=zh-TW
YOUTUEB：
http://www.youtube.com/terry28853669
ASP.NET 3.5,吳清輝老師,文化大學,推廣部,職訓案,程式設計,WEB2.0,線上教學,TQC,Dreamweaver,Flash,影音資料庫
sql between 在 Difference between SQL and PL/SQL | SQL vs PL SQL 的美食出口停車場
So in this PLSQL vs SQL comparison some important parameters have been taken into consideration to tell ... ... <看更多>