text:
About Us
Nicolas Sarkozy Posts
- Kim Kardashian To Fly To Paris Side-By-Side With Former French President Nicolas Sarkozy
April 29, 2014... Kim Kardashian better be brushing up on her French! The reality show star -- set to marry fiance Kanye West at a chateau just outside of Paris on May 24 -- will fly to the French capital today in...
Carla Bruni Is Pregnant With Third Child
June 29, 2012... Former French First Lady Carla Bruni is expecting her third child with former French President Nicolas Sarkozy, which comes after reports that she has "fallen into depression." This will be the second child for the couple, France's Closer magazine reported, and...
Nicolas And Carla Bruni-Sarkozy Welcome Baby Girl
October 19, 2011... French President Nicolas Sarkozy and French First Lady Carla Bruni-Sarkozy are the proud new parents of a baby girl. They couple have yet to release their daughter's name. The little girl was born at 8pm at the Clinque de la...
Nicolas Sarkozy And His Preg Wife Carla Bruni Get Cozy On Vacation In France
July 11, 2011... France's First Lady may be many months preg, but if it wasn't for her growing tummy, you'd never know it -- check out those legs! French President Nicolas Sarkozy and Carla Bruni kicked off their summer vacation at the official presidential...
A President And A Supermodel On Holiday
August 01, 2009... Ahh, to be a rich celebrity without a care in the world! French prez Nicolas Sarkozy and his wife Carla Bruni-Sarkozy were snapped at Carla's mansion at Cap Negre in the South of France, and it looks like these two are...
Sarkozy's Tour de France
August 06, 2008... Nicholas Sarkozy, president of France, went out for a bike ride near supermodel wife Carla Bruni's family house in Cap Negre, Cavalaire, France. I love how he looks so relaxed and happy, riding through the town without a huge gaggle of...
Sarkozy Gettin' Cozy With Bruni!
December 26, 2007... French prez Nicolas Sarkozy went public with his new girlfriend, model Carla Bruni in Egypt over the Christmas holiday. Is EVERYTHING sexier in France? Even their public officials??
Join X17 on Twitter!
Tweets by @x17online
Latest Celebrity Tweets
Tweets from @x17online/celebs-twittertivity
Who wore her leather harness better?
Taylor Swift
Kim Kardashian
See Results
Latest News
Taylor Swift Returns To Social Media With A Sweet Birthday Message For BFF Selena Gomez
Orlando Bloom And Joe Jonas Flex Their Muscles In Tight White Tees
Report: Lamar Odom Walks Out Of Intervention In NYC
A New
Game Of Thrones
Teaser Is Already Out, And We Want More!
Kim K And Her Squad Fly To Vegas On A Private Jet After She Gets Her Chipped Tooth Fixed
Tara Reid's TV Boyfriend Says Starlet Is Back On The Booze And "Train-Wrecking"
Kim K Struts Her Stuff In Beverly Hills As Fergie Hints Taylor Swift Feud Is A "Publicity Stunt"
Caitlyn Jenner Works It In A Flirty Minidress After Discussing Her "Biggest Victories" In New H&M Campaign
Teresa Giudice Hits The Red Carpet With Her Daughters While Husband Joe Serves His Time In The Slammer
She's Got A Type! Amber Heard "Spending Time" With Billionaire Elon Musk
Prince George Serves Up His Cutest Photoshoot Yet In Honor Of Third Birthday
Report: Tom Hiddleston Wants To Marry Taylor Swift
Donald Trump Accepts GOP Nomination, Stars Flock To Twitter To Trash His Speech
Justin Bieber's Got Another Hit On His Hands With New Track "Cold Water"
- Kim Kardashian Copies Enemy Taylor Swift's Leather Harness Look!
Bobby Brown Welcomes His Seventh Child, A Baby Girl
Buy Pix
Sell Pix
Terms of Use
Your Tips
©2016 X17 Inc., All Rights Reserved
Help us to improve!
Send us your suggestions

subset: commoncrawl


text:
FIFA have confirmed that the Arena da Baixada stadium in Curitiba is still set to host 2014 World Cup fixtures as originally scheduled.
The stadium missed FIFA's initial December 31 deadline for completion and was considered to be so far behind schedule that a four-week ultimatum to accelerate construction was issued by general secretary Jerome Valcke last month.
A joint statement from the state of Parana, the city of Curitiba and local club Atletico Paranaense released last week insisted that everything had been done to ensure that the arena would be completed in time for the World Cup.
And FIFA revealed that they are satisfied with the progress made in the past few weeks, but were quick to stress that the stadium still faces a race against time to be ready for the start of the tournament.
"Curitiba confirmed as World Cup venue, based on the financial guarantees, the commitment by all stakeholders & progress made," a post on the governing body's Twitter account read.
"It's a race against a very tight timeline. Collective effort by all stakeholders involved in Curitiba must continue at highest pace."
Iran's clash with Nigeria is scheduled to be the first game to be held at the arena on June 16, with defending champions Spain travelling to Curitiba to take on Australia seven days later.
The two other games to be held at the stadium include Honduras versus Ecuador on June 20, and Algeria versus Russia on June 26.
Brazil's preparations for the World Cup have been beset by construction problems, while protests over the cost of staging the tournament and fatal accidents at the venues in Manaus, Sao Paulo and Brasilia have also marred the build-up.
|MLS Review: Wright-Phillips double inspires Red Bulls to New York derby rout
|James seeks more game time at Madrid
|Rooney: I want to be a manager
|Mignolet welcomes Karius challenge in Liverpool number one battle
|Batshuayi buoyed by winning vibes at Chelsea
|Moyes and Sunderland players diverted after plane fault
|´Loved´ Varane targets long Madrid stay
|Kostic set for Hamburg medical
|Leicester crying over Kante sale - Ranieri
|Schurrle the perfect Mkhitaryan replacement - Tuchel
|West Ham face anxious wait on Cresswell injury
|Mourinho will accept criticism from United legends
|Bertolacci desperate for fresh start after underwhelming first season at Milan
|Hoops hand Toure one-year deal
|Origi ready to fight for Liverpool spot
|Emery wants PSG stay for ´fantastic´ Matuidi
|No Barcelona offer for Vietto - Cerezo
|Burnley apologise for racist abuse from supporter
|Guardiola will not rush Kompany comeback
|Of course I´ll shake Guardiola´s hand, snaps riled Mourinho
|Watzke: No more signings for Dortmund
|Roma expect Manolas to snub Premier League move
|Adriano set to leave Barcelona for Besiktas
|Manchester United in worst possible situation - Mourinho
|Sporting would have to sell stadium to afford Van Persie - Jesus
|Jonas´ agent confirms Barcelona approach
|No problem with Mourinho, insists Guardiola ahead of derby in China
|Toronto´s hat-trick hero Giovinco: I´m back
|Drogba revels in ´special night´, dedicates hat-trick to family
|MLS Review: Hat-tricks for Drogba and Giovinco as stars shine
|Whelan backs Liverpool for top-four finish
|Pellegrini still waiting for right offer
|Ronaldo deserves to win Ballon d´Or - Vazquez
|Phelan wants Hull job
|Alaba saddened by Gotze exit
|Morgan: Vardy right to re-sign
|Maradona ´hurting´ as Higuain closes on Juventus move
|Moyes watches Sunderland win, Ibe opens account in six-goal Bournemouth thriller
|Messi cuts short holiday for Barcelona training camp
|Ranieri still confident of keeping Mahrez
|Toure to complete Celtic move on Sunday, says Rodgers
|Vietto sends Simeone a reminder amid Barcelona links
|Celtic 1 Leicester City 1 (5-6 on penalties): Mahrez magic the highlight as Ranieri´s side triumph i
|Ribery, Alaba on target in Bayern win
|Neymar hails Micale ahead of Olympic tilt
|Ronaldo wants Real Madrid renewal
|Ochoa joins Granada from Malaga
|Heidel quashes Meyer to Liverpool as ´nonsense´
|Scholes challenges Allardyce to change England mentality
|Tenerife star Crosas investigated for killing endangered shark
|De Gea: Manchester United can win title under Mourinho
|Marseille replace Batshuayi with brother Leya Iseka
|Cristiano Ronaldo: Best season of my career
|Scholes: Pogba is not worth £100million
|Gotze has not forgotten how to play football - Riedle
|Delph learning more than ever under Guardiola
|Jovetic ´not worried´ about Juventus
|Allardyce wants Euro 2016 woes to fire his England
|Giggs not in a rush to take manager´s job
|Lopetegui: If not for Spain I would be Wolves boss
|Shaw one of best left-backs in world - Herrera
|Injured Sanchez to miss Arsenal tour
|Melbourne Victory 1 Juventus 1 (Melbourne win 4-3 on pens): Thomas inspires Victory as Juve pay pena
|Janssen: Ajax and PSV were never going to pay as much as Tottenham
|Bayern to make Munich shooting tributes
|Wenger wishes luck to old foe Allardyce
|United defender Varela joins Frankfurt on loan
|Sunderland appoint Moyes as Allardyce replacement
|Javi Martinez devastated by Munich shootings
|Rooney: I´m desperate to play for Mourinho, just like under Ferguson
|Godin: Champions League the dream, but LaLiga the focus
|Klopp hails Wijnaldum´s ´football smartness´
|Klavan ready to fight for starting spot after completing ´dream´ Liverpool move
|Real Salt Lake 1 San Jose Earthquakes 1: Mulholland salvages point
|Madeira airport to be named after Cristiano Ronaldo
|Villar, Ceferin and Van Praag announce UEFA presidential bid
|Witsel has offers from England and Italy
|Tuchel will bring out Gotze´s best - Watzke
|Swansea confirm interest in Liverpool´s Allen
|Arsenal´s Coquelin: LeBron v Curry is like Messi v Ronaldo
|Rooney backs Allardyce appointment
|Bayern and Ancelotti respond to Munich attacks
|West Brom friendly cancelled over violence concerns


