Knowledge in Databases

SQL for Dummies

SQL for Dummies

PHP6 and MySQL Bible

PHP6 and MySQL Bible by Steve Suehring

How to Use Microsoft Excel

How to Use Microsoft Excel  An Overview of Microsoft Excel L E A R N I N G O B JE C T I V E S 1. Examine the value of using Excel to make decisions. 2. Learn how to start Excel. 3. Become familiar with the Excel workbook. 4. Understand how to navigate worksheets. 5. Examine the Excel Ribbon. 6. Become familiar with the Quick Access Toolbar. 7. Examine the right-click menu options. 8. Become familiar with the commands in the File tab. 9. Learn how to save workbooks. 10. Save workbooks in the Excel 97-2003 file type. 11. Examine the Status Bar. 12. Become familiar with the features in the Excel Help window

Intro to data modelling

This is a presentation on data modelling.

Data Model

Introduction to data models presentation of Centurion University of Technology and Management

SQL

SQL

Zookeeper

A brief presentation on zookeeper

Local area networks generally called LANS

Local area networks generally called LANS Types of LANS, usage,Scope

Tablo

Tablo is a small black box, kind of like an oversized Roku, that you plug your antenna into. The Tablo Dual Lite requires an external USB hard drive (which you have to supply) to store your recordings (unless you use their cloud recording feature, which will have a fee so I didn’t review it). The regular Tablo Dual has 64GB of internal storage, so no external drive is necessary. Connectors from left are antenna coax, USB, Ethernet (optional), and power. Tablo connects to your home Wi-Fi or wired network.  If you have Internet access, you probably have a home network, and if you have Wi-Fi, you definitely do.  Tablo transmits live TV and your recordings to other devices on the network such as computers, tablets, smartphones, Roku, Apple TV, Amazon Fire, Chromecast, and now, Xbox. With one Tablo, you can play live TV and your recordings back on any of these devices. Thus, you can use one Tablo to watch recordings on all of your Internet-connected TVs and devices. Which Version Should You Get and Why? The specific model I would recommend (and the one I test in this article) is the Tablo Dual Lite for $140. This is the lowest-cost Tablo model, but it requires an external USB hard drive sold separately. These are not hard to come by; you can purchase one at almost any computer/electronics store, or you might already have an old USB hard drive lying around (as I did). If you want to get up and running without an external hard drive, there is a cloud recording option, but that has a fee, so I wouldn’t use that personally. Or, you can get the regular Tablo Dual (without the “Lite”) for $170. This has 64GB of internal storage (approximately 40 hours of HD recording, according to the manufacturer). That might sound like a lot, but power users can easily exceed this, which is why I recommend the Lite version.  You can also attach a hard drive to the regular version though. Benefits The most obvious benefit is that you can make and playback recordings on any TV in your home that is attached to one of the compatible set-top boxes. It’s a whole-home recording solution! But, I was surprised to find that I also enjoyed watching TV on my computer’s browser and on my iPad.That was something I did not expect! In effect, it turned my computer screen into another TV. This could be great if you have people fighting over TVs in your home. Very cool! Another benefit is that if you have multiple TVs, you only need one antenna with Tablo, and you don’t need to buy separate antennas or run coax cable all throughout your house to get broadcast TV. Tablo does it all wirelessly with one antenna! Finally, you can put your Tablo and your antenna anywhere in your home, as long as it’s in Wi-Fi range. It doesn’t have to be next to your TV. You can put it in your attic, where it can get better reception, or in a closet, just as long as the antenna is somewhere with a good line-of-site to the stations.

Java programming

