Long Island City, NY SQL Lessons

elerate your learning

and productivity programs. I went to The University of Wisconsin and earned a degree in Computer Science in 2017. My teaching style is patient, thorough and detail oriented. I look forward to helping you reach your goals!

Skills:
PHP
JAVA
SQL
Mysql
HTML
CSS
JAVASCRIPT
Microsoft Access
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Microsoft Windows

There is a great digital divider between the Knows and Know Nots. Crossing this digital divider requires solid understanding of digital concepts. One should not only live with these concepts, but could hardly live without. Many find a lot of IT potential opportunities but not enough knowledge to benefit from these opportunities.

I have helped people of all walks of life how to cross this digital divider. This includes professionals, business owners, college graduate students, college undergraduate students, high school students, and job applicants.

I am exceedingly-educated and I manage to close the digital gab by simplifying mathematical and computer science concepts. I do not simply repeat what has been already detailed in trillions of pages of books and lectures. Everyone’s mind is different and thus everyone has a unique perception to understanding one issue or another.

I have taught programming algorithms, pseudo programming codes, programming codes in Python and other computer languages, Databases, Microsoft Office Applications (MS Word, MS Excel, MS Publisher, MS Access, MS Outlook), and other IT areas for different levels: beginning, intermediate, and advanced.

I am a programmer analyst. I have an IT sole proprietary business that deals with the design of computer software including programming analysis, databases, and data analysis. My sole proprietary business applies mathematical modeling that relates to computer software. This includes One-Dimensional Databases; Multi-Dimensional Databases; Data Science; Data Structuring; Data Management; Data Compression; Data Arranging; Data Search; Extracting Data; Big Data; Spatial Data, Data Integrity; Data Anomaly; Utilizing SQL in Data Science; Data Correction; Applications of the Theory of Probability to Data; Application of Monty Hall Paradox to Raw Data; Data Storage; Data Control; Blocking Bad Data; Importing & Exporting Data; Creating Live Data; Complex Data Problems; Mutually Inclusive & Mutually Exclusive Data; Data Wrangling; Data Pattern Identification; Descriptive & Predictive Data; Data Security; Data Visualization; Structured & Unstructured & Semi-Structured Data; Data-Driven Products & Services; Data Theory & Application; Machine Learning in Data.

My sole proprietary business also covers software programming in computer languages that span from earlier languages such as BASIC, FORTRAN PASCAL, DBASE, COBOL to languages that continued and expanded such as C. And newer languages such as PYTHON with its extended libraries that managed to combine other tools and programming languages and became in its 3.x version an object-oriented language that runs linearly. Computer languages that include Weakly-Typed language, Strongly-Typed Language, High-Level Language, Low-Level Language, Interpreted Language, Compiled Language, General-Use Language, and Target-Use Language. My sole proprietary covers software design that combine code quality with efficient use of mathematics, logic, syntax, time, memory, and processing power. I have designed algorithms in various fields including Business; E-Commerce; Office Management; Real Estate; Legal; Demography; Technology; Architecture; Structural Engineering; Solid Mechanics; Analysis of Internal Forces (Normal; Shear; Bending Moment); Beams (Simple; Extended; Cantilevered); Frames; Trusses; Statically-Determinate & Statically- Indeterminate Structures; Virtual work; Deflection; Properties of Materials; Reinforced Concrete; Traffic & Transportation Engineering; Fluid Mechanics; Irrigation Engineering; Geotechnical Engineering; Computer-Aided Design & Manufacturing; Matrices & Determinants; Thermodynamics.

My computer skills include the following:

