ocdatabases's profile picture. We provide software training, tutoring and programming services in Microsoft Office and data technologies. Classes and tutoring conducted online via Zoom.

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


OC Databases 已轉發

Top performers aren't just magically more productive - They're using these 6 techniques:

georgestern's tweet image. 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.


OC Databases 已轉發

Computer shortcuts Source: Techie Programmer

QCompounding's tweet image. 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.


OC Databases 已轉發

The AI data center value chain

StockMKTNewz's tweet image. The AI data center value chain

OC Databases 已轉發

The best performing stocks in the S&P 500 over the last 5, 10, 15, and 20 years... bilello.blog/newsletter

charliebilello's tweet image. The best performing stocks in the S&P 500 over the last 5, 10, 15, and 20 years...

bilello.blog/newsletter

OC Databases 已轉發

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


OC Databases 已轉發

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,…

VivekGRamaswamy's tweet image. 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,…

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

ocdatabases's tweet card. Tips and Tricks for Using SQL Server Management Studio Effectively

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


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 趨勢

Loading...

Something went wrong.


Something went wrong.