Database Management

Introduction to SQL Programming Learn how to use the Structured Query Language (SQL) to create, manipulate, and create reports from database tables. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Single and multiple table queries will be created with simple and compound conditions using SQL operators such as: BETWEEN ​LIKE IN EXIST ALL ANY Basic and complex reports will be created based on data in a table or view. Database Administration features of SQL will be discussed. Course...

Intermediate SQL Programming SQL is a language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). SQL allows you to access many records with one single command and it eliminates the need to specify how to reach a record, e.g. with or without an index. This intermediate course will be focused on using MS SQL Server and T-SQL. Topics include: Data aggregation using aggregate functions Writing sub-queries Recursive queries Common table expressions You will...

Take your SQL skills to the next level! Managing SQL server requires working knowledge of database structure and design, importing and exporting data, permissions and security, indexing, Linked servers, SQL Server Agent jobs, Backup and Restoration, and System Tables and Functions. Building on the knowledge acquired in our Introduction to SQL course, students will learn to implement administrative techniques on SQL server. Upon completion of this course students will have a solid foundation for managing SQL databases and servers. Course Highlights: Database Structure and Design Importing...

Cloud Computing Architecture using Amazon Web Services (AWS) will give students an understanding of business and technical tools, and architecting on AWS. It will include practical hands-on experience solving real-world cloud computing problems with AWS. These tools can be useful for managing your business’ IT infrastructure, and provide an understanding of how this cloud platform can help your company meet compliance, governance, and regulatory requirements. Participants will develop technical expertise in cloud computing architecture using Amazon Web Services (AWS). AWS is a secure cloud...

Design and Build Web Applications using Python Web Frameworks Python is rapidly becoming a favorite programming language for developing responsive websites, due in large part to the excellent availability of web frameworks. Web frameworks are Python packages that provide a suite of tools built-in that allow rapid development and deployment of websites. In this course, students will gain experience with the popular Django web framework to design, develop and implement a web application. The curriculum covers front-end-coding and back-end libraries for frameworks, optimization, and security...

This course explores the Linux operating system which is very popular in industry and Internet services. This will be an interactive hands-on course. Students will have access to their own dedicated Linux system on which to learn and explore. Key topics covered include using the command line, Linux tools, configuring your environment, automation, system utilities, filesystem layout, intro shell programming. Course Highlights: Current uses of the Linux operating system Shell basics Basic tools Text processing Configuration Automation Course Learning Outcomes: Explain the history and origins...

According to the Bureau of Labor Statistics most recent figures, overall employment of mathematicians and statisticians is projected to grow 30 percent from 2018 to 2028 - much faster than the average for all occupations. Businesses will need these workers to analyze the increasing volume of digital and electronic data. With the explosion of data and analysts, it has become increasingly important for companies to hire managers capable of achieving business objectives by leveraging data best practices. This course will equip you with the knowledge and skills required to pivot your workplace...

An essential part of most .NET applications, especially line of business software, is the ability to interact with relational databases. Two principal frameworks that are available to .NET developers: ADO.NET and Entity Framework will be introduced in this course. The first is a set of classes that allow database programming at a low level, while the latter is a fully-featured Object-Relational Mapping (ORM) framework. Participants will obtain practical knowledge on data manipulation in those frameworks while reviewing T-SQL language and discussing the data binding in various .NET UI...

AWS Academy Cloud Developing is designed to help students gain technical expertise in development using cloud technologies and prepare them to take the AWS Certified Developer – Associate level AWS Certification exam. The curriculum is delivered through instructor-led classes, knowledge assessments, and hands-on labs. Students will also have access to course manuals, online knowledge assessments, a free practice certification exam, and a discount voucher for the certification exam. Course Highlights: AWS Review Academic Cloud Developing (ACD) Introduction to Developing on Amazon Web...

Data Analytics Using Python In this course, you will learn the rich set of tools, libraries, and packages that comprise the highly popular and practical Python data analysis ecosystem. This course is primarily taught via screen sharing programming videos. Topics taught range from basic Python syntax all the way to more advanced topics like supervised and unsupervised machine learning techniques. Key topics: Installing Python/Jupyter/IPython on Windows and Mac Python Basics (variables, strings, simple math, conditional logic, for loops, lists, tuples, dictionaries, etc.) Using the Pandas...

Data Science with R Data management and manipulation is an essential task for data scientists who deal with data on a day-to-day basis. In recent years, many R packages were developed to tackle a wide variety of data science challenges. The focus of this course is the tidyverse suite of packages, which contain a large variety of tools to efficiently manage complex and big data. The materials in this course are essential for developing robust and efficient R programs in the data science field. At the end of this course, students will be able to work independently to solve common data...