Operating Systems & Microsoft Applications & Corel Applications including: Android; Linux; Microsoft Disk Operating System; Microsoft Windows (MS Windows 10, MS Windows 8.1, MS Windows 8, MS Windows 7, MS Windows Vista, MS Windows ME, MS Windows XP, MS Windows Mobile); Bash Shell Command-Line Tools; DDL; CPU Testing; Maximizing CPU Performance; Files Integrity; Stochastic Optimization; Microsoft Office; Microsoft Utilities; Excel; Access; Word; Publisher; Powerpoint; OneNote; Outlook; Dashboards; Microsoft Works; Works Spreadsheets; Works Database; Works Word; Corel Office; Word Perfect; Corel Spreadsheets; Corel Presentation; Windows File Explorer; Disk Partition; Disk Formatting (NTFS, exFAT, FAT32); Disk Defragmenting; Digital Cleanup; System Restore; System Information; Registry; Macros; Merging Documents; Master Documents; Templates; VBA Programming; Pivot Tables; Error Trapping; Logical Functions; Financial Formulas; Mathematical Functions; Statistical Functions; Navigation Systems; Crosstab Queries; Advanced Reports; Smart Tables; Record Sheets; Web-Based Presentations; Web-Based Applications; Interactions Between Different Applications; Smart Art Diagrams; Virtual Memory; Data Macros in Web Applications; Python Tools For Visual Studio; Multi-Booting; Virtualization Software; Utilizing Python in MS Window Automation; Utilizing Python in Power Point Data Visualization; Python Scripting in Excel.

Graphic Design & Multimedia including: Layering; Projection (Isometric, Oblique, Prospective); In-Depth Framings; Analytical Databases that query some 16,777,216 colors that are defined by Hex Triplet, RGB, Hue, Saturation, Tint, Shade, Depth; Color Calibration; Patterns; Sizing; Cropping; Utilizing Permutations & Combinations in Colors Integrations; Typography Effects (Shadow, Reflection, Glow, Bevel, 3-D Rotation); Design & Layout; Print and Digital Publishing; Illustration; Digital Processing & Editing; BMP; BNG; FPX; GIF; JPEG; PCX; RGB; TIFF; Compressed TIFF; File TIFF; EPS; Pixel-Based Imaging; Vector-Based Imaging; Integrating Graphics with Trigonometry and Geometry (Plane, Solid, Analytical, Descriptive, Fractal, Differential); Applications of Chaos Theory to Graphics; Incorporating Graphics with Computer-Aided Design (AutoCad, ViaCad, Turbo Cad); Graphic Calibration; Soft Proofing; Enhancing Pixel Quality; Motion Graphics & Animations; Virtual Reality; Augmented Reality; Polygon Graphics (Simple, Complex, Concave, Convex, Regular, Irregular, N-Gon); Polyhedra & Non-Polyhedra Graphics; Applications of the Theory of Numbers to Graphic Design; Clip Art; Smart Art; Image Compressing; Resolution Reduction; Hierarchy Graphic Structure; Raster Graphics; Graphic Representations of Irrational Numbers; Edge Detection; Audio and Video Software; Window Media Player; Real Player; UM Player; VLC Media Player; QuickTime; Roxio; Nero; Corel; Paint; Panorama Maker; Wavepad; Mort Player; EXPStudio; Dragon; MP3; WAV; GSM; 3GP; M4A; WMV; AVI; FLV; MPEG-1; MPEG-2; MIDI; MOV; WEBM; MKV; Audio Fading; Audio Delaying.

PDF software and Adobe Applications: PDFILL; PDFREDIRECT; Adobe; Turbo PDF; Power PDF; Handling PDF files (Merging, Splitting, Reordering, Rotating, Reformatting, Text Watermarks, Picture Watermarks, Converting PDF to Images, Converting Images to PDF, Bookmarks, Hypertexts); InDesign; Illustrator; Adobe Acrobat DC; Premiere Elements; Premiere Pro; Acrobat; Stock; Lightroom; Muse; Acrobat Pro; After Effects; Project Felix; Dreamweaver; Animate; Audition; Bridge; Media Encoder; Flash Builder; InCopy; Prelude; Spark; Scout; StoryPlus; PhoneGap Build; Creative Cloud; Gaming SDK; Extension Manager; ExtendScript Toolkit; Photoshop; Creative Suite; Digital Editions.

Mapping & Navigation & GPS software including: Programming Longitudes & Latitudes; Spherical Trigonometry; Topography; Delmorme; Navaman; Pharos; Google Earth; Street & Trips; Google-Based Navigation; Map Matching; Green Wave Algorithms.

