{"id":17023,"date":"2019-07-11T11:09:50","date_gmt":"2019-07-11T04:09:50","guid":{"rendered":"https:\/\/itviec.com\/blog\/?p=17023"},"modified":"2024-01-29T16:55:09","modified_gmt":"2024-01-29T09:55:09","slug":"sql-la-gi","status":"publish","type":"post","link":"https:\/\/itviec.com\/blog\/sql-la-gi\/","title":{"rendered":"Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec? T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 ng\u00f4n ng\u1eef SQL \u0111\u1ec1u n\u1eb1m trong b\u00e0i vi\u1ebft n\u00e0y"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung b\u00e0i vi\u1ebft<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/#SQL_la_gi\" >SQL l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/#SQL_Server_la_gi\" >SQL Server l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/#PLSQL_la_gi\" >PL\/SQL l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/#Cong_viec_cua_SQL_Developer\" >C\u00f4ng vi\u1ec7c c\u1ee7a SQL Developer<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/#Nhung_to_chat_nen_co_khi_lam_SQL_la_gi\" >Nh\u1eefng t\u1ed1 ch\u1ea5t n\u00ean c\u00f3 khi l\u00e0m SQL l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/#Lo_trinh_su_nghiep_khi_theo_SQL_la_gi\" >L\u1ed9 tr\u00ecnh s\u1ef1 nghi\u1ec7p khi theo SQL l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/#Tai_lieu_hoc_SQL_tham_khao\" >T\u00e0i li\u1ec7u h\u1ecdc SQL tham kh\u1ea3o<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/#SQL_Developer_trong_nganh_IT_noi_gi\" >SQL Developer trong ng\u00e0nh IT n\u00f3i g\u00ec?<\/a><\/li><\/ul><\/nav><\/div>\n\r\n<p><strong><em><em>SQL l\u00e0 g\u00ec? SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb Structured Query Language, ngh\u0129a l\u00e0 ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/em> <em>C\u00f3 th\u1ec3 coi SQL l\u00e0 ng\u00f4n ng\u1eef chung m\u00e0 b\u1ea5t c\u1ee9 h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 (RDBMS) n\u00e0o c\u0169ng ph\u1ea3i \u0111\u00e1p \u1ee9ng.<\/em><\/em><\/strong><\/p>\r\n\r\n\r\n\r\n<p>\u0110\u1ecdc b\u00e0i ph\u1ecfng v\u1ea5n c\u1ee7a ITviec v\u1edbi anh\u00a0<strong>H\u1ed3ng Minh Tr\u00ed<\/strong>\u00a0\u2013 ng\u01b0\u1eddi c\u00f3 h\u01a1n 7 n\u0103m l\u00e0m vi\u1ec7c v\u1edbi SQL \u0111\u1ec3 bi\u1ebft \u0111\u1ea7y \u0111\u1ee7 v\u1ec1 SQL l\u00e0 g\u00ec v\u00e0 Nh\u1eefng t\u00e0i li\u1ec7u h\u1ecdc SQL tham kh\u1ea3o cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u v\u1ec1 ng\u00f4n ng\u1eef SQL.<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><strong><em>Xem th\u00eam <a href=\"https:\/\/itviec.com\/it-jobs\/sql-developer?utm_source=blogpost&amp;utm_medium=first_post&amp;utm_campaign=linktosite\" target=\"_blank\" rel=\"noopener noreferrer\">vi\u1ec7c l\u00e0m SQL Developer<\/a> tr\u00ean ITviec<\/em><\/strong><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p><!--more--><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-sql-l-g\"><span class=\"ez-toc-section\" id=\"SQL_la_gi\"><\/span><b>SQL l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>Tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u SQL l\u00e0 g\u00ec, ta c\u1ea7n bi\u1ebft \u0111\u1ebfn c\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n sau v\u1ec1 c\u01a1 s\u1edf d\u1eef li\u1ec7u:<\/p>\r\n<ul>\r\n<li><strong>C\u01a1 s\u1edf d\u1eef li\u1ec7u<\/strong> (Database) l\u00e0 t\u1eadp h\u1ee3p d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef v\u00e0 truy c\u1eadp t\u1eeb h\u1ec7 th\u1ed1ng m\u00e1y t\u00ednh.<\/li>\r\n<li><strong>Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/strong> \u0111\u01b0\u1ee3c hi\u1ec3u \u0111\u01a1n gi\u1ea3n l\u00e0 m\u1ed9t \u201cb\u1ed9 l\u1ecdc\u201d c\u00f3 kh\u1ea3 n\u0103ng thu th\u1eadp th\u00f4ng tin t\u1eeb nhi\u1ec1u b\u1ea3ng trong m\u1ed9t h\u1ec7 c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u00e0 thi\u1ebft l\u1eadp c\u00e1c c\u00e1c ti\u00eau ch\u00ed \u0111\u1ec3 h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u00edch h\u1ee3p.<\/li>\r\n<\/ul>\r\n<p>SQL l\u00e0 g\u00ec? SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Structured Query Language, ngh\u0129a l\u00e0 ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u00f3 th\u1ec3 coi ng\u00f4n ng\u1eef SQL l\u00e0 ng\u00f4n ng\u1eef chung m\u00e0 b\u1ea5t c\u1ee9 h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 (RDBMS) n\u00e0o c\u0169ng ph\u1ea3i \u0111\u00e1p \u1ee9ng, \u0111i\u1ec3n h\u00ecnh nh\u01b0: Oracle Database, SQL Server, <a href=\"https:\/\/itviec.com\/blog\/mysql-la-gi\/\" target=\"_blank\" rel=\"noopener\">MySQL<\/a>\u2026 (C\u00f2n &#8220;SQL Server l\u00e0 g\u00ec&#8221; s\u1ebd \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p ngay ph\u1ea7n sau d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a b\u00e0i vi\u1ebft nh\u00e9.)<\/p>\r\n\r\n\r\n\r\n<p>B\u1ea5t k\u00ec c\u00f4ng ty n\u00e0o l\u1edbn c\u0169ng c\u1ea7n x\u00e2y d\u1ef1ng m\u1ed9t h\u1ec7 th\u1ed1ng \u0111\u1ec3 l\u01b0u tr\u1eef c\u01a1 s\u1edf d\u1eef li\u1ec7u. M\u1ecdi th\u1ee9 trong c\u01a1 s\u1edf d\u1eef li\u1ec7u n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c quy ra th\u00e0nh nhi\u1ec1u b\u1ea3ng, c\u00f3 m\u1ed1i quan h\u1ec7 v\u1edbi nhau. SQL gi\u00fap qu\u1ea3n l\u00fd hi\u1ec7u qu\u1ea3 v\u00e0 truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u00f4ng tin nhanh h\u01a1n, gi\u00fap b\u1ea3o tr\u00ec th\u00f4ng tin d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>Khi doanh nghi\u1ec7p l\u01b0u tr\u1eef th\u00f4ng tin d\u1ea1ng truy\u1ec1n th\u1ed1ng nh\u01b0 gi\u1ea5y hay file Excel th\u00ec s\u1ebd c\u00f3 nhi\u1ec1u r\u1ee7i ro nh\u01b0 b\u1ecb m\u1ea5t, s\u1eeda, x\u00f3a\u2026 c\u0169ng nh\u01b0 ph\u1ea3i m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 l\u1ee5c l\u1ea1i h\u1ed3 s\u01a1. Ch\u01b0a k\u1ec3, m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p sau khi th\u00eam ho\u1eb7c s\u1eeda th\u00f4ng tin, h\u1ed3 s\u01a1 s\u1ebd kh\u00f4ng c\u00f2n h\u1ee3p l\u1ec7.<\/em><\/p>\r\n<p><em>Trong khi, n\u1ebfu l\u01b0u tr\u1eef th\u00f4ng tin v\u00e0o m\u1ed9t h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u, b\u1ea1n ch\u1ec9 c\u1ea7n g\u00f5 m\u1ed9t c\u00e2u l\u1ec7nh SQL ng\u1eafn l\u00e0 \u0111\u00e3 c\u00f3 th\u1ec3 tr\u00edch xu\u1ea5t \u0111\u01b0\u1ee3c th\u00f4ng tin em c\u1ea7n. Vi\u1ec7c th\u00eam\/x\u00f3a\/s\u1eeda c\u0169ng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng.<\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p>\u0110\u1ec3 truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u00e0 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u00e1c b\u1ea3ng n\u00e0y (nh\u1eb1m t\u1ed5ng h\u1ee3p th\u00e0nh th\u00f4ng tin h\u1eefu \u00edch n\u00e0o \u0111\u00f3), ng\u01b0\u1eddi ta d\u00f9ng \u0111\u1ebfn SQL th\u00f4ng qua c\u00e1c c\u00e2u query.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SQL_Server_la_gi\"><\/span><strong>SQL Server l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>SQL Server l\u00e0 g\u00ec? SQL Server &#8211; m\u1ed9t ph\u1ea7n m\u1ec1m do Microsoft ph\u00e1t tri\u1ec3n v\u00e0o n\u0103m 1989, l\u00e0 h\u1ec7 th\u1ed1ng qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 hay c\u00f2n g\u1ecdi l\u00e0 RDBMS (<strong>R<\/strong>elational <strong>D<\/strong>atabase <strong>M<\/strong>anagement <strong>S<\/strong>ystem).<\/p>\r\n<p>SQL Server \u0111\u01b0\u1ee3c d\u00f9ng v\u00e0o vi\u1ec7c t\u1ea1o, duy tr\u00ec v\u00e0 l\u01b0u tr\u1eef, ph\u00e2n t\u00edch v\u00e0 tr\u00edch xu\u1ea5t c\u01a1 s\u1edf d\u1eef li\u1ec7u theo y\u00eau c\u1ea7u.<\/p>\r\n<p>C\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n t\u1ea1i c\u1ee7a SQL Server l\u00e0 g\u00ec? Hi\u1ec7n nay, Microsoft \u0111ang cung c\u1ea5p c\u00e1c phi\u00ean b\u1ea3n SQL Server nh\u01b0 sau \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf cho t\u1eebng \u0111\u1ed1i t\u01b0\u1ee3ng ri\u00eang bi\u1ec7t:<\/p>\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td>\r\n<p><b>Phi\u00ean b\u1ea3n SQL Server<\/b><\/p>\r\n<\/td>\r\n<td>\r\n<p><b>Mi\u00eau t\u1ea3 phi\u00ean b\u1ea3n SQL Server<\/b><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><b>SQL Server Enterprise<\/b><\/p>\r\n<\/td>\r\n<td>\r\n<p><span style=\"font-weight: 400;\">Phi\u00ean b\u1ea3n SQL Server d\u00e0nh cho doanh nghi\u1ec7p n\u00e0y cung c\u1ea5p \u0111\u1ea7y \u0111\u1ee7 c\u00e1c ch\u1ee9c n\u0103ng v\u1edbi hi\u1ec7u su\u1ea5t c\u1ef1c nhanh, tr\u1ef1c quan h\u00f3a th\u00f4ng tin kh\u00f4ng gi\u1edbi h\u1ea1n v\u00e0 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng c\u00f3 to\u00e0n quy\u1ec1n truy c\u1eadp th\u00f4ng tin chi ti\u1ebft v\u1ec1 d\u1eef li\u1ec7u.<\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><b>SQL Server Standard<\/b><\/p>\r\n<\/td>\r\n<td>\r\n<p><span style=\"font-weight: 400;\">Phi\u00ean b\u1ea3n SQL Server ti\u00eau chu\u1ea9n cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u \u1edf m\u1ee9c c\u01a1 b\u1ea3n \u0111\u1ec3 ch\u1ea1y c\u00e1c \u1ee9ng d\u1ee5ng v\u00e0 h\u1ed7 tr\u1ee3 c\u00e1c c\u00f4ng c\u1ee5 ph\u00e1t tri\u1ec3n ph\u1ed5 bi\u1ebfn cho on-premise v\u00e0 cloud, ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c c\u00f4ng ty quy m\u00f4 nh\u1ecf ho\u1eb7c c\u00f3 ngu\u1ed3n nh\u00e2n l\u1ef1c IT h\u1ea1n ch\u1ebf.<\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><b>SQL Server Web<\/b><\/p>\r\n<\/td>\r\n<td>\r\n<p><span style=\"font-weight: 400;\">Phi\u00ean b\u1ea3n SQL Server Web l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn v\u1edbi chi ph\u00ed h\u1ee3p l\u00fd d\u00e0nh cho c\u00e1c Web hoster v\u00e0 Web VAP, cung c\u1ea5p kh\u1ea3 n\u0103ng m\u1edf r\u1ed9ng v\u00e0 kh\u1ea3 n\u0103ng qu\u1ea3n l\u00fd cho c\u00e1c Web properties c\u00f3 quy m\u00f4 t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn.<\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><b>SQL Server Developer<\/b><\/p>\r\n<\/td>\r\n<td>\r\n<p><span style=\"font-weight: 400;\">Phi\u00ean b\u1ea3n SQL Server Developer cho ph\u00e9p developer x\u00e2y d\u1ef1ng b\u1ea5t k\u1ef3 lo\u1ea1i \u1ee9ng d\u1ee5ng n\u00e0o tr\u00ean SQL Server. Phi\u00ean b\u1ea3n n\u00e0y bao g\u1ed3m t\u1ea5t c\u1ea3 c\u00e1c ch\u1ee9c n\u0103ng c\u1ee7a phi\u00ean b\u1ea3n Enterprise, nh\u01b0ng \u0111\u01b0\u1ee3c c\u1ea5p ph\u00e9p \u0111\u1ec3 s\u1eed d\u1ee5ng nh\u01b0 m\u1ed9t h\u1ec7 th\u1ed1ng ph\u00e1t tri\u1ec3n v\u00e0 testing, kh\u00f4ng ph\u1ea3i nh\u01b0 m\u1ed9t production server.<\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>\r\n<p><b>SQL Server Express<\/b><\/p>\r\n<\/td>\r\n<td>\r\n<p><span style=\"font-weight: 400;\">Phi\u00ean b\u1ea3n SQL Server Express l\u00e0 phi\u00ean b\u1ea3n \u0111\u01a1n gi\u1ea3n, d\u1ec5 d\u00f9ng nh\u1ea5t, th\u00edch h\u1ee3p cho c\u00e1c nh\u00e0 ph\u00e1t tri\u1ec3n ph\u1ea7n m\u1ec1m \u0111\u1ed9c l\u1eadp v\u00e0 nh\u1eefng ng\u01b0\u1eddi m\u1edbi t\u00ecm hi\u1ec3u v\u1ec1 SQL.<\/span><\/p>\r\n<p><span style=\"font-weight: 400;\">N\u1ebfu c\u1ea7n c\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 n\u00e2ng c\u1ea5p SQL Server Express l\u00ean c\u00e1c phi\u00ean b\u1ea3n SQL Server cao c\u1ea5p h\u01a1n d\u1ec5 d\u00e0ng.<\/span><\/p>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<h2 id=\"h-pl-sql-l-g\"><span class=\"ez-toc-section\" id=\"PLSQL_la_gi\"><\/span><strong>PL\/SQL l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>PL\/SQL l\u00e0 g\u00ec? PL\/SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Procedural Language\/Structured Query Language \u2013 m\u1ed9t lo\u1ea1i ng\u00f4n ng\u1eef th\u1ee7 t\u1ee5c d\u00f9ng cho Oracle. PL\/SQL l\u00e0 m\u1ed9t extension (m\u1edf r\u1ed9ng) c\u1ee7a ri\u00eang Oracle.<\/p>\r\n\r\n\r\n\r\n<p>PL\/SQL ra \u0111\u1eddi \u0111\u1ec3 h\u1ed7 tr\u1ee3 th\u00eam cho web service. N\u1ebfu nh\u01b0 SQL c\u00f3 nhi\u1ec7m v\u1ee5 truy v\u1ea5n \u0111\u1ebfn c\u00e1c b\u1ea3ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u th\u00ec PL\/SQL s\u1ebd th\u1ef1c hi\u1ec7n nh\u1eefng c\u00f4ng \u0111o\u1ea1n ti\u1ebfp theo nh\u01b0: \u0111\u00f3ng g\u00f3i k\u1ebft qu\u1ea3, x\u1eed l\u00fd c\u00e1ch hi\u1ec3n th\u1ecb tr\u00ean giao di\u1ec7n\u2026<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-c-ng-vi-c-c-a-sql-developer\"><span class=\"ez-toc-section\" id=\"Cong_viec_cua_SQL_Developer\"><\/span><strong>C\u00f4ng vi\u1ec7c c\u1ee7a SQL Developer<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>C\u00f4ng vi\u1ec7c c\u1ee7a m\u1ed9t SQL Developer t\u00f9y thu\u1ed9c v\u00e0o y\u00eau c\u1ea7u c\u1ee7a m\u1ed7i c\u00f4ng ty. Anh Tr\u00ed chia s\u1ebb,<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>V\u1ec1 c\u01a1 b\u1ea3n, SQL gi\u1ed1ng nh\u01b0 m\u1ed9t k\u1ef9 n\u0103ng. H\u1ea7u nh\u01b0 developer n\u00e0o c\u0169ng s\u1ebd l\u00e0m vi\u1ec7c v\u1edbi SQL d\u00f9 \u00edt hay nhi\u1ec1u.<\/em><\/p>\r\n<p><em>Ch\u1ec9 c\u00f3 ng\u00e2n h\u00e0ng ho\u1eb7c nh\u1eefng c\u00f4ng ty c\u00f3 h\u1ec7 th\u1ed1ng d\u1eef li\u1ec7u c\u1ef1c l\u1edbn nh\u01b0 th\u00ec h\u1ecd m\u1edbi tuy\u1ec3n developer chuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi SQL v\u00e0 ch\u1ec9 duy nh\u1ea5t SQL m\u00e0 th\u00f4i.<\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p>C\u00f4ng vi\u1ec7c c\u1ee7a m\u1ed9t SQL Devloper s\u1ebd:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Th\u01b0\u1eddng xuy\u00ean tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u, t\u1ed5ng h\u1ee3p c\u00e1c b\u00e1o c\u00e1o<\/li>\r\n<li>Ph\u00e2n t\u00edch v\u00e0 d\u1ef1 \u0111o\u00e1n v\u1ec1 t\u00ecnh h\u00ecnh t\u00e0i ch\u00ednh doanh nghi\u1ec7p<\/li>\r\n<li>\u0110\u01b0a ra k\u1ebf ho\u1ea1ch ho\u1eb7c \u0111\u1ecbnh h\u01b0\u1edbng \u0111\u1ec3 c\u1ea3i thi\u1ec7n t\u00ecnh h\u00ecnh t\u00e0i ch\u00ednh doanh nghi\u1ec7p<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>C\u00f2n l\u1ea1i, c\u00f4ng vi\u1ec7c c\u1ee7a m\u1ed9t SQL c\u0169ng s\u1ebd gi\u1ed1ng nh\u01b0 nh\u1eefng l\u1eadp tr\u00ecnh vi\u00ean kh\u00e1c. Anh Tr\u00ed chia s\u1ebb th\u00eam v\u1ec1 c\u00f4ng vi\u1ec7c hi\u1ec7n t\u1ea1i c\u1ee7a anh khi l\u00e0m theo m\u00f4 h\u00ecnh Scrum, chia ra l\u00e0m nhi\u1ec1u Sprint kh\u00e1c nhau:<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>M\u1ed7i s\u00e1ng, anh th\u01b0\u1eddng h\u1ecdp v\u1edbi v\u0103n ph\u00f2ng b\u00ean \u00dac \u0111\u1ec3 b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh c\u00f4ng vi\u1ec7c: H\u00f4m qua \u0111\u00e3 l\u00e0m nh\u1eefng g\u00ec, h\u00f4m nay s\u1ebd l\u00e0m g\u00ec ti\u1ebfp theo, c\u00f3 kh\u00f3 kh\u0103n n\u00e0o c\u1ea7n h\u1ed7 tr\u1ee3 kh\u00f4ng\u2026 r\u1ed3i m\u1edbi b\u1eaft \u0111\u1ea7u v\u00e0o c\u00f4ng vi\u1ec7c ch\u00ednh.<\/em><\/p>\r\n<p><em>C\u00f4ng vi\u1ec7c c\u1ee7a anh l\u00e0 gi\u1ea3i quy\u1ebft t\u1eebng story c\u1ee5 th\u1ec3 trong t\u1eebng Sprint m\u00e0\u00a0<\/em><a href=\"https:\/\/itviec.com\/blog\/scrum-master-la-gi\/\"><em>Scrum Master<\/em><\/a><em>\u00a0\u0111\u00e3 ph\u00e2n b\u1ed5 cho m\u1ecdi ng\u01b0\u1eddi. Nh\u1eefng story n\u00e0y th\u01b0\u1eddng s\u1ebd \u0111\u01b0\u1ee3c chia \u0111i\u1ec3m t\u00f9y theo m\u1ee9c \u0111\u1ed9 ph\u1ee9c t\u1ea1p c\u1ee7a requirement.<\/em><\/p>\r\n<p><em>Ph\u00eda kh\u00e1ch h\u00e0ng c\u0169ng c\u00f3 r\u00e0ng bu\u1ed9c l\u00e0 trong m\u1ed9t Sprint, m\u1ed7i m\u1ed9t developer ph\u1ea3i l\u00e0m \u00edt nh\u1ea5t bao nhi\u00eau point \u0111\u00f3, ch\u1ee9 kh\u00f4ng \u00edt h\u01a1n \u0111\u01b0\u1ee3c.<\/em><\/p>\r\n<p><em>\u0110\u1ec3 gi\u1ea3i quy\u1ebft story, th\u1eddi gian c\u1ee7a anh v\u1eabn xoay quanh vi\u1ec7c coding v\u00e0 unit test (test l\u1ea1i c\u00e1c ch\u1ee9c n\u0103ng c\u01a1 b\u1ea3n sau khi develop m\u1ed9t ch\u1ee9c n\u0103ng n\u00e0o \u0111\u00f3), sau \u0111\u00f3 b\u00e0n giao l\u1ea1i cho Tester ki\u1ec3m th\u1eed requirement.<\/em><\/p>\r\n<p><em>Th\u1ec9nh tho\u1ea3ng, b\u1ecdn anh c\u0169ng s\u1ebd review code ch\u00e9o cho nhau khi \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o m\u1ecdi ng\u01b0\u1eddi \u0111\u1ec1u c\u00f3 th\u1ec3 c\u1ea3i thi\u1ec7n k\u1ef9 n\u0103ng coding.<\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<div class=\"wp-block-image wp-image-17137 size-large\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17137\" src=\"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-2a-640x427.jpg\" alt=\"Chia s\u1ebb t\u1eeb anh H\u1ed3ng Minh Tr\u00ed v\u1ec1 truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u00e0 SQL\" width=\"640\" height=\"427\" srcset=\"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-2a.jpg 640w, https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-2a-300x200.jpg 300w, https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-2a-768x513.jpg 768w, https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-2a-200x134.jpg 200w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/>\r\n<figcaption>Ngo\u00e0i gi\u1edd l\u00e0m, anh Tr\u00ed c\u00f3 s\u1edf th\u00edch ch\u1ee5p \u1ea3nh v\u00e0 \u0111i du l\u1ecbch \u0111\u00e2y \u0111\u00f3<\/figcaption>\r\n<\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-nh-ng-t-ch-t-n-n-c-khi-l-m-sql-l-g\"><span class=\"ez-toc-section\" id=\"Nhung_to_chat_nen_co_khi_lam_SQL_la_gi\"><\/span><strong>Nh\u1eefng t\u1ed1 ch\u1ea5t n\u00ean c\u00f3 khi l\u00e0m SQL l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>Theo anh Tr\u00ed, m\u1ed9t ng\u01b0\u1eddi mu\u1ed1n l\u00e0m v\u1ec1 SQL th\u00ec n\u00ean s\u1edf h\u1eefu 3 t\u1ed1 ch\u1ea5t sau \u0111\u00e2y:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Th\u1ee9 nh\u1ea5t, n\u00ean <strong>c\u00f3 t\u01b0 duy l\u1eadp tr\u00ecnh c\u01a1 b\u1ea3n:<\/strong><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Khi c\u00f3 t\u01b0 duy l\u1eadp tr\u00ecnh, c\u00f3 n\u1ec1n t\u1ea3ng h\u1ecdc v\u1ec1 IT t\u1ea1i tr\u01b0\u1eddng \u0111\u1ea1i h\u1ecdc r\u1ed3i th\u00ec b\u1ea1n s\u1ebd l\u00e0m quen v\u1edbi SQL r\u1ea5t nhanh. V\u1ec1 c\u01a1 b\u1ea3n, c\u00e1c ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh ch\u1ec9 kh\u00e1c nhau v\u1ec1 c\u00fa ph\u00e1p c\u00f2n b\u1ea3n ch\u1ea5t hay logic th\u00ec kh\u00e1 t\u01b0\u01a1ng \u0111\u1ed3ng.<\/p>\r\n\r\n\r\n\r\n<p>Tuy nhi\u00ean, anh Tr\u00ed c\u0169ng chia s\u1ebb th\u00eam r\u1eb1ng \u0111i\u1ec1u n\u00e0y c\u0169ng kh\u00f4ng ph\u1ea3i y\u1ebfu t\u1ed1 b\u1eaft bu\u1ed9c v\u00ec anh th\u1ea5y c\u00f3 nhi\u1ec1u b\u1ea1n h\u1ecdc kinh t\u1ebf nh\u01b0ng chuy\u1ec3n qua h\u1ecdc v\u00e0 l\u00e0m SQL c\u0169ng \u201c\u1ed5n \u00e1p\u201d.<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Th\u1ee9 hai, c\u1ea7n\u00a0<strong>c\u00f3 kh\u1ea3 n\u0103ng ti\u1ebfng Anh:<\/strong><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Theo anh Tr\u00ed, vi\u1ec7c h\u1ecdc ti\u1ebfng Anh c\u00f3 nhi\u1ec1u l\u1ee3i \u00edch:<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>H\u1ea7u h\u1ebft c\u00e1c t\u00e0i li\u1ec7u h\u1ecdc SQL hay \u0111\u1ec1u \u0111\u01b0\u1ee3c vi\u1ebft b\u1eb1ng ti\u1ebfng Anh. C\u00f3 nhi\u1ec1u b\u00e0i \u0111\u01b0\u1ee3c d\u1ecbch sang ti\u1ebfng Vi\u1ec7t nh\u01b0ng v\u1eabn ch\u01b0a th\u1eadt s\u1ef1 \u201cchu\u1ea9n\u201d v\u00e0 d\u1ec5 hi\u1ec3u.<\/li>\r\n<li>Khi l\u00e0m vi\u1ec7c trong m\u00f4i tr\u01b0\u1eddng c\u00f4ng ty n\u01b0\u1edbc ngo\u00e0i, vi\u1ec7c ph\u1ea3i giao ti\u1ebfp, tham d\u1ef1 c\u00e1c cu\u1ed9c h\u1ecdp v\u1edbi ng\u01b0\u1eddi n\u01b0\u1edbc ngo\u00e0i l\u00e0 chuy\u1ec7n \u0111\u01b0\u01a1ng nhi\u00ean n\u00ean kh\u1ea3 n\u0103ng ti\u1ebfng Anh t\u1ed1t s\u1ebd l\u00e0 m\u1ed9t l\u1ee3i th\u1ebf khi l\u00e0m vi\u1ec7c.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p>N\u00f3i v\u1ec1 kinh nghi\u1ec7m h\u1ecdc ti\u1ebfng Anh c\u1ee7a m\u00ecnh th\u00ec anh chia s\u1ebb r\u1eb1ng anh ch\u1ee7 y\u1ebfu h\u1ecdc qua trung t\u00e2m. Anh th\u1ef1c h\u00e0nh n\u00f3i chuy\u1ec7n v\u1edbi th\u1ea7y c\u00f4 ng\u01b0\u1eddi b\u1ea3n x\u1ee9, l\u00e0m b\u00e0i t\u1eadp v\u1ec1 nh\u00e0, coi phim kh\u00f4ng ph\u1ee5 \u0111\u1ec1 tr\u00ean Youtube, c\u1ee9 nghe \u0111i nghe l\u1ea1i nhi\u1ec1u l\u1ea7n.<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Th\u1ee9 ba, c\u1ea7n\u00a0<strong>c\u00f3 t\u00ednh c\u1ea9n th\u1eadn v\u00e0 t\u1ec9 m\u1ec9<\/strong>:<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>L\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u m\u00e0 sai m\u1ed9t ly l\u00e0 \u0111i m\u1ed9t d\u1eb7m.<\/p>\r\n\r\n\r\n\r\n<p>Anh Tr\u00ed khuy\u1ebfn kh\u00edch ng\u01b0\u1eddi m\u1edbi l\u00e0m v\u1ec1 SQL n\u00ean th\u01b0\u1eddng xuy\u00ean \u0111\u1ecdc l\u1ea1i log server \u0111\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c nguy\u00ean nh\u00e2n s\u00e2u xa g\u00e2y ph\u00e1t sinh l\u1ed7i. Bi\u1ebft \u0111\u01b0\u1ee3c nguy\u00ean nh\u00e2n th\u00ec l\u1ea7n sau m\u1edbi tr\u00e1nh l\u1eb7p l\u1ea1i l\u1ed7i t\u01b0\u01a1ng t\u1ef1.<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><strong><em>Xem th\u00eam\u00a0<\/em><\/strong><a href=\"https:\/\/itviec.com\/it-jobs\/sql-developer?utm_source=blogpost&amp;utm_medium=first_post&amp;utm_campaign=linktosite\"><em><strong>vi\u1ec7c l\u00e0m SQL Developer<\/strong><\/em><\/a><strong><em>\u00a0tr\u00ean ITviec<\/em><\/strong><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-l-tr-nh-s-nghi-p-khi-theo-sql-l-g\"><span class=\"ez-toc-section\" id=\"Lo_trinh_su_nghiep_khi_theo_SQL_la_gi\"><\/span><strong>L\u1ed9 tr\u00ecnh s\u1ef1 nghi\u1ec7p khi theo SQL l\u00e0 g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>C\u00e1 nh\u00e2n anh Tr\u00ed th\u1ea5y SQL Developer n\u00f3i ri\u00eang, v\u00e0 Database Developer n\u00f3i chung, c\u00f3 th\u1ec3 ph\u00e1t tri\u1ec3n theo 2 h\u01b0\u1edbng ph\u00e1t tri\u1ec3n:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>V\u1edbi nh\u1eefng ai c\u00f3\u00a0<strong>thi\u00ean h\u01b0\u1edbng k\u1ef9 thu\u1eadt<\/strong>:<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>B\u01b0\u1edbc ti\u1ebfp theo th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ph\u1ea5n \u0111\u1ea5u \u0111\u1ec3 tr\u1edf th\u00e0nh\u00a0Data Architect \u2013 ng\u01b0\u1eddi thi\u1ebft k\u1ebf ra c\u01a1 s\u1edf d\u1eef li\u1ec7u cho doanh nghi\u1ec7p. Mu\u1ed1n l\u00e0m Data Architect th\u00ec y\u00eau c\u1ea7u b\u1eaft bu\u1ed9c l\u00e0 ph\u1ea3i n\u1eafm r\u00f5 \u0111\u01b0\u1ee3c h\u1ec7 th\u1ed1ng tr\u01b0\u1edbc \u0111\u00e3 nh\u00e9.<\/p>\r\n\r\n\r\n\r\n<p>Ngo\u00e0i ra, Data Scientist c\u0169ng l\u00e0 v\u1ecb tr\u00ed \u0111\u00e1ng c\u00e2n nh\u1eafc. Ngo\u00e0i ki\u1ebfn th\u1ee9c v\u1ec1 SQL, em c\u00f2n ph\u1ea3i bi\u1ebft v\u1ec1 x\u00e1c su\u1ea5t th\u1ed1ng k\u00ea v\u00e0 ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh kh\u00e1c, th\u01b0\u1eddng l\u00e0 Python.<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>Anh nh\u1eadn \u0111\u1ecbnh Data Scientist l\u00e0 h\u01b0\u1edbng \u0111i kh\u00e1 hay v\u00e0 ti\u1ec1m n\u0103ng, kh\u00f4ng ch\u1ec9 v\u1edbi m\u1ea3ng database m\u00e0 c\u00f2n v\u1edbi ng\u00e0nh IT n\u00f3i chung.<\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>V\u1edbi nh\u1eefng ai c\u00f3\u00a0<strong>thi\u00ean h\u01b0\u1edbng v\u1ec1 qu\u1ea3n l\u00fd<\/strong>:<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Nh\u1eefng SQL Developer ph\u00e1t tri\u1ec3n theo h\u01b0\u1edbng qu\u1ea3n l\u00fd th\u00ec c\u00f3 th\u1ec3 l\u00e0m Business Analyst ho\u1eb7c Project Manager.<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>\u0110\u1ecdc th\u00eam: <a href=\"https:\/\/itviec.com\/blog\/business-analyst\/\" target=\"_blank\" rel=\"noreferrer noopener\">C\u00f4ng vi\u1ec7c c\u1ee7a Business Analyst l\u00e0 g\u00ec? K\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ec3 tr\u1edf th\u00e0nh Business Analyst?<\/a><\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-t-i-li-u-h-c-sql-tham-kh-o\"><span class=\"ez-toc-section\" id=\"Tai_lieu_hoc_SQL_tham_khao\"><\/span><strong>T\u00e0i li\u1ec7u h\u1ecdc SQL tham kh\u1ea3o<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n\r\n\r\n\r\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm \u0111\u1ecdc s\u00e1ch v\u1ec1 SQL l\u00e0 g\u00ec th\u00ec anh Tr\u00ed g\u1ee3i \u00fd nh\u1eefng t\u00e0i li\u1ec7u h\u1ecdc SQL sau \u0111\u00e2y s\u1ebd ph\u00f9 h\u1ee3p v\u1edbi ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><a href=\"https:\/\/www.amazon.com\/SQL-Dummies-Allen-G-Taylor\/dp\/1118607961\">SQL For Dummies<\/a>: H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng SQL \u0111\u1ec3 x\u00e2y d\u1ef1ng h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u, thi\u1ebft k\u1ebf database, truy xu\u1ea5t th\u00f4ng tin khi c\u1ea7n\u2026<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>C\u00f2n n\u1ebfu mu\u1ed1n t\u00ecm hi\u1ec3u ri\u00eang v\u1ec1 Oracle SQL (c\u1ee5 th\u1ec3 l\u00e0 PL\/SQL), anh g\u1ee3i \u00fd nh\u01b0 sau:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><a href=\"https:\/\/www.amazon.com\/Oracle-SQL-Dummies-Michael-Rosenblum\/dp\/0764599577\">Oracle PL\/SQL For Dummies<\/a>: Gi\u1ea3i \u0111\u00e1p t\u1ea5t t\u1ea7n t\u1eadt c\u00e1c c\u00e2u h\u1ecfi c\u1ee7a nh\u1eefng ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u v\u1ec1 PL\/SQL, k\u00e8m h\u01b0\u1edbng d\u1eabn th\u1ef1c h\u00e0nh c\u1ee5 th\u1ec3.<\/li>\r\n<li><a href=\"https:\/\/www.amazon.com\/Oracle-PL-SQL-Programming-Versions\/dp\/1449324452\">Oracle PL\/SQL Programming<\/a>: Ng\u01b0\u1eddi \u0111\u1ecdc s\u1ebd hi\u1ec3u h\u01a1n v\u1ec1 l\u1eadp tr\u00ecnh PL\/SQL v\u00e0 c\u00f3 nh\u1eefng ki\u1ebfn th\u1ee9c nh\u1ea5t \u0111\u1ecbnh v\u1ec1 c\u00e1ch l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u1edbi PL\/SQL th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5 minh h\u1ecda.<\/li>\r\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/index.html\">Learn About\u00a0Oracle Database<\/a>: Kh\u00f4ng th\u1ec3 b\u1ecf qua trang ch\u1ee7 c\u1ee7a Oracle v\u1edbi r\u1ea5t nhi\u1ec1u c\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan \u0111\u1ebfn SQL, PL\/SQL v\u00e0 Oracle Database.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/www.bacs.vn\/vi\/blog\/kien-thuc\/50-cau-hoi-phong-van-ve-sql-thuong-gap-8778.html\" target=\"_blank\" rel=\"noreferrer noopener\">50 c\u00e2u ph\u1ecfng v\u1ea5n SQL th\u01b0\u1eddng g\u1eb7p<\/a><\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-sql-developer-trong-ng-nh-n-i-g\"><span class=\"ez-toc-section\" id=\"SQL_Developer_trong_nganh_IT_noi_gi\"><\/span><strong>SQL Developer trong ng\u00e0nh IT n\u00f3i g\u00ec?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>Anh Minh Tr\u00ed chia s\u1ebb v\u1ec1 3 l\u01b0u \u00fd d\u00e0nh cho SQL Developer nh\u01b0ng kh\u00f4ng ai d\u1ea1y b\u1ea1n c\u1ea3:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>\u201cSQL s\u1ebd kh\u00f4ng bao gi\u1edd ch\u1ebft\u201d<\/strong><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Anh Tr\u00ed chia s\u1ebb r\u1eb1ng,<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>Anh th\u1ea5y SQL ra \u0111\u1eddi r\u1ea5t l\u00e2u \u0111\u1eddi r\u1ed3i v\u00e0 anh nh\u1eadn \u0111\u1ecbnh l\u00e0 SQL s\u1ebd kh\u00f4ng bao gi\u1edd ch\u1ebft.<\/em><\/p>\r\n<p><em>H\u1ea7u h\u1ebft c\u00e1c ng\u00e2n h\u00e0ng, c\u00f4ng ty t\u00e0i ch\u00ednh l\u1edbn \u0111\u1ec1u \u0111ang s\u1eed d\u1ee5ng SQL \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho h\u1ec7 th\u1ed1ng qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u Oracle. M\u00e0 em bi\u1ebft r\u1ed3i \u0111\u00f3, c\u00e1i g\u00ec h\u1ecd \u0111\u00e3 \u0111\u1ea7u t\u01b0 nhi\u1ec1u ti\u1ec1n th\u00ec r\u1ea5t \u00edt khi h\u1ecd mu\u1ed1n thay \u0111\u1ed5i.<\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p>Tuy nhi\u00ean, th\u1ef1c t\u1ebf th\u00ec m\u00ecnh h\u1ecdc c\u00e1i g\u00ec c\u0169ng v\u1eady, n\u00ean nh\u00ecn ra th\u1ecb tr\u01b0\u1eddng v\u00e0 ti\u00ean \u0111o\u00e1n xem ng\u00e0nh m\u00ecnh \u0111ang l\u00e0m c\u00f3 c\u00f2n ch\u1ed7 \u0111\u1ee9ng trong 5-10 n\u0103m n\u1eefa hay kh\u00f4ng, c\u00f3 c\u00f2n ph\u00e1t tri\u1ec3n \u0111\u01b0\u1ee3c n\u1eefa hay kh\u00f4ng.<\/p>\r\n\r\n\r\n\r\n<p>N\u00ean m\u00ecnh c\u00f3 th\u1ec3 linh ho\u1ea1t \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c xu th\u1ebf c\u1ee7a th\u1ecb tr\u01b0\u1eddng v\u00ec th\u1ecb tr\u01b0\u1eddng kh\u00f4ng th\u1ec3 \u0111\u1ee9ng im m\u00e3i m\u1ed9t ch\u1ed7 \u0111\u01b0\u1ee3c. N\u00ean anh c\u0169ng kh\u1eb3ng \u0111\u1ecbnh r\u1eb1ng c\u00e1c ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u00e1c r\u1ea5t c\u1ea7n thi\u1ebft cho developer.<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>\u0110\u1ecdc th\u00eam b\u00e0i vi\u1ebft: &#8220;<a href=\"https:\/\/erikbern.com\/2018\/08\/30\/i-dont-want-to-learn-your-garbage-query-language.html\" target=\"_blank\" rel=\"noopener noreferrer\">T\u00f4i kh\u00f4ng mu\u1ed1n h\u1ecdc ng\u00f4n ng\u1eef truy v\u1ea5n r\u00e1c n\u00e0o kh\u00e1c, ngo\u00e0i SQL<\/a>&#8221; &#8211; Erik Bernhardsson<\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>C\u00e2u query c\u00f3 ch\u1ea1y t\u1ed1t hay kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o d\u1eef li\u1ec7u \u1edf m\u1ed7i m\u00f4i tr\u01b0\u1eddng<\/strong><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Anh Tr\u00ed k\u1ec3 v\u1ec1 m\u1ed9t trong nh\u1eefng sai l\u1ea7m m\u00e0 anh \u0111\u00e3 t\u1eebng m\u1eafc ph\u1ea3i trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c,<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>Anh nh\u1edb tr\u01b0\u1edbc \u0111\u00e2y c\u00f3 m\u1ed9t c\u00e2u query anh vi\u1ebft ch\u01b0a th\u1ef1c s\u1ef1 t\u1ed1i \u01b0u n\u00ean anh quy\u1ebft \u0111\u1ecbnh th\u00eam Oracle hint (di\u1ec5n gi\u1ea3i d\u00f9ng \u0111\u1ec3 h\u01b0\u1edbng d\u1eabn Oracle ch\u1ea1y theo \u00fd m\u00ecnh) th\u00ec th\u1ea5y code ch\u1ea1y nhanh h\u01a1n h\u1eb3n.<\/em><\/p>\r\n<p><em>\u1ef6 y l\u00e0 code c\u1ee7a m\u00ecnh ngon r\u1ed3i, cool r\u1ed3i, anh \u0111\u01b0a l\u00ean m\u00f4i tr\u01b0\u1eddng UAT (User Acceptance Testing). \u0110\u00e2y l\u00e0 m\u00f4i tr\u01b0\u1eddng \u0111\u1ec3 m\u00ecnh test tr\u01b0\u1edbc khi demo cho kh\u00e1ch h\u00e0ng.<\/em><\/p>\r\n<p><em>L\u00fac n\u00e0y, nh\u1eefng nh\u00e2n vi\u00ean \u1edf c\u00e1c ph\u00f2ng ban kh\u00e1c c\u00f9ng truy xu\u1ea5t v\u00e0o c\u00e2u query c\u1ee7a anh \u0111\u1ec3 test th\u1eed th\u00ec b\u1ecb treo, b\u1ecb \u0111\u01a1 to\u00e0n t\u1eadp.<\/em><\/p>\r\n<p><em>Sau khi t\u00ecm hi\u1ec3u, anh ph\u00e1t hi\u1ec7n nguy\u00ean nh\u00e2n b\u1ecb l\u1ed7i n\u1eb1m \u1edf ch\u00ednh c\u00e1i hint m\u00e0 anh \u0111\u00e3 th\u00eam v\u00e0o. N\u00f3 ch\u1ec9 ch\u1ea1y t\u1ed1t trong m\u00f4i tr\u01b0\u1eddng development \u2013 n\u01a1i ch\u1ec9 c\u00f3 1 user l\u00e0 anh \u0111ang l\u00e0m vi\u1ec7c. C\u00f2n \u1edf m\u00f4i tr\u01b0\u1eddng nh\u01b0 UAT \u2013 n\u01a1i c\u00f3 nhi\u1ec1u user ho\u1ea1t \u0111\u1ed9ng c\u00f9ng l\u00fac th\u00ec n\u00f3 l\u1ea1i ch\u1ea1y r\u1ea5t ch\u1eadm.<\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p>Ch\u00ednh v\u1ec1 th\u1ebf, SQL Developer n\u00ean nh\u1edb l\u00e0 c\u00e2u query c\u00f3 ch\u1ea1y t\u1ed1t hay kh\u00f4ng c\u00f2n ph\u1ee5 thu\u1ed9c v\u00e0o d\u1eef li\u1ec7u \u1edf m\u1ed7i m\u00f4i tr\u01b0\u1eddng. Kh\u00f4ng n\u00ean d\u1ef1a ho\u00e0n to\u00e0n v\u00e0o m\u00f4i tr\u01b0\u1eddng development. D\u1eef li\u1ec7u \u1edf m\u00f4i tr\u01b0\u1eddng n\u00e0y \u00edt h\u01a1n h\u1eb3n so v\u1edbi m\u00f4i tr\u01b0\u1eddng production.<\/p>\r\n\r\n\r\n\r\n<p>Kinh nghi\u1ec7m c\u1ee7a anh l\u00e0 n\u00ean ch\u1ee7 \u0111\u1ed9ng test t\u1ea5t c\u1ea3 c\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u00f3 th\u1ec3 x\u1ea3y ra tr\u00ean nhi\u1ec1u m\u00f4i tr\u01b0\u1eddng nh\u1ea5t c\u00f3 th\u1ec3. Kh\u00f4ng n\u00ean th\u1ee5 \u0111\u1ed9ng, kh\u00f4ng ch\u1edd Tester la l\u00e0ng th\u00ec m\u1edbi b\u1eaft tay v\u00e0o s\u1eeda.<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>\u0110i l\u00e0m v\u00e0 \u0111i h\u1ecdc s\u1ebd r\u1ea5t kh\u00e1c nhau<\/strong><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>C\u00f3 m\u1ed9t s\u1ef1 th\u1eadt ai c\u0169ng bi\u1ebft nh\u01b0ng c\u0169ng c\u1ea7n ph\u1ea3i nh\u1eafc l\u1ea1i \u0111\u00f3 l\u00e0 \u0111i h\u1ecdc v\u00e0 \u0111i l\u00e0m l\u00e0 hai m\u00f4i tr\u01b0\u1eddng ho\u00e0n to\u00e0n kh\u00e1c nhau.<\/p>\r\n\r\n\r\n\r\n<p>Anh Tr\u00ed k\u1ec3 v\u1ec1 c\u00e2u chuy\u1ec7n c\u1ee7a b\u1ea3n th\u00e2n khi \u0111i \u0111\u1ebfn v\u1edbi \u201cph\u00e1t hi\u1ec7n\u201d n\u00e0y:<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p><em>Khi h\u1ecdc \u1edf tr\u01b0\u1eddng, anh ph\u1ea3i t\u1ef1 thi\u1ebft k\u1ebf ra c\u01a1 s\u1edf qu\u1ea3n l\u00fd d\u1eef li\u1ec7u ri\u00eang, ph\u1ee5c v\u1ee5 cho \u0111\u1ec1 \u00e1n ch\u1ee9 kh\u00f4ng c\u00f3 c\u01a1 s\u1edf qu\u1ea3n l\u00fd d\u1eef li\u1ec7u th\u1ef1c t\u1ebf c\u1ee7a doanh nghi\u1ec7p \u0111\u1ec3 th\u1ef1c h\u00e0nh.\u00a0<\/em><\/p>\r\n<p><em>Anh kh\u00f4ng bi\u1ebft m\u1ed9t h\u1ec7 th\u1ed1ng l\u1edbn s\u1ebd ho\u1ea1t \u0111\u1ed9ng ra sao, ch\u01b0a \u0111\u01b0\u1ee3c ti\u1ebfp x\u00fac v\u1edbi performance issue, kh\u00f4ng bi\u1ebft c\u00e2u query c\u1ee7a m\u00ecnh s\u1ebd ch\u1ea1y nhanh hay ch\u1eadm khi \u0111\u01b0a v\u00e0o m\u00f4i tr\u01b0\u1eddng c\u00f3 l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u00ean \u0111\u1ebfn h\u00e0ng tr\u0103m GB\u2026<\/em><\/p>\r\n<p><em>R\u1ed3i \u0111\u00f3, \u0111i l\u00e0m m\u1edbi nh\u1eadn ra th\u1ef1c t\u1ebf ph\u0169 ph\u00e0ng. C\u00e2u query c\u1ee7a m\u00ecnh kh\u00f4ng hi\u1ec7u qu\u1ea3, kh\u00f4ng tr\u00edch xu\u1ea5t \u0111\u01b0\u1ee3c \u0111\u00fang d\u1eef li\u1ec7u m\u00ecnh c\u1ea7n.<\/em><\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p>C\u1ea3m \u01a1n anh Tr\u00ed v\u00ec nh\u1eefng chia s\u1ebb r\u1ea5t ch\u00e2n th\u1eadt v\u00e0 h\u1eefu \u00edch!<\/p>\r\n\r\n\r\n\r\n<p><strong>Ti\u1ec3u s\u1eed:<\/strong><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400;\">Anh <strong>H\u1ed3ng Minh Tr\u00ed<\/strong> t\u1ed1t nghi\u1ec7p \u0111\u1ea1i h\u1ecdc Huflit ng\u00e0nh Software Engineering n\u0103m 2011. Anh \u0111\u00e3 t\u1eebng l\u00e0m vi\u1ec7c cho r\u1ea5t nhi\u1ec1u c\u00f4ng ty nh\u01b0 <a href=\"https:\/\/itviec.com\/companies\/fe-credit\" target=\"_blank\" rel=\"noopener noreferrer\">FE Credit<\/a>, <a href=\"https:\/\/itviec.com\/companies\/cosatech\" target=\"_blank\" rel=\"noopener noreferrer\">Cosatech<\/a>, <a href=\"https:\/\/itviec.com\/companies\/bpc-banking-technologies\" target=\"_blank\" rel=\"noopener noreferrer\">BPC Banking Technologies<\/a>, <a href=\"https:\/\/itviec.com\/companies\/amaris\" target=\"_blank\" rel=\"noopener noreferrer\">Amaris<\/a> v\u00e0 hi\u1ec7n l\u00e0 PL\/SQL Developer \u1edf <\/span><a href=\"https:\/\/itviec.com\/companies\/hansencx\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"font-weight: 400;\">Hansen Technologies<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-weight: 400;\">T\u00ednh \u0111\u1ebfn nay, anh Tr\u00ed \u0111\u00e3 c\u00f3 h\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi SQL, PL\/SQL c\u0169ng nh\u01b0 h\u1ec7 th\u1ed1ng qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u Oracle Database.<\/span><\/p>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"200\" height=\"200\" class=\"wp-image-5668 aligncenter\" src=\"\/\/itviec.com\/blog\/wp-content\/uploads\/2015\/07\/Robby2-200x200.png\" alt=\"Robby2\" srcset=\"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2015\/07\/Robby2-200x200.png 200w, https:\/\/itviec.com\/blog\/wp-content\/uploads\/2015\/07\/Robby2-60x60.png 60w, https:\/\/itviec.com\/blog\/wp-content\/uploads\/2015\/07\/Robby2.png 300w\" sizes=\"auto, (max-width: 200px) 100vw, 200px\" \/><\/figure>\r\n<\/div>\r\n\r\n\r\n\r\n<p style=\"text-align: center;\"><strong>N\u1ebfu b\u1ea1n ngh\u0129 nh\u1eefng chia s\u1ebb n\u00e0y c\u00f3 th\u1ec3 gi\u00fap \u00edch cho b\u1ea1n b\u00e8 ho\u1eb7c \u0111\u1ed3ng nghi\u1ec7p, \u0111\u1eebng qu\u00ean nh\u1ea5n n\u00fat Share b\u00ean d\u01b0\u1edbi nh\u00e9!<\/strong><\/p>\r\n\r\n\r\n\r\n<p class=\"has-text-align-center\" style=\"text-align: center;\"><strong>V\u00e0 \u0111\u1eebng qu\u00ean tham kh\u1ea3o vi\u1ec7c l\u00e0m <a href=\"https:\/\/itviec.com\/it-jobs\/sql-developer?utm_source=blogpost&amp;utm_medium=end_post&amp;utm_campaign=linktosite\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Developer<\/a> t\u1ea1i <a href=\"https:\/\/itviec.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">ITviec<\/a>!<\/strong><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>SQL l\u00e0 g\u00ec? SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb Structured Query Language, ngh\u0129a l\u00e0 ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u00f3 th\u1ec3 coi SQL l\u00e0 ng\u00f4n ng\u1eef chung m\u00e0 b\u1ea5t c\u1ee9 h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 (RDBMS) n\u00e0o c\u0169ng ph\u1ea3i \u0111\u00e1p \u1ee9ng. \u0110\u1ecdc b\u00e0i ph\u1ecfng v\u1ea5n c\u1ee7a ITviec v\u1edbi anh\u00a0H\u1ed3ng [&hellip;]<\/p>\n","protected":false},"author":87,"featured_media":17026,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_gspb_post_css":"","footnotes":""},"categories":[99,94],"tags":[10114,10135],"class_list":["post-17023","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer","category-su-nghiep-it","tag-developer","tag-sql"],"blocksy_meta":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.8 (Yoast SEO v27.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Ng\u00f4n ng\u1eef SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb g\u00ec? Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec?<\/title>\n<meta name=\"description\" content=\"SQL l\u00e0 g\u00ec? C\u00f4ng vi\u1ec7c c\u1ee7a SQL Developer l\u00e0 g\u00ec? Ba l\u01b0u \u00fd m\u00e0 m\u1ecdi SQL Developer \u0111\u1ec1u c\u1ea7n bi\u1ebft nh\u01b0ng kh\u00f4ng ai d\u1ea1y b\u1ea1n \u0111\u00e2u (tr\u1eeb b\u00e0i vi\u1ebft n\u00e0y).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/itviec.com\/blog\/sql-la-gi\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec? T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 ng\u00f4n ng\u1eef SQL \u0111\u1ec1u n\u1eb1m trong b\u00e0i vi\u1ebft n\u00e0y\" \/>\n<meta property=\"og:description\" content=\"SQL l\u00e0 g\u00ec? SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb Structured Query Language, ngh\u0129a l\u00e0 ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u00f3 th\u1ec3 coi SQL l\u00e0 ng\u00f4n ng\u1eef chung m\u00e0 b\u1ea5t c\u1ee9 h\u1ec7 th\u1ed1ng\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itviec.com\/blog\/sql-la-gi\/\" \/>\n<meta property=\"og:site_name\" content=\"ITviec Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ITviec\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-11T04:09:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T09:55:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-thumnail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"335\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Tinh To\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ITviec\" \/>\n<meta name=\"twitter:site\" content=\"@ITviec\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tinh To\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 ph\u00fat\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Ng\u00f4n ng\u1eef SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb g\u00ec? Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec?","description":"SQL l\u00e0 g\u00ec? C\u00f4ng vi\u1ec7c c\u1ee7a SQL Developer l\u00e0 g\u00ec? Ba l\u01b0u \u00fd m\u00e0 m\u1ecdi SQL Developer \u0111\u1ec1u c\u1ea7n bi\u1ebft nh\u01b0ng kh\u00f4ng ai d\u1ea1y b\u1ea1n \u0111\u00e2u (tr\u1eeb b\u00e0i vi\u1ebft n\u00e0y).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/itviec.com\/blog\/sql-la-gi\/","og_locale":"vi_VN","og_type":"article","og_title":"Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec? T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 ng\u00f4n ng\u1eef SQL \u0111\u1ec1u n\u1eb1m trong b\u00e0i vi\u1ebft n\u00e0y","og_description":"SQL l\u00e0 g\u00ec? SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb Structured Query Language, ngh\u0129a l\u00e0 ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u00f3 th\u1ec3 coi SQL l\u00e0 ng\u00f4n ng\u1eef chung m\u00e0 b\u1ea5t c\u1ee9 h\u1ec7 th\u1ed1ng","og_url":"https:\/\/itviec.com\/blog\/sql-la-gi\/","og_site_name":"ITviec Blog","article_publisher":"https:\/\/www.facebook.com\/ITviec","article_published_time":"2019-07-11T04:09:50+00:00","article_modified_time":"2024-01-29T09:55:09+00:00","og_image":[{"width":640,"height":335,"url":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-thumnail.png","type":"image\/png"}],"author":"Tinh To","twitter_card":"summary_large_image","twitter_creator":"@ITviec","twitter_site":"@ITviec","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Tinh To","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"12 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/#article","isPartOf":{"@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/"},"author":{"name":"Tinh To","@id":"https:\/\/itviec.com\/blog\/#\/schema\/person\/6580f1be8090663be6e793f5d5f14d6c"},"headline":"Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec? T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 ng\u00f4n ng\u1eef SQL \u0111\u1ec1u n\u1eb1m trong b\u00e0i vi\u1ebft n\u00e0y","datePublished":"2019-07-11T04:09:50+00:00","dateModified":"2024-01-29T09:55:09+00:00","mainEntityOfPage":{"@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/"},"wordCount":4152,"publisher":{"@id":"https:\/\/itviec.com\/blog\/#organization"},"image":{"@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-thumnail.png","keywords":["developer","SQL"],"articleSection":["Developer","S\u1ef1 nghi\u1ec7p IT"],"inLanguage":"vi"},{"@type":"WebPage","@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/","url":"https:\/\/itviec.com\/blog\/sql-la-gi\/","name":"Ng\u00f4n ng\u1eef SQL l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a t\u1eeb g\u00ec? Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec?","isPartOf":{"@id":"https:\/\/itviec.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/#primaryimage"},"image":{"@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/#primaryimage"},"thumbnailUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-thumnail.png","datePublished":"2019-07-11T04:09:50+00:00","dateModified":"2024-01-29T09:55:09+00:00","description":"SQL l\u00e0 g\u00ec? C\u00f4ng vi\u1ec7c c\u1ee7a SQL Developer l\u00e0 g\u00ec? Ba l\u01b0u \u00fd m\u00e0 m\u1ecdi SQL Developer \u0111\u1ec1u c\u1ea7n bi\u1ebft nh\u01b0ng kh\u00f4ng ai d\u1ea1y b\u1ea1n \u0111\u00e2u (tr\u1eeb b\u00e0i vi\u1ebft n\u00e0y).","breadcrumb":{"@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itviec.com\/blog\/sql-la-gi\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/#primaryimage","url":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-thumnail.png","contentUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2019\/07\/sql-thumnail.png","width":640,"height":335,"caption":"Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec? SQL l\u00e0 g\u00ec?"},{"@type":"BreadcrumbList","@id":"https:\/\/itviec.com\/blog\/sql-la-gi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"S\u1ef1 nghi\u1ec7p IT","item":"https:\/\/itviec.com\/blog\/su-nghiep-it\/"},{"@type":"ListItem","position":2,"name":"Truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 g\u00ec? T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 ng\u00f4n ng\u1eef SQL \u0111\u1ec1u n\u1eb1m trong b\u00e0i vi\u1ebft n\u00e0y"}]},{"@type":"WebSite","@id":"https:\/\/itviec.com\/blog\/#website","url":"https:\/\/itviec.com\/blog\/","name":"ITviec Blog","description":"IT Jobs &amp; People in Vietnam","publisher":{"@id":"https:\/\/itviec.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/itviec.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/itviec.com\/blog\/#organization","name":"ITviec","url":"https:\/\/itviec.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/itviec.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2018\/12\/itviec-black-square-facebook.png","contentUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2018\/12\/itviec-black-square-facebook.png","width":1800,"height":1800,"caption":"ITviec"},"image":{"@id":"https:\/\/itviec.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ITviec","https:\/\/x.com\/ITviec","https:\/\/www.linkedin.com\/company\/itviec","https:\/\/www.youtube.com\/channel\/UCYthAQ3bcGr57M_ag5gHDvQ"]},{"@type":"Person","@id":"https:\/\/itviec.com\/blog\/#\/schema\/person\/6580f1be8090663be6e793f5d5f14d6c","name":"Tinh To","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/secure.gravatar.com\/avatar\/a67154fc44dbb2d39713d4bb3a2591ba69ced8c6bb191b9af5305b02054b21ae?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a67154fc44dbb2d39713d4bb3a2591ba69ced8c6bb191b9af5305b02054b21ae?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a67154fc44dbb2d39713d4bb3a2591ba69ced8c6bb191b9af5305b02054b21ae?s=96&d=mm&r=g","caption":"Tinh To"},"description":"T\u00ecnh c\u00f3 h\u01a1n 4 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c, vi\u1ebft b\u00e0i ph\u1ecfng v\u1ea5n v\u1ec1 ki\u1ebfn th\u1ee9c chuy\u00ean m\u00f4n IT v\u1edbi c\u00e1c chuy\u00ean gia c\u00f4ng ngh\u1ec7 \u1edf \u0111a d\u1ea1ng v\u1ecb tr\u00ed nh\u01b0 Front-end Developer, Data Analyst, Data Scientist, CTO\u2026 v\u00e0 c\u00e1c ch\u1ee7 \u0111\u1ec1 ph\u00e1t tri\u1ec3n s\u1ef1 nghi\u1ec7p IT, th\u00f4ng tin th\u1ecb tr\u01b0\u1eddng ng\u00e0nh IT t\u1ea1i Vi\u1ec7t Nam. Qua s\u1ef1 t\u00ecm hi\u1ec3u, trao \u0111\u1ed5i li\u00ean t\u1ee5c v\u1edbi Nh\u00e0 tuy\u1ec3n d\u1ee5ng IT &amp; Chuy\u00ean gia IT, T\u00ecnh cung c\u1ea5p c\u00e1c g\u00f3c nh\u00ecn kh\u00e1ch quan nh\u1ea5t trong c\u00e1c b\u00e0i vi\u1ebft v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh trung th\u1ef1c nh\u1ea5t c\u1ee7a c\u00e1c n\u1ed9i dung \u0111\u01b0\u1ee3c th\u00f4ng tin \u0111\u1ebfn \u0111\u1ed9c gi\u1ea3.","url":"https:\/\/itviec.com\/blog\/author\/tinh-to\/"}]}},"_links":{"self":[{"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/posts\/17023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/users\/87"}],"replies":[{"embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/comments?post=17023"}],"version-history":[{"count":0,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/posts\/17023\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/media\/17026"}],"wp:attachment":[{"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/media?parent=17023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/categories?post=17023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/tags?post=17023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}