OC Databases
@ocdatabases
We provide software training, tutoring and programming services in Microsoft Office and data technologies. Classes and tutoring conducted online via Zoom.
Just got John Sperling distinguished faculty award. @uopx. credly.com/badges/6f58181… via @credly
Top performers aren't just magically more productive - They're using these 6 techniques:
Creating an SQL Join in Python using pyodbc and Microsoft SQL Server at d2associates.blogspot.com.
Computer shortcuts Source: Techie Programmer
Orange Coast Database Associates: Parameterized ODBC book query. This query in the pyodbc series is the one discussed last week that avoids sql injection. d2associates.blogspot.com/2024/06/last-w…
Orange Coast Database Associates: This is the second in the series of using Python t... d2associates.blogspot.com/2024/05/this-i… Shows fetching and displaying records from SQL Server in Python using ODBC.
The best performing stocks in the S&P 500 over the last 5, 10, 15, and 20 years... bilello.blog/newsletter
There are 3 functions to number rows in #SQL ROW_NUMBER => Unique consecutive values RANK => Ties have same value, after ties value equals row number DENSE_RANK => Ties have same value, consecutive numbers after ties Set the sort in the OVER clause FN() OVER ( ORDER BY... )
Orange Coast Database Associates: I am starting a brief series of posts on manipulat... d2associates.blogspot.com/2024/05/i-am-s…
The following is a great free tool for automating #SQLExpress database backups. We are not being paid to post this, just passing on our recommendation. Simple and straightforward. We have been using it for some time - #SQLBackupMaster @ sqlbackupmaster.com
The last version of the climate cult mania was nominally the opposite of what it is now: existential concern about “global cooling” instead of global warming. But at its core it’s really the same thing: the agenda has little to do with climate and everything to do power,…
I was looking to include #moscowpriorites in #jira. Here is a link to a site that shows hw to do it. Very helpful! herndlbauer.com/blog/jira-mosc…
This video goes into a lot of detail on using #SSMS. Tips and Tricks for Using SQL Server Management Studio Effectively youtu.be/Jy0ndgHzoIM via @YouTube
youtube.com
YouTube
Tips and Tricks for Using SQL Server Management Studio Effectively
Finished adjusting our prices. Generally $165 for 1 day #micrsoftaccessclass, $195 for #sqlclasse and $245 for #databaseclass. 1/2 day #onlinetutor session $95.
Interesting article on #databasepopularity. Put out monthly. Apparently based on search traffic, social media, etc. #microsoftaccess is at #9. Surprised it is not higher. It is an ideal #desktopapp for small scale #businessreporting. db-engines.com/en/ranking
Here is an interesting link for #downloadingwebdata in to #excel. Just tried it with #Excel2016. Some things were a little different but it worked! lifewire.com/using-web-page…
Just dropped the price for #sql202 #sqlclass to $290 for 1 and 1/2 days. See ocdatabases.com/courses/comput… . Available online or at your facility in SoCal.
Lowered price of #MySQLintroduction class to $195. This is a good course for querying data. See below link for #MySQLcourse details...ocdatabases.com/list-courses.p…
United States 趨勢
- 1. $SWC 2,511 posts
- 2. Mateer 4,794 posts
- 3. #UFC321 76.4K posts
- 4. Ole Miss 12K posts
- 5. Almeida 56.1K posts
- 6. Arbuckle 2,575 posts
- 7. Lane Kiffin 5,604 posts
- 8. Oklahoma 16.7K posts
- 9. Umar 24.6K posts
- 10. Volkov 49.3K posts
- 11. UCLA 7,845 posts
- 12. Brentford 37.6K posts
- 13. Hugh Freeze 1,457 posts
- 14. Kerkez 14.1K posts
- 15. Arkansas 20.1K posts
- 16. Memphis 13.7K posts
- 17. Jackson Arnold 1,057 posts
- 18. Alex McPherson N/A
- 19. Taylen Green N/A
- 20. June Lockhart 1,210 posts
Something went wrong.
Something went wrong.