text:
This action might not be possible to undo. Are you sure you want to continue?
SQL - Data Types
SQL recognizes 4 general types of data. As the database designer you will be selecting which type of data that can be placed in each table column. Before we look at each type of table column we will elaborate on specific data types and how they are handled in SQL.
• • • •
Character Strings - ('Words or numbers') Numbers - (3, 3.423, -17) Booleans - (True / False) Nulls - (empty fields)
SQL - NULL Values
A null value may be the most foreign to new programmers. Stating that a value has a null value indicates that nothing exists in that table field. When the table is created you may either allow a table to have a null value or may disallow null values for each table column.
SQL Code:
CREATE TABLE weekly_payroll (employee_id VARCHAR(10) PRIMARY KEY, total_hours INT NULL, hourly_rate MONEY NOT NULL,);
SQL - Numeric Data
Dates, time stamps, integers, and money are all numeric data types. The advantage of working with numbers is that SQL has built in functions such as the AVG() or SUM() functions that will return the average or the sum of a numeric column.
rate_of_pay 27 26.66 28.40
SQL - Boolean Data
Boolean values are either yes/no (true/false) types of data. Others use a 1/0 (1 for yes 0 for no) approach. Either something is or something is not.
Boolean Values:
admin 1 1
SQL - Character Strings
Character strings are sentences, symbols, or a combination of both. Math functions can not be performed with character strings.
Character Strings:
employee_id TS_0036 TS_0078 CL_1099
• •
Dates and times should always be set to "NOT NULL" since time always exists. Character Strings are sometimes referred to as varchar(s).
SQL - Commands
SQL commands can be categorized into three distinct groups. Each type of command plays an essential role while working with your database. One analogy might be to think of each SQL Command as a possible tool in your tool shed. Certain duties require specific tools and the more tools you have in your shed, the greater the chances that you will have the exact tool you need for the appropriate job.
SQL - What is a Clause
Clauses were mentioned briefly in the SQL Queries lesson. To briefly recap, they are the commands issued during a query. SELECT, INSERT, ADD, DROP, CREATE, etc are all clauses that begin each SQL Query and execute some sort of action upon your database.
SQL - What is a Function
There are a number of functions built into SQL that can add column values for you, average column values, or even change lowercase to uppercase strings. These functions are used directly inside of your queries and are excellent tools for you to use.
SQL Code:
Count() function SELECT COUNT(*) FROM table_one;
The query above will return a numeric value representing the number of rows that have been inserted into your database. We will be covering this function as well as many others as this tutorial continues.
SQL - What is an Operator
Operators are a means by which SQL can manipulate numbers and strings or test for equality. They come in four flavors including: Arithmatic, Range, Equality, and Logical. As your skills with SQL grow, you may want the language to start performing some basic arithmatic for you or perhaps you wish to select a range of rows with a numeric column value larger than 5. This becomes possible with operators.
SQL Code:
SELECT * FROM table_one WHERE column_one > 5;
Operators are used in expressions or conditional statements. they show equality, inequality, or a combination of both. Mathematical operators are found in every computer language and may be familiar to you. SQL operators follow the same rules you may have learned in a math class or know from previous programming experience. Operators come in three flavors, mathematical, logical, or range operations. Mathematical operators add, subtract, multiply, divide, and compare equality of numbers and strings. There are two logical operators, AND / OR. Range operators include the infamous < and > symbols used to compare equality. Take note of the following tables for future reference.
SQL Arithmetic Operators:
Operator Example Result Definition + 7+7 = 14 Addition 7-7 =0 Subtraction * 7*7 = 49 Multiplication / 7/7 =1 Division % 7%7 =0 Modulus Modulus may be the only unfamiliar term on the chart. this term describes the result when one number is divided by another number resulting in a remainder. For example 4 % 3 would result with a value of 1 since 1 is left over after 4 is divided by 3.
SQL Range Operators:
Operator Example Defined Result < 7<4 7 less than 4? False > 7>4 greater than 4? True <= 7 <= 11 Is 7 less than or equal to 11? True >= 7 >= 11 Is 7 greater than or equal to 11? False
SQL Equality Operators:
Operator Example Defined Result = 5=5 Is 5 equal to 5? True <> 7 <> 2 Is 7 not equal to 2? True
SQL Logical Operators:
Operator Defined Example AND Associates two values using AND if (($x AND $y) == 5)... OR Associates two values using OR if (($x OR $y) == 5)...
SQL - Expressions
In the programming world an expression is a special statement that returns a value. SQL is no exception to this standard rule.
SQL - Expression Types
Expressions in SQL generally fall into one of four categories including: Boolean, Numeric, Character, and/or Date Expressions.
SQL Code:
SELECT column_one FROM table_name;
The simplest form of an expression appears as column_one of our table. Select is our clause telling our database what we want to do, and column_one acts as the defined expression returning each row of that particular column. Expressions after the where clause might appear more familiar to programmers.
SQL Code:
SELECT * FROM table_name WHERE column_one = 'some value';
The latter example returns rows of the specified column containing 'some value'. Using expressions like the one above gives you precise control over what results will be returned. More information on the where clause is available at SQL Where.
SQL - Boolean Expressions
A boolean expression in any programming language returns a true/false result. Returning to the previous example containing the where clause.
SQL Code:
SELECT * FROM table_name WHERE column_one = 'some value';
The logic behind this query is that each row is being tested for 'some value' to appear in our column_one. Each time a match is found (testing true), that row is selected and returned for our viewing pleasure.
SQL - Numeric Expression
A numeric expression simply returns a numeric value. There are some built in functions that we will be examining in greater detail later on. Using one of the following functions is perhaps the easiest way to demonstrate the return of a number:
• • •
AVG() -- Returns the average of a stated column. COUNT() -- Returns a count of the number of rows of a given column. SUM() -- Returns the sum of a given column.
SQL Code:
SELECT COUNT(*) FROM table_name;
Our expression above returns a numeric value representing the number of rows that have been inserted into your table thus far. Please be aware that the AVG(), COUNT(), and SUM() only return results for integer table columns. Using one of these functions with a varchar column will result in an error message.
SQL - Character Expressions
Character expressions are used to test for values of a string. Often these expressions will appear in a where clause as follows.
SQL Code:
SELECT * FROM table_name WHERE column_one LIKE '%string';
Here we have used the percent(%) symbol to signify the start of our string. SQL tests our expression against column_one and returns all the rows and columns where column_one contains our string. This might come across easier if we use a live example. Say we have created a table with employee information. In this table we have set up a column a last_name column. The query above will come in handy if we were wanting to pull all the employees with a last_name that begins with a "T". Now if we plug in our hypothetical situation into our code, we should have something like the following.
SQL Code:
SELECT * FROM employees WHERE last_name LIKE '%T';
Keep in mind that SQL is case sensitive, using a lowercase t would not yield results for a last_name that has been capitalized.
SQL - Date Expressions
Date expressions come in three flavors. These expressions are very straight forward, simply type in any of those listed below and SQL will return exactly what you have requested.
• • •
Current_Date -- Returns the current date. Current_Time -- Returns the current time. Current_Timestamp -- Returns the current timestamp.
These expressions can also be placed into your tables as column values for any given row with an insert statement. We will be looking more indepth at the insert clause, however here is a glimpse of what is to come.
SQL Code:
INSERT INTO table_name(column_one,column_two,)
This statement inserts a new row into our imaginary table with the current date value for column one and the current timestamp value for columne_two.
SQL - Create
A database is nothing more than an empty shell, like a vacant warehouse. It offers no real functionality what so ever, other than holding a name. Tables are the next tier of our tree offering a wide scope of functionality. If you follow our warehouse example, a SQL table would be the physical shelving inside our vacant warehouse. Depending on the situation, your goods may require reorganization, reshelving, or removal. SQL tables can be manipulated in this same way or in any fashion the situation calls for.
SQL - Create Database
We first need to build our warehouse, or create our database. The create clause is straight forward. Here we have a one line script using the create clause to create a database we named business. The exact number of databases a SQL program can handles is entirely up to the manufacturer, visit your sites manufacturer if you would like to have specifics.
SQL Code:
CREATE DATABASE business;
We will be using this database for the remainder of the tutorial.
SQL - Create Table
Our emtpy shell of a database will do nothing standing alone, next we create our tables to store and organize our data. We use the same create clause and follow the same syntax above. Tables, however, are fairly complex. In our script we must also include parameters for each table column as well as name each one. Naming your table columns can be as simple or complicated as desired. SQL programs are case sensitive, keep this in mind as you will be calling on our table columns by name a great deal as you enhance your SQL knowledge. Also, most programs do not support spaces in column names, you must use the underscore (_). Column types specify what type of data can be placed inside a table column ranging from numbers, paragraphs, or brief strings. For example, setting a column type to an int value means your database will ONLY accept an interger value for this column type.
Column Types:
Column Type int varchar text/blob Description Accepts integer values only Accepts any symbol, character, or number Accepts paragraph style data including line returns and page breaks Syntax tinyint, int varchar(char limit value) text, blob
Int, varchar, and text are the 3 most common types of columns. Text and int columns have 3 flavors tiny, medium, and large. Every SQL program has its unique sizes, but for this tutorial we will be using medium sized column fields for each exercise. Later on as your database exapands it becomes extremely important to not
overdue the size of your column fields. Using the correct size field will dramatically increase performance including query speeds. Now create the table.
SQL Code:
CREATE TABLE employees ( id INT(3) NOT NULL AUTO_INCREMENT, Lastname VARCHAR(50), Firstname VARCHAR(25), Title VARCHAR(10) DEFAULT 'crew' NULL );
Above is our table, the first column simply numbers each row that will be added to the table up to a maximum of 3 digits wide (999) automatically(auto_increment). Our second line is a varchar meaning it will hold numbers, digits, or symbols, which is perfect for short names of people. The last column has a specified default value of "crew" so that if we add a new crew member we can simply place a default value. We do not always have to specify a default value or state weather each column may have a NULL value, By default, most table columns will allow null values to be recorded but certain table columns will not allow a null value to be inserted. We recommend reading up on each column type available to you from your database manufacturer.
SQL - Primary Key
A primary key is a property given to a table column that distinguishes that record apart from each. For each record in the table the primary key acts like a driver's license number, only one number exists for each person. The same principle applys here. Any table can only be given one auto increment field and as such it is forced to be the primary key of the table. Therefore in our following examples we use the 'id' field as our primary key. The alter clause is used to add or drop primary keys and indexes. To change a primary key you must drop the first one, then add your desired primary as shown below. More about the alter clause later.
SQL Code:
ALTER TABLE 'employees' DROP PRIMARY KEY, ADD PRIMARY KEY ('id');
SQL - Indexes
SQL automatically creates some indexes based on column types and attributes. An index can also be given to a table column to optimize speeds. When a query is executed searching for a specific column value, SQL will start at the top of the table and search each and every record until it finds matches. This becomes a performance issue when a table holds a vast amount of records. By adding an index to columns, SQL will no longer search the entire table, it will pinpoint your index columns and search those first. The downside to indexing is that it enlarges the disk space consumed by a table on your webserver. Use indexes when you notice a drop in your query speeds.
SQL Code:
ALTER TABLE 'employees' ADD INDEX ('id'); or ALTER TABLE `employees` DROP INDEX `Lastname`;
The insert clause has one function; to insert data into a table. Insert populates each table column with a value. Rows are inserted one right after another into the coresponding column.
SQL Code:
INSERT INTO employees (Lastname,Firstname,Title) VALUES(Johnson,David,crew);
Above we have a single line example of the insert syntax. Since our 'id' column is set up to auto increment, we can omit this field from our script. Our SQL program automatically begins counting starting with one, when the auto increment attribute is added to an interger field.
id Lastname Firstname Title 1 Johnson David crew
SQL - Insert defaults and nulls
We mentioned setting up default or null values for table columns. Simply placing the word default or null, in place of a value is the solution.
SQL Code:
INSERT INTO employees (Lastname,Firstname,Title) VALUES('Hively','Jessica',DEFAULT); or INSERT INTO employees (Lastname,Firstname,Title) VALUES('Hively','Jessica',NULL);
SQL - Inserting multilpe values
Here's an example of how to insert more than one record at a time. Many web developers will use the single example above along with HTML forms to continually insert and update their SQL tables.
SQL Code:
INSERT INTO employees VALUES (DEFAULT,'Hicks','Freddy','crew'), (DEFAULT,'Harris','Joel','crew'), (DEFAULT,'Davis','Julie','manager');
We use a default value for the id field so that it will continue to auto increment for each new record. Using this method you must have some value for each table column.
SQL - Insert into multiple tables
This concept isn't widely supported by open source database programs, however they do offer alternative methods to achieve the same goal. The idea is to insert similar record values into 2 or more tables with one statement. Using the example from above, we want to place Julie's information into our manager table as well as the general employee table.
SQL Code:
INSERT ALL INTO employees (Lastname,Firstname,Title) VALUES('Davis','Julie','manager') INTO manager (training,salary) VALUES ('yadayada','22500');
SQL - Select
In SQL, queries begin with the select clause. A typical query statement needs only two parts, we select what from where. The what will represent columns of your table you wish to select and the where represents the table name of your data table. To avoid typing a list of every single column in your table, you can use the astric (*) to select all table columns from a table. However, query speeds are very important and always selecting every table column can dramatically decrease your SQL performance. As good practice, it is best to only select the table columns that you wish to use or display.
SQL Code:
SELECT * FROM employees;
SQL Table:
ID 1 2 9 10 11 Lastname Johnson Hively Hicks Harris Davis Firstname David Jessica Freddy Joel Julie Title crew crew crew crew manager
Our result should print every table column and every bit of data stored in each row thus far.
SQL Code:
SELECT Lastname,Firstname FROM employees;
SQL Table:
Lastname Firstname
Johnson Hively Hicks Harris Davis
David Jessica Freddy Joel Julie
SQL - Select Multiple Tables
Multiple columns from different tables can also be selected. The syntax is relatively the same, the difference being when you choose that table column you wish to select, you must now name the table of the desired table column. The period is necessary to differentiate between the table name and the column name, other than that all the same query rules apply.
SQL Code:
SELECT employees.Fisrtname, employees.Lastname, crew.experience FROM employees, crew;
SQL - Select Functions
We havn't mentioned anything about SQL Functions yet and we will eventually cover them in greater detail, for the moment we would like to introduce this concept of using a selection query with a function. For instance we can query our database program for the current_timestamp or retrieve the number of rows in our table using the COUNT() function.
SQL Code:
This will return a server timestamp representing the date and time of when the query was executed, more on this toward the end of the tutorial.
SQL Code:
SELECT COUNT(Lastname) FROM employees;
We will dive deeper into detail as the tutorial progresses, but be aware of this concept of selecting date by means of calling a function as it will prove more useful later on.
SQL - Order By
The order by statement allows for table column assortment. It allows for ascending or descending lists of your table column values permitting SQL to reorder your table rows for the purpose of viewing.
SQL Code:
SELECT * FROM employees ORDER BY Lastname;
SQL Table:
ID 11 10 9 2 1 Lastname Davis Harris Hicks Hively Johnson Firstname Julie Joel Freddy Jessica David Title manager crew crew crew crew
The above example resorts our rows of data alphabetically by lastname. Here is another example ordering by two different columns First we alphabatize our job titles and again we order by lastname.
SQL Code:
SELECT * FROM employees ORDER BY Title,Lastname;
SQL Table:
ID 10 9 2 1 11 Lastname Harris Hicks Hively Johnson Davis Firstname Joel Freddy Jessica David Julie Title crew crew crew crew manager
Hint: It is possible to order by a column you do not wish to display such as an ID field. Also notice at the bottom of each query display will be the number of rows affected by your query. This number will also be displayed anytime an insert, select, update, or delete statement is properly executed by your SQL program. Distinct is used to retrieve rows of your database that have unique values for a given column. For example say we have a table of employees and in this table of employees we have several job titles from janitors to CEOs. We would like to know just how many distinct job titles we have.
SQL Code:
SELECT DISTINCT job_titles FROM employees;
Our statement will return the number of rows with a distinct value for our column (job_titles).
SQL - Distinct Multiple Columns
Using the distinct function with more than one column yields some substantial results. SQL will return the rows with distinct or unique combinations of those columns. Assume this same employee table has another column including the salary of each employee. With the use of the distinct function we can pull a list of unique job titles salaries.
SQL Code:
SELECT DISTINCT job_titles, salary FROM employees;
SQL has returned all the rows with unique combinations of job titles and salaries. Any duplicate combinations of job titles and salaries will be ignored. For example if we had two CEOs in the table making the same salary each year, only one row would be returned but if we had two CEOs with different salaries, both rows would be returned.
SQL - Where
The where clause sets a conditional statement for your queries. Your server will query the database searching for rows that meet your specific where condition. A typical query will have the following syntax. A conditional statement has 2 parts, the left side is your table column and the right side is the condition to be met. Example:WHERE table_column(s) = condition.
SQL Code:
SELECT * FROM employees WHERE Title = 'crew' ORDER BY Lastname;
SQL Table:
ID 10 9 2 1 Lastname Harris Hicks Hively Johnson Firstname Joel Freddy Jessica David Title crew crew crew crew
All the known typical operators can be used in the conditional statements, for a complete list backtrack to SQL
SQL - Where multiple conditionals
SQL also supports multiple conditional statements within one script by using the AND or OR operators. Continuing the example from above we can select only those employees that worked 36 or more hours for the week, perhaps meaning they are full time employees.
SQL Code:
SELECT employees.Lastname, employees.Firstname, employees.Title, payroll.Hours FROM employees,payroll WHERE employees.Lastname = payroll.Lastname AND payroll.Hours => '36' ORDER BY employees.Lastname;
As you can see, the where clause is a very powerful tool used to quickly pull rows from one table or many.
SQL - In
In is a special kind of operator for use in your where clauses. Recall that in a where expression only one value is allowed to be sent through the query. With the in operator one can send multiple values in the where clause.
SQL Code:
SELECT * FROM table_name WHERE some_column IN('value1','value2','value3');
The rows returned will have one of the values listed (value1, value2, or value3) in brackets as the value for the specified column (column_one).
SQL - In Subqueries
To better understand the power of this function, let's use an example involving a subquery. Say we have a database with the following tables. employees logbook user_id last first user_id timestamp 0045 Davis Julie 0045 000000002345 0067 Smith John 0045 000000045666 0098 Hodgensen Bruce 0098 000000076444 Now above we have an employees table giving us a user_id along with a first and last name of employees we have working in the office. The second table might be a log type table that keeps track of who accessed the database and at what time. This a security check. A standard operating procedure if many people will be accessing the database. What we want to know is the last name and first name of those that accessed the database. To do this we may use a subquery like in the example below.
SQL Code:
SELECT first,last FROM employees WHERE user_id IN (Select user_id FROM logbook);
The subquery highlighted in red selects all the values of user_id in the logbook and returns those to the previous in statement. The result is a complete listing of the names of the employees that have accessed the database and have been recorded inside the logbook table. The good news is that this feat was accomplished without having to know the user_ids of every employee in the office. This definatly adds some depth to your SQL knowledge thus far.
SQL - Between
Between is a special operator appearing in a where statement. It allows for the selection of a range of values between one value and another.
SQL Code:
SELECT * FROM table_name WHERE column_one BETWEEN value1 AND value2;
Be aware that the values you specify will also return results. For example if we were looking for values between 5 and 10, all rows would be retrieved where our column value is 5,6,7,8,9, or 10.
SQL - In Between (Subqueries)
This next example requires that you are familiar with the previous lesson, SQL In. You may recall that the In operator allows the where clause to return more than one single value for a column. Below are two tables. The employee table only stores personal information about employees while the logbook records when and who accessed our database. employees logbook user_id last first user_id timestamp 0045 Davis Julie 0045 000000002345 0048 Thomas David 0045 000000045666 0067 Smith John 0048 000000055767 0098 Hodgensen Bruce 0098 000000076444 Say we were thinking ahead when issuing user_ids and coordinated each user_id number with a department. For example our data security department employees will be numbered 004X, where X represents any number 0-9 (So data security employees are numbered 0040-0049). Since we konw this information it will prove useful if we want to track down database users by department.
SQL Code:
SELECT * FROM employees WHERE user_id IN (SELECT user_id FROM logbook WHERE user_id BETWEEN 0040 AND 0049);
SQL will now retrieve exactly what we need. A listing of all the data security employees (user_id 004X) that have accessed the database thus far. The alter clause changes a table by adding, removing, or modifying an existing table column. The following example adds a new column to our table.
SQL Code:
ALTER TABLE employees ADD dob varchar(10);
SQL Table:
id Lastname Firstname Title dob 1 Johnson David crew Now we will remove the same column from the table.
SQL Code:
ALTER TABLE employees DROP dob;
id Lastname Firstname Title 1 Johnson David crew
SQL - Alter Columns
Alter is used again when changing attributes of the table cloumns. For instance if we wanted to change a table column name or change a column from a varchar to an interger type.
SQL Code:
ALTER TABLE 'employees' CHANGE 'ID' 'id' TINYINT ( 3 ) NOT NULL AUTO_INCREMENT;
Above we changed 'ID' to 'id' because SQL is case sensative and this will remove a potential bug issue. After we have selected a new name, we list the new attributes to be given to the altered column. The update clause updates column values of a table. Update requires a conditional statement to select the row to be updated.
SQL Code:
UPDATE employees SET Lastname = 'Fletcher', Firstname = 'Ron' WHERE id = '11';
SQL Table:
ID Lastname Firstname Title 11 Fletcher Ron manager Here we changed record 11, our manager, to a new manager.
SQL - Updating Multiple Rows
With the use of expressions and operators, update allows for the manipulation of several rows at once.
SQL Code:
UPDATE employees SET Title = UPPER(Title);
SQL Table:
ID 1 2 9 10 11 Lastname Johnson Hively Hicks Harris Davis Firstname David Jessica Freddy Joel Julie Title CREW CREW CREW CREW MANAGER
Using the UPPER expression we changed our Title field to all capital letters. Update also supports the use of subqueries.
SQL - Delete
Entire rows can be deleted from a table using the delte clause.
SQL Code:
DELETE FROM employees WHERE id='4';
We could use the above code to delete an employee using their unique employee number that has been assigned by the auto_increment field.
SQL - Deleting Multiple Rows
Delete is not limited to one row at a time. We may use all of our known SQL operators as well as subqueries to delete any or all rows that apply to our conditional.
SQL Code:
DELETE FROM employees WHERE id <= '999';
The above example would delete every row from our table since we had previously limited our "id" field when we set up the table. Predicates, expressions, subqueries, and operators can be used to delete any rows you would like to remove from your table.
SQL - Truncate
We can clear an entire table using a truncate statement. Truncate quickly clears all rows of a table without deleting the table itself. If you are following along, we don't recommend that you run this script because you will essentially undo all of your inserts and have only empty table field to show for it, but it is a handy statement to know and use when the time is right.
SQL Code:
TRUNCATE TABLE employees;
SQL - Predicates
Predicates follow the where clause. Predicates allow the searching through database records to recover specific strings and ranges or characters. Rows will be returned if they match the predicate condition.
SQL - Like; Not Like
Like is a means of quering data in your database by keyword or keyletter means. After a where clause, use LIKE to match a character or a string. SQL retrieves all rows containing all or part of the string placed within the parameters. Generally, a percent sign (%) is used to define the start and ending or your string. Escape characters can be used for special situations.
SQL Code:
SELECT * FROM employees WHERE Lastname LIKE '%H%';
SQL Table:
ID 10 9 2 Lastname Harris Hicks Hively Firstname Joel Freddy Jessica Title crew crew crew
Our example will retrieve any and all rows with a capital letter H in the lastname field. Case sensitivity is important in this situation. On a contrary note, use the Not Like predicate to find all rows that do not match the string.
SQL Code:
SELECT * FROM employees WHERE Lastname NOT LIKE '%H%';
SQL Table:
ID Lastname Firstname Title 1 Johnson David crew 11 Davis Julie manager
SQL - Predicates Escaping Characters
Say you want to find a percent character(%) in your database, or all rows associated with one. SQL Server and Oracle, require an additional statement over MySQL. With Oracle and SQL Server, you must specify the character used to escape. Here's code example.
SQL Code:
Oracle/SQL Server
SELECT * FROM employees WHERE Lastname LIKE '%\%%' ESCAPE '\';
SELECT * FROM employees WHERE Lastname LIKE '%\%%'
MySQL has a built in default escape character the backslash (\). MySQL also supports the escape predicate allowing you to change your escape character exactly as it is done in the other programs.
SQL - Between
Between is a predicate to call a range of numeric values such as 1-20 or the like. Its syntax follows the same as above.
SQL Code:
SELECT * FROM employees WHERE id BETWEEN 1 AND 4;
SQL Table:
ID Lastname Firstname Title 1 Johnson David crew 2 Hively Jessica crew Between is essentially replacing your range operators. Always start your ranges with the lowest number first.
SQL - Limit
The limit predicate allows you to limit the number of rows selected.
SQL Code:
SELECT * FROM employees LIMIT 2;
SQL Table:
ID Lastname Firstname Title 1 Johnson David crew 2 Hively Jessica crew
SQL - Inner Join
The join clause combines columns of one table to that of another to create a single table. Join matches up a column with one table to a column in another table. A join query does not alter either table, but temporarily combines data from each table to be viewed as a single table. There are three types of join statements, inner, left, and right. We will be using our employees table from previous examples, and a new table to track sales of each employee called invoices. Our invoices table is set up with 3 fields, EmployeeID, Sale, and Price. If we were a business owner we now have a means to track what was sold, and by whom and we can bring this information together using an inner join clause. Inner Join: An inner join returns all rows that result in a match such as the example above.
SQL Code:
SELECT employees.Lastname, employees.Firstname, invoices.Sale, invoices.Price FROM employees INNER JOIN invoices ON employees.id = invoices.EmployeeID
SQL Table:
Lastname Johnson Hively Davis Davis Firstname David Jessica Julie Julie Sale HOT DOG LG SFT DRK CD SLD CD SLD Price 1.99 1.49 3.99 3.99
We haven't changed or updated any information in either of our tables but we were able to fashion together a new table using a conditional that matches one table column to another.
SQL - Left Join
A Left join returns all rows of the left of the conditional even if there is no right column to match.
SQL Code:
SELECT employees.Lastname, employees.Firstname, invoices.Sale, invoices.Price FROM employees LEFT JOIN invoices ON employees.id = invoices.EmployeeID
SQL Table:
Lastname Johnson Hively Hicks Harris Davis Davis Firstname David Jessica Freddy Joel Julie Julie Sale Price HOT DOG 1.99 LG SFT DRK 1.49
3.99 3.99
This would be a great way to track sales per person per day if the invoice table had a date field as well.
SQL - Right Join
A right join will display rows on the right side of the conditional that may or may not have a match.
SQL Code:
SELECT employees.Lastname, employees.Firstname, invoices.Sale, invoices.Price FROM employees RIGHT JOIN invoices ON employees.id = invoices.EmployeeID
SQL Table:
Lastname Davis Davis Johnson Hively
Firstname Julie Julie David Jessica
Sale CD SLD CD SLD HOT DOG HOT DOG LG SFT DRK LG SFT DRK
Price 3.99 3.99 1.99 1.99 1.49 1.49
This would happen generally if perhaps nobody recieved credit for the sale or the sale was credited to the store by default.
SQL - Union
The union clause places two serarate queries together forming one table. A union works best when using two tables with similar columns because each cloumn must have the same data type. Say we had another table called employees2 with the names and information of employees from our second store. With 2 queries, we can combine the tables into a list of all employees.
SQL Code:
SELECT * FROM employees UNION SELECT * FROM employees2;
SQL Table:
ID 1 2 9 10 11 101 102 103 104 Lastname Johnson Hively Hicks Harris Davis Yazzow Anderson Carlson Maines Firstname David Jessica Freddy Joel Julie Jim Craig Kevin Brad Title crew crew crew crew manager crew crew crew crew
The result is a complete listing every employee from store 1 and 2. The next example shows a more practical means of using a union clause. Here we will select all of our employees from both tables, and join them with our invoices table to generate a complete list of sales from both stores on a given day.
SQL Code:
SELECT employees.Lastname, employees.Firstname, invoices.Sale, invoices.Price FROM employees INNER JOIN invoices ON employees.id = invoices.EmployeeID UNION
SELECT employees2.Lastname, employees2.Firstname, invoices.Sale, invoices.Price FROM employees2 INNER JOIN invoices ON employees2.id = invoices.EmployeeID;
SQL Table:
Lastname Johnson Hively Davis Yazzow Carlson Firstname David Jessica Julie Jim Kevin Sale HOT DOG LG SFT DRK CK SLD HOT DOG LG SFT DRK Price 1.99 1.49 3.99 1.99 1.49
Here we combined a join query with the union clause to create one table.
SQL - Union All
Union all selects all rows from each table and combines them into a single table. The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table.
SQL Code:
SELECT * FROM employees UNION ALL SELECT * FROM employees2;
SQL Table:
ID 1 2 9 10 11 101 102 103 11 104 Lastname Johnson Hively Hicks Harris Davis Yazzow Anderson Carlson Davis Maines Firstname David Jessica Freddy Joel Julie Jim Craig Kevin Julie Brad Title crew crew crew crew manager crew crew crew manager crew
SQL Code:
SELECT employees.Lastname, employees.Firstname, invoices.Sale, invoices.Price FROM employees INNER JOIN invoices ON employees.id = invoices.EmployeeID UNION ALL SELECT employees2.Lastname, employees2.Firstname, invoices.Sale, invoices.Price FROM employees2 INNER JOIN invoices
ON employees2.id = invoices.EmployeeID;
SQL Table:
Lastname Johnson Hively Davis 11 Yazzow Carlson 11 11 Firstname David Jessica Julie Davis Jim Kevin Davis Davis Sale HOT DOG LG SFT DRK CK SLD Julie HOT DOG LG SFT DRK Julie Julie Price 1.99 1.49 3.99 manager 1.99 1.49 manager manager
SQL - Subqueries
MySQL offers a very limited support for subqueries, however Oracle and DB2 fully support them. Subqueries are Select queries placed within an existing SQL statement. They may exist in any of the following types of SQL statements.
• • • • • •
Select Insert Update Delete Set Do
Subqueries are great for answering very specific questions regarding your data inside your database. For instance, as the employer you may notice employee number 101 had a great day yesterday with sales. Just given this information we can use a subquery to pull the employee lastname and first name from our database.
SQL Code:
SELECT * FROM employees WHERE id = (SELECT EmployeeID FROM invoices WHERE EmployeeID='1');
SQL Table:
id Lastname Firstname Title 11 Davis Julie MANAGER Here we have pulled our employee information from the employees table by only knowing the employee number from the invoices table.
SQL - Subquery Inserts
Subqueries can be used to pull old data from your database and insert it into new tables. For instance if we opened up a third store and we wanted to place the same manager over 3 stores we could do this by pulling the manager's information using a subquery and then inserting the records. Also note that this form of insert will insert all cases where the subquery is true, therefore several rows may or may not be inserted depending upon how your table is set up.
SQL Code:
INSERT INTO employees3 (id,Lastname,Firstname,Title) (SELECT id,Lastname,Firstname,Title FROM employees WHERE Title='manager');
With complete mastery of a subqueries you can now see the power of the SQL language. The language is capable of nearly all things imaginable.
SQL - Dates
Unfortunately, every SQL platform has its own version of date functions, the few listed work in DB2, Oracle, and MySQL. Microsoft SQL Server users should skip to our SQL Datepart lesson.
SQL - Timestamp
A timestamp servers as the catch all for dates and times. Retrieving a timestamp is very simple and the result can be converted or manipulated in nearly every way imaginable.
SQL Code:
Return a Timestamp:
2004-06-22 10:33:11.840 Keep in mind that each platform of SQL (DB2, Oracle, SQL Server, etc...) may return dates and times which are formatted differently.
SQL - Date Functions
As we just mentioned, it is possible to breakdown timestamps into their individual pieces using any of the following date functions.
SQL Code:
Return a Month:
SQL Code:
Return a Day:
22 There are many more functions available, including functions to extract milliseconds, names of the months, names of each week day, etc. Each SQL platform varies in the actual naming of date functions. Here's a few c\The following is a list of other date functions available to most platforms of SQL with the exception of MS's SQL Server.
SQL Function Code:
SELECT DATE(CURRENT_TIMESTAMP); - returns a date (2004-06-22) SELECT TIME(CURRENT_TIMESTAMP); - returns the time (10:33:11.840) SELECT DAYOFWEEK(CURRENT_TIMESTAMP); - returns a numeric value (1-7) SELECT DAYOFMONTH(CURRENT_TIMESTAMP); - returns a day of month (1-31) SELECT DAYOFYEAR(CURRENT_TIMESTAMP); - returns the day of the year (1-365) SELECT MONTHNAME(CURRENT_TIMESTAMP); - returns the month name (January - December SELECT DAYNAME(CURRENT_TIMESTAMP); - returns the name of the day (Sunday - Saturday) SELECT WEEK(CURRENT_TIMESTAMP); - returns number of the week (1-53)
Timestamps are often the easiest to work with, but we certainly are not limited to using only the current_timestamp as our parameter. We can send any date, time, or timestamp to the function which then returns our result.
SQL Code:
Return a Month Name:
MONTHNAME('2004-11-27') November Date functions can also be performed on table columns similarly to numeric and mathematical functions such as SUM() or AVG().
SQL Code:
SELECT DAYOFYEAR(column_name) FROM table_name WHERE name = 'Joe';
SQL will return a numeric result from 1 - 365 representing the day of the year that Joe's record was created/inserted.
We can expand this concept one step further with the use of a subquery. Say we have a table with a column named timestamp. In this table column are timestamps of when each record was entered and we would like to know what was the numeric day of the year that a record was entered.
SQL Code:
SELECT DAYOFYEAR( (SELECT DATE(timestamp) FROM employees WHERE name = 'James Bond') );
Above you can see how it is possible to combine several date functions as well as a subquery to return very specific information about Mr. James Bond.
SQL - Inserting Date Data
Date data exists as numbers, strings, and timestamps. Built into most platforms are several date column types such as DATE or TIMESTAMP. By setting the default value to the current date or timestamp, the table column will automatically be filled with a current date/timestamp as each record is inserted. Here's the code to add a timestamp column to an existing table.
SQL Code:
ALTER TABLE `orders` ADD `order_date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL;
Now each time an order is placed in our make believe business, a timestamp of that order is also recorded. A date or timestamp table column will only allow date data types to be inserted as values so be sure to convert any strings or numbers to dates and timestamps before trying to insert them.
Each platform has some sort of special date, time, or timestamp table column which will automatically post the current_dates/times/timestamps.
SQL - Case
In SQL case works with either the select or update clauses. It provides when-then-else functionality (WHEN this_happens THEN do_this) also known as conditional statements. employee_name Ted Terry Trish admin 0 0 1
As you can see, we have a list of a few employees and then an admin column with boolean (true/false) values for their administration rights (admin). A zero means they are not an admin a 1 mean they are.
SQL Code:
SELECT employee_name CASE admin WHEN 1 THEN 'yes' ELSE 'no' END 'admin' FROM employees;
SQL Case:
employee_name Ted Terry Trish admin no no yes
In short all we really did is replace 1's and 0's with the words 'yes' and 'no'.
SQL - Case (update)
Case functions additionally allow for the updating of records within your table. For example, we could update the prices of items in our online store, but more importantly we could update very specific records because of the conditional logic allowed by case. item goldfish guppy blow fish quantity 12 24 1 price 1.00 0.50 5.00
Let's say we wanted to have a sale to clean out some of our overstock. We'll go ahead and take 25% off of all our items that we currently have 20 or more of (>20). Then we'll take 10% off the items that we have 10-20 of (between 10 and 20) and everything else we will discount only 5%.
SQL Code:
UPDATE inventory SET price = price * CASE WHEN quantity > 20 THEN 0.75 WHEN quantity BETWEEN 10 AND 20 THEN 0.90 ELSE 0.95 END;
SQL Case:
item goldfish guppy blow fish quantity 12 24 1 price .9 0.375 4.75
What is Normalization?
Normalization is the process of efficiently organizing data in a database.
There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.
The Normal Forms
The database community has developed a series of guidelines for ensuring that databases are normalized. These are referred to as normal forms and are numbered from one (the lowest form of normalization, referred to as first normal form or 1NF) through five (fifth normal form or 5NF). In practical applications, you'll often see 1NF, 2NF, and 3NF along with the occasional 4NF. Fifth normal form is very rarely seen and won't be discussed in this article. Before we begin our discussion of the normal forms, it's important to point out that they are guidelines and guidelines only. Occasionally, it becomes necessary to stray from them to meet practical business requirements. However, when variations take place, it's extremely important to evaluate any possible ramifications they could have on your system and account for possible inconsistencies. That said, let's explore the normal forms.
First Normal Form (1NF)
First normal form (1NF) sets the very basic rules for an organized database:
• •
Eliminate duplicative columns from the same table. Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key).
Second Normal Form (2NF)
Second normal form (2NF) further addresses the concept of removing duplicative data:
• • •
Meet all the requirements of the first normal form. Remove subsets of data that apply to multiple rows of a table and place them in separate tables. Create relationships between these new tables and their predecessors through the use of foreign keys.
Third Normal Form (3NF)
Third normal form (3NF) goes one large step further:
• •
Meet all the requirements of the second normal form. Remove columns that are not dependent upon the primary key.
Fourth Normal Form (4NF)
Finally, fourth normal form (4NF) has one additional requirement:
• •
Meet all the requirements of the third normal form. A relation is in 4NF if it has no multi-valued dependencies. Remember, these normalization guidelines are cumulative. For a database to be in 2NF, it must first fulfill all the criteria of a 1NF database.
This action might not be possible to undo. Are you sure you want to continue?
We've moved you to where you read on your other device.
Get the full title to continue listening from where you left off, or restart the preview.


text:
Jimmer Fredette looking forward to future with Kings, pops in to Vegas for team workout
David Zalubowski, ASSOCIATED PRESS
While former teammate Brandon Davies is trying to make an impression playing on the L.A. Clippers summer league team in Las Vegas, Jimmer Fredette arrived in town looking to learn more about his team's vision for the future.
According to the Sacramento Bee, he participated in a workout Monday in Vegas with the new Kings coaching staff and teammates Isaiah Thomas, Jason Thompson and Marcus Thornton.
"Hopefully, I'll be a big part of this organization next season," Fredette told the Sacramento Bee. "You never know what their vision is exactly, but that's why I'm here. I'm able to talk with them, meet with them and see what their vision is."
Fredette told Sacramento ABC affiliate News 10 it was a mutual decision between himself and the Kings organization that he didn't participate in summer league play this year, even though he's heading into just his third season in the NBA. Instead, the team decided it was more important to allow its rookies and younger players the time in Vegas to develop in a league setting.
The former Cougar's career is uncertain, as Fredette's name has come up lately in NBA trade rumors. Last week, a report surfaced that he could be headed to Cleveland in a trade.
"You can't worry about it, because most of those rumors don't happen and something completely different happens," Fredette told News 10, about the trade rumors. "You just worry about controlling what you can control, especially in the offseason, and that's getting better. And I feel I'm doing that this offseason."
Fredette has had a difficult time earning significant playing time in his short NBA career, averaging just 14 minutes per game last year, down from 18.6 minutes his rookie season. While he shot 41.6 percent from 3-point range in 2012-13, Fredette, the nation's leading scorer his senior year at BYU, has averaged just 7.2 points per game as a pro. He has also struggled with his defense and adjusting to ball pressure in the NBA.
Sacramento's plans for its guard situation is unclear, as the team drafted a pair of guards — Ben McLemore and Ray McCallum — in this year's NBA Draft. McLemore has led the Kings' summer league team in scoring thus far, averaging 17.0 points per game, while McCallum is tops on the team in a pair of categories, with 2.7 assists and 3.0 steals per game.
The Kings also traded away Tyreke Evans, but brought in point guard Greivis Vasquez, who started 78 games for the Hornets last season and averged 13.9 points, 9.0 assists and 4.3 rebounds per game. In addition to Fredette, the team has seven guards currently on its roster.
Fredette said he's sure the team has a game plan for its guard situation. New Sacramento coach Michael Malone said Fredette will be given the chance to earn more playing time.
"As I told him, 'Jimmer, I've never coached you before, but you're a high-character kid. You're a kid I used to watch at BYU lighting it up. So you come in here, and it's an open tryout,'" Malone told the Sacramento Bee. "Nothing is set in stone."
While the team's point guard situation, with Vasquez and incumbent starter Thomas, doesn't seem to favore Fredette, he told News 10 he's most comfortable as a point guard, but could play shooting guard if needed.
"I can play off the ball some, and that's fine with me as long as I can be out on the floor," Fredette said. "But I am definitely more natural as a point guard than I am as a two guard."
Email: email@example.com; Twitter: @brandonljudd
- Tom Holmoe says BYU 'excited' that Big 12...
- Poll: Many Brazilians think Olympic Games...
- AP source: ACC, ESPN to launch ACC Network in...
- BYU and the Big 12: A timeline of events
- NCAA: No. 1 overall seed to choose tourney...
- IOC explores legal options on banning all...
- ACC, ESPN extend deal to 2036 that includes...
- NBA moving All-Star Game out of Charlotte,...
- Tom Holmoe says BYU 'excited' that Big... 125
- Brad Rock: What BYU needs to nail down... 105
- Morning links: National college... 72
- Nine Big 12 candidates: The pros and cons 68
- Report: Tom Holmoe tells Big 12 he's... 51
- Finding a Power 5 home for all BYU... 50
- Big 12 Media Days social roundup:... 49
- Annual instate college basketball... 37


text:
Were In Trouble: January 1 2013 It All Comes Crashing Down
Posted in the Cookeville Forum
1 - 10 of 10 Comments Last updated Nov 9, 2012
#1 Nov 9, 2012
Were In Trouble: January 1, 2013 It All Comes Crashing Down
Now that the election is over, there is one thing that hasnt changed at all and that is the unwillingness of the Democrats to compromise and then blaming Republicans for the same.
January 1, 2013 is being referred to as the Fiscal Cliff. If nothing is done, the tax breaks enjoyed by all of us will end and we will see a significant decrease in our take-home pay. Additionally, there will be forced massive spending cuts in the federal government, some of which will not be beneficial such as in the Defense Department.
Just like they have done over the past two years, the Democrats and President Obama have stated that the Republicans MUST accept their proposed legislation. If they dont, and America topples off the Fiscal Cliff, it will be the fault of the Republicans for not compromising with the Democrats.
But who are the ones that are truly unwilling to compromise? Its Obama and the Democrats. They have said its their way or no way. And like old times, the media is already taking the liberal side and laying the blame on Republicans for not compromising.
#2 Nov 9, 2012
What about the martial law before the election? The UN taking over America? Riots and bank crashes? Shut the hell up. You lost. Go immediately back to rock you crawled out from and let the grownups fix what the GOP broke. Bush tax expire. New tax cuts for the middle class. GOP can plead to Grover Norquist that they didn't raise taxes, but are giving middle class taxcuts. As for sequestration, Why did the congress make the deal in the first place? GOP! Get out of the way and let the Democrats fix the problems like they did when Clinton was president.
#3 Nov 9, 2012
I am very afraid. You are scaring me. Save it for the next election. If republicans aren't in fear, they ain't breathing. Bye Bye Williard.
Since: Nov 12
Location hidden
#4 Nov 9, 2012
You should look at the facts. You'll see Repubs broke their own record in using filibustering to obstruct business in DC. Repubs don't understand the concept of an election. They lost. Therefore they do not get to control things. Obama will simply use his executive order power to get things done this term if Repubs block business.
#5 Nov 9, 2012
Well sure thing Teddy Boy he could use that NDAA and round up all them Pubs and ship um off to Gitmo.
He can do that you know just say the word and they can even send in the Drones hope they watch out for civilians don't you Teddy.
#6 Nov 9, 2012
Teddy WTH MOMAR James same poster
Teddy bonkers Edge of a Nervous Breakdown
see teddy bonkers video
#7 Nov 9, 2012
God job teddy !! Keep posting and reposting under other names shows what a lame loser you are when you cant actually get anyone to agree with you lol
#9 Nov 9, 2012
Yeah teddy
US Treasury quietly warned at the end of a statement issued last Wednesday that it expects the federal government to hit its legal debt limit before the end of this year--which means before the new Congress is seated--and that "extraordinary measures" will be needed before then to keep the government fully funded into the early part of 2013.
On Aug. 2, 2011, President Obama signed a deal he had negotiated with congressional leaders to increase the debt limit of the federal government by $2.4 trillion. But, now, after only 15 months, almost all of that additional borrowing authority has been exhausted.
Although Treasury revealed in its statement on Wednesday that it was likely to hit the debt limit by the end of the year, Treasury Secretary Geithner failed to respond to a letter that Senate Finance Ranking Member Orrin Hatch and Senate Budget Ranking Member Jeff Sessions sent to him on Oct. 15 demanding that he notify them by Nov. 1 what he believes to be the exact date Treasury will hit the debt limit and the date he expects to begin using "extraordinary measures" to avoid it.
"Treasury continues to expect the debt limit to be reached near the end of 2012," says the tenth paragraph of the "Quarterly Refunding Statement" put out by Assistant Secretary of the Treasury for Financial Markets Matthew Rutherford.
"However, Treasury has the authority to take certain extraordinary measures to give Congress more time to act to ensure we are able to meet the legal obligations of the United States of America," said the statement. "We continue to expect that these extraordinary measures would provide sufficient 'headroom' under the debt limit to allow the government to continue to meet its obligations until early in 2013."
Prior to the release of this statement, Sen. Hatch and Sen. Sessions sent Treasury Secretary Tim Geithner a letter asking him specific questions about the approaching debt limit and the administration's plans for dealing with it. Hatch's and Sessions's questions included these two: 1) "What is Treasurys forecast of the date upon which Treasury will find it necessary to use extraordinary measures to manage to keep federal debt at or below the statutory debt limit?" 2) "What is Treasurys forecast of the date upon which the U.S. government will reach the statutory debt limit given use and exhaustion of these extraordinary measures?"
The senators gave Geithner a "hard deadline" of Nov. 1 for providing an initial response to these questions. Julia Lawless, spokesperson for the Republicans on the Senate Finance Committee, confirmed that as of Nov. 6 the committee had received no response from the Treasury secretary.
As of Oct. 31, according to the Daily Treasury Statement (DTS), the portion of the federal debt subject to the legal limit was $16,222,235,000,000--just $171.765 billion below the $16,394,000,000 debt limit.
In October alone, according to the DTS, the debt subject to the limit increased by $195.214 billion.
#10 Nov 9, 2012
I see teddy using my handle to post with. They should hire teddy as a moderator for topix since the idiot is on here around the clock seven days a week.
"The EYE "
Since: Aug 09
#11 Nov 9, 2012
Whut in the sam hill is a fillerbusterin? Seems like them republickins a come off'n with sumthang all oh the time! I be in the way o nowin it ist all abouwsts to end. Afore for yeers i ben a siggin hidyholes at indisclothed lokashuns afore the govermunt an opra and strisand an cumpany. They a moved in seeds an medikashun an everathang a body can imagun they a gonna let that rachil ray cume to cook an ellen degenerite afore fun an a jz and beyonsay afore ennertanmunt in return afore my help with that an a gittin peeple registered to vote i git my own little hideyhole an it mine to stock up as i seed fit. I reckon with all of the wheapons i bowt afrom that atturnee general i kin take ova most o the state an they a promised i kin be a govurner or a general. I is a gunna arm all my hommie an we gunna rise up out the trailer park and yall aint gunna be able to by or sell withowt my scrip. A matter o fact yall be werkin the fields an a doin the washin an all hee hee hee. They didunt a tell me whut was a gunna happen but i suspekt it be unexpekted an soon
Tell me when this thread is updated:Subscribe Now Add to my Tracker
Add your comments below
Cookeville Discussions
|Last By
|Tina Gail (Blondie) Where Are You...
|5 hr
|Spring Creek Road
|6 hr
|crossville johnny
|Cookeville Honda
|7 hr
|Only 13% are black
|7 hr
|We Know
|Help the Poor Not the Rich,Leave your Church
|7 hr
|Dumb Donald J.Trump doesn't know who or what he...
|7 hr
|Devil's Tower, Gallup: Trump's speech the worst...
|11 hr
Find what you want!
Search Cookeville Forum Now
Copyright © 2016 Topix LLC


text:
Dead Man's Burden (2013)
Dead Man's Burden Videos
Dead Man's Burden Photos
Movie Info
as Martha McCurry
as Heck Kirkland
as Wade McCurry
as E.J. Lane
as Three Penny Hank
News & Interviews for Dead Man's Burden
Critic Reviews for Dead Man's Burden
All Critics (17) | Top Critics (11) | Fresh (12) | Rotten (5)
It's a strong debut for Moshe, who, with the exception of some of the oater dialogue, shows both a reverence for and a knowledge of the genre that's intriguing.
Ponderous but lovely, simple but elegant, it should appeal to fans of Westerns.
Small in scale but with a grand visual ambition, "Dead Man's Burden" draws nourishment from its burned-out desert setting and ambling pace.
Despite visual nods to dozens of classic Westerns, the film cannot break through with its own vision.
The story is modest to the point of occasionally seeming slight, and the ending is a tad too cute in the way it circles back to the beginning, but even those flaws just make it feel more authentic. See it now, before it gets rediscovered.
You never get over the feeling that you're watching modern actors play frontier-drama dress-up. It's a deathblow.
Audience Reviews for Dead Man's Burden
Some fine performances all-around, in particular Jacobs and Bowen; I'm talking award nomination material here. Moshe does a great job in his directorial/writing debut in presenting a compelling story.
In "Dead Man's Burden," Wade McCurry(Barlow Jacobs) has survived the Civil War only to find that he is not entirely done with violence just yet. And then once he gets to his family homestead in Texas, he has to prove to his younger sister Martha(Clare Bowen) and her husband Heck(David Call) that he is who he says he is and that his death was greatly exaggerated. That's only to discover that he is too late to attend his father's funeral. "Dead Man's Burden" is a great looking western that has some deep thoughts on the nature of frontier justice. But as far as any kind of story or characterization goes, the movie is sadly paper thin, with acting on the amateurish level of historical reconstructions.
Super Reviewer
Criminally overlooked, Dead Man's Burden is a stark poetic western that takes you through a gritty world of deception. The dialogue has a poetic, almost Cormac McCarthy, approach and the most intriguing aspects are the conversations between the characters rather than big action scenes. It speaks to both the mind and the heart, slow, minimalist, and with the rare quality to meet its ambition. The director obviously has a keen sense for detail and the actors disappear into the world. It is not perfect by any means (some specific things come to mind) but definitely worth a look.
Discussion Forum
Discuss Dead Man's Burden on our Movie forum!


text:
- All Products(1061)
Results 81 - 100 of 1061 matches
Top RatedSquier Bullet Strat with Tremolo
A solid starter axe with a tremolo bar!
Now you can afford to play the legend. Equipped with a comfortably...$149.99Compare Compare Now site7prod517304
- Was:
- $249.99
- 1 Open Box:
- $119.99
$629.00Compare Compare Now site7prodJ19236
- Was:
- $899.00
$1,575.00Compare Compare Now site7prodH99784
- Was:
- $2,429.00
- 1 Open Box:
- $1,386.00
Epiphone Limited Edition Les Paul Special-I Electric Guitar
Real Les Paul tone and feel for beginners or pros.$149.00Compare Compare Now site7prodH71861
- Was:
- $245.00
Top Rated$249.99 - $269.99Compare Compare Now site7prodH97608
- Was:
- $359.99
Top RatedEpiphone Les Paul Special II Electric Guitar
One of the most popular Epiphone models, the Epiphone Special-II electric guitar gives you all the essential...$129.00Compare Compare Now site7prod518334
- Was:
- $299.00
- 1 Open Box:
- $103.20
Price DropDean Custom 350F Electric Guitar
The Custom 350 Floyd features a carved flamed maple top, basswood back, and a bolt-on maple neck. A 24-fret...$279.01 - $348.42Compare Compare Now site7prod424027
- Was:
- $487.50
Dean Vendetta VNXM 7-String Electric Guitar
A 7-string from the ever popular and affordable Vendetta XM series.$179.99Compare Compare Now site7prod516905
- Was:
- $339.00
$649.99Compare Compare Now site7prodH98289
- Was:
- $929.00
Top RatedEpiphone Les Paul Black Beauty 3 Electric Guitar
3 Alnico Classic humbuckers for extending your tonal range; set mahogany neck with slim-tapered neck; solid...$729.00Compare Compare Now site7prod518340
- Was:
- $1,267.00
- 1 Restock:
- $634.99
Top RatedIbanez GRGM21 Mikro Electric Guitar
Armed with the same Powersound pickups that go into all GIO Series axes, its smaller size and shorter 22-1/5" ...$149.99Compare Compare Now site7prod518875
- Was:
- $214.27
Top RatedFender Classic Series Classic Player Baja Telecaster...
Fender Custom Shop's "Dream Machine" '50s-style Tele is customized with "dream list" features including...$799.99Compare Compare Now site7prod512765
Top Rated$499.00Compare Compare Now site7prodH75810
- Was:
- $832.00
Top RatedFender Classic Player '60s Stratocaster Electric Guitar
Designed by Fender Custom Shop Master Builder Greg Fessler with an alder body and a maple C-shaped neck with...$799.99Compare Compare Now site7prod512767
- 1 Open Box:
- $639.99
Top RatedDean Vendetta XM Electric Guitar
Naked dual-humbucker tone and natural wood for next to nothing! The lightweight string-thru paulownia body is...$99.00Compare Compare Now site7prod512150
- Was:
- $210.50
- 1 Open Box:
- $87.12
Top RatedSchecter Guitar Research Synyster Standard Electric Guitar
Like the guitar Synyster plays, it has a Deathbat fretboard inlay with SYN in gothic letters and a gloss black...$699.00Compare Compare Now site7prod518486
- Was:
- $999.00
Top RatedDean Vendetta XMT Electric Guitar with Tremolo
A well-made entry-level guitar with all the features you'll need to start rockin'.
The Vendetta-style...$99.99Compare Compare Now site7prod620248
- Was:
- $265.00
- 2 Open Box:
- $63.99
Top RatedESP EC-50 Electric Guitar
An incredible value for a serious, hard-rocking guitar with huge humbucking tone, easy-play scale length, and...$269.00Compare Compare Now site7prod516672
- Was:
- $370.00
Top RatedKramer Striker 211 Custom Electric Guitar
The Striker 211 Custom features a double-cutaway mahogany body with a flamed maple top, bolt-on maple neck...$309.96Compare Compare Now site7prod423785
- Was:
- $633.00
$2,399.99Compare Compare Now site7prodH86357


text:
- Sign in
- Join
- Find a rental
- Manage your booking
- Vela Luka rentals
- Newest Vela Luka Rentals
- Kid Friendly Vela Luka Rentals
- 2 Bedroom Vela Luka Rentals
- Last Minute Vela Luka Rentals
- Waterfront Vela Luka Rentals
- Pet Friendly Vela Luka Rentals
- Vela Luka Beach Rentals
- Cheap Vela Luka Rentals
- 4 Bedroom Vela Luka Rentals
- 3 Bedroom Vela Luka Rentals
- 5-Star Vela Luka Rentals
- Vela Luka Rentals with Pool
- See more rentals
- How to book
- Traveler Help Center
- Write a review
Isolated stone house/vacation house island korcula
From $110 / week
Payment Protection
balance of due
Description from the owner
Description from the owner
Bedrooms: 3/
Bathrooms: 2/
Sleeps: 5/
Type: House
Book this 3 bedroom, 2 bathroom house in Vela Luka today! A total of 5 people can sleep here comfortably. This property has been booked 7 times.
Guests can enjoy a deck, outdoor grill, and parking space among other amenities offered by this rental.
Travelers are sharing their opinions on this property. It has an overall rating of 5/5 thanks to an average of 3 reviews.
Costs vary, with the average weekly rate as low as $100.00 to as high as $1,050.00, depending on travel dates.
The owner responds to 100% of inquiries and last updated the property's calendar 7 days ago.
Proximity to TripAdvisor's Top Vela Luka Attractions
Proximity to TripAdvisor's Top Vela Luka Attractions
Reviews (0)
Also consider
- FlipKey has rentals in over 11,000 destinations around the world:
- Florida vacation rentals - 39,709 rentals from $95/night
- Pattaya vacation rentals - 1,204 rentals from $20/night
- Cocoa vacation rentals - 212 rentals from $121/night
- Monopoli vacation rentals - 609 rentals from $54/night
- Venice vacation rentals - 229 rentals from $73/night


text:
Your name
Your email
Recipient's Name
Recipient's Email
Here's a fun quilt pattern I designed at eQuilter.
They have the best fabrics and patterns.
If you Log in to your wish list, your items will also appear in the fabric selector.
Click on Add to Cart when your pattern is ready.
Customize your pattern by dragging thumbnail images to the pattern.
Pattern designed by Deborah Stanley, courtesy of Elizabeth's Studio.
Jessie Wheat, USA
February 8, 2012
Shirley Lattis, Flower Mound, TX
May 26, 2016
Linda Nelsen, Kerby Oregon
July 19, 2012
Gail Everson, Canada
December 12, 2014


text:
Hundreds of thousands of premium domains
Questions? We're here to help! Call today:1-303-893-0552
CgcFayetteville.com is for sale
- Take Immediate ownership
- Transfer the domain to the Registrar of your choosing
- 12 monthly payments, only $324.58 per month
- Start using the domain today See details
Talk to a domain expert: 1-303-893-0552
Hurry - once it's sold this opportunity will be gone!
Besides being memorable, .com domains are unique: This is the one and only .com name of it's kind. Other extensions usually just drive traffic to their .com counterparts. To learn more about premium .com domain valuations, watch the video below:
Turbocharge your Web site. Watch our video to learn how.
Improves Your Web Presence
Get noticed online with a great domain name
73% of all domains registered on the Web are .coms. The reason is simple: .com is the where most of Web traffic happens. Owning a premium .com gives you great benefits including better SEO, name recognition, and providing your site with a sense of authority.
Here's What Others Are Saying
Since 2005, we've helped thousands of people get the perfect domain name
- Good - Phonia Srl, Appiu.com, 6/28/2016
- The process was very easy. Fast and serious. Thank you. - Yannick Bensacq, Yookid.com, 6/23/2016
- I'm come from China, i buy this domain for my domain investment, thanks, NameBright is good choice! - Zhang, TibetGroup.com, 6/22/2016
- More testimonials
Own this domain today
|Our Price: $3,795 (USD)
Visit our Help Center for answers to
Frequently Asked Questions
- FayettevilleOrthoK.com$4,795
- CgCopilot.com$3,995
- CgConsultant.com$3,895
- FayettevilleProperties.com$2,495
- FayettevilleGuard.com$3,495
- FayettevillePA.com$3,495
- Wacgc.com$2,195


text:
Luey R. Bornheim 1943 - 2013 Lawrence
Memorial services for Luey R. Bornheim, 69, Lawrence, will be at 10 a.m. Thursday at Rumsey-Yost Funeral Home, with the Rev. Angela Lowe officiating. Luey died Monday, Apr. 8, 2013, at his home.
He was born Aug. 14, 1943, in Denison, Tex., the son of Luey William Jr. and Martha Frances Smith Bornheim. He attended Lawrence schools, and graduated from Lawrence High School. He had been employed at Hallmark Cards, Dillon's, and had owned a motel in Hutchinson before hiring on with the Lawrence School District as a Warehouse Supervisor, retiring in 2004 after 20 years of service. He was a member of KASBO, the Lawrence Corvette Club, coffee groups, and a past member of Wheelsport Motorcycle Club. Luey enjoyed fishing, camping, traveling, motorcycles, and drag racing.
He married Judy K. Avery on Aug. 19, 1962 in Lawrence. They later divorced. He married Eloise Smith on Nov. 24, 1997, in Las Vegas. She survives of the home. Other survivors include a daughter, Dawn Thompson and husband Gregg, Salem, Ore.; a step daughter, Mischa Bell and husband Chris, Lawrence; a step son, Rich McCart and wife Jennie, Parker, Colo.; three brothers, Jack Bornheim and wife Judy, Colbert, Okla., Jerry Bornheim, Colbert, Okla., and Rickie Frame and wife Vickie, Nevada City, Calif.; a sister, Paulette Hathaway and husband Ted, Midvale, Idaho; and 8 grandchildren, Tyler Pracht, Teal Collins, Trevin Thompson, Allison, Aspen, and Jackson McCart, Aeron Stokes, and Lexy Bell.
The family will receive friends following the service. Memorial contributions may be made to the American Heart Association, or the American Cancer Society, in care of the funeral home, 601 Indiana St., Lawrence, KS, 66044 Online condolences may be sent at rumsey-yost.com.
Please sign this guestbook at Obituaries.LJWorld.com.
D & D Tire Company 785-843-0191
Find more businesses on Marketplace
Arts & Entertainment · Bars · Theatres · Restaurants · Coffeehouses · Libraries · Antiques · Services
- Kansans split over questions about Melania Trump speech July 19, 2016 · 39 comments
- 100 years ago: With National Guard called away, Lawrence plans to start rifle club July 23, 2016 · 1 comment
- Kansas Supreme Court upholds death sentence of man who killed Greenwood County sheriff July 22, 2016 · 2 comments
- Letter to the editor: Silly, scary July 23, 2016 · 2 comments
- Letter to the editor: 'We like him' July 23, 2016 · 6 comments
- Brownback, chairman of Cruz campaign in Kansas knock refusal to back Trump July 21, 2016 · 18 comments
- Lawrence to start smoke testing sewer pipes on Monday July 22, 2016 · 1 comment
- Hillary Clinton chooses Va. Sen. Tim Kaine as running mate July 22, 2016 · 3 comments
- On the street: How good a chance do you think the Royals have of making the playoffs? July 23, 2016 · 2 comments
- Letter to the editor: Hypocrisy showing? July 22, 2016 · 5 comments
- Douglas County launches regional effort to double SNAP benefits at farmers markets July 22, 2016
- Cut in state virtual school funding felt in Lawrence district's budget July 23, 2016
- Guilty verdict in social worker's death May 19, 2007
- Datebook: 'Senior Moments,' Simple Gifts and more events for July 23 July 23, 2016
- Svi scores 12 in setback July 23, 2016
- Kansas students to see significant reduction in state assessments July 20, 2016
- Fix-It Chick: Repair a roller chain July 23, 2016
- Grisly details of Johnson County social worker's slaying disclosed May 17, 2007


text:
Manufacturing Area
Category: Hardware, Hand tool and Garden Accessories
1.Provides maximize control for different loads 2.Steel construction with painted finish for added durability 3.Used frelly and easy to assemble 4.products availablity timelyKeyword : hand truck | hand trolley | warehouse hand truck | metal hand truck | China hand truck
1.Used frelly and easy to assemble 2.products availablity timely 3.professional research and dpt.team 4.OEM avaliableKeyword : hand truck | hand trolley | warehouse hand truck | have duty hand truck | metal hand truck
Category: Garden Hand Tools
garbage picker/easy picker/pick grabber /Pick Up tool/easy reacher&grabber: 1. Made of aluminium and plastic material. 2. We can make different size and colors reacher tool. 3. Pick up the litter with ...Keyword : pick up tool
Category: Cutting Hand Tools (incl. Saws, Shears, Trimmers)
cutting hand tools / shears Understruction hardware Your good partner. Keyword : cutting hand tools | cutting hand tool | cutting hand
I.S.O. Flaring tool set Contents: 4 adapters 4.75, 6, 8 Keyword : flaring tool set | flaring tool | flare tool | flaring set
Category: Carpentry Hand Tools
We're manufacturer , the main products of our company are as follow: ? 1.Non-sparking tools. Aluminum copper alloy, beryllium copper alloy. Non sparking tools can avoid rise sparking when tools stri ...
Category: Garage Tools & Tool Sets
Chain Breake And Riverting tool motorcycle tools,manual tool,auto too,automotive tool,car repair tool This tool is designed to rivet chain links to form an endless chain and is versatile enough to ...Keyword : motorcycle repair tool | automotive tool | car repair tool | auto equipment tool | garage tool
FOR RIGHT & LEFT hand IN ONE
Category: Tool Sets
hand cart/ hand trolley/China hand trolley/hand trolley manufacture/hand truck 1.Used as a workbench in the work shop site and for temporary storage and transportation; 2.Configure drawer,layer-boar ...Keyword : hand cart | hand trolley | China hand trolley | hand trolley manufacture
Silent handcart/ soundless hand trolley/China hand trolley/hand trolley manufacture 1. Platform is made of light-weight, high-density structural form; 2. Two fixed, two swivel noiseless casters make ...Keyword : soundless hand trolley | China hand trolley | hand trolley manufacture
Category: Hand Tools
Superior Features: 1. Beautiful bowl shape 2. Lightweight and portable 3. Long lasting materials (stainless steel and plastic) 4. Equipped with a powerful, efficient and quiet motor 5. With inver ...
1.Inside of the cabinet body, layer-boards are provided if needed. the layer-boards can be adjusted up and down at the distance of 40mm/layer and the bearing capacity of layer-board with reinforcement ...Keyword : Tool storage cabinet
1.Maximum the utilization of your warehouse; 2.both single and double face type; 3. Make small tools and component regular and find easily,such as screws, hardware tools; 4. the trundles are made ...Keyword : tool hanging shelf
150 PC automobile workshop tool set Chrome-Vanadium steel Chrome plated,mirror polishedKeyword : tool set
Category: Combination Tool Sets
hand tools 5pcs of garden tools used in gardening and home apliane,also used for children. Material:function part :steel &painting . handle:TRP(soft andti-slip) size:22-32cm any colour could be avalia ...Keyword : Hand tools | Hand tools set | Hand tools supplier | good Hand tools
Welcome to buy mp3


text:
|By Marketwired .
Article Rating:
|February 25, 2013 04:30 PM EST
SAN JOSE, CA -- (Marketwire) -- 02/25/13 -- Brocade (NASDAQ: BRCD) today announced the appointment of Jeff Lindholm to the position of senior vice president of Worldwide Sales to be effective on March 4. In this role, Mr. Lindholm is responsible for leading the development and execution of the company's overall global sales strategy spanning across all Brocade networking products and solutions. Mr. Lindholm will report directly to Brocade CEO, Lloyd Carney.
Mr. Lindholm is chartered with implementing strategies to expand the company's customer base and to take advantage of new business opportunities that are arising in the networking industry due to key industry trends such as data center virtualization, cloud computing and software-defined networking. His primary objective will be to grow sales revenue within the IP/Ethernet networking market and to maintain leadership in the storage networking market, through OEM and channel partners as well as system integrators and direct sales.
"After careful evaluation of Brocade's current opportunities in the marketplace and consideration for the future direction of the company, I am confident that Jeff has the right mix of industry knowledge, business acumen and leadership skills to drive continued growth in key customer segments and geographies," said Lloyd Carney, CEO of Brocade. "His extensive background in networking sales and experience with implementing a customer-focused sales approach will undoubtedly solidify Brocade's position as the industry's leading pure-play networking vendor."
With more than 30 years of experience in the high-tech industry, Mr. Lindholm has held a number of sales and marketing leadership positions at networking and telecommunications technology companies. At Juniper Networks, he served in key executive roles including the senior vice president of Worldwide Sales as well as the chief marketing officer. Mr. Lindholm was also senior vice president of Sales and Marketing at Bigband Networks, where he oversaw the direct sales organization and led market development of next-generation video technologies.
Most recently, Mr. Lindholm served as the senior vice president of Field Operations at Arbor Networks, a provider of network security and management solutions for enterprise and service provider networks. There, he was instrumental in leading the expansion of Arbor Networks' footprint and revenues within its core markets.
"With the ongoing proliferation of cloud computing and the continued acceptance of nascent technologies like fabric-based network architectures and software-defined networking, Brocade is well-positioned to lead in the exciting transformation taking place in the networking industry today," said Jeff Lindholm. "This will require discipline, operational excellence and high levels of collaboration among teams. I am committed to leading a talented sales organization and ensuring that we have the right sales strategy in place that will enable us to quickly respond to customer needs and fully capitalize on these opportunities as they present themselves."
About Brocade
Brocade (NASDAQ: BRCD) networking solutions help the world's leading organizations transition smoothly to a world where applications and information reside anywhere. (www.brocade.com)
ADX, AnyIO, Brocade, Brocade Assurance, the B-wing symbol, DCX, Fabric OS, ICX, MLX, MyBrocade, OpenScript, VCS, VDX, and Vyatta are registered trademarks, and HyperEdge, The Effortless Network, and The On-Demand Data Center are trademarks of Brocade Communications Systems, Inc., in the United States and/or in other countries. Other brands, products, or service names mentioned may be trademarks of their respective owners.
© 2013 Brocade Communications Systems, Inc. All Rights Reserved.
Add to Digg Bookmark with del.icio.us Add to Newsvine
Brocade Media Relations
John Noh
Tel: 408.333.5108
[email protected]
Brocade Investor Relations
Rob Eggers
Tel: 408.333.8797
[email protected]
"There's a growing demand from users for things to be faster. When you think about all the transactions or interactions users will have with your product and everything that is between those transactions and interactions - what drives us at Catchpoint Systems is the idea to measure that and to analyze it," explained Leo Vasiliou, Director of Web Performance Engineering at Catchpoint Systems, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York Ci...
Jul. 27, 2016 06:45 PM EDT Reads: 2,046
I wanted to gather all of my Internet of Things (IOT) blogs into a single blog (that I could later use with my University of San Francisco (USF) Big Data "MBA" course). However as I started to pull these blogs together, I realized that my IOT discussion lacked a vision; it lacked an end point towards which an organization could drive their IOT envisioning, proof of value, app dev, data engineering and data science efforts. And I think that the IOT end point is really quite simple…
Jul. 27, 2016 06:45 PM EDT Reads: 1,132
A critical component of any IoT project is what to do with all the data being generated. This data needs to be captured, processed, structured, and stored in a way to facilitate different kinds of queries. Traditional data warehouse and analytical systems are mature technologies that can be used to handle certain kinds of queries, but they are not always well suited to many problems, particularly when there is a need for real-time insights.
Jul. 27, 2016 04:30 PM EDT Reads: 1,849
Big Data, cloud, analytics, contextual information, wearable tech, sensors, mobility, and WebRTC: together, these advances have created a perfect storm of technologies that are disrupting and transforming classic communications models and ecosystems. In his session at @ThingsExpo, Erik Perotti, Senior Manager of New Ventures on Plantronics' Innovation team, provided an overview of this technological shift, including associated business and consumer communications impacts, and opportunities it ...
Jul. 27, 2016 04:30 PM EDT Reads: 181
You think you know what's in your data. But do you? Most organizations are now aware of the business intelligence represented by their data. Data science stands to take this to a level you never thought of – literally. The techniques of data science, when used with the capabilities of Big Data technologies, can make connections you had not yet imagined, helping you discover new insights and ask new questions of your data. In his session at @ThingsExpo, Sarbjit Sarkaria, data science team lead ...
Jul. 27, 2016 04:15 PM EDT Reads: 1,118
Is your aging software platform suffering from technical debt while the market changes and demands new solutions at a faster clip? It's a bold move, but you might consider walking away from your core platform and starting fresh. ReadyTalk did exactly that. In his General Session at 19th Cloud Expo, Michael Chambliss, Head of Engineering at ReadyTalk, will discuss why and how ReadyTalk diverted from healthy revenue and over a decade of audio conferencing product development to start an innovati...
Jul. 27, 2016 04:00 PM EDT Reads: 1,050
Extracting business value from Internet of Things (IoT) data doesn't happen overnight. There are several requirements that must be satisfied, including IoT device enablement, data analysis, real-time detection of complex events and automated orchestration of actions. Unfortunately, too many companies fall short in achieving their business goals by implementing incomplete solutions or not focusing on tangible use cases. In his general session at @ThingsExpo, Dave McCarthy, Director of Products...
Jul. 27, 2016 04:00 PM EDT Reads: 1,735
WebRTC is bringing significant change to the communications landscape that will bridge the worlds of web and telephony, making the Internet the new standard for communications. Cloud9 took the road less traveled and used WebRTC to create a downloadable enterprise-grade communications platform that is changing the communication dynamic in the financial sector. In his session at @ThingsExpo, Leo Papadopoulos, CTO of Cloud9, discussed the importance of WebRTC and how it enables companies to focus...
Jul. 27, 2016 03:30 PM EDT Reads: 965
SYS-CON Events announced today that 910Telecom will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Housed in the classic Denver Gas & Electric Building, 910 15th St., 910Telecom is a carrier-neutral telecom hotel located in the heart of Denver. Adjacent to CenturyLink, AT&T, and Denver Main, 910Telecom offers connectivity to all major carriers, Internet service providers, Internet backbones and ...
Jul. 27, 2016 11:00 AM EDT Reads: 711
SYS-CON Events announced today that LeaseWeb USA, a cloud Infrastructure-as-a-Service (IaaS) provider, will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. LeaseWeb is one of the world's largest hosting brands. The company helps customers define, develop and deploy IT infrastructure tailored to their exact business needs, by combining various kinds cloud solutions.
Jul. 27, 2016 10:30 AM EDT Reads: 1,225
Manufacturers are embracing the Industrial Internet the same way consumers are leveraging Fitbits – to improve overall health and wellness. Both can provide consistent measurement, visibility, and suggest performance improvements customized to help reach goals. Fitbit users can view real-time data and make adjustments to increase their activity. In his session at @ThingsExpo, Mark Bernardo Professional Services Leader, Americas, at GE Digital, discussed how leveraging the Industrial Internet a...
Jul. 27, 2016 09:45 AM EDT Reads: 467
The cloud market growth today is largely in public clouds. While there is a lot of spend in IT departments in virtualization, these aren't yet translating into a true "cloud" experience within the enterprise. What is stopping the growth of the "private cloud" market? In his general session at 18th Cloud Expo, Nara Rajagopalan, CEO of Accelerite, explored the challenges in deploying, managing, and getting adoption for a private cloud within an enterprise. What are the key differences between wh...
Jul. 27, 2016 09:30 AM EDT Reads: 2,078
SYS-CON Events announced today that Venafi, the Immune System for the Internet™ and the leading provider of Next Generation Trust Protection, will exhibit at @DevOpsSummit at 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Venafi is the Immune System for the Internet™ that protects the foundation of all cybersecurity – cryptographic keys and digital certificates – so they can't be misused by bad guys in attacks...
Jul. 27, 2016 09:15 AM EDT Reads: 1,372
The best-practices for building IoT applications with Go Code that attendees can use to build their own IoT applications. In his session at @ThingsExpo, Indraneel Mitra, Senior Solutions Architect & Technology Evangelist at Cognizant, provided valuable information and resources for both novice and experienced developers on how to get started with IoT and Golang in a day. He also provided information on how to use Intel Arduino Kit, Go Robotics API and AWS IoT stack to build an application tha...
Jul. 27, 2016 09:15 AM EDT Reads: 1,169
Amazon has gradually rolled out parts of its IoT offerings in the last year, but these are just the tip of the iceberg. In addition to optimizing their back-end AWS offerings, Amazon is laying the ground work to be a major force in IoT – especially in the connected home and office. Amazon is extending its reach by building on its dominant Cloud IoT platform, its Dash Button strategy, recently announced Replenishment Services, the Echo/Alexa voice recognition control platform, the 6-7 strategic...
Jul. 27, 2016 09:00 AM EDT Reads: 473
For basic one-to-one voice or video calling solutions, WebRTC has proven to be a very powerful technology. Although WebRTC's core functionality is to provide secure, real-time p2p media streaming, leveraging native platform features and server-side components brings up new communication capabilities for web and native mobile applications, allowing for advanced multi-user use cases such as video broadcasting, conferencing, and media recording.
Jul. 27, 2016 08:45 AM EDT Reads: 947
IoT generates lots of temporal data. But how do you unlock its value? You need to discover patterns that are repeatable in vast quantities of data, understand their meaning, and implement scalable monitoring across multiple data streams in order to monetize the discoveries and insights. Motif discovery and deep learning platforms are emerging to visualize sensor data, to search for patterns and to build application that can monitor real time streams efficiently. In his session at @ThingsExpo, ...
Jul. 27, 2016 08:45 AM EDT Reads: 1,080
Verizon Communications Inc. (NYSE, Nasdaq: VZ) and Yahoo! Inc. (Nasdaq: YHOO) have entered into a definitive agreement under which Verizon will acquire Yahoo's operating business for approximately $4.83 billion in cash, subject to customary closing adjustments. Yahoo informs, connects and entertains a global audience of more than 1 billion monthly active users** -- including 600 million monthly active mobile users*** through its search, communications and digital content products. Yahoo also co...
Jul. 27, 2016 08:00 AM EDT Reads: 611
There will be new vendors providing applications, middleware, and connected devices to support the thriving IoT ecosystem. This essentially means that electronic device manufacturers will also be in the software business. Many will be new to building embedded software or robust software. This creates an increased importance on software quality, particularly within the Industrial Internet of Things where business-critical applications are becoming dependent on products controlled by software. Qua...
Jul. 27, 2016 06:30 AM EDT Reads: 1,501
In addition to all the benefits, IoT is also bringing new kind of customer experience challenges - cars that unlock themselves, thermostats turning houses into saunas and baby video monitors broadcasting over the internet. This list can only increase because while IoT services should be intuitive and simple to use, the delivery ecosystem is a myriad of potential problems as IoT explodes complexity. So finding a performance issue is like finding the proverbial needle in the haystack.
Jul. 27, 2016 04:45 AM EDT Reads: 2,296