{"id":441,"date":"2017-06-27T09:07:02","date_gmt":"2017-06-27T13:07:02","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=441"},"modified":"2021-09-16T14:58:13","modified_gmt":"2021-09-16T18:58:13","slug":"database-administration-fundamentals-ws17sql1007-day-1","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=441","title":{"rendered":"Database Administration Fundamentals (WS17SQL1007) – Day 1"},"content":{"rendered":"

We have started a new SQL<\/a>\u00a0course.<\/p>\n

As I explained last night, each relational database management systems<\/a> (RDBMS<\/a>) vendor has some proprietary syntax and tools. Therefore some code has to be converted\u00a0when moving code from SQL Server<\/a> to\u00a0Oracle<\/a>, PostgreSQL<\/a>\u00a0or\u00a0SQLite<\/a>. Some third-parties have released\u00a0facilities like\u00a0SQLines<\/a>. If you have any questions on other systems, do not hesitate to contact me.<\/p>\n

By the way,\u00a0you can use Valentina Studio Free<\/a> to access databases<\/a>\u00a0similar to the SQL Server Management Studio<\/a> client that we use in the classroom.<\/p>\n

If you have Mac can use VirtualBox<\/a> and download the Windows 10 with IE 11 VDI<\/a>. Note you will need to install the .NET framework version 3.51<\/a> before the installation of SQL Server Express Edition<\/a> and the SQL Server Management Studio<\/a> (SSMS<\/a>) client.<\/p>\n

Download the\u00a0class notes<\/a>\u00a0for day 1.\u00a0Note that the file includes a lot of theory that you need to know if you are planning to take the certification exam.<\/p>\n

If you have any questions regarding any material covered in class or any RDBMS<\/a> issues you might face at work, do not hesitate to contact me.<\/p>\n","protected":false},"excerpt":{"rendered":"

We have started a new SQL\u00a0course. As I explained last night, each relational database management systems (RDBMS) vendor has some proprietary syntax and tools. Therefore some code has to be converted\u00a0when moving code from SQL Server to\u00a0Oracle, PostgreSQL\u00a0or\u00a0SQLite. Some third-parties have released\u00a0facilities like\u00a0SQLines. If you have any questions on other systems, do not hesitate to […]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[19,3,1,17,2],"tags":[],"class_list":["post-441","post","type-post","status-publish","format-standard","hentry","category-ws17sql1007","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/441","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=441"}],"version-history":[{"count":5,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/441\/revisions"}],"predecessor-version":[{"id":449,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/441\/revisions\/449"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}