投稿時間:2021-08-01 15:19:52 RSSフィード2021-08-01 15:00 分まとめ(22件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	Kindleストアや楽天Koboなどで｢竹書房の日 2021｣のセールが開催中 − 3日間限定で1万冊以上が半額以下に	https://taisy0.com/2021/08/01/143663.html	amazon	2021-08-01 05:19:00
python	Pythonタグが付けられた新着投稿 - Qiita	Databricks（Spark）にてDelta Lake形式・Parquet形式でAnalyze Tableを実行した際に格納されるデータの調査結果	https://qiita.com/manabian/items/115f659b2cfdcc5fb9db	DatabricksSparkにてDeltaLake形式・Parquet形式でAnalyzeTableを実行した際に格納されるデータの調査結果概要DatabricksSparkにてDeltaLake形式・Parquet形式でAnalyzeTableを実行した際に格納されるデータの調査結果を共有します。	2021-08-01 14:23:40
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	ReactのECサイトで商品一覧ページから商品詳細ページへのリンクをうまく作りたい。	https://teratail.com/questions/352244?rss=all	ReactのECサイトで商品一覧ページから商品詳細ページへのリンクをうまく作りたい。	2021-08-01 14:48:51
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	処理関数の先頭行でたまに見る「-> None:」の意味	https://teratail.com/questions/352243?rss=all	処理関数の先頭行でたまに見る「gtNone」の意味実現したい事defnbspinitselfargargargnbspgtnbspNone自作関数の出だしの末尾で見る「gtnbsp値」の意味と役割について教えてほしいです。	2021-08-01 14:48:44
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	python:値が置き換わらない	https://teratail.com/questions/352242?rss=all	print	2021-08-01 14:37:28
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	投稿にいいねしたユーザー名を、いいね数に応じて表示内容を変える	https://teratail.com/questions/352241?rss=all	投稿にいいねしたユーザー名を、いいね数に応じて表示内容を変える前提・実現したいこと・下記記述内容の意味が知りたい・この記述内でのstrongの意味が知りたいTechpitでRubynbsponnbspRailsの教材をやっています。	2021-08-01 14:26:16
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	【Vuex】gettersで取得したデータをコンポーネント側のdataに追加したい	https://teratail.com/questions/352240?rss=all	【Vuex】gettersで取得したデータをコンポーネント側のdataに追加したいいつも大変お世話になっております。	2021-08-01 14:22:02
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	デフォルトの分数と約分後の分数の共存方法	https://teratail.com/questions/352239?rss=all	デフォルトの分数と約分後の分数の共存方法分数の計算をするプログラムを書いています。	2021-08-01 14:17:00
Linux	Ubuntuタグが付けられた新着投稿 - Qiita	WSL2のUbuntuにリモートデスクトップ接続する。（その２：xrdpインストール）	https://qiita.com/sakai00kou/items/e2523b6c195693e8f184	xrdp待ち受けポート番号の変更sudosedieportsgetcxrdpxrdpiniDock環境のインストールUbuntuをUbuntuDesktop環境で使うと、画面左にDockと呼ばれるアプリケーション起動用のバーが表示されますが、今回の環境では表示されないようなので、gnometweaktoolをインストールして、Dockを使用できるようにします。	2021-08-01 14:18:30
AWS	AWSタグが付けられた新着投稿 - Qiita	AWS Solutions Architect Professionalに100時間で合格した話	https://qiita.com/yukitsuboi/items/07c1c7c6e1acb7062e70	SAAとSAPの範囲はあまり変わらないので、SAPの勉強をしているときにこの本に戻って理解しなおすこともありました。	2021-08-01 14:54:19
AWS	AWSタグが付けられた新着投稿 - Qiita	AWS ECS Exec と Exec Checker を使ってみた	https://qiita.com/quryu/items/bbff2e00be63dbe80075	AWSCLIのバージョンが古い場合ECSExecrequirestheAWSCLIvvorlaterと表示されています。	2021-08-01 14:08:20
Docker	dockerタグが付けられた新着投稿 - Qiita	ラズパイ４を買ったのでからあげ本をやってみた その１	https://qiita.com/shun_xx/items/5790829645def1e885c3	dockerをインストール自分の場合は基本的にクリーンな環境でやりたいこともあるのですが、セットアップにあれこれ時間がかかるのはどうだろうなぁということと、インストール手順とか忘れてしまうのでコードで残せるように基本的にdockerを使って色々やっています。	2021-08-01 14:36:16
Ruby	Railsタグが付けられた新着投稿 - Qiita	ウィザード形式でデータを保存できない‥	https://qiita.com/hayatoganbaru/items/267e6122bb581abc2f5c	エラーにはならないしbindingpryしてみてもparamsにデータは入ってたのでデータを保存する段階で何か不備が起きていたのだろうとは思ってましたが、それがなかなか見つからず‥。	2021-08-01 14:36:56
技術ブログ	Developers.IO	viteでreact(or preact)+typescript(+tailwindcss)な開発環境を構築	https://dev.classmethod.jp/articles/vite-react-preact-typescript-tailwindcss/	gettingstartedvitevite	2021-08-01 05:56:21
海外TECH	DEV Community	My Favorite Free SQL Courses for Beginners	https://dev.to/javinpaul/my-favorite-free-sql-courses-for-beginners-2d3j	My Favorite Free SQL Courses for BeginnersDisclosure This post includes affiliate links I may receive compensation if you purchase products or services from the different links provided in this article Hello folks if you want to learn SQL and Database fundamentals or want to improve your SQL skills and looking for free resources like books and online courses then you have come to the right place In this article I am going to share my favorite free online courses to learn SQL from Udemy Coursera Pluralsight and other popular online learning websites If you want to become a better programmer or better developer then learning SQL is really important as its one of the key skills for any programmer or software developers This list includes free SQL course from Udemy a popular online portal to learn popular database like Oracle PostgreSQL and Microsoft SQL Server Yes I have tried hard to include free courses on different databases so that you can choose the right course for you As you already know SQL is one of the essential and timeless skills and much more important than any fancy library or framework you are thinking to learn If you ask me which two skills every programmer should have I would say SQL and UNIX these two have survived for a long time and will survive for many coming decades SQL is also exciting once you get the hang of it you would love to write queries and analyze your queries performance Even though SQL is so important and many programmers realize this I have found that many more programmers just don t spend much time improving their SQL skills They think that knowing just SELECT UPDATE and DELETE statements is enough which is not correct Even though SQL is not as vast as C or Java there are still many things to learn like indexing choosing the right index writing a correct query that performs better and there are always many database specific nuisances Things that may work in one data like Oracle it s not guaranteed to work on another database especially if you are using a database specific feature and not limited to SQL ANSI standard Anyway you don t need to worry if you have made a goal to learn SQL or improve your SQL skill you will definitely spend some time learning more about SQL and the database you are currently working on You can take help from these courses books and several tutorials I have shared in this blog to fill the gaps in your understanding Btw I also recommend everyone to join a comprehensive SQL beginner course for structured learning Best Free Online Courses to Learn SQL in These courses have been made free by their instructor for promotional and education reasons but you better check the price before joining the course Sometimes Instructors convert their free course to the paid course once they reach their promotional target and you may need to pay to access the material available for free earlier That s why I join the course when they are free and use it when I get some time to spend Once you join the course will be free for you Without any further ado here is my list of some of the best yet free courses to learn SQL and Database from scratch Introduction to Databases and SQL Querying This is an introductory course on Databases and SQL Querying There are no pre requisites for this course If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst this is the right course for you All you need is a windows machine and we will walk through it step by step right from setting up your environment to creating your first table to writing your first SQL query This course is structured in a way that you can follow along with me At the end of this course you should be comfortable writing simple queries including queries related to Dates String manipulation Aggregation etc This is an ideal course for SQL beginners with absolutely no experience in the database You will not only learn basic SQL Syntax but also learn essential concepts of databases No Prior Programming experience is required This course is probably not for you if you re looking to learn more advanced and complex queries SQL Crash Course PostgreSQL for Beginners This is another free online course to learn SQL basics but with PostgreSQL another leading relational database This free Udemy SQL course is also aimed at Beginners to Intermediate levels It covers all the bases for you to get up to speed with writing SQL before you progress on to more advanced SQL for transforming and analyzing data It will explain everything step by step and in detail to get to know SQL very well The course uses PostgreSQL which you can download for free from the PostgreSQL website Here are key things you will learn in this free SQL course Basic SQL commands Become proficient in SQL queries like SELECT CREATE and ALTER Solid understanding of SQLAfter completing this course you should understand write join queries involving multiple tables write aggregation based queries using group by and having a clause and learn how to do backups and restores You will also learn more advanced SQL query techniques for data analysis and discovery Advanced Databases and SQL QueryingThis course is an advanced T SQL Querying course The course expects students to know basic database concepts and are comfortable writing basic T SQL queries like SELECT JOINs etc Students are expected to have taken my previous course Introduction to Databases and Querying This course covers advanced concepts like Views Triggers Dynamic Queries etc The T SQL Scripts for all demos are uploaded The course is about hours and has assignments at the end of each concept If you looking for your next database job or trying to improve your existing database knowledge and apply it to your projects this is the course for you Microsoft SQL Server An Introduction This is another awesome free database course to learn about Microsoft SQL Server from Udemy This free course is hours long and will teach you MSSQL or T SQL from group up Here are the key things you will learn in this free Udemy SQL course How to download and install SQL Server Express on your computer for free How to log in and create a database How to create a table and insert data How to retrieve the data contained in your table Learn about the SELECT FROM WHERE GROUP BY HAVING and ORDER BY clauses In short a nice course to learn SQL with Microsoft SQL Server If you happen to use this database this is just the perfect course and it s free Oracle SQL A Complete Introduction In this course you will learn how to write basic SQL statements to view data insert data update existing data and delete data in a database It s perfect for beginners or first timers who have no idea about databases or SQL and want to learn these skills using Oracle database SQL in hours FreeCodeCamp This is another excellent free course to learn SQL online This course is available on FreeCodeCamp s YouTube channel In this course Mike Dane will teach you database management basics and SQL using the MySQL RDBMS The course is designed for beginners to SQL and database management systems and will introduce common database management topics Throughout the course you will learn different SQL topics including schema design basic C R U D operations aggregation nested queries joins keys and much more I really loved the triggers and ER diagrams sections they are great Here is full list of topics covered in this free SQL course ️Contents ️ Introduction️ What is a Database ️ Tables amp Keys️ SQL Basics️ MySQL Windows Installation️ MySQL Mac Installation️ Creating Tables️ Inserting Data️ Constraints ️ Update amp Delete️ Basic Queries️ Company Database Intro️ Creating Company Database️ More Basic Queries️ Functions️ Wildcards️ Union️ Joins️ Nested Queries️ On Delete️ Triggers️ ER Diagrams Intro️ Designing an ER Diagram️ Converting ER Diagrams to SchemasAnd here is the link to watch this SQL course for free Database Design and ManagementThis is another great free course from Udemy to learn Database design and modeling In this free online course you will learn relational database design with practical concepts and examples This series works with any database system Here are the key skills you will learn in this free database design course How to design a database with ERD How to maintain database productively and effectively How to use Visual Paradigm in database design How to use Visual Paradigm in database managementThis is an ideal course for developers who write SQL code and have at least a year of SQL experience and if you are thinking of becoming a DBA SQL for Data ScienceThis is another awesome course to learn SQL Fundamentals for Data Scientists This is one of the most popular SQL course on Coursera and more than K people have joined this course It s also part of Learn SQL Basics for Data Science Specialization which is offered by UCDavis University of California This course is designed for beginners and will teach you fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes The best thing about this course is that it starts with the basics and assumes you do not have any knowledge or skills in SQL You can also audit this course for Free on Coursera It will build on that foundation and gradually have you write both simple and complex queries to help you select data from tables You ll start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results That s all about some of the best free SQL courses to learn online for beginners People often have free means of low quality but these courses are excellent high quality courses We are lucky that their authors have made them available for free and big thanks to them for sharing their hard work for free for other people s benefit I hope you can achieve your goal of improving your SQL skill this year and I am sure you will thank yourself for learning SQL Other Useful Programming Resources you may like to explore Top Courses to Learn Python for Beginners Courses to Learn Microservice Development for Java Devs DevOps Courses for Experienced Programmers Courses to Learn Java for Beginners Top Free Courses to Learn Blockchain for Beginners Top Free React Courses for Web Developers Free Courses to Learn Angular for Beginners Machine Learning and Data Science Courses Free Course to Learn Big Data Hadoop and Spark Free Docker Courses for Developers My favorite free courses to learn Java Best SQL and Database Courses for Beginners Best Courses to learn MySQL Database in depthThanks for reading this article so far If you find these Database and SQL courses useful please share them with your friends and colleagues If you have any questions or feedback then please drop a note P S If you don t mind paying a small amount for learning something as valuable as Database and SQL concepts then I also suggest you take a look at these best SQL and Database courses on Hacker Noon which are not free but definitely worth your time and money	2021-08-01 05:35:56
海外TECH	DEV Community	3 general 🚀 Productivity 🚀 tools you should be using that you possibly haven't heard of ⁉	https://dev.to/inhuofficial/3-general-productivity-tools-you-should-be-using-that-you-possibly-haven-t-heard-of-1h9j	general Productivity tools you should be using that you possibly haven x t heard of pieces of software that I use that I am sure a lot of people haven t heard of but should start using If you have heard of them do you use any all of them and how do you use them Oh and this isn t a tutorial post on how to use them just what they are and how they benefit me Cold Turkey It blocks stuff But not just websites it blocks everything It will block websites applications and your computer seriously I use it to block certain sites during the day that I know will distract me boring loads of people do that I also use it to block Outlook Yes I only check my emails times a day No pinging every minutes distracting me just times where I tackle stuff that needs doing I know you are thinking this isn t possible due to X Y and Z trust me you can persuade people that email is not live chat It has not caused me any issues in the years I have done it Cold Turkey stops me going back to the ping ping ping days The best bitBut best of all I use Cold Turkey to block my computer It has a mode called Frozen Turkey that lets you lock yourself out of your computer at certain times of the day Fair warning if you get this wrong it can really cause headaches However when you get it right it can be so good for sticking to a routine For example I wanted to make sure I eat at certain times of the day So I just lock my computer for minutes each time Obviously I have to be careful that I don t schedule meetings that might run into these times as you can imagine that would be unprofessional but I have also become very good at saying no to meetings that don t fit my diary Managing work life balanceI also lock my PC at night when I need to Sometimes I get into bad habits where I am working at am due to deadlines It doesn t work as you then end up producing less the next day anyway meaning you have to work to am again and the cycle continues When this happens I set a block up for the week computer off at pm can t access it until am That way I ensure I have at least hours where I CANNOT work so I might as well sleep It is a feature to be used with caution I did once lock the computer for a day by mistake and had to spend an hour fiddling to undo the lock so I could work But bar that one slip up which you learn from it has been fine Anyway you should check it out Price £ GBP now lifetime usage not sure whether that price changes based on Country but that is about USD Worth every penny Mac and Windows They also offer micro manager which does the same except you whitelist applications for a while and everything else gets blocked so you can have focus sprints They also offer Writer which blocks everything on your computer blacks out all the screens if you have more than one and provides you with a very simple screen to write on Oh and this one blocks you for an amount of time or an amount of words I don t tend to use the micro manager as I have my block list set pretty well but the writer occasionally gets used if I want to just free write to clear my head work on an idea Yet again if I need to focus on writing something I have a different block list for Cold Turkey so I don t need the writer very often Rescue TimeThere are loads of time tracking applications this one works best for me Why Because it tracks things automatically and with a little bit of work it can provide some really interesting insights They have a free version don t bother there are better alternatives The paid version that is where the magic is The difference is subtle the free version tracks what applications you are using and when the paid version tracks the applications and which document you are working on using With a little bit of manipulation and effort you can use it to tell you exactly how long you have spent on each project each day they also have project tracking built in but it was a bit simplistic for my liking it might work for you though It also lets you categorise time with fine detail For example visiting dev to and any page is considered leisure time the way I have it set up But if I am on dev to new or the URL ends in edit I mark it as writing time productive They also added slack integration so you can update your status to show what you are working on automatically don t worry it wont tell people when you are procrastinating and looking at non work stuff It is USD for a year or USD a month save up and buy the year as it costs almost half as much that way Go check it out as well works on everything Linux Mac Windows Android iOS PowerToysYes I know it sounds like a website for industrial strength vibrators just me But despite the unfortunate name it is a great piece of kit for Windows It is a set of utilities that Windows should really just ship with You get a few features but the ones I use are Colour picker Windows Shift C A colour picker that works across everything and copies the result to the keyboard It also shows you the current colour under the cursor as you move around as hex and RGB values Power Toys Run kind of like Mac Spotlight but worse it lets you quickly access applications documents etc with Alt Space I use it occasionally but I find it too slow your mileage may vary Improved file explorer previews preview SVGs and markdown handy Fancy Zones This is why this is worth downloading I have screens and of them are massive not flexing just to show how hard it is to manage monitors I like to arrange my Windows in certain ways that you just can t do without patience on Windows such as add applications split horizontally one on top of the other on the right hand screen for monitoring applications etc Fancy zones lets you add zones to your screens where you can drag and drop a window and they will fill that zone Technically you can make a window fit into two zones or even zones that are next to each other if you set the zones up correctly My main monitor fancy zones layout Where zones intersect you can make an application fill all zonesThe joy of just pressing Shift when dragging a window and having it take up exactly a third of the screen vertically or a third horizontally etc cannot be over stated This one is free so even if you can t afford the other two right now you should definitely get this one if you have more than one screen or like to set your application layout a certain way and use Windows Get it here gt SummaryI just wanted to share applications I thought were useful you may not have heard of Let me know if you end up using any of them or already use them and how they help you in the comments Little note to people who read my stuffIf you are wondering why I would follow up on my word monster post with something so simple and low effort it is a little experiment more on that in a bit In case you missed that one and have an hour to kill Digital Accessibility tips and tricks InHuOfficial・Jul ・ min read webdev html ay beginners	2021-08-01 05:29:58
海外TECH	DEV Community	Learning Python Course- yearning for suggestions	https://dev.to/aatmaj/learning-python-course-yearning-for-suggestions-l35	Learning Python Course yearning for suggestionsHi guys we have just completed the basic module of the Learning Python Course So in case you missed it out here Put link is a short summary of the module This post is made for discussions of any comments or doubts related to this course I urge all to comment belowfor any suggestions which I can incorporate in the next module	2021-08-01 05:16:30
海外TECH	CodeProject Latest Articles	Mkdoc over Confluence for indie project documentation	https://www.codeproject.com/Articles/5308571/Mkdoc-over-Confluence-for-indie-project-documentat	local	2021-08-01 05:29:00
金融	ニュース - 保険市場TIMES	アクサダイレクト、「子育て世帯ドライバーの安全運転とリスク認知に関する意識調査」結果発表	https://www.hokende.com/news/blog/entry/2021/08/01/150000	アクサダイレクト、「子育て世帯ドライバーの安全運転とリスク認知に関する意識調査」結果発表「子どもを乗せるになった」ことが安全運転のきっかけアクサ損害保険株式会社以下、アクサダイレクトは年月日、「子育て世帯ドライバーの安全運転とリスク認知に関する意識調査」の結果を発表した。	2021-08-01 15:00:00
海外ニュース	Japan Times latest articles	‘Surreal!’ says Australia’s Emma McKeon after picking up seventh medal in Tokyo	https://www.japantimes.co.jp/sports/2021/08/01/olympics/summer-olympics/olympic-swimming/mckeon-australia-seven-medals/	Surreal says Australia s Emma McKeon after picking up seventh medal in TokyoMcKeon won four gold medals in Tokyo and she joins Michael Phelps Mark Spitz and Matt Biondi as the only swimmers with seven medals at	2021-08-01 14:16:27
ニュース	BBC News - Home	Worthington wins gold & GB swimmers make history - day nine so far	https://www.bbc.co.uk/sport/olympics/58045115	swimmers	2021-08-01 05:11:45
ニュース	BBC News - Home	Tokyo Olympics: Ben Whittaker into final as Frazer Clarke beats Mourad Aliev	https://www.bbc.co.uk/sport/olympics/58044571	tokyo	2021-08-01 05:40:33