File Compressing & Backup & Digital security including: Winzip; Cloud Backup; Cloud Architecture Patterns; Carbonite; Google Drive; Drop Box; Firewalls; Anti malicious software (Viruses, Warms, Trojans, Rootkits, Spyware); Digital Security Against Phishing & Spamming & Hacking; Mcfee; Norton; ZoneAlarm; AVG; MS Defender; Kasparsky; VPN; SSL; SSH; Port Forwarding; Dynamic Port Forwarding.

Solid knowledge of computer hardware including: Computers; Monitors; Microprocessors; Motherboards; Wifi Cards; RAM; SDRAM; DDR SDRAM; ROM; CD/DVD/Disk Drives; Hard Drives; Flash Drives; Memory Cards (Secure Digital, Micro Secure Digital, Compact Flash, SmartMedia); Scanners; Faxes; Copiers; Printers (Inkjet; Laser, Multi-Purpose, Cloud-Based; 3-D); Printer’s Cartridges & Toners; Printing Media; Keyboard (Wired & Wireless); Mice (Wired & Wireless) & Touchpads; Projectors; Wired and Bluetooth Head Phones & Headsets; Digital Cameras; PC Cameras; Smart Phones; Modems; Routers; Lightscribe; Specifications Comparison; BIOS; Wireless LAN; IEEE 1394 Devices; Graphics Cards.
Integrating E-Commerce with Social Media & Online Communications & Internet Browsers & Search Engines. Business Planning; Business Venturing; Business Modeling; Market Research; Worldwide Market Analysis; U.S. Market Analysis; Variance Analysis; B2B; SIC-Based Databases.

Very strong communication skills including solid oral and written communications and technical writings in both English and Arabic.

My mathematical skills include the following:

Algebra; Geometry; Trigonometry; Analysis (Calculus); Statistics; Permutations & Combinations; Theory of Probabilities; Engineering (Civil, Structural, Geotechnical, Surveying, Traffic, Transportation); Architecture; Solid mechanics; Fluid Mechanics; Soil Mechanics; Hydraulics; Theory Of Structures; Trusses, Frames, and Beams (Simple, Extended, Cantilevered); Properties of Materials; Thermodynamics; Concepts of Forces, Work, Momentum, Energy, and Work; Numbers Theory (Natural, Real, Imaginary, Rational, Irrational, Special, Large, Whole, Fraction, Simple, Complex, One-Dimensional, Multi-Dimensional (Matrices & Determinates)); Modulus; Decimal/ Hexadecimal/ Binary/ Octal Systems; Modulus Functions; Equations; Sequences (Finite, Infinite, Fibonacci, Arithmetic, Geometric, Harmonic, Cauchy, Power, and Triangular); Algorithms; Plane Geometry; Solid Geometry; Analytical Geometry; Descriptive Geometry; Fractal Geometry, Differential Geometry; Projection; Differential Equations; Databased Unit Conversions; Discrete Mathematics including Computer Science; Algorithms including: Constant Algorithms; Logarithmic Algorithms; Linear Algorithms; Quadratic Algorithms; Exponential Algorithms, Searching Algorithms (Linear/Brute Force; Bi-Sectional; etc.); Sorting Algorithms (Comparison Sorts; Non-Comparison Sorts; Slow Sorts; Comparison Sorts (Quick Sort; Merge Sort; Heap Sort; Insertion Sort; Intro Sort; Selection Sort; Tim Sort; Cube Sort; Shell Sort; Bubble Sort; Binary Tree Sort; Cycle Sort; Library Sort; Patience Sort; Smooth Sort; Strand Sort; Tournament Sort; Cocktail Sort; Comb Sort; Gnome Sort; Block Sort; Odd-Even Sort); Non-Comparison Sorts (Pigeonhole Sort; Bucket Sort; Bucket Sort; Counting Sort; LSD Radix Sort; MSD Radix Sort; MSD Radix Sort (in-place); Spread Sort; Burst Sort; Flash Sort; Postman Sort; Slow Sorts (Bead Sort; Simple Pancake Sort; Spaghetti (Poll) Sort; Sorting Network; Bitonic Sort; Bogo Sort; Stooge Sort).