Java language" redirects here. For the natural language from the Indonesian island of Java, see Javanese language. This article is about a programming language. For the software platform, see Java (software platform). For the software package downloaded from java.com, see Java SE. Not to be confused with JavaScript. Java is a general-purpose computer-programming language that is concurrent, class-based, object-oriented,[15] and specifically designed to have as few implementation dependencies as possible. It is intended to let application developers "write once, run anywhere" (WORA),[16] meaning that compiled Java code can run on all platforms that support Java without the need for recompilation.[17] Java applications are typically compiled to bytecode that can run on any Java virtual machine (JVM) regardless of computer architecture. As of 2016, Java is one of the most popular programming languages in use,[18][19][20][21] particularly for client-server web applications, with a reported 9 million developers.[22] Java was originally developed by James Gosling at Sun Microsystems (which has since been acquired by Oracle Corporation) and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++, but it has fewer low-level facilities than either of them

Python

Python is an interpreted, high-level, general-purpose programming language. Created by Guido van Rossum and first released in 1991, Python has a design philosophy that emphasizes code readability, notably using significant whitespace. It provides constructs that enable clear programming on both small and large scales.[26] In July 2018, Van Rossum stepped down as the leader in the language community.[27][28]

Sybase ASE -Introduction to Sybase ASE(Part 1)

Sybase ASE -Introduction to Sybase ASE(Part 1) The Client-Server Architecture As every other Database platform this is also a Client Server Architecture. Client – Program that receives requests from a user and sends them to the server; also receives responses from the server and displays them for a user Server – Program that processes requests from the client and returns results to the client ASE – History This is commonly known as Sybase DB or Sybase ASE, is a Relational Database Model product by Sybase Corporation which became part of  SAP in July 2010. ASE is a legacy software predominantly used on the Unix  platform, but is also available for Microsoft Windows. Versions so far, 1992 : SQL Server 4.2 1993: Sybase SQL Server 10.0 1995: Sybase released SQL Server 11.0 1996: Sybase with version 11.5 1998: ASE 11.9.2 1999: ASE 12.0 2001: ASE 12.5 2005: Sybase released ASE 15.0 2010: Sybase release ASE 15.5 2011: Sybase released ASE 15.7 at Techwave 2014: SAP released ASE 16. Adaptive Server It is a Sybase server that manages multiple databases Databases are divided as follows.Required Databases Master Model Sybsystemprocs Sybsystemdb tempdb Utility databases sybsecurity dbccdb sybsyntax pubs2 Application Databases. Connection For connecting to the server, you need any of the ASE client Valid Login name and password The connection so created, is called as the session When your login name is authenticated, you are connected to your default database Default database is the database, where you are placed after a successful connection It is specific to a login The SA (System Administrator) assigns it to individual logins. Isql – Connection to server isql is a command line utility which acts as a client to Adaptive Server isql can be invoked with the following options (most commonly used) -U login name -S server name -P password -w width of display -c line terminator e.g:  $isql –Usa –Sserver1 –Ppassword If –P parameter is omitted, it prompts for the password The prompt defaults to the line number, where the commands can be typed e.g :  1>select db_name()     2>go   ———————   master   (1 row affected) go, on a line by itself executes the command (There cannot be any blank spaces in front of go) Batches in isql A batch is a set of Transact-SQL statements that are submitted as a group by the client and executed as a group by the server Example: select * from titles   select * from authors   go isql batches are terminated by the word go Database Navigation in isql A session is always in one of the server databases To display the current database, use the command: select db_name( ) go To move to a different database, use the command: use go System Procedures System procedures are built-in utilities of Sybase to view, modify information inside Sybase ASE They generally reside in sybsystemprocs(System database) They are preceded with sp_ Examples of procedures sp_help Displays all the objects in the current database sp_helpdb Displays all the databases in the current server sp_helpdb databasename Displays detailed information about a particular database Summary In a client/server relationship: The client is the program that receives requests from the user, sends them to the server, and returns the results to the user. The server receives and executes client requests. Adaptive Server is the ASE server. ASE 12.5 includes two client applications: isql, a command-line client jisql, a java-based graphical interface client System procedures can provide information on: The databases managed by the server The objects